DBA Data[Home] [Help]

APPS.PJM_INQUIRY dependencies on HZ_CUST_SITE_USES_ALL

Line 329: FROM hz_cust_site_uses_all site

325: SELECT decode(loc.city , null , null , loc.city || ', ')
326: || decode(loc.postal_code , null , null , loc.postal_code || ', ')
327: || decode(loc.country , null , null , loc.country)
328: INTO L_Org_Address
329: FROM hz_cust_site_uses_all site
330: , hz_locations loc
331: , hz_party_sites party_site
332: , hz_cust_acct_sites_all acct_site
333: WHERE site.site_use_id = X_Org_ID

Line 345: FROM hz_cust_site_uses_all site

341: SELECT decode(loc.city , null , null , loc.city || ', ')
342: || decode(loc.postal_code , null , null , loc.postal_code || ', ')
343: || decode(loc.country , null , null , loc.country)
344: INTO L_Org_Address
345: FROM hz_cust_site_uses_all site
346: , hz_locations loc
347: , hz_party_sites party_site
348: , hz_cust_acct_sites_all acct_site
349: WHERE site.site_use_id = X_Org_ID