DBA Data[Home] [Help]

APPS.MSC_X_VMI_POREQ dependencies on MTL_SYSTEM_ITEMS_TL

Line 714: OE_BLANKET_HEADERS_EXT BHE,MTL_SYSTEM_ITEMS_TL T,OE_LOOKUPS OL

710: FROM
711: (
712: SELECT BH.ORDER_NUMBER order_number, bh.TRANSACTIONAL_CURR_CODE curr, bh.FLOW_STATUS_CODE status
713: FROM OE_BLANKET_LINES BL,OE_BLANKET_HEADERS BH,OE_BLANKET_LINES_EXT BLE,
714: OE_BLANKET_HEADERS_EXT BHE,MTL_SYSTEM_ITEMS_TL T,OE_LOOKUPS OL
715: ,HZ_PARTIES PARTY, HZ_CUST_ACCOUNTS ACCT
716: WHERE BH.HEADER_ID = BL.HEADER_ID
717: AND BL.LINE_ID = BLE.LINE_ID
718: AND BH.ORDER_NUMBER = BHE.ORDER_NUMBER