Skip to main content

Posts

Showing posts with the label Interface

Important Join conditions between Oracle apps modules

Book mark this page...to find more and more useful join conditions in upcoming days!!!!!!!! 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 A...