DBA Data[Home] [Help]

APPS.EGO_GTIN_PVT dependencies on HZ_PARTY_SITES

Line 117: FROM hz_party_sites

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
118: WHERE party_site_id = l_party_site_id;
119:
120: l_publication_status := Get_Publication_Status( p_inventory_item_id,
121: p_org_id,

Line 197: FROM hz_party_sites

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
198: WHERE party_site_id = l_party_site_id;
199:
200: l_publication_status := Get_Publication_Status_Code( p_inventory_item_id,
201: p_org_id,