APPS.MSC_X_VMI_POREQ dependencies on HZ_CUST_ACCOUNTS

Line 683: from hz_cust_accounts hca,

679: begin
680:
681: select nvl(hca.order_type_id, hua.order_type_id) order_type_id
682: into lv_order_type_id
683: from hz_cust_accounts hca,
684: hz_cust_acct_sites_all hsa,
685: hz_cust_site_uses_all hua
686: where hca.CUST_ACCOUNT_ID = p_cust_id
687: and hca.cust_account_id = hsa.CUST_ACCOUNT_ID

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 877: HZ_CUST_ACCOUNTS CUST_ACCT,

873: BEGIN
874: SELECT SITE_USES_ALL.ORG_ID INTO l_operating_unit FROM
875: HZ_CUST_ACCT_SITES_ALL ACCT_SITE,
876: HZ_CUST_SITE_USES_ALL SITE_USES_ALL,
877: HZ_CUST_ACCOUNTS CUST_ACCT,
878: HZ_PARTY_SITES PARTY_SITE,
879: HZ_LOCATIONS LOC,
880: HR_ORGANIZATION_INFORMATION O,
881: HR_ALL_ORGANIZATION_UNITS_TL OTL,