DBA Data[Home] [Help]

APPS.MSC_X_VMI_POREQ dependencies on MTL_CROSS_REFERENCES

Line 771: FROM OE_BLANKET_LINES BL,OE_BLANKET_HEADERS BH, MTL_CROSS_REFERENCES MCR,

767: AND BH.ORDER_NUMBER = BHE.ORDER_NUMBER
768: AND (OL.Lookup_type = 'ITEM_IDENTIFIER_TYPE' AND OL.Lookup_code = BL.ITEM_IDENTIFIER_TYPE)
769: UNION ALL
770: SELECT BH.ORDER_NUMBER order_number, bh.TRANSACTIONAL_CURR_CODE curr, bh.FLOW_STATUS_CODE status
771: FROM OE_BLANKET_LINES BL,OE_BLANKET_HEADERS BH, MTL_CROSS_REFERENCES MCR,
772: OE_BLANKET_LINES_EXT BLE, OE_BLANKET_HEADERS_EXT BHE
773: , HZ_PARTIES PARTY, HZ_CUST_ACCOUNTS ACCT
774: WHERE BH.HEADER_ID = BL.HEADER_ID
775: AND BH.SOLD_TO_ORG_ID = ACCT.CUST_ACCOUNT_ID(+)