Oracle AP Tax Joins

 AP Table Relation Oracle Apps

ORACLE PAYABLE TABLE RELATION
Source Table	Dependent Table	Condition
AP_INVOICE_LINES_ALL AIL	ZX_LINES_SUMMARY ZLS	AIL.invoice_id=ZLS.trx_id and ZLS.application_id = 200 and ZLS.entity_code = 'AP_INVOICES' and ZLS.event_class_code in ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS') and AIL.summary_tax_line_id =ZLS.summary_tax_line_id
AP_INVOICE_LINES_ALL AIL	ZX_LINES ZL	AIL.invoice_id=ZL.trx_id and ZL.application_id = 200 and ZL.entity_code = 'AP_INVOICES' and ZL.event_class_code in ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS') and AIL.line_number=ZL.trx_line_number
AP_INVOICE_DISTRIBUTIONS_ALL AID	ZX_REC_NREC_DIST ZD	AID.invoice_id=ZD.trx_id and ZD.application_id = 200 and ZD.entity_code = 'AP_INVOICES' and ZD.event_class_code in ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS') and AID.summary_tax_line_id = ZD.summary_tax_line_id and AID.detail_tax_dist_id = ZD.rec_nrec_tax_dist_id
AP_SELF_ASSESSED_TAX_DIST_ALL ASTD	ZX_REC_NREC_DIST ZD	ASTD.invoice_id=ZD.trx_id and ZD.application_id = 200 and ZD.entity_code = 'AP_INVOICES' and ZD.event_class_code in ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS') and ASTD.summary_tax_line_id = ZD.summary_tax_line_id and ASTD.detail_tax_dist_id =ZD.rec_nrec_tax_dist_id and ZD.self_assessed_flag='Y'
AP_INVOICE_LINES_ALL AIL	ZX_LINES_DET_FACTORS ZLDF	AIL.invoice_id=ZLDF.trx_id and ZLDF.application_id = 200 and ZLDF.entity_code = 'AP_INVOICES' and ZLDF.event_class_code in ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS') and AIL.line_number=ZLDF.trx_line_number
AP_INVOICE_DISTRIBUTIONS_ALL or AP_SELF_ASSESSED_TAX_DIST_ALL AID	XLA_EVENTS XE	Actual Event: -------------- xe.event_id = aid.accounting_event_id and xe.application_id = 200 Budgetary Event: ----------------- xe.event_id = aid.bc_event_id and xe.application_id = 200
AP_INVOICE_DISTRIBUTIONS_ALL or AP_SELF_ASSESSED_TAX_DIST_ALL AID	RCV_TRANSACTIONS RT	aid.rcv_transaction_id = rt.transaction_id
AP_INVOICE_DISTRIBUTIONS_ALL or AP_SELF_ASSESSED_TAX_DIST_ALL AID	GL_CODE_COMBINATIONS GCC	aid.dist_code_combination_id =gcc.code_combination_id
AP_PAYMENT_HISTORY_ALL APH	XLA_EVENTS XE	aph.accounting_event_id = xe.event_id    and xe.application_id = 200
AP_INVOICE_PAYMENTS_ALL AIP	XLA_EVENTS XE	aip.accounting_event_id = xe.event_id and xe.application_id = 200
AP_INVOICE_DISTRIBUTIONS_ALL or AP_SELF_ASSESSED_TAX_DIST_ALL AID	PO_DISTRIBUTIONS_ALL	PD aid.po_distribution_id = pd.po_distribution_id
AP_INVOICES_ALL AI	PO_HEADERS_ALL PH	ai.po_header_id = ph.po_header_id
AP_SUPPLIER_SITES_ALL ASS	HZ_PARTY_SITES HPS	ass.party_site_id = hps.party_site_id
AP_SUPPLIERS AS	HZ_PARTIES HP	as.party_id = hp.party_id
AP_PRERPAY_APP_DISTS or AP_PAYMENT_HIST_DISTS APA	XLA_EVENTS XE	apa.accounting_event_id = xe.event_id xe.application_id = 200
AP_PREPAY_HISTORY_ALL APH	XLA_EVENTS XE	aph.accounting_event_id = xe.event_id and xe.application_id = 200
AP_INVOICES_ALL AI	XLA.XLA_TRANSACTION_ENTITIES XTE	ai.invoice_id = nvl(xte.source_id_int_1, -99) and xte.entity_code = 'AP_INVOICES' and xte.application_id = 200
AP_CHECKS_ALL AC	XLA.XLA_TRANSACTION_ENTITIES XTE	ac.check_id = nvl(xte.source_id_int_1, -99) and xte.entity_code = 'AP_PAYMENTS' and xte.application_id =200