[Home] [Help]
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
305: P_MODE = 'CP'
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
567: trx_summ.reference_1 = '1'
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:
831: WHERE
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:
1089: WHERE
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:
1338: WHERE
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'
1578: AND trx_summ.cust_account_id = acc.cust_account_id
1657: ar.resource_id,
1658: ar.resource_type,
1659: ar.collector_id
1660: FROM
1661: ar_collectors ar,
1662: iex_dln_uwq_summary ids
1663: WHERE
1664: ar.collector_id = ids.collector_id
1665: AND ar.resource_id is NOT NULL
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
3564: and hp.collector_id=ac.collector_id;
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
4791: and hp.cust_account_id=temp.object_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
6012: and hp.site_use_id is null