APPS.IEX_UWQ_POP_SUM_TBL_PVT dependencies on HZ_CUSTOMER_PROFILES

Line 300: hz_customer_profiles prf,

296: jtf_objects_b objb,
297: hz_contact_points phone,
298: fnd_territories_tl fnd_terr,
299: hz_cust_site_uses_all site_uses,
300: hz_customer_profiles prf,
301: ar_collectors ac,
302: GL_SETS_OF_BOOKS gl,
303: AR_SYSTEM_PARAMETERS_all sys
304: WHERE

Line 562: hz_customer_profiles prf,

558: jtf_objects_b objb,
559: hz_contact_points phone,
560: fnd_territories_tl fnd_terr,
561: hz_cust_site_uses_all site_uses,
562: hz_customer_profiles prf,
563: ar_collectors ac,
564: GL_SETS_OF_BOOKS gl,
565: AR_SYSTEM_PARAMETERS_all sys
566: WHERE

Line 826: hz_customer_profiles prf,

822: hz_parties party,
823: jtf_objects_b objb,
824: hz_contact_points phone,
825: fnd_territories_tl fnd_terr,
826: hz_customer_profiles prf,
827: ar_collectors ac,
828: GL_SETS_OF_BOOKS gl,
829: AR_SYSTEM_PARAMETERS_all sys
830:

Line 1084: hz_customer_profiles prf,

1080: hz_parties party,
1081: jtf_objects_b objb,
1082: hz_contact_points phone,
1083: fnd_territories_tl fnd_terr,
1084: hz_customer_profiles prf,
1085: ar_collectors ac,
1086: GL_SETS_OF_BOOKS gl,
1087: AR_SYSTEM_PARAMETERS_all sys
1088:

Line 1333: hz_customer_profiles prf,

1329: hz_parties party,
1330: jtf_objects_b objb,
1331: hz_contact_points phone,
1332: fnd_territories_tl fnd_terr,
1333: hz_customer_profiles prf,
1334: ar_collectors ac,
1335: GL_SETS_OF_BOOKS gl,
1336: AR_SYSTEM_PARAMETERS_all sys
1337:

Line 1573: hz_customer_profiles prf,

1569: hz_parties party,
1570: jtf_objects_b objb,
1571: hz_contact_points phone,
1572: fnd_territories_tl fnd_terr,
1573: hz_customer_profiles prf,
1574: ar_collectors ac,
1575: GL_SETS_OF_BOOKS gl,
1576: AR_SYSTEM_PARAMETERS_all sys
1577: WHERE trx_summ.reference_1 = '1'

Line 1677: hz_customer_profiles hp,

1673: ids.party_id,
1674: ids.cust_account_id,
1675: ids.site_use_id
1676: FROM
1677: hz_customer_profiles hp,
1678: iex_dln_uwq_summary ids
1679: WHERE
1680: hp.party_id = ids.party_id
1681: AND decode(hp.cust_account_id,null,1,hp.cust_account_id)

Line 3559: hz_customer_profiles hp,

3555: hp.party_id,
3556: hp.cust_account_id,
3557: hp.site_use_id
3558: FROM
3559: hz_customer_profiles hp,
3560: ar_collectors ac,
3561: iex_pop_uwq_summ_gt temp
3562: WHERE
3563: hp.site_use_id=temp.object_id

Line 4786: hz_customer_profiles hp,

4782: ac.resource_type,
4783: hp.party_id,
4784: hp.cust_account_id
4785: FROM
4786: hz_customer_profiles hp,
4787: ar_collectors ac,
4788: iex_pop_uwq_summ_gt temp
4789: WHERE
4790: hp.site_use_id is null

Line 6007: hz_customer_profiles hp,

6003: ac.resource_id,
6004: ac.resource_type,
6005: hp.party_id
6006: FROM
6007: hz_customer_profiles hp,
6008: ar_collectors ac,
6009: iex_pop_uwq_summ_gt temp
6010: WHERE
6011: hp.cust_account_id = -1