APPS.MSC_X_VMI_POREQ dependencies on HZ_PARTIES

Line 715: ,HZ_PARTIES PARTY, HZ_CUST_ACCOUNTS ACCT

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
719: AND BH.SOLD_TO_ORG_ID = ACCT.CUST_ACCOUNT_ID(+)

Line 745: ,OE_LOOKUPS OL, HZ_PARTIES PARTY, HZ_CUST_ACCOUNTS ACCT

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

Line 773: , HZ_PARTIES PARTY, HZ_CUST_ACCOUNTS ACCT

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

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'

Line 882: HZ_PARTIES HP

878: HZ_PARTY_SITES PARTY_SITE,
879: HZ_LOCATIONS LOC,
880: HR_ORGANIZATION_INFORMATION O,
881: HR_ALL_ORGANIZATION_UNITS_TL OTL,
882: HZ_PARTIES HP
883: WHERE OTL.ORGANIZATION_ID = SITE_USES_ALL.ORG_ID
884: AND O.ORGANIZATION_ID = OTL.ORGANIZATION_ID
885: AND O.ORG_INFORMATION_CONTEXT = 'Operating Unit Information'
886: AND OTL.LANGUAGE = userenv('LANG')