P2P Cycle & Table Joins

P2P Cycle & Table Joins

por_requisition_headers_all

por_requisition_lines_all

por_req_distributions_all

po_headers_all

po_lines_all

po_line_locations_all

po_distributions_all

rcv_shipment_lines

rcv_shipment_headers

rcv_transactions

ap_invoice_all

ap_invoice_lines_all

ap_invoice_distributions_all

ap_invoice_payments_all

iby_payments_all

ap_payment_schedules_all

ap_checks_all

xla_transaction_entities

xla_ae_headers

xla_ae_lines

xla_events

xla_distribution_links

gl_import_references

gl_je_headers

gl_je_lines

gl_je_batches

==================JOINS=====================

prha.requisition_header_id=prla.requisition_header_id

prla.requisition_line_id=prda.requisition_line_id

prla.po_header_id=pha.po_header_id

pha.po_header_id=pla.po_header_id

pla.po_line_id=plla.po_line_id

plla.line_location_id=pda.line_location_id

pha.po_header_id=rsl.po_header_id

rsl.shipment_header_id=rsh.shipment_header_id

rsl.shipment_line_id=rt.shipment_line_id

pha.po_header_id=aia.po_header_id

aia.invoice_id=aila.invoice_id

aila.invoice_id=aida.invoice_id

aia.invoice_id=aipa.invoice_id

aipa.invoice_payment_id=ipa.payment_id

ipa.payment_id=apsa.invoice_id

apsa.check_id=aca.check_id

aia.invoice_id=xte.source_id_int_1

xte.entity_id=xah.entity_id

xte.ae_header_id=xah.ae_header_id

xah.ae_header_id=xal.ae_header_id

xah.event_id=xe.event_id

(Note: aida.accounting_event_id=xe.event_id (This is also a join condition))

xah.ae_header_id=xdl.ae_header_id

xal.ae_line_num=xdl.ae_line_num

xe.event_id=xdl.event_id

xdl.APPLIED_TO_DIST_ID_NUM_1=decode(xe.EVENT_TYPE_CODE,'INVOICE CANCELLED',aida.PARENT_REVERSAL_ID,aida.INVOICE_DISTRIBUTION_ID)

xal.gl_sl_link_id=gir.gl_sl_link_id

gir.je_header_id=gjh.je_header_id

gjh.je_header_id=gjl.je_header_id

gjh.je_batch_id=gjb.je_batch_id