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 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
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_HEADERS_ALL WSH_DELIVARY_DETAILS
LINE_ID =
SOURCE_LINE_ID
AP AND AR (BANKS)
AR_CASH_RECEIPTS_ALL AP_BANK_ACCOUNTS
REMITTANCE_BANK_ACCOUNT_ID = ABA.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
Thanks for info but these are all 11i links please post R12 links
ReplyDelete