eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_X_VMI_POREQ dependencies on OE_BLANKET_HEADERS_EXT

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

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

Line 772: OE_BLANKET_LINES_EXT BLE, OE_BLANKET_HEADERS_EXT BHE

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(+)
776: AND PARTY.PARTY_ID(+) = ACCT.PARTY_ID

Line 802: OE_BLANKET_HEADERS_EXT BHE, OE_LOOKUPS OL, HZ_PARTIES PARTY, HZ_CUST_ACCOUNTS ACCT

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
806: AND acct.status(+) = 'A'