[Home] [Help]
1148: jtf_objects_b objb,
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
1477: hp.party_id,
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
1766: jtf_objects_b objb,
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
2114: hp.party_id,
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
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
2144: and ac.collector_id = hp.collector_id
2419: hz_party_preferences party_pref,--Added for Bug 8707923 27-Jul-2009 barathsr
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
2719: 'RS_EMPLOYEE' resource_type,
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
3001: hz_party_preferences party_pref,--Added for Bug 8707923 27-Jul-2009 barathsr
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:
3321: 'RS_EMPLOYEE' resource_type,
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
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
3353: and ac.collector_id(+) = hp.collector_id
3614: hz_party_preferences party_pref,--Added for Bug 8707923 27-Jul-2009 barathsr
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:
3919: 1 resource_id,
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
4192: hz_party_preferences party_pref,--Added for Bug 8707923 27-Jul-2009 barathsr
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'
4516: 1 resource_id,
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
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
4550: and ac.collector_id(+) = hp.collector_id
4759: ar.resource_id,-- Added for 15906302
4760: decode(ar.resource_type, 'RS_RESOURCE' , rs.source_name , rg.group_name) collector_resource_name,-- Added for 15906302
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
9716: hp.party_id,
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
11041: ac.resource_type,
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
12352: decode(ac.resource_type, 'RS_RESOURCE' , rs.source_name , rg.group_name) collector_resource_name,
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