Query to find Org ID attached to responsibility

Query to find Org ID attached to responsibility

Get Org id from Responsibility Name

1 2 3 4 5 6 7 8 9 10 11 12 13 14

SELECT frv.responsibility_name, fpov.profile_option_value org_id, hou.NAME FROM apps.hr_organization_units hou, apps.fnd_profile_options_vl fpo, apps.fnd_profile_option_values fpov, apps.fnd_responsibility_vl frv WHERE frv.responsibility_name = <Responsibility Name> AND fpov.level_value = frv.responsibility_id AND fpo.profile_option_id = fpov.profile_option_id AND fpo.user_profile_option_name = 'MO: Operating Unit' AND fpov.profile_option_id = fpo.profile_option_id AND hou.organization_id = TO_NUMBER (fpov.profile_option_value) ORDER BY frv.responsibility_name

Query to find responsibility for Operating Unit or Org_id

1 2 3 4 5 6 7 8 9 10 11 12 13

SELECT frv.responsibility_name, fpov.profile_option_value org_id, hou.NAME FROM apps.fnd_profile_options_vl fpo, apps.fnd_responsibility_vl frv, apps.fnd_profile_option_values fpov, apps.hr_organization_units hou WHERE hou.NAME = <OU Name> AND fpov.profile_option_value = TO_CHAR (hou.organization_id) AND fpo.profile_option_id = fpov.profile_option_id AND fpo.user_profile_option_name = 'MO: Operating Unit' AND frv.responsibility_id = fpov.level_value ORDER BY frv.responsibility_name

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 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