DBA Data[Home] [Help]

APPS.MSC_X_VMI_POREQ dependencies on MTL_CUSTOMER_ITEMS

Line 744: OE_BLANKET_HEADERS_EXT BHE, mtl_customer_items citems

740: AND (OL.Lookup_type = 'ITEM_IDENTIFIER_TYPE' AND OL.Lookup_code = BL.ITEM_IDENTIFIER_TYPE)
741: UNION ALL
742: SELECT BH.ORDER_NUMBER order_number, bh.TRANSACTIONAL_CURR_CODE curr, bh.FLOW_STATUS_CODE status
743: FROM OE_BLANKET_LINES BL, OE_BLANKET_HEADERS BH, OE_BLANKET_LINES_EXT BLE,
744: OE_BLANKET_HEADERS_EXT BHE, mtl_customer_items citems
745: ,OE_LOOKUPS OL, HZ_PARTIES PARTY, HZ_CUST_ACCOUNTS ACCT
746: WHERE BH. HEADER_ID = BL.HEADER_ID
747: AND BH.SOLD_TO_ORG_ID = ACCT.CUST_ACCOUNT_ID(+)
748: AND PARTY.PARTY_ID(+) = ACCT.PARTY_ID