APPS.EGO_GTIN_PVT dependencies on HZ_CUST_ACCT_SITES_ALL

Line 113: FROM hz_cust_acct_sites_all

109: BEGIN
110: --derive gln and customer_id from address_id
111:
112: SELECT cust_account_id, party_site_id INTO l_customer_id, l_party_site_id
113: FROM hz_cust_acct_sites_all
114: WHERE cust_acct_site_id = p_address_id;
115:
116: SELECT global_location_number INTO l_gln
117: FROM hz_party_sites

Line 193: FROM hz_cust_acct_sites_all

189: BEGIN
190: --derive gln and customer_id from address_id
191:
192: SELECT cust_account_id, party_site_id INTO l_customer_id, l_party_site_id
193: FROM hz_cust_acct_sites_all
194: WHERE cust_acct_site_id = p_address_id;
195:
196: SELECT global_location_number INTO l_gln
197: FROM hz_party_sites

Line 512: HZ_CUST_ACCT_SITES_ALL HCAS

508: SELECT
509: NVL(MAX(EICA.LAST_UPDATE_DATE) , TO_DATE('01-01-1998', 'MM-DD-YYYY'))
510: FROM EGO_ITEM_CUST_ATTRS_B EICA,
511: EGO_UCCNET_EVENTS EV2,
512: HZ_CUST_ACCT_SITES_ALL HCAS
513: WHERE EV2.BATCH_ID = UE.BATCH_ID
514: AND EV2.TOP_ITEM_ID = UE.INVENTORY_ITEM_ID
515: AND EV2.ORGANIZATION_ID = UE.ORGANIZATION_ID
516: AND EV2.ADDRESS_ID = UE.ADDRESS_ID

Line 552: HZ_CUST_ACCT_SITES_ALL HCAS

548: ) AS LAST_UPDATE_DATE
549: FROM EGO_ITEM_TP_ATTRS_EXT_B b,
550: EGO_ITEM_TP_ATTRS_EXT_TL tl,
551: EGO_UCCNET_EVENTS EV2,
552: HZ_CUST_ACCT_SITES_ALL HCAS
553: WHERE EV2.BATCH_ID = UE.BATCH_ID
554: AND EV2.TOP_ITEM_ID = UE.INVENTORY_ITEM_ID
555: AND EV2.ORGANIZATION_ID = UE.ORGANIZATION_ID
556: AND EV2.ADDRESS_ID = UE.ADDRESS_ID

Line 661: HZ_CUST_ACCT_SITES_ALL HCAS

657: SELECT
658: NVL(MAX(EICA.LAST_UPDATE_DATE) , TO_DATE('01-01-1998', 'MM-DD-YYYY'))
659: FROM EGO_ITEM_CUST_ATTRS_B EICA,
660: EGO_UCCNET_EVENTS EV2,
661: HZ_CUST_ACCT_SITES_ALL HCAS
662: WHERE EV2.BATCH_ID = UE.BATCH_ID
663: AND EV2.TOP_ITEM_ID = UE.INVENTORY_ITEM_ID
664: AND EV2.ORGANIZATION_ID = UE.ORGANIZATION_ID
665: AND EV2.ADDRESS_ID = UE.ADDRESS_ID

Line 701: HZ_CUST_ACCT_SITES_ALL HCAS

697: ) AS LAST_UPDATE_DATE
698: FROM EGO_ITEM_TP_ATTRS_EXT_B b,
699: EGO_ITEM_TP_ATTRS_EXT_TL tl,
700: EGO_UCCNET_EVENTS EV2,
701: HZ_CUST_ACCT_SITES_ALL HCAS
702: WHERE EV2.BATCH_ID = UE.BATCH_ID
703: AND EV2.TOP_ITEM_ID = UE.INVENTORY_ITEM_ID
704: AND EV2.ORGANIZATION_ID = UE.ORGANIZATION_ID
705: AND EV2.ADDRESS_ID = UE.ADDRESS_ID

Line 1401: FROM MTL_CUSTOMER_ITEMS MCI, MTL_CUSTOMER_ITEM_XREFS MCIX, HZ_CUST_ACCT_SITES_ALL ACCT_SITE

1397: 'Order_Quantity_Min', 'Order_Quantity_Max', 'Shippable_Item_Flag',
1398: 'Invoiceable_Item_Flag');
1399: CURSOR c_customers(c_gtin IN VARCHAR2) IS
1400: SELECT ACCT_SITE.PARTY_SITE_ID AS PARTY_SITE_ID
1401: FROM MTL_CUSTOMER_ITEMS MCI, MTL_CUSTOMER_ITEM_XREFS MCIX, HZ_CUST_ACCT_SITES_ALL ACCT_SITE
1402: WHERE MCI.ITEM_DEFINITION_LEVEL = 3
1403: AND MCI.CUSTOMER_CATEGORY_CODE= 'UCCNET'
1404: AND MCI.CUSTOMER_ITEM_ID = MCIX.CUSTOMER_ITEM_ID
1405: AND MCIX.PREFERENCE_NUMBER = 1

Line 3735: FROM HZ_CUST_ACCT_SITES_ALL

3731: IF l_do_tp_validations THEN
3732: -- validating address_id
3733: BEGIN
3734: SELECT PARTY_SITE_ID INTO l_party_site_id
3735: FROM HZ_CUST_ACCT_SITES_ALL
3736: WHERE CUST_ACCT_SITE_ID = p_address_id;
3737: EXCEPTION
3738: WHEN NO_DATA_FOUND THEN
3739: l_error_table.EXTEND;

Line 4628: FROM HZ_CUST_ACCT_SITES_ALL

4624:
4625: IF l_do_tp_validations THEN
4626: -- retreiving party_site_id from address_id
4627: SELECT PARTY_SITE_ID INTO l_party_site_id
4628: FROM HZ_CUST_ACCT_SITES_ALL
4629: WHERE CUST_ACCT_SITE_ID = p_address_id;
4630: END IF; --IF l_do_tp_validations THEN
4631:
4632: -- validating first the attributes that are not TP-Dependant