DBA Data[Home] [Help]

APPS.MSC_X_VMI_POREQ dependencies on MTL_CATEGORIES

Line 801: MTL_CATEGORIES C, OE_BLANKET_LINES_EXT BLE,

797: AND BL.LINE_ID = BLE.LINE_ID AND BH.ORDER_NUMBER = BHE.ORDER_NUMBER
798: UNION ALL
799: SELECT BH.ORDER_NUMBER order_number, bh.TRANSACTIONAL_CURR_CODE curr, bh.FLOW_STATUS_CODE status
800: FROM OE_BLANKET_LINES BL,OE_BLANKET_HEADERS BH, MTL_ITEM_CATEGORIES IC,
801: MTL_CATEGORIES C, OE_BLANKET_LINES_EXT BLE,
802: OE_BLANKET_HEADERS_EXT BHE, OE_LOOKUPS OL, HZ_PARTIES PARTY, HZ_CUST_ACCOUNTS ACCT
803: WHERE BH.HEADER_ID = BL.HEADER_ID
804: AND BH.SOLD_TO_ORG_ID = ACCT.CUST_ACCOUNT_ID(+)
805: AND PARTY.PARTY_ID(+) = ACCT.PARTY_ID