eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEX_UWQ_POP_SUM_TBL_PVT dependencies on AR_COLLECTORS

Line 1153: ar_collectors ac,

1149: hz_contact_points phone,
1150: fnd_territories_tl fnd_terr,
1151: hz_cust_site_uses_all site_uses,
1152: hz_customer_profiles prf,
1153: ar_collectors ac,
1154: GL_SETS_OF_BOOKS gl,
1155: AR_SYSTEM_PARAMETERS_all sys,
1156: -- Added for the bug#8538945 by PNAVEENK
1157: HZ_CUST_ACCT_SITES_all ACCT_SITE,--Modified for Bug 9487600 23-Mar-2010 barathsr

Line 1482: ar_collectors ac,

1478: hp.cust_account_id,
1479: hp.site_use_id
1480: FROM
1481: hz_customer_profiles hp,
1482: ar_collectors ac,
1483: iex_dln_uwq_summary temp,
1484: JTF_RS_GROUPS_VL rg,
1485: jtf_rs_resource_extns rs
1486: WHERE

Line 1771: ar_collectors ac,

1767: hz_contact_points phone,
1768: fnd_territories_tl fnd_terr,
1769: hz_cust_site_uses_all site_uses,
1770: hz_customer_profiles prf,
1771: ar_collectors ac,
1772: GL_SETS_OF_BOOKS gl,
1773: AR_SYSTEM_PARAMETERS_all sys,
1774: -- Added for the bug#8538945 by PNAVEENK
1775: HZ_CUST_ACCT_SITES_all ACCT_SITE,--Modified for Bug 9487600 23-Mar-2010 barathsr

Line 2119: ar_collectors ac,

2115: hp.cust_account_id,
2116: hp.site_use_id
2117: FROM
2118: hz_customer_profiles hp,
2119: ar_collectors ac,
2120: iex_dln_uwq_summary temp,
2121: JTF_RS_GROUPS_VL rg,
2122: jtf_rs_resource_extns rs
2123: WHERE

Line 2139: ar_collectors ac,

2135: ac.resource_type COLLECTOR_RES_TYPE,
2136: ac.collector_id collector_id,
2137: hp.site_use_id
2138: FROM
2139: ar_collectors ac,
2140: hz_customer_profiles hp,
2141: iex_dln_uwq_summary ids
2142: WHERE
2143: hp.site_use_id=ids.site_use_id

Line 2424: ar_collectors ac,

2420: jtf_objects_b objb,
2421: hz_contact_points phone,
2422: fnd_territories_tl fnd_terr,
2423: hz_customer_profiles prf,
2424: ar_collectors ac,
2425: GL_SETS_OF_BOOKS gl,
2426: AR_SYSTEM_PARAMETERS_all sys
2427: WHERE
2428: P_MODE = 'CP'

Line 2724: ar_collectors ac,

2720: hp.party_id,
2721: hp.cust_account_id
2722: FROM
2723: hz_customer_profiles hp,
2724: ar_collectors ac,
2725: iex_dln_uwq_summary temp,
2726: JTF_RS_GROUPS_VL rg,
2727: jtf_rs_resource_extns rs
2728: WHERE

Line 3006: ar_collectors ac,

3002: jtf_objects_b objb,
3003: hz_contact_points phone,
3004: fnd_territories_tl fnd_terr,
3005: hz_customer_profiles prf,
3006: ar_collectors ac,
3007: GL_SETS_OF_BOOKS gl,
3008: AR_SYSTEM_PARAMETERS_all sys
3009:
3010: WHERE

Line 3326: ar_collectors ac,

3322: hp.party_id,
3323: hp.cust_account_id
3324: FROM
3325: hz_customer_profiles hp,
3326: ar_collectors ac,
3327: iex_dln_uwq_summary temp,
3328: JTF_RS_GROUPS_VL rg,
3329: jtf_rs_resource_extns rs
3330: WHERE

Line 3348: ar_collectors ac,

3344: ac.resource_type COLLECTOR_RES_TYPE,
3345: ac.collector_id collector_id,
3346: hp.cust_account_id
3347: FROM
3348: ar_collectors ac,
3349: hz_customer_profiles hp,
3350: iex_dln_uwq_summary ids
3351: WHERE
3352: hp.cust_account_id=ids.cust_account_id

Line 3619: ar_collectors ac,

3615: jtf_objects_b objb,
3616: hz_contact_points phone,
3617: fnd_territories_tl fnd_terr,
3618: hz_customer_profiles prf,
3619: ar_collectors ac,
3620: GL_SETS_OF_BOOKS gl,
3621: AR_SYSTEM_PARAMETERS_all sys
3622:
3623: WHERE

Line 3924: ar_collectors ac,

3920: 'RS_EMPLOYEE' resource_type,
3921: hp.party_id
3922: FROM
3923: hz_customer_profiles hp,
3924: ar_collectors ac,
3925: iex_dln_uwq_summary temp,
3926: JTF_RS_GROUPS_VL rg,
3927: jtf_rs_resource_extns rs
3928: WHERE

Line 4197: ar_collectors ac,

4193: jtf_objects_b objb,
4194: hz_contact_points phone,
4195: fnd_territories_tl fnd_terr,
4196: hz_customer_profiles prf,
4197: ar_collectors ac,
4198: GL_SETS_OF_BOOKS gl,
4199: AR_SYSTEM_PARAMETERS_all sys
4200: WHERE trx_summ.reference_1 = '1'
4201: AND trx_summ.cust_account_id = acc.cust_account_id

Line 4521: ar_collectors ac,

4517: 'RS_EMPLOYEE' resource_type,
4518: hp.party_id
4519: FROM
4520: hz_customer_profiles hp,
4521: ar_collectors ac,
4522: iex_dln_uwq_summary temp,
4523: JTF_RS_GROUPS_VL rg,
4524: jtf_rs_resource_extns rs
4525: WHERE

Line 4545: ar_collectors ac,

4541: ac.resource_type COLLECTOR_RES_TYPE,
4542: ac.collector_id collector_id,
4543: hp.party_id
4544: FROM
4545: ar_collectors ac,
4546: hz_customer_profiles hp,
4547: iex_dln_uwq_summary ids
4548: WHERE
4549: hp.party_id=ids.party_id

Line 4735: ar_collectors ar,

4731: ar.resource_type,
4732: decode(ar.resource_type, 'RS_RESOURCE' , rs.source_name , rg.group_name) collector_resource_name,
4733: ar.collector_id
4734: FROM
4735: ar_collectors ar,
4736: iex_dln_uwq_summary ids,
4737: jtf_rs_resource_extns rs,
4738: JTF_RS_GROUPS_VL rg
4739: WHERE

Line 4765: ar_collectors ar,

4761: ar.resource_type -- Added for 15906302
4762: FROM
4763: hz_customer_profiles hp,
4764: iex_dln_uwq_summary ids,
4765: ar_collectors ar,
4766: jtf_rs_resource_extns rs,
4767: JTF_RS_GROUPS_VL rg
4768: WHERE
4769: hp.party_id = ids.party_id

Line 9721: ar_collectors ac,

9717: hp.cust_account_id,
9718: hp.site_use_id
9719: FROM
9720: hz_customer_profiles hp,
9721: ar_collectors ac,
9722: iex_pop_uwq_summ_gt temp,
9723: jtf_rs_resource_extns rs,
9724: JTF_RS_GROUPS_VL rg
9725: WHERE

Line 11046: ar_collectors ac,

11042: hp.party_id,
11043: hp.cust_account_id
11044: FROM
11045: hz_customer_profiles hp,
11046: ar_collectors ac,
11047: iex_pop_uwq_summ_gt temp,
11048: jtf_rs_resource_extns rs,
11049: JTF_RS_GROUPS_VL rg
11050: WHERE

Line 12357: ar_collectors ac,

12353: ac.resource_type,
12354: hp.party_id
12355: FROM
12356: hz_customer_profiles hp,
12357: ar_collectors ac,
12358: iex_pop_uwq_summ_gt temp,
12359: jtf_rs_resource_extns rs,
12360: JTF_RS_GROUPS_VL rg
12361: WHERE