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
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
|
Book mark this page...to find more and more useful join conditions in upcoming days!!!!!!!!
Click the links below to find join condition......
- Join between AR_CASH_RECEIPTS_ALL and AP_BANK_ACCOUNTS
- Join between GL_CODE_COMBINATIONS and AP_INVOICES_ALL
- Join between GL_CODE_COMBINATIONS and AP_INVOICES_DISTRIBUTIONS_ALL
- Join between GL_CODE_COMBINATIONS and MTL_SYSTEM_ITEMS_B
- Join between GL_CODE_COMBINATIONS and PO_DISTRIBUTIONS_ALL
- Join between GL_CODE_COMBINATIONS and RA_CUST_TRX_LINE__GL_DIST_ALL
- Join between GL_SETS_OF_BOOKS and AP_INVOICES_ALL
- Join between HZ_PARTIES and AP_INVOICES_ALL
- Join between MTL_SYSTEM_ITEMS_B and HR_EMPLOYEES
- Join between OE_ORDER_HEADERS_ALL and RA_CUSTOMER_TRX_LINES_ALL
- Join between OE_ORDER_LINES_ALL and CSI_ITEM_INSTANCES
- Join between OE_ORDER_LINES_ALL and RA_CUSTOMER_TRX_LINES_ALL
- Join between PO_DISTRIBUTIONS_ALL and AP_INVOICE_DISTRIBUTIONS_ALL
- Join between PO_DISTRIBUTIONS_ALL and PO_REQ_DISTRIBUTIONS_ALL
- Join between PO_HEADERS_ALL and HR_EMPLOYEES
- Join between PO_HEADERS_ALL and RCV_TRANSACTIONS
- Join between PO_VENDORS and AP_INVOICES_ALL
- Join between RCV_TRANSACTIONS and MTL_SYSTEM_ITEMS_B
- Join between CSP_EXCESS_LISTS and PO_REQUISITION_HEADERS_ALL
- Join between JAI_PO_REQ_LINES and PO_REQUISITION_HEADERS_ALL
- Join between OE_ORDER_HEADERS_ALL and WSH_DELIVARY_DETAILS
- Join between OE_ORDER_LINES_ALL and WSH_DELIVARY_DETAILS
- Join between PO_DISTRIBUTIONS_ALL and RCV_TRANSACTIONS
- Join between PO_REQUISITION_LINES_ALL and MTL_SYSTEM_ITEMS_B
- Join between RCV_TRANSACTIONS and AP_INVOICE_DISTRIBUTIONS_ALL
- Join condition between AHL_MR_EFFECTIVITIES and MTL_SYSTEM_ITEMS_B
- Join condition between AHL_OSP_ORDERS_B and OE_ORDER_HEADERS_ALL
- Join condition between AHL_OSP_ORDERS_B and PO_HEADERS_ALL
- Join condition between AHL_OSP_ORDER_LINES and OE_ORDER_LINES_ALL
- Join condition between AHL_OSP_ORDER_LINES and PO_LINES_ALL
- Join condition between AHL_ROUTES_B and MTL_SYSTEM_ITEMS_B
- Join condition between AHL_RT_OPER_MATERIALS and MTL_SYSTEM_ITEMS_B
- Join condition between AHL_UF_HEADERS and MTL_SYSTEM_ITEMS_B
- Join condition between AHL_VISITS_B and MTL_SYSTEM_ITEMS_B
- Join condition between AHL_VISIT_TASKS_B and MTL_SYSTEM_ITEMS_B
- Join condition between AHL_WORKORDER_MTL_TXNS and MTL_ITEM_LOCATIONS
- Join condition between AHL_WORKORDER_MTL_TXNS and MTL_MATERIAL_TRANSACTIONS
- Join condition between AHL_WORKORDER_MTL_TXNS and MTL_SECONDARY_INVENTORIES
- Join condition between AHL_WORKORDER_MTL_TXNS and MTL_SYSTEM_ITEMS_B
- Join condition between AMS_ACT_PRODUCTS and MTL_SYSTEM_ITEMS_B
- Join condition between AMS_EVENT_REGISTRATIONS and OE_ORDER_HEADERS_ALL
- Join condition between AMS_EVENT_REGISTRATIONS and OE_ORDER_LINES_ALL
- Join condition between AMS_ITEM_ATTRIBUTES and MTL_SYSTEM_ITEMS_B
- Join condition between AP_CHECK_TRANSMISSIONS and GL_JE_BATCHES
- Join condition between AP_HOLDS_ALL and PO_LINE_LOCATIONS_ALL
- Join condition between AP_HOLDS_ALL and RCV_TRANSACTIONS
- Join condition between AP_INVOICES_ALL and PO_HEADERS_ALL
- Join condition between AP_INVOICE_DISTRIBUTIONS_ALL and RCV_TRANSACTIONS
- Join condition between AP_INVOICE_TRANSMISSIONS and GL_JE_BATCHES
- Join condition between AP_MATCHED_RECT_ADJ_ALL and RCV_TRANSACTIONS
- Join condition between AP_RECURRING_PAYMENTS_ALL and PO_LINE_LOCATIONS_ALL
- Join condition between AR_ADJUSTMENTS_ALL and RA_CUSTOMER_TRX_ALL
- Join condition between AR_DEFERRED_LINES_ALL and OE_ORDER_LINES_ALL
- Join condition between AR_REVENUE_ADJUSTMENTS_ALL and MTL_CATEGORIES_B
- Join condition between AS_AP_TRACKING_OBJECTIVES and MTL_CATEGORIES_B
- Join condition between BOM_BILL_OF_MATERIALS and MTL_SYSTEM_ITEMS_B
- Join condition between BOM_EXPLOSIONS and MTL_SYSTEM_ITEMS_B
- Join condition between BOM_MIXED_MODEL_MAP_HEADER and MTL_SYSTEM_ITEMS_B
- Join condition between BOM_OPERATIONAL_ROUTINGS and MTL_ITEM_LOCATIONS
- Join condition between BOM_OPERATIONAL_ROUTINGS and MTL_SECONDARY_INVENTORIES
- Join condition between BOM_OPERATIONAL_ROUTINGS and MTL_SYSTEM_ITEMS_B
- Join condition between BOM_STRUCTURES_B and MTL_SYSTEM_ITEMS_B
- Join condition between CRP_BILL_OF_RESOURCE_ITEMS and MTL_SYSTEM_ITEMS_B
- Join condition between CRP_RESOURCE_HOURS and MTL_SYSTEM_ITEMS_B
- Join condition between CSD_GROUP_JOB_PARAM_TEMP and MTL_SYSTEM_ITEMS_B
- Join condition between CSD_REPAIRS and OE_ORDER_LINES_ALL
- Join condition between CSI_ITEM_INSTANCES and MTL_SYSTEM_ITEMS_B
- Join condition between CSI_ITEM_INSTANCES and OE_ORDER_LINES_ALL
- Join condition between CSI_ITEM_INSTANCES and PO_LINES_ALL
- Join condition between CSI_I_EXTENDED_ATTRIBS and MTL_CATEGORIES_B
- Join condition between CSI_I_EXTENDED_ATTRIBS and MTL_SYSTEM_ITEMS_B
- Join condition between CSP_CURR_SUP_DEM_SUMS and MTL_SECONDARY_INVENTORIES
- Join condition between CSP_CURR_SUP_DEM_SUMS and MTL_SYSTEM_ITEMS_B
- Join condition between CSP_EXCESS_LISTS and MTL_SECONDARY_INVENTORIES
- Join condition between CSP_EXCESS_LISTS and MTL_SYSTEM_ITEMS_B
- Join condition between CSP_EXCESS_LISTS and PO_REQUISITION_HEADERS_ALL
- Join condition between CSP_EXCESS_RULES_B and MTL_CATEGORIES_B
- Join condition between CSP_INV_LOC_ASSIGNMENTS and MTL_ITEM_LOCATIONS
- Join condition between CSP_INV_LOC_ASSIGNMENTS and MTL_SECONDARY_INVENTORIES
- Join condition between CSP_MOVEORDER_HEADERS and MTL_TXN_REQUEST_HEADERS
- Join condition between CSP_MOVEORDER_LINES and MTL_TXN_REQUEST_HEADERS
- Join condition between CSP_MSTRSTCK_LISTS_ITMS and MTL_SYSTEM_ITEMS_B
- Join condition between CSP_NOTIFICATIONS and MTL_SYSTEM_ITEMS_B
- Join condition between CSP_NOTIFICATION_DETAILS and MTL_SYSTEM_ITEMS_B
- Join condition between CSP_PACKLIST_HEADERS and MTL_SECONDARY_INVENTORIES
- Join condition between CSP_PACKLIST_LINES and MTL_SYSTEM_ITEMS_B
- Join condition between CSP_PLANNING_PARAMETERS and MTL_SECONDARY_INVENTORIES
- Join condition between CSP_REQUIREMENT_LINES and MTL_RESERVATIONS
- Join condition between CSP_REQUIREMENT_LINES and MTL_SECONDARY_INVENTORIES
- Join condition between CSP_REQUIREMENT_LINES and OE_ORDER_LINES_ALL
- Join condition between CSP_SEC_INVENTORIES and MTL_SECONDARY_INVENTORIES
- Join condition between CSP_STOCK_LISTS and MTL_SYSTEM_ITEMS_B
- Join condition between CSP_SUPPLY_CHAIN and MTL_SECONDARY_INVENTORIES
- Join condition between CSP_SUPPLY_CHAIN and MTL_SYSTEM_ITEMS_B
- Join condition between CSP_USAGE_HEADERS and MTL_SECONDARY_INVENTORIES
- Join condition between CSP_USAGE_HEADERS and MTL_SYSTEM_ITEMS_B
- Join condition between CSP_USAGE_HISTORIES and MTL_SECONDARY_INVENTORIES
- Join condition between CSP_USAGE_HISTORIES and MTL_SYSTEM_ITEMS_B
- Join condition between CST_AE_HEADERS and MTL_MATERIAL_TRANSACTIONS
- Join condition between CST_AE_HEADERS and RCV_TRANSACTIONS
- Join condition between CST_AP_PO_RECONCILIATION and PO_DISTRIBUTIONS_ALL
- Join condition between CST_AP_PO_RECONCILIATION and RCV_TRANSACTIONS
- Join condition between CST_AP_VARIANCE_LINES and PO_DISTRIBUTIONS_ALL
- Join condition between CST_COGS_EVENTS and MTL_MATERIAL_TRANSACTIONS
- Join condition between CST_COGS_EVENTS and OE_ORDER_LINES_ALL
- Join condition between CST_COMP_SNAPSHOT and MTL_MATERIAL_TRANSACTIONS
- Join condition between CST_COST_TYPE_HISTORY and MTL_SYSTEM_ITEMS_B
- Join condition between CST_ITEM_COSTS and MTL_SYSTEM_ITEMS_B
- Join condition between CST_ITEM_COSTS_INTERFACE and MTL_SYSTEM_ITEMS_B
- Join condition between CST_ITEM_COST_DETAILS and MTL_SYSTEM_ITEMS_B
- Join condition between CST_ITEM_CST_DTLS_INTERFACE and MTL_SYSTEM_ITEMS_B
- Join condition between CST_MGD_INFL_TSF_ORG_ENTRIES and MTL_MATERIAL_TRANSACTIONS
- Join condition between CST_MISC_RECONCILIATION and MTL_MATERIAL_TRANSACTIONS
- Join condition between CST_MISC_RECONCILIATION and PO_DISTRIBUTIONS_ALL
- Join condition between CST_RCV_ACQ_COSTS and RCV_TRANSACTIONS
- Join condition between CST_RCV_ACQ_COST_DETAILS and PO_LINES_ALL
- Join condition between CST_RECONCILIATION_SUMMARY and PO_DISTRIBUTIONS_ALL
- Join condition between CST_REVENUE_COGS_MATCH_LINES and OE_ORDER_LINES_ALL
- Join condition between CST_REVENUE_RECOGNITION_LINES and OE_ORDER_LINES_ALL
- Join condition between CST_WRITE_OFFS and PO_DISTRIBUTIONS_ALL
- Join condition between CST_WRITE_OFF_DETAILS and RCV_TRANSACTIONS
- Join condition between CS_INCIDENTS_ALL_B and MTL_CATEGORIES_B
- Join condition between CS_LINE_INST_DETAILS and OE_ORDER_LINES_ALL
- Join condition between CS_SR_PROB_CODE_MAPPING and MTL_CATEGORIES_B
- Join condition between CS_SR_RES_CODE_MAPPING and MTL_CATEGORIES_B
- Join condition between CZ_AUTOSELECTION_ITEMS and MTL_SYSTEM_ITEMS_B
- Join condition between CZ_CONSTRAINT_ASSIGNMENTS and MTL_SYSTEM_ITEMS_B
- Join condition between EAM_ASSET_METERS and MTL_SYSTEM_ITEMS_B
- Join condition between EAM_JOB_COMPLETION_TXNS and MTL_SYSTEM_ITEMS_B
- Join condition between EAM_OP_COMPLETION_TXNS and MTL_SYSTEM_ITEMS_B
- Join condition between EAM_WORK_ORDER_BILLS and MTL_SYSTEM_ITEMS_B
- Join condition between ENG_REVISED_ITEMS and MTL_SYSTEM_ITEMS_B
- Join condition between FA_ASSET_INVOICES and PO_DISTRIBUTIONS_ALL
- Join condition between FA_ASSET_INVOICES and PO_HEADERS_ALL
- Join condition between FA_DEPRN_PERIODS and GL_JE_BATCHES
- Join condition between FA_MASSADD_REP_ITF and PO_DISTRIBUTIONS_ALL
- Join condition between FA_MASS_ADDITIONS and PO_DISTRIBUTIONS_ALL
- Join condition between FA_MC_ASSET_INVOICES and PO_DISTRIBUTIONS_ALL
- Join condition between FA_MC_ASSET_INVOICES and PO_HEADERS_ALL
- Join condition between FA_MC_DEPRN_PERIODS and GL_JE_BATCHES
- Join condition between FLM_KANBAN_SUMMARY and MTL_SECONDARY_INVENTORIES
- Join condition between FLM_MMM_OP_ITEMS and MTL_SYSTEM_ITEMS_B
- Join condition between FLM_SEQ_TASK_DEMANDS and MTL_SYSTEM_ITEMS_B
- Join condition between FTE_LANE_COMMODITIES and MTL_CATEGORIES_B
- Join condition between FV_INV_SELECTED_DUEDATE and PO_DISTRIBUTIONS_ALL
- Join condition between FV_INV_SELECTED_DUEDATE and RCV_TRANSACTIONS
- Join condition between FV_RCV_TRANSACTIONS and RCV_TRANSACTIONS
- Join condition between FV_SF1219_TEMP and GL_JE_BATCHES
- Join condition between GL_ARCHIVE_BATCHES and GL_JE_BATCHES
- Join condition between GL_ARCHIVE_HEADERS and GL_JE_BATCHES
- Join condition between GL_ARCHIVE_REFERENCES and GL_JE_BATCHES
- Join condition between GL_AUTO_ALLOC_BATCH_HISTORY and GL_JE_BATCHES
- Join condition between GL_AUTO_ALLOC_REV_BATCHES and GL_JE_BATCHES
- Join condition between GL_BC_PACKETS and GL_JE_BATCHES
- Join condition between GL_BC_PACKETS_HISTS and GL_JE_BATCHES
- Join condition between GL_ELIMINATION_HISTORY and GL_JE_BATCHES
- Join condition between GL_IMPORT_REFERENCES and GL_JE_BATCHES
- Join condition between GL_INTERFACE and GL_JE_BATCHES
- Join condition between GL_INTERFACE_HISTORY and GL_JE_BATCHES
- Join condition between GL_JE_BATCHES and GL_JE_BATCHES
- Join condition between GL_JE_HEADERS and GL_JE_BATCHES
- Join condition between GL_JOURNAL_REPORTS_ITF and GL_JE_BATCHES
- Join condition between GL_UPGRADE_STATUS and GL_JE_BATCHES
- Join condition between GMS_AWARD_DISTRIBUTIONS and PO_DISTRIBUTIONS_ALL
- Join condition between GMS_AWARD_DISTRIBUTIONS and PO_REQ_DISTRIBUTIONS_ALL
- Join condition between IBE_CT_IMEDIA_SEARCH and MTL_CATEGORIES_B
- Join condition between IBE_CT_IMEDIA_SEARCH and MTL_SYSTEM_ITEMS_B
- Join condition between IBE_CT_RELATED_ITEMS and MTL_SYSTEM_ITEMS_B
- Join condition between IBE_CT_RELATION_RULES and MTL_CATEGORIES_B
- Join condition between IBE_CT_REL_EXCLUSIONS and MTL_SYSTEM_ITEMS_B
- Join condition between IBE_DSP_OBJ_LGL_CTNT and MTL_CATEGORIES_B
- Join condition between IBE_DSP_SECTION_ITEMS and MTL_SYSTEM_ITEMS_B
- Join condition between IBE_ECR_ORDERS_FACT and MTL_SYSTEM_ITEMS_B
- Join condition between IBE_ECR_QUOTES_FACT and MTL_SYSTEM_ITEMS_B
- Join condition between IBE_SECTION_SEARCH and MTL_SYSTEM_ITEMS_B
- Join condition between IBE_SHP_LIST_ITEMS_ALL and MTL_SYSTEM_ITEMS_B
- Join condition between ICX_SHOPPING_CART_LINES and PO_LINES_ALL
- Join condition between IGC_CC_ACCT_LINES and PO_LINES_ALL
- Join condition between IGC_CC_ACCT_LINES and PO_LINE_LOCATIONS_ALL
- Join condition between IGC_CC_ACCT_LINES_INTERFACE and PO_LINES_ALL
- Join condition between IGC_CC_ACCT_LINES_INTERFACE and PO_LINE_LOCATIONS_ALL
- Join condition between IGC_CC_ARC_ACCT_LINES and PO_LINES_ALL
- Join condition between IGC_CC_ARC_ACCT_LINES and PO_LINE_LOCATIONS_ALL
- Join condition between IGC_CC_ARC_DET_PF and PO_DISTRIBUTIONS_ALL
- Join condition between IGC_CC_ARC_HEADERS and PO_HEADERS_ALL
- Join condition between IGC_CC_DET_PF and PO_DISTRIBUTIONS_ALL
- Join condition between IGC_CC_DET_PF_INTERFACE and PO_DISTRIBUTIONS_ALL
- Join condition between IGC_CC_HEADERS and PO_HEADERS_ALL
- Join condition between IGC_CC_HEADERS_INTERFACE and PO_HEADERS_ALL
- Join condition between JAI_AP_MATCH_INV_TAXES and PO_HEADERS_ALL
- Join condition between JAI_AP_MATCH_INV_TAXES and PO_LINES_ALL
- Join condition between JAI_AP_MATCH_INV_TAXES and PO_LINE_LOCATIONS_ALL
- Join condition between JAI_CMN_RG_23AC_I_TRXS and PO_HEADERS_ALL
- Join condition between JAI_CMN_RG_23AC_I_TRXS and PO_LINES_ALL
- Join condition between JAI_CMN_RG_23AC_I_TRXS and PO_LINE_LOCATIONS_ALL
- Join condition between JAI_PO_COPYDOC_T and PO_HEADERS_ALL
- Join condition between JAI_PO_COPYDOC_T and PO_LINES_ALL
- Join condition between JAI_PO_COPY_T and PO_HEADERS_ALL
- Join condition between JAI_PO_COPY_T and PO_LINES_ALL
- Join condition between JAI_PO_LINE_LOCATIONS and PO_HEADERS_ALL
- Join condition between JAI_PO_LINE_LOCATIONS and PO_LINES_ALL
- Join condition between JAI_PO_OSP_HDRS and PO_HEADERS_ALL
- Join condition between JAI_PO_OSP_LINES and PO_LINES_ALL
- Join condition between JAI_PO_QUOT_LINES_T and PO_HEADERS_ALL
- Join condition between JAI_PO_QUOT_LINES_T and PO_LINES_ALL
- Join condition between JAI_PO_REP_PRRG_T and PO_HEADERS_ALL
- Join condition between JAI_PO_REQUEST_T and PO_HEADERS_ALL
- Join condition between JAI_PO_REQUEST_T and PO_LINES_ALL
- Join condition between JAI_PO_REQ_LINES and PO_REQUISITION_HEADERS_ALL
- Join condition between JAI_PO_REQ_LINES and PO_REQUISITION_LINES_ALL
- Join condition between JAI_PO_REQ_LINE_TAXES and PO_REQUISITION_HEADERS_ALL
- Join condition between JAI_PO_REQ_LINE_TAXES and PO_REQUISITION_LINES_ALL
- Join condition between JAI_PO_TAXES and PO_HEADERS_ALL
- Join condition between JAI_PO_TAXES and PO_LINES_ALL
- Join condition between JA_AU_SUBINV_LOC_ASSOCS and MTL_SECONDARY_INVENTORIES
- Join condition between JE_IT_PO_PACKSLIPS and RCV_TRANSACTIONS
- Join condition between JL_BR_AR_TX_EXC_ITM_ALL and MTL_SYSTEM_ITEMS_B
- Join condition between JL_BR_PO_TAX_EXC_ITEMS_ALL and MTL_SYSTEM_ITEMS_B
- Join condition between JL_CO_GL_TRX and GL_JE_BATCHES
- Join condition between JL_ZZ_AR_TX_EXC_ITM_ALL and MTL_SYSTEM_ITEMS_B
- Join condition between JMF_SHIKYU_REPLENISHMENTS and OE_ORDER_LINES_ALL
- Join condition between MRP_FORECAST_INTERFACE and MTL_SYSTEM_ITEMS_B
- Join condition between MRP_FORECAST_ITEMS and MTL_SYSTEM_ITEMS_B
- Join condition between MRP_ITEM_SUPPLIERS and MTL_SYSTEM_ITEMS_B
- Join condition between MRP_RELIEF_INTERFACE and MTL_SYSTEM_ITEMS_B
- Join condition between MRP_SALES_ORDER_UPDATES and MTL_SYSTEM_ITEMS_B
- Join condition between MRP_SCHEDULE_INTERFACE and MTL_SYSTEM_ITEMS_B
- Join condition between MRP_SCHEDULE_ITEMS and MTL_SYSTEM_ITEMS_B
- Join condition between MRP_SR_ASSIGNMENTS and MTL_CATEGORIES_B
- Join condition between MRP_SUB_INVENTORIES and MTL_SECONDARY_INVENTORIES
- Join condition between MRP_SUPPLIER_CAPACITIES and MTL_SYSTEM_ITEMS_B
- Join condition between MRP_SUPPLIER_FLEX_FENCES and MTL_SYSTEM_ITEMS_B
- Join condition between MRP_SYSTEM_ITEMS and MTL_CATEGORIES_B
- Join condition between MRP_SYSTEM_ITEMS and MTL_SYSTEM_ITEMS_B
- Join condition between MTL_ABC_ASSIGNMENT_GROUPS and MTL_SECONDARY_INVENTORIES
- Join condition between MTL_ACTUAL_COST_SUBELEMENT and MTL_MATERIAL_TRANSACTIONS
- Join condition between MTL_CATALOG_SEARCH_ITEMS and MTL_SYSTEM_ITEMS_B
- Join condition between MTL_CC_ENTRIES_INTERFACE and MTL_ITEM_LOCATIONS
- Join condition between MTL_CC_ENTRIES_INTERFACE and MTL_SECONDARY_INVENTORIES
- Join condition between MTL_CC_ENTRIES_INTERFACE and MTL_SYSTEM_ITEMS_B
- Join condition between MTL_CROSS_REFERENCES and MTL_SYSTEM_ITEMS_B
- Join condition between MTL_CST_ACTUAL_COST_DETAILS and MTL_MATERIAL_TRANSACTIONS
- Join condition between MTL_CST_ACTUAL_COST_DETAILS and MTL_SYSTEM_ITEMS_B
- Join condition between MTL_CST_TXN_COST_DETAILS and MTL_MATERIAL_TRANSACTIONS
- Join condition between MTL_CST_TXN_COST_DETAILS and MTL_SYSTEM_ITEMS_B
- Join condition between MTL_CUSTOMER_ITEM_XREFS and MTL_SYSTEM_ITEMS_B
- Join condition between MTL_CYCLE_COUNT_ENTRIES and MTL_ITEM_LOCATIONS
- Join condition between MTL_CYCLE_COUNT_ENTRIES and MTL_SECONDARY_INVENTORIES
- Join condition between MTL_DEMAND and MTL_ITEM_LOCATIONS
- Join condition between MTL_EAM_ASSET_ACTIVITIES and MTL_SYSTEM_ITEMS_B
- Join condition between MTL_EAM_ASSET_ATTR_GROUPS and MTL_SYSTEM_ITEMS_B
- Join condition between MTL_ITEM_CATEGORIES and MTL_SYSTEM_ITEMS_B
- Join condition between MTL_ITEM_LOCATIONS and GL_CODE_COMBINATIONS
- Join condition between MTL_ITEM_LOCATIONS and MTL_MATERIAL_STATUSES_B
- Join condition between MTL_ITEM_LOCATIONS and MTL_PARAMETERS
- Join condition between MTL_ITEM_LOCATIONS and MTL_SECONDARY_INVENTORIES
- Join condition between MTL_ITEM_LOC_DEFAULTS and MTL_ITEM_LOCATIONS
- Join condition between MTL_ITEM_LOC_DEFAULTS and MTL_SECONDARY_INVENTORIES
- Join condition between MTL_ITEM_LOC_DEFAULTS and MTL_SYSTEM_ITEMS_B
- Join condition between MTL_ITEM_REVISIONS_B and MTL_SYSTEM_ITEMS_B
- Join condition between MTL_ITEM_SUB_DEFAULTS and MTL_SECONDARY_INVENTORIES
- Join condition between MTL_ITEM_SUB_DEFAULTS and MTL_SYSTEM_ITEMS_B
- Join condition between MTL_ITEM_SUB_INVENTORIES and MTL_SECONDARY_INVENTORIES
- Join condition between MTL_ITEM_SUB_INVENTORIES and MTL_SYSTEM_ITEMS_B
- Join condition between MTL_KANBAN_CARD_ACTIVITY and PO_DISTRIBUTIONS_ALL
- Join condition between MTL_KANBAN_CARD_ACTIVITY and PO_HEADERS_ALL
- Join condition between MTL_KANBAN_CARD_ACTIVITY and PO_REQUISITION_HEADERS_ALL
- Join condition between MTL_KANBAN_CARD_ACTIVITY and PO_REQUISITION_LINES_ALL
- Join condition between MTL_LOT_NUMBERS and MTL_SYSTEM_ITEMS_B
- Join condition between MTL_MATERIAL_STATUS_HISTORY and MTL_ITEM_LOCATIONS
- Join condition between MTL_MATERIAL_STATUS_HISTORY and MTL_SECONDARY_INVENTORIES
- Join condition between MTL_MATERIAL_TRANSACTIONS and CST_COST_GROUPS
- Join condition between MTL_MATERIAL_TRANSACTIONS and GL_CODE_COMBINATIONS
- Join condition between MTL_MATERIAL_TRANSACTIONS and GL_DAILY_CONVERSION_TYPES
- Join condition between MTL_MATERIAL_TRANSACTIONS and MTL_ITEM_LOCATIONS
- Join condition between MTL_MATERIAL_TRANSACTIONS and MTL_ITEM_REVISIONS_B
- Join condition between MTL_MATERIAL_TRANSACTIONS and MTL_SECONDARY_INVENTORIES
- Join condition between MTL_MATERIAL_TRANSACTIONS and MTL_SYSTEM_ITEMS_B
- Join condition between MTL_MATERIAL_TRANSACTIONS and MTL_TRANSACTION_REASONS
- Join condition between MTL_MATERIAL_TRANSACTIONS and MTL_TRANSACTION_TYPES
- Join condition between MTL_MATERIAL_TRANSACTIONS and MTL_TXN_REQUEST_LINES
- Join condition between MTL_MATERIAL_TRANSACTIONS and MTL_TXN_SOURCE_TYPES
- Join condition between MTL_MATERIAL_TRANSACTIONS and ORG_ACCT_PERIODS
- Join condition between MTL_MATERIAL_TRANSACTIONS and RCV_TRANSACTIONS
- Join condition between MTL_MATERIAL_TRANSACTIONS and WIP_DISCRETE_JOBS
- Join condition between MTL_MATERIAL_TRANSACTIONS and WIP_FLOW_SCHEDULES
- Join condition between MTL_MATERIAL_TRANSACTIONS and WIP_MOVE_TRANSACTIONS
- Join condition between MTL_MATERIAL_TRANSACTIONS and WIP_REPETITIVE_ITEMS
- Join condition between MTL_MATERIAL_TRANSACTIONS_TEMP and MTL_ITEM_LOCATIONS
- Join condition between MTL_MATERIAL_TRANSACTIONS_TEMP and MTL_RESERVATION
- Join condition between MTL_MATERIAL_TRANSACTIONS_TEMP and MTL_SECONDARY_INVENTORIES
- Join condition between MTL_MATERIAL_TRANSACTIONS_TEMP and MTL_SYSTEM_ITEMS_B
- Join condition between MTL_MATERIAL_TXN_ALLOCATIONS and MTL_MATERIAL_TRANSACTIONS
- Join condition between MTL_MFG_PART_NUMBERS and MTL_SYSTEM_ITEMS_B
- Join condition between MTL_ONHAND_QUANTITIES and MTL_ITEM_LOCATIONS
- Join condition between MTL_ONHAND_QUANTITIES and MTL_MATERIAL_TRANSACTIONS
- Join condition between MTL_ONHAND_QUANTITIES and MTL_SECONDARY_INVENTORIES
- Join condition between MTL_ONHAND_QUANTITIES and MTL_SYSTEM_ITEMS_B
- Join condition between MTL_ONHAND_QUANTITY_TEMP and MTL_ITEM_LOCATIONS
- Join condition between MTL_ONHAND_QUANTITY_TEMP and MTL_SECONDARY_INVENTORIES
- Join condition between MTL_ONHAND_QUANTITY_TEMP and MTL_SYSTEM_ITEMS_B
- Join condition between MTL_PAC_ACTUAL_COST_DETAILS and MTL_MATERIAL_TRANSACTIONS
- Join condition between MTL_PAC_COST_SUBELEMENTS and MTL_MATERIAL_TRANSACTIONS
- Join condition between MTL_PAC_TXN_COST_DETAILS and MTL_MATERIAL_TRANSACTIONS
- Join condition between MTL_PARAMETERS and MTL_SECONDARY_INVENTORIES
- Join condition between MTL_PENDING_ITEM_STATUS and MTL_SYSTEM_ITEMS_B
- Join condition between MTL_RELATED_ITEMS and MTL_SYSTEM_ITEMS_B
- Join condition between MTL_REPLENISH_HEADERS and MTL_SECONDARY_INVENTORIES
- Join condition between MTL_REPLENISH_HEADERS_INT and MTL_SECONDARY_INVENTORIES
- Join condition between MTL_REPLENISH_LINES and MTL_ITEM_LOCATIONS
- Join condition between MTL_REPLENISH_LINES and MTL_SECONDARY_INVENTORIES
- Join condition between MTL_REPLENISH_LINES and MTL_SYSTEM_ITEMS_B
- Join condition between MTL_REPLENISH_LINES_INT and MTL_ITEM_LOCATIONS
- Join condition between MTL_REPLENISH_LINES_INT and MTL_SYSTEM_ITEMS_B
- Join condition between MTL_RESERVATIONS and MTL_ITEM_LOCATIONS
- Join condition between MTL_RESERVATIONS and MTL_ITEM_REVISIONS_B
- Join condition between MTL_RESERVATIONS and MTL_LOT_NUMBERS
- Join condition between MTL_RESERVATIONS and MTL_PARAMETERS
- Join condition between MTL_RESERVATIONS and MTL_SECONDARY_INVENTORIES
- Join condition between MTL_RESERVATIONS and MTL_SYSTEM_ITEMS_B
- Join condition between MTL_RESERVATIONS and MTL_TXN_SOURCE_TYPES
- Join condition between MTL_RESERVATIONS_INTERFACE and MTL_ITEM_LOCATIONS
- Join condition between MTL_RESERVATIONS_INTERFACE and MTL_SECONDARY_INVENTORIES
- Join condition between MTL_RESERVATIONS_INTERFACE and MTL_SYSTEM_ITEMS_B
- Join condition between MTL_RESERVATIONS_INTERFACE and MTL_TXN_SOURCE_TYPES
- Join condition between MTL_SECONDARY_INVENTORIES and CST_COST_GROUPS
- Join condition between MTL_SECONDARY_INVENTORIES and ENG_ECN_APPROVAL_LISTS
- Join condition between MTL_SECONDARY_INVENTORIES and GL_CODE_COMBINATIONS
- Join condition between MTL_SECONDARY_INVENTORIES and MTL_MATERIAL_STATUSES_B
- Join condition between MTL_SECONDARY_INVENTORIES and MTL_PARAMETERS
- Join condition between MTL_SECONDARY_INVENTORIES and MTL_SECONDARY_INVENTORIES
- Join condition between MTL_SECONDARY_LOCATORS and MTL_ITEM_LOCATIONS
- Join condition between MTL_SERIAL_NUMBERS and MTL_ITEM_LOCATIONS
- Join condition between MTL_SERIAL_NUMBERS and MTL_MATERIAL_TRANSACTIONS
- Join condition between MTL_SERIAL_NUMBERS and MTL_SECONDARY_INVENTORIES
- Join condition between MTL_SERIAL_NUMBERS and MTL_SYSTEM_ITEMS_B
- Join condition between MTL_SERIAL_NUMBERS and MTL_TXN_SOURCE_TYPES
- Join condition between MTL_SO_RMA_INTERFACE and MTL_SYSTEM_ITEMS_B
- Join condition between MTL_SO_RMA_RECEIPTS and MTL_SYSTEM_ITEMS_B
- Join condition between MTL_SUPPLY and PO_DISTRIBUTIONS_ALL
- Join condition between MTL_SUPPLY and PO_HEADERS_ALL
- Join condition between MTL_SUPPLY and PO_LINES_ALL
- Join condition between MTL_SUPPLY and PO_LINE_LOCATIONS_ALL
- Join condition between MTL_SUPPLY and PO_REQUISITION_HEADERS_ALL
- Join condition between MTL_SUPPLY and PO_REQUISITION_LINES_ALL
- Join condition between MTL_SUPPLY and RCV_SHIPMENT_HEADERS
- Join condition between MTL_SUPPLY and RCV_SHIPMENT_LINES
- Join condition between MTL_SUPPLY and RCV_TRANSACTIONS
- Join condition between MTL_SYSTEM_ITEMS_B and ENG_ENGINEERING_CHANGES
- Join condition between MTL_SYSTEM_ITEMS_B and FA_CATEGORIES_B
- Join condition between MTL_SYSTEM_ITEMS_B and GL_CODE_COMBINATIONS
- Join condition between MTL_SYSTEM_ITEMS_B and GL_CODE_COMBINATIONS
- Join condition between MTL_SYSTEM_ITEMS_B and MTL_ATP_RULES
- Join condition between MTL_SYSTEM_ITEMS_B and MTL_ITEM_CATALOG_GROUPS_B
- Join condition between MTL_SYSTEM_ITEMS_B and MTL_ITEM_LOCATIONS
- Join condition between MTL_SYSTEM_ITEMS_B and MTL_ITEM_STATUS
- Join condition between MTL_SYSTEM_ITEMS_B and MTL_PARAMETERS
- Join condition between MTL_SYSTEM_ITEMS_B and MTL_PICKING_RULES
- Join condition between MTL_SYSTEM_ITEMS_B and MTL_PLANNERS
- Join condition between MTL_SYSTEM_ITEMS_B and MTL_SECONDARY_INVENTORIES
- Join condition between MTL_SYSTEM_ITEMS_B and PO_HAZARD_CLASSES_B
- Join condition between MTL_SYSTEM_ITEMS_B and PO_UN_NUMBERS_B
- Join condition between MTL_SYSTEM_ITEMS_B and RA_RULES
- Join condition between MTL_SYSTEM_ITEMS_B and RA_TERMS_B
- Join condition between MTL_SYSTEM_ITEMS_TL and MTL_SYSTEM_ITEMS_B
- Join condition between MTL_TRANSACTIONS_INTERFACE and MTL_ITEM_LOCATIONS
- Join condition between MTL_TRANSACTIONS_INTERFACE and MTL_SECONDARY_INVENTORIES
- Join condition between MTL_TRANSACTIONS_INTERFACE and MTL_SYSTEM_ITEMS_B
- Join condition between MTL_TRANSACTION_ACCOUNTS and BOM_RESOURCES
- Join condition between MTL_TRANSACTION_ACCOUNTS and CST_ACTIVITIES
- Join condition between MTL_TRANSACTION_ACCOUNTS and CST_COST_ELEMENTS
- Join condition between MTL_TRANSACTION_ACCOUNTS and FND_CURRENCIES
- Join condition between MTL_TRANSACTION_ACCOUNTS and GL_CODE_COMBINATIONS
- Join condition between MTL_TRANSACTION_ACCOUNTS and GL_ENCUMBRANCE_TYPES
- Join condition between MTL_TRANSACTION_ACCOUNTS and MTL_MATERIAL_TRANSACTIONS
- Join condition between MTL_TRANSACTION_ACCOUNTS and MTL_SYSTEM_ITEMS_B
- Join condition between MTL_TRANSACTION_ACCOUNTS and MTL_TXN_SOURCE_TYPES
- Join condition between MTL_TRANSACTION_ACCOUNTS and ORG_GL_BATCHES
- Join condition between MTL_TRANSACTION_ACCOUNTS and WIP_REPETITIVE_SCHEDULES
- Join condition between MTL_TRANSACTION_LOT_NUMBERS and MTL_MATERIAL_TRANSACTIONS
- Join condition between MTL_TRANSACTION_LOT_NUMBERS and MTL_TXN_SOURCE_TYPES
- Join condition between MTL_TRANSACTION_TYPES and MTL_TXN_SOURCE_TYPES
- Join condition between MTL_TXN_REQUEST_HEADERS and GL_CODE_COMBINATIONS
- Join condition between MTL_TXN_REQUEST_HEADERS and MTL_PARAMETERS
- Join condition between MTL_TXN_REQUEST_HEADERS and MTL_SECONDARY_INVENTORIES
- Join condition between MTL_TXN_REQUEST_HEADERS and MTL_TRANSACTION_TYPES
- Join condition between MTL_TXN_REQUEST_LINES and MTL_SECONDARY_INVENTORIES
- Join condition between MTL_TXN_REQUEST_LINES and MTL_SYSTEM_ITEMS_B
- Join condition between MTL_TXN_REQUEST_LINES and MTL_TXN_REQUEST_HEADERS
- Join condition between MTL_TXN_REQUEST_LINES and MTL_TXN_SOURCE_TYPES
- Join condition between MTL_UNIT_TRANSACTIONS and MTL_ITEM_LOCATIONS
- Join condition between MTL_UNIT_TRANSACTIONS and MTL_MATERIAL_TRANSACTIONS
- Join condition between MTL_UNIT_TRANSACTIONS and MTL_SECONDARY_INVENTORIES
- Join condition between MTL_UNIT_TRANSACTIONS and MTL_TXN_SOURCE_TYPES
- Join condition between MTL_USER_DEMAND and MTL_SYSTEM_ITEMS_B
- Join condition between MTL_USER_SUPPLY and MTL_SYSTEM_ITEMS_B
- Join condition between MTL_USER_SUPPLY and PO_HEADERS_ALL
- Join condition between OE_DROP_SHIP_SOURCES and OE_ORDER_HEADERS_ALL
- Join condition between OE_DROP_SHIP_SOURCES and OE_ORDER_LINES_ALL
- Join condition between OE_DROP_SHIP_SOURCES and PO_HEADERS_ALL
- Join condition between OE_DROP_SHIP_SOURCES and PO_LINES_ALL
- Join condition between OE_DROP_SHIP_SOURCES and PO_REQUISITION_HEADERS_ALL
- Join condition between OE_DROP_SHIP_SOURCES and PO_REQUISITION_LINES_ALL
- Join condition between OE_HEADERS_IFACE_ALL and OE_ORDER_HEADERS_ALL
- Join condition between OE_HEADER_ACKS and OE_ORDER_HEADERS_ALL
- Join condition between OE_HOLD_DEFINITIONS and WF_ITEM_TYPES
- Join condition between OE_HOLD_RELEASES and OE_HOLD_SOURCES_AL
- Join condition between OE_HOLD_RELEASES and OE_HOLD_SOURCES_ALL
- Join condition between OE_HOLD_SOURCES_ALL and HR_ALL_ORGANIZATION_UNITS
- Join condition between OE_HOLD_SOURCES_ALL and OE_HOLD_DEFINITIONS
- Join condition between OE_HOLD_SOURCES_ALL and OE_ORDER_HEADERS_ALL
- Join condition between OE_HOLD_SOURCES_ALL and RA_CUSTOMERS
- Join condition between OE_HOLD_SOURCES_ALL and RA_SITE_USES_ALL
- Join condition between OE_LINE_ACKS and OE_ORDER_HEADERS_ALL
- Join condition between OE_LINE_ACKS and OE_ORDER_LINES_ALL
- Join condition between OE_LINE_SETS and OE_ORDER_LINES_ALL
- Join condition between OE_LOT_SERIAL_NUMBERS and OE_ORDER_LINES_ALL
- Join condition between OE_ORDER_HEADERS_ALL and FND_APPLICATION
- Join condition between OE_ORDER_HEADERS_ALL and HR_ALL_ORGANIZATION_UNITS
- Join condition between OE_ORDER_HEADERS_ALL and HZ_CUST_ACCOUNTS
- Join condition between OE_ORDER_HEADERS_ALL and HZ_CUST_ACCOUNT_ROLES
- Join condition between OE_ORDER_HEADERS_ALL and HZ_CUST_SITE_USES_ALL
- Join condition between OE_ORDER_HEADERS_ALL and OE_AGREEMENTS_B
- Join condition between OE_ORDER_HEADERS_ALL and OE_ORDER_SOURCES
- Join condition between OE_ORDER_HEADERS_ALL and OE_TRANSACTION_TYPES_ALL
- Join condition between OE_ORDER_HEADERS_ALL and QP_LIST_HEADERS_B
- Join condition between OE_ORDER_HEADERS_ALL and RA_RULES
- Join condition between OE_ORDER_HEADERS_ALL and RA_SALESREPS_ALL
- Join condition between OE_ORDER_HEADERS_ALL and RA_TERMS_B
- Join condition between OE_ORDER_HOLDS_ALL and OE_HOLD_SOURCES_ALL
- Join condition between OE_ORDER_HOLDS_ALL and OE_ORDER_HEADERS_ALL
- Join condition between OE_ORDER_HOLDS_ALL and OE_ORDER_LINES_ALL
- Join condition between OE_ORDER_LINES_ALL and BOM_COMPONENTS_B
- Join condition between OE_ORDER_LINES_ALL and FND_APPLICATION
- Join condition between OE_ORDER_LINES_ALL and HR_ALL_ORGANIZATION_UNITS
- Join condition between OE_ORDER_LINES_ALL and HZ_CUST_ACCOUNTS
- Join condition between OE_ORDER_LINES_ALL and HZ_CUST_ACCOUNT_ROLES
- Join condition between OE_ORDER_LINES_ALL and HZ_CUST_SITE_USES_ALL
- Join condition between OE_ORDER_LINES_ALL and IBE_MSITES_B
- Join condition between OE_ORDER_LINES_ALL and MTL_CROSS_REFERENCE_TYPES
- Join condition between OE_ORDER_LINES_ALL and MTL_CUSTOMER_ITEMS
- Join condition between OE_ORDER_LINES_ALL and OE_AGREEMENTS_B
- Join condition between OE_ORDER_LINES_ALL and OE_ORDER_HEADERS_ALL
- Join condition between OE_ORDER_LINES_ALL and OE_ORDER_LINES_ALL
- Join condition between OE_ORDER_LINES_ALL and OE_ORDER_SOURCES
- Join condition between OE_ORDER_LINES_ALL and OE_SETS
- Join condition between OE_ORDER_LINES_ALL and OE_TRANSACTION_TYPES_ALL
- Join condition between OE_ORDER_LINES_ALL and QP_LIST_HEADERS_B
- Join condition between OE_ORDER_LINES_ALL and RA_CUSTOMER_TRX_LINES_ALL
- Join condition between OE_ORDER_LINES_ALL and RA_RULES
- Join condition between OE_ORDER_LINES_ALL and RA_SALESREPS_ALL
- Join condition between OE_ORDER_LINES_ALL and RA_TERMS_B
- Join condition between OE_ORDER_LINES_HISTORY and OE_ORDER_LINES_ALL
- Join condition between OE_ORDER_PRICE_ATTRIBS and OE_ORDER_HEADERS_ALL
- Join condition between OE_ORDER_PRICE_ATTRIBS and OE_ORDER_LINES_ALL
- Join condition between OE_PRICE_ADJUSTMENTS and OE_ORDER_HEADERS_ALL
- Join condition between OE_PRICE_ADJUSTMENTS and OE_ORDER_LINES_ALL
- Join condition between OE_PRICE_ADJ_ASSOCS and OE_ORDER_LINES_ALL
- Join condition between OE_SALES_CREDITS and OE_ORDER_HEADERS_ALL
- Join condition between OE_SETS and OE_ORDER_HEADERS_ALL
- Join condition between OE_TRANSACTION_TYPES_TL and OE_TRANSACTION_TYPES_ALL
- Join condition between OKL_SUBSIDY_CRITERIA and MTL_SYSTEM_ITEMS_B
- Join condition between OZF_CLAIMS_ALL and OE_ORDER_HEADERS_ALL
- Join condition between OZF_RETAIL_PRICE_POINTS and MTL_SYSTEM_ITEMS_B
- Join condition between PA_BC_COMMITMENTS_ALL and PO_DISTRIBUTIONS_ALL
- Join condition between PA_BC_COMMITMENTS_ALL and PO_HEADERS_ALL
- Join condition between PA_BC_COMMITMENTS_ALL and PO_REQ_DISTRIBUTIONS_ALL
- Join condition between PA_BC_PACKETS and PO_HEADERS_ALL
- Join condition between PA_CI_SUPPLIER_DETAILS and PO_HEADERS_ALL
- Join condition between PA_CI_SUPPLIER_DETAILS and PO_LINES_ALL
- Join condition between PA_EXPENDITURE_ITEMS_AR and PO_LINES_ALL
- Join condition between PA_RESOURCE_ASSIGNMENTS and MTL_CATEGORIES_B
- Join condition between PA_RESOURCE_LIST_MEMBERS and MTL_CATEGORIES_B
- Join condition between PA_TRANSACTION_INTERFACE_ALL and PO_HEADERS_ALL
- Join condition between PA_TRANSACTION_INTERFACE_ALL and PO_LINES_ALL
- Join condition between PA_TXN_INTERFACE_AUDIT_ALL and PO_HEADERS_ALL
- Join condition between PA_TXN_INTERFACE_AUDIT_ALL and PO_LINES_ALL
- Join condition between PA_TXN_INTERFACE_AUDIT_AR and PO_HEADERS_ALL
- Join condition between PA_TXN_INTERFACE_AUDIT_AR and PO_LINES_ALL
- Join condition between PJM_BORROW_PAYBACKS and MTL_MATERIAL_TRANSACTIONS
- Join condition between PJM_BORROW_TRANSACTIONS and MTL_MATERIAL_TRANSACTIONS
- Join condition between PJM_BORROW_TRANSACTIONS and MTL_SYSTEM_ITEMS_B
- Join condition between PJM_DEFAULT_TASKS and MTL_CATEGORIES_B
- Join condition between PJM_DEFAULT_TASKS and MTL_SECONDARY_INVENTORIES
- Join condition between PJM_DEFAULT_TASKS and MTL_SYSTEM_ITEMS_B
- Join condition between PJM_DEFAULT_TASKS and PO_HEADERS_ALL
- Join condition between PJM_UNIT_NUMBERS and MTL_SYSTEM_ITEMS_B
- Join condition between PON_AUCTION_ITEM_PRICES_ALL and MTL_CATEGORIES_B
- Join condition between PON_AUC_ITEMS_INTERFACE and MTL_CATEGORIES_B
- Join condition between PON_AWARD_ALLOCATIONS and PO_REQUISITION_HEADERS_ALL
- Join condition between PON_AWARD_ALLOCATIONS and PO_REQUISITION_LINES_ALL
- Join condition between PON_BACKING_REQUISITIONS and PO_REQUISITION_HEADERS_ALL
- Join condition between PON_BACKING_REQUISITIONS and PO_REQUISITION_LINES_ALL
- Join condition between PO_ACCEPTANCES and PO_HEADERS_ALL
- Join condition between PO_ACCEPTANCES and PO_LINE_LOCATIONS_ALL
- Join condition between PO_ACCRUAL_RECONCILE_TEMP_ALL and MTL_MATERIAL_TRANSACTIONS
- Join condition between PO_ACCRUAL_RECONCILE_TEMP_ALL and PO_DISTRIBUTIONS_ALL
- Join condition between PO_ACCRUAL_RECONCILE_TEMP_ALL and PO_HEADERS_ALL
- Join condition between PO_ACCRUAL_RECONCILE_TEMP_ALL and PO_LINES_ALL
- Join condition between PO_ACCRUAL_RECONCILE_TEMP_ALL and RCV_TRANSACTIONS
- Join condition between PO_ACCRUAL_WRITE_OFFS_ALL and MTL_MATERIAL_TRANSACTIONS
- Join condition between PO_ACCRUAL_WRITE_OFFS_ALL and PO_DISTRIBUTIONS_ALL
- Join condition between PO_ACCRUAL_WRITE_OFFS_ALL and PO_HEADERS_ALL
- Join condition between PO_ACCRUAL_WRITE_OFFS_ALL and PO_LINES_ALL
- Join condition between PO_ACCRUAL_WRITE_OFFS_ALL and RCV_TRANSACTIONS
- Join condition between PO_ACTION_HISTORY and PO_HEADERS_ALL
- Join condition between PO_ACTION_HISTORY and PO_REQUISITION_HEADERS_ALL
- Join condition between PO_AGENTS and MTL_CATEGORIES_B
- Join condition between PO_AUTOSOURCE_DOCUMENTS_ALL and PO_HEADERS_ALL
- Join condition between PO_AUTOSOURCE_DOCUMENTS_ALL and PO_LINES_ALL
- Join condition between PO_COMMODITY_CATEGORIES and MTL_CATEGORIES_B
- Join condition between PO_DISTRIBUTIONS_ALL and BOM_RESOURCES
- Join condition between PO_DISTRIBUTIONS_ALL and GL_CODE_COMBINATIONS
- Join condition between PO_DISTRIBUTIONS_ALL and GL_SETS_OF_BOOKS
- Join condition between PO_DISTRIBUTIONS_ALL and MTL_SECONDARY_INVENTORIES
- Join condition between PO_DISTRIBUTIONS_ALL and MTL_SECONDARY_INVENTORIES
- Join condition between PO_DISTRIBUTIONS_ALL and PA_TASKS
- Join condition between PO_DISTRIBUTIONS_ALL and PO_HEADERS_ALL
- Join condition between PO_DISTRIBUTIONS_ALL and PO_LINES_ALL
- Join condition between PO_DISTRIBUTIONS_ALL and PO_LINE_LOCATIONS_ALL
- Join condition between PO_DISTRIBUTIONS_ALL and PO_RELEASES_ALL
- Join condition between PO_DISTRIBUTIONS_ALL and PO_REQ_DISTRIBUTIONS_ALL
- Join condition between PO_DISTRIBUTIONS_ARCHIVE_ALL and MTL_SECONDARY_INVENTORIES
- Join condition between PO_DISTRIBUTIONS_ARCHIVE_ALL and PO_DISTRIBUTIONS_ALL
- Join condition between PO_DISTRIBUTIONS_ARCHIVE_ALL and PO_HEADERS_ALL
- Join condition between PO_DISTRIBUTIONS_ARCHIVE_ALL and PO_LINES_ALL
- Join condition between PO_DISTRIBUTIONS_ARCHIVE_ALL and PO_LINE_LOCATIONS_ALL
- Join condition between PO_DISTRIBUTIONS_ARCHIVE_ALL and PO_REQ_DISTRIBUTIONS_ALL
- Join condition between PO_HEADERS_ALL and FND_CURRENCIES
- Join condition between PO_HEADERS_ALL and GL_DAILY_CONVERSION_TYPES
- Join condition between PO_HEADERS_ALL and HR_LOCATIONS_ALL
- Join condition between PO_HEADERS_ALL and PO_AGENTS
- Join condition between PO_HEADERS_ALL and PO_VENDORS
- Join condition between PO_HEADERS_ALL and PO_VENDOR_CONTACTS
- Join condition between PO_HEADERS_ALL and PO_VENDOR_SITES_ALL
- Join condition between PO_HEADERS_ARCHIVE_ALL and PO_HEADERS_ALL
- Join condition between PO_HISTORY_REQUISITIONS_ALL and PO_REQUISITION_HEADERS_ALL
- Join condition between PO_LINES_ALL and MTL_CATEGORIES_B
- Join condition between PO_LINES_ALL and MTL_SYSTEM_ITEMS_B
- Join condition between PO_LINES_ALL and PO_HAZARD_CLASSES_B
- Join condition between PO_LINES_ALL and PO_HEADERS_ALL
- Join condition between PO_LINES_ALL and PO_LINES_ALL
- Join condition between PO_LINES_ALL and PO_LINE_TYPES_B
- Join condition between PO_LINES_ALL and PO_UN_NUMBERS_B
- Join condition between PO_LINES_ARCHIVE_ALL and PO_HEADERS_ALL
- Join condition between PO_LINES_ARCHIVE_ALL and PO_LINES_ALL
- Join condition between PO_LINE_LOCATIONS_ALL and AP_TAX_CODES_ALL
- Join condition between PO_LINE_LOCATIONS_ALL and HR_LOCATIONS_ALL
- Join condition between PO_LINE_LOCATIONS_ALL and PO_HEADERS_ALL
- Join condition between PO_LINE_LOCATIONS_ALL and PO_LINES_ALL
- Join condition between PO_LINE_LOCATIONS_ALL and PO_LINE_LOCATIONS_ALL
- Join condition between PO_LINE_LOCATIONS_ALL and PO_RELEASES_ALL
- Join condition between PO_LINE_LOCATIONS_ALL and RCV_ROUTING_HEADERS
- Join condition between PO_LINE_LOCATIONS_ARCHIVE_ALL and PO_HEADERS_ALL
- Join condition between PO_LINE_LOCATIONS_ARCHIVE_ALL and PO_LINES_ALL
- Join condition between PO_LINE_LOCATIONS_ARCHIVE_ALL and PO_LINE_LOCATIONS_ALL
- Join condition between PO_LINE_TYPES_B and MTL_CATEGORIES_B
- Join condition between PO_MASSCANCEL_INTERIM and PO_HEADERS_ALL
- Join condition between PO_MASSCANCEL_INTERIM and PO_REQUISITION_HEADERS_ALL
- Join condition between PO_NOTIFICATIONS_ALL and PO_HEADERS_ALL
- Join condition between PO_NOTIFICATIONS_ALL and PO_REQUISITION_HEADERS_ALL
- Join condition between PO_NOTIFICATION_CONTROLS and PO_HEADERS_ALL
- Join condition between PO_ONLINE_REPORT_TEXT and RCV_TRANSACTIONS
- Join condition between PO_PURGE_PO_LIST and PO_HEADERS_ALL
- Join condition between PO_PURGE_REQ_LIST and PO_REQUISITION_HEADERS_ALL
- Join condition between PO_QUOTATION_APPROVALS_ALL and PO_LINE_LOCATIONS_ALL
- Join condition between PO_RELEASES_ALL and PO_HEADERS_ALL
- Join condition between PO_REQEXPRESS_LINES_ALL and PO_HEADERS_ALL
- Join condition between PO_REQUISITIONS_INTERFACE_ALL and MTL_CATEGORIES_B
- Join condition between PO_REQUISITIONS_INTERFACE_ALL and MTL_SECONDARY_INVENTORIES
- Join condition between PO_REQUISITIONS_INTERFACE_ALL and PO_REQUISITION_HEADERS_ALL
- Join condition between PO_REQUISITIONS_INTERFACE_ALL and PO_REQUISITION_LINES_ALL
- Join condition between PO_REQUISITIONS_INTERFACE_ALL and PO_REQ_DISTRIBUTIONS_ALL
- Join condition between PO_REQUISITION_LINES_ALL and AP_TAX_CODES_ALL
- Join condition between PO_REQUISITION_LINES_ALL and BOM_RESOURCES
- Join condition between PO_REQUISITION_LINES_ALL and FND_CURRENCIES
- Join condition between PO_REQUISITION_LINES_ALL and GL_DAILY_CONVERSION_TYPES
- Join condition between PO_REQUISITION_LINES_ALL and MTL_CATEGORIES_B
- Join condition between PO_REQUISITION_LINES_ALL and PO_AGENTS
- Join condition between PO_REQUISITION_LINES_ALL and PO_HAZARD_CLASSES_B
- Join condition between PO_REQUISITION_LINES_ALL and PO_HEADERS_ALL
- Join condition between PO_REQUISITION_LINES_ALL and PO_LINE_LOCATIONS_ALL
- Join condition between PO_REQUISITION_LINES_ALL and PO_LINE_TYPES_B
- Join condition between PO_REQUISITION_LINES_ALL and PO_REQUISITION_HEADERS_ALL
- Join condition between PO_REQUISITION_LINES_ALL and PO_REQUISITION_LINES_ALL
- Join condition between PO_REQUISITION_LINES_ALL and PO_UN_NUMBERS_B
- Join condition between PO_REQUISITION_LINES_ALL and PO_VENDORS
- Join condition between PO_REQUISITION_LINES_ALL and PO_VENDOR_CONTACTS
- Join condition between PO_REQUISITION_LINES_ALL and PO_VENDOR_SITES_ALL
- Join condition between PO_REQUISITION_LINES_ALL and WIP_ENTITIES
- Join condition between PO_REQUISITION_LINES_ALL and WIP_LINES
- Join condition between PO_REQUISITION_LINES_ALL and WIP_REPETITIVE_SCHEDULES
- Join condition between PO_REQ_DISTRIBUTIONS_ALL and GL_CODE_COMBINATIONS
- Join condition between PO_REQ_DISTRIBUTIONS_ALL and GL_SETS_OF_BOOKS
- Join condition between PO_REQ_DISTRIBUTIONS_ALL and PA_EXPENDITURE_TYPES
- Join condition between PO_REQ_DISTRIBUTIONS_ALL and PA_PROJECTS_ALL
- Join condition between PO_REQ_DISTRIBUTIONS_ALL and PA_TASKS
- Join condition between PO_REQ_DISTRIBUTIONS_ALL and PO_REQUISITION_LINES_ALL
- Join condition between PO_REQ_DISTRIBUTIONS_ALL and PO_REQ_DISTRIBUTIONS_ALL
- Join condition between PO_RFQ_VENDORS and PO_HEADERS_ALL
- Join condition between PV_PG_ENRL_REQUESTS and OE_ORDER_HEADERS_ALL
- Join condition between QA_RESULTS and MTL_SYSTEM_ITEMS_B
- Join condition between RCV_ACCOUNTING_EVENTS and PO_DISTRIBUTIONS_ALL
- Join condition between RCV_ACCOUNTING_EVENTS and PO_HEADERS_ALL
- Join condition between RCV_ACCOUNTING_EVENTS and PO_LINES_ALL
- Join condition between RCV_ACCOUNTING_EVENTS and PO_LINE_LOCATIONS_ALL
- Join condition between RCV_ACCOUNTING_EVENTS and RCV_TRANSACTIONS
- Join condition between RCV_LOTS_INTERFACE and RCV_SHIPMENT_LINES
- Join condition between RCV_LOTS_SUPPLY and RCV_SHIPMENT_LINES
- Join condition between RCV_LOTS_SUPPLY and RCV_TRANSACTIONS
- Join condition between RCV_LOT_TRANSACTIONS and RCV_SHIPMENT_LINES
- Join condition between RCV_LOT_TRANSACTIONS and RCV_TRANSACTIONS
- Join condition between RCV_RECEIVING_SUB_LEDGER and RCV_TRANSACTIONS
- Join condition between RCV_SERIALS_SUPPLY and RCV_SHIPMENT_LINES
- Join condition between RCV_SERIALS_SUPPLY and RCV_TRANSACTIONS
- Join condition between RCV_SERIAL_TRANSACTIONS and RCV_SHIPMENT_LINES
- Join condition between RCV_SERIAL_TRANSACTIONS and RCV_TRANSACTIONS
- Join condition between RCV_SHIPMENT_HEADERS and PO_VENDORS
- Join condition between RCV_SHIPMENT_HEADERS and PO_VENDOR_SITES_ALL
- Join condition between RCV_SHIPMENT_LINES and GL_CODE_COMBINATIONS
- Join condition between RCV_SHIPMENT_LINES and MTL_CATEGORIES_B
- Join condition between RCV_SHIPMENT_LINES and MTL_SECONDARY_INVENTORIES
- Join condition between RCV_SHIPMENT_LINES and MTL_SECONDARY_INVENTORIES
- Join condition between RCV_SHIPMENT_LINES and MTL_SYSTEM_ITEMS_B
- Join condition between RCV_SHIPMENT_LINES and MTL_TRANSACTION_REASONS
- Join condition between RCV_SHIPMENT_LINES and PO_DISTRIBUTIONS_ALL
- Join condition between RCV_SHIPMENT_LINES and PO_HEADERS_ALL
- Join condition between RCV_SHIPMENT_LINES and PO_LINES_ALL
- Join condition between RCV_SHIPMENT_LINES and PO_LINE_LOCATIONS_ALL
- Join condition between RCV_SHIPMENT_LINES and PO_RELEASES_ALL
- Join condition between RCV_SHIPMENT_LINES and PO_REQUISITION_LINES_ALL
- Join condition between RCV_SHIPMENT_LINES and PO_REQ_DISTRIBUTIONS_ALL
- Join condition between RCV_SHIPMENT_LINES and RCV_SHIPMENT_HEADERS
- Join condition between RCV_SUPPLY and MTL_SECONDARY_INVENTORIES
- Join condition between RCV_SUPPLY and PO_DISTRIBUTIONS_ALL
- Join condition between RCV_SUPPLY and PO_HEADERS_ALL
- Join condition between RCV_SUPPLY and PO_LINES_ALL
- Join condition between RCV_SUPPLY and PO_LINE_LOCATIONS_ALL
- Join condition between RCV_SUPPLY and PO_REQUISITION_HEADERS_ALL
- Join condition between RCV_SUPPLY and PO_REQUISITION_LINES_ALL
- Join condition between RCV_SUPPLY and RCV_SHIPMENT_HEADERS
- Join condition between RCV_SUPPLY and RCV_SHIPMENT_LINES
- Join condition between RCV_SUPPLY and RCV_TRANSACTIONS
- Join condition between RCV_TRANSACTIONS and BOM_RESOURCES
- Join condition between RCV_TRANSACTIONS and GL_DAILY_CONVERSION_TYPES
- Join condition between RCV_TRANSACTIONS and HR_LOCATIONS_ALL
- Join condition between RCV_TRANSACTIONS and MTL_ITEM_LOCATIONS
- Join condition between RCV_TRANSACTIONS and MTL_ITEM_LOCATIONS
- Join condition between RCV_TRANSACTIONS and MTL_MATERIAL_TRANSACTIONS
- Join condition between RCV_TRANSACTIONS and MTL_SECONDARY_INVENTORIES
- Join condition between RCV_TRANSACTIONS and MTL_SECONDARY_INVENTORIES
- Join condition between RCV_TRANSACTIONS and MTL_TRANSACTION_REASONS
- Join condition between RCV_TRANSACTIONS and PO_DISTRIBUTIONS_ALL
- Join condition between RCV_TRANSACTIONS and PO_HEADERS_ALL
- Join condition between RCV_TRANSACTIONS and PO_LINES_ALL
- Join condition between RCV_TRANSACTIONS and PO_LINE_LOCATIONS_ALL
- Join condition between RCV_TRANSACTIONS and PO_RELEASES_ALL
- Join condition between RCV_TRANSACTIONS and PO_REQUISITION_LINES_ALL
- Join condition between RCV_TRANSACTIONS and PO_REQ_DISTRIBUTIONS_ALL
- Join condition between RCV_TRANSACTIONS and PO_VENDORS
- Join condition between RCV_TRANSACTIONS and PO_VENDOR_SITES_ALL
- Join condition between RCV_TRANSACTIONS and RCV_ROUTING_HEADERS
- Join condition between RCV_TRANSACTIONS and RCV_ROUTING_STEPS
- Join condition between RCV_TRANSACTIONS and RCV_SHIPMENT_HEADERS
- Join condition between RCV_TRANSACTIONS and RCV_SHIPMENT_LINES
- Join condition between RCV_TRANSACTIONS and RCV_TRANSACTIONS
- Join condition between RCV_TRANSACTIONS_INTERFACE and MTL_ITEM_LOCATIONS
- Join condition between RCV_TRANSACTIONS_INTERFACE and MTL_MATERIAL_TRANSACTIONS
- Join condition between RCV_TRANSACTIONS_INTERFACE and MTL_SECONDARY_INVENTORIES
- Join condition between RCV_TRANSACTIONS_INTERFACE and PO_DISTRIBUTIONS_ALL
- Join condition between RCV_TRANSACTIONS_INTERFACE and PO_HEADERS_ALL
- Join condition between RCV_TRANSACTIONS_INTERFACE and PO_LINES_ALL
- Join condition between RCV_TRANSACTIONS_INTERFACE and PO_LINE_LOCATIONS_ALL
- Join condition between RCV_TRANSACTIONS_INTERFACE and PO_REQUISITION_LINES_ALL
- Join condition between RCV_TRANSACTIONS_INTERFACE and PO_REQ_DISTRIBUTIONS_ALL
- Join condition between RCV_TRANSACTIONS_INTERFACE and RCV_SHIPMENT_HEADERS
- Join condition between RCV_TRANSACTIONS_INTERFACE and RCV_SHIPMENT_HEADERS
- Join condition between RCV_TRANSACTIONS_INTERFACE and RCV_SHIPMENT_LINES
- Join condition between RCV_TRANSACTIONS_INTERFACE and RCV_TRANSACTIONS
- Join condition between SO_DROP_SHIP_SOURCES and PO_HEADERS_ALL
- Join condition between SO_DROP_SHIP_SOURCES and PO_LINES_ALL
- Join condition between SO_DROP_SHIP_SOURCES and PO_LINE_LOCATIONS_ALL
- Join condition between SO_DROP_SHIP_SOURCES and PO_REQUISITION_HEADERS_ALL
- Join condition between SO_DROP_SHIP_SOURCES and PO_REQUISITION_LINES_ALL
- Join condition between WIP_COST_TXN_INTERFACE and MTL_SYSTEM_ITEMS_B
- Join condition between WIP_COST_TXN_INTERFACE and PO_HEADERS_ALL
- Join condition between WIP_COST_TXN_INTERFACE and PO_LINES_ALL
- Join condition between WIP_COST_TXN_INTERFACE and RCV_TRANSACTIONS
- Join condition between WIP_DISCRETE_JOBS and MTL_ITEM_LOCATIONS
- Join condition between WIP_DISCRETE_JOBS and MTL_SECONDARY_INVENTORIES
- Join condition between WIP_DISCRETE_JOBS and MTL_SYSTEM_ITEMS_B
- Join condition between WIP_ENTITIES and MTL_SYSTEM_ITEMS_B
- Join condition between WIP_FLOW_SCHEDULES and MTL_ITEM_LOCATIONS
- Join condition between WIP_FLOW_SCHEDULES and MTL_SYSTEM_ITEMS_B
- Join condition between WIP_MOVE_TXN_INTERFACE and MTL_SYSTEM_ITEMS_B
- Join condition between WIP_PARAMETERS and MTL_ITEM_LOCATIONS
- Join condition between WIP_PARAMETERS and MTL_SECONDARY_INVENTORIES
- Join condition between WIP_REPETITIVE_ITEMS and MTL_ITEM_LOCATIONS
- Join condition between WIP_REPETITIVE_ITEMS and MTL_SECONDARY_INVENTORIES
- Join condition between WIP_REPETITIVE_ITEMS and MTL_SYSTEM_ITEMS_B
- Join condition between WIP_REQUIREMENT_OPERATIONS and MTL_ITEM_LOCATIONS
- Join condition between WIP_REQUIREMENT_OPERATIONS and MTL_SECONDARY_INVENTORIES
- Join condition between WIP_REQUIREMENT_OPERATIONS and MTL_SYSTEM_ITEMS_B
- Join condition between WIP_SCRAP_VALUES and MTL_MATERIAL_TRANSACTIONS
- Join condition between WIP_TEMP_REPORTS and MTL_SYSTEM_ITEMS_B
- Join condition between WIP_TRANSACTIONS and MTL_SYSTEM_ITEMS_B
- Join condition between WIP_TRANSACTIONS and PO_HEADERS_ALL
- Join condition between WIP_TRANSACTIONS and PO_LINES_ALL
- Join condition between WIP_TRANSACTIONS and RCV_TRANSACTIONS
- Join condition between WMS_DEPARTMENT_SUBINVENTORIES and MTL_SECONDARY_INVENTORIES
- Join condition between WMS_DISPATCHED_TASKS_HISTORY and MTL_MATERIAL_TRANSACTIONS
- Join condition between WMS_DOCK_APPOINTMENTS_B and MTL_ITEM_LOCATIONS
- Join condition between WMS_LICENSE_PLATE_NUMBERS and MTL_ITEM_LOCATIONS
- Join condition between WMS_LICENSE_PLATE_NUMBERS and MTL_SECONDARY_INVENTORIES
- Join condition between WMS_LICENSE_PLATE_NUMBERS and MTL_SYSTEM_ITEMS_B
- Join condition between WMS_LPN_CONTENTS and MTL_SYSTEM_ITEMS_B
- Join condition between WMS_LPN_HISTORIES and MTL_ITEM_LOCATIONS
- Join condition between WMS_LPN_HISTORIES and MTL_SECONDARY_INVENTORIES
- Join condition between WMS_LPN_HISTORIES and MTL_SYSTEM_ITEMS_B
- Join condition between WMS_LPN_INTERFACE and MTL_ITEM_LOCATIONS
- Join condition between WMS_LPN_INTERFACE and MTL_SECONDARY_INVENTORIES
- Join condition between WMS_LPN_INTERFACE and MTL_SYSTEM_ITEMS_B
- Join condition between WMS_SHIPPING_TRANSACTION_TEMP and MTL_ITEM_LOCATIONS
- Join condition between WMS_SHIPPING_TRANSACTION_TEMP and MTL_SYSTEM_ITEMS_B
- Join condition between WSH_PACKED_CONTAINERS and MTL_SYSTEM_ITEMS_B
- Join condition between WSM_CO_PRODUCTS and MTL_ITEM_LOCATIONS
- Join condition between WSM_CO_PRODUCTS and MTL_SECONDARY_INVENTORIES
- Join condition between WSM_LOT_JOB_INTERFACE and MTL_ITEM_LOCATIONS
- Join condition between WSM_LOT_JOB_INTERFACE and MTL_SECONDARY_INVENTORIES
- Join condition between WSM_RESULTING_LOTS_INTERFACE and MTL_ITEM_LOCATIONS
- Join condition between WSM_RESULTING_LOTS_INTERFACE and MTL_SECONDARY_INVENTORIES
- Join condition between WSM_SM_RESULTING_LOTS and MTL_ITEM_LOCATIONS
- Join condition between WSM_SM_STARTING_LOTS and MTL_ITEM_LOCATIONS
- Join condition between WSM_SM_STARTING_LOTS and MTL_SECONDARY_INVENTORIES
- Join condition between WSM_STARTING_LOTS_INTERFACE and MTL_ITEM_LOCATIONS
- Join condition between WSM_STARTING_LOTS_INTERFACE and MTL_SECONDARY_INVENTORIES
- Join condition between WSM_SUBINVENTORY_EXTENSIONS and MTL_SECONDARY_INVENTORIES
- Join condition between XDP_ORDER_LINE_ITEMS and MTL_SYSTEM_ITEMS_B
- Join condition between XDP_SERVICE_VAL_ACTS and MTL_SYSTEM_ITEMS_B
- Join condition between XNC_FESW_REST_B and MTL_SYSTEM_ITEMS_B
- Join condition between XNC_ITEM_ACTIONS_B and MTL_SYSTEM_ITEMS_B
- Join condition between ZX_EXCEPTIONS and MTL_SYSTEM_ITEMS_B
can anybody please provide the differences between Intercompany sales query and Account receivables queries
ReplyDeletePlease find below query for account receivables data
DeleteSELECT
ACCOUNT_NAME,
ACCOUNT_NUMBER,
RCT.TRX_NUMBER,
EXTENDED_AMOUNT,
GROSS_EXTENDED_AMOUNT,
RCTD.GL_DATE
FROM
HZ_CUST_ACCOUNTS HCA,
RA_CUSTOMER_TRX RCT,
RA_CUSTOMER_TRX_LINES RCTL,
RA_CUST_TRX_LINE_GL_DIST_ALL RCTD
WHERE HCA.CUST_ACCOUNT_ID=RCT.BILL_TO_CUSTOMER_ID
AND RCT.CUSTOMER_TRX_ID=RCTL.CUSTOMER_TRX_ID
AND RCTL.CUSTOMER_TRX_LINE_ID=RCTD.CUSTOMER_TRX_LINE_ID