Important Join conditions between Oracle apps modules

Important Join conditions between Oracle apps modules, askhareesh blog for Oracle Apps

Module
Table
column



GL and AP
GL_CODE_COMBINATIONS
AP_INVOICES_ALL
code_combination_id  
acct_pay_code_combination_id
GL_CODE_COMBINATIONS
AP_INVOICES_DISTRIBUTIONS_ALL
code_combination_id
dist_code_combination_id
GL_SETS_OF_BOOKS
AP_INVOICES_ALL
set_of_books_id
set_of_books_id
GL and AR
GL_CODE_COMBINATIONS
RA_CUST_TRX_LINE__GL_DIST_ALL
code_combination_id
code_combination_id
GL and INV

GL_CODE_COMBINATIONS
MTL_SYSTEM_ITEMS_B
code_combination_id
cost_of_sales_account
GL and PO
GL_CODE_COMBINATIONS
PO_DISTRIBUTIONS_ALL
code_combination_id
code_combination_id

PO and AP
PO_DISTRIBUTIONS_ALL
AP_INVOICE_DISTRIBUTIONS_ALL
Po_distribution_id
Po_distribution_id
PO_VENDORS
AP_INVOICES_ALL
vendor_id
vendor_id

PO and SHIPMENTS
PO_HEADERS_ALL
RCV_TRANSACTIONS
Po_header_id
Po_header_id
PO_DISTRIBUTIONS_ALL
RCV_TRANSACTIONS
Po_distribution_id
Po_distribution_id
SHIPMENTS and AP INVOICE
RCV_TRANSACTIONS
AP_INVOICE_DISTRIBUTIONS_ALL
Rcv_transaction_id
Rcv_transaction_id
PO and INV
PO_REQUISITION_LINES_ALL
MTL_SYSTEM_ITEMS_B
item_id
inventory_item_id
PO_REQUISITION_LINES_ALL
MTL_SYSTEM_ITEMS_B
org_id              
organization_id
PO and HRMS
PO_HEADERS_ALL
HR_EMPLOYEES
Agent_id
employee_id
PO and REQUISITION
PO_DISTRIBUTIONS_ALL
PO_REQ_DISTRIBUTIONS_ALL
req_distribution_id
distribution_id
SHIPMENTS and INV
RCV_TRANSACTIONS
MTL_SYSTEM_ITEMS_B
Organization_id
Organization_id
INV and HRMS
MTL_SYSTEM_ITEMS_B
HR_EMPLOYEES
buyer_id
employee_id



OM and AR
OE_ORDER_HEADERS_ALL
RA_CUSTOMER_TRX_LINES_ALL
TO_CHAR( Order_number)
interface_line_attribute1
OE_ORDER_LINES_ALL
RA_CUSTOMER_TRX_LINES_ALL
TO_CHAR(Line_id)
interface_line_attribute6
OE_ORDER_LINES_ALL
RA_CUSTOMER_TRX_LINES_ALL
reference_customer_trx_line_id
customer_trx_line_id


OM and SHIPPING
OE_ORDER_HEADERS_ALL
WSH_DELIVARY_DETAILS
Header_id
Source_header_id
OE_ORDER_LINES_ALL
WSH_DELIVARY_DETAILS
Line_id
Source_line_id
AP and AR (Banks)
AR_CASH_RECEIPTS_ALL
AP_BANK_ACCOUNTS
Remittance_bank_account_id
Bank_account_id
AP and AR
HZ_PARTIES  
AP_INVOICES_ALL
Party_id
Party_id
OM and CRM
OE_ORDER_LINES_ALL
CSI_ITEM_INSTANCES(Install Base)
Line_id
Last_oe_order_line_id


*/