[Home] [Help]
1145: hz_cust_accounts acc,
1146: hz_parties party,
1147: hz_party_preferences party_pref,--Added for Bug 8707923 27-Jul-2009 barathsr
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,
1448: phone.phone_area_code phone_area_code,
1449: phone.phone_number phone_number,
1450: phone.phone_extension phone_extension
1451: FROM iex_dln_uwq_summary summ,
1452: hz_contact_points phone
1453: WHERE
1454: phone.owner_table_id = summ.party_id
1455: AND phone.owner_table_name = 'HZ_PARTIES'
1456: AND phone.contact_point_type = 'PHONE'
1763: hz_cust_accounts acc,
1764: hz_parties party,
1765: hz_party_preferences party_pref,--Added for Bug 8707923 27-Jul-2009 barathsr
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,
2084: phone.phone_area_code phone_area_code,
2085: phone.phone_number phone_number,
2086: phone.phone_extension phone_extension
2087: FROM iex_dln_uwq_summary summ,
2088: hz_contact_points phone
2089: WHERE
2090: phone.owner_table_id = summ.party_id
2091: AND phone.owner_table_name = 'HZ_PARTIES'
2092: AND phone.contact_point_type = 'PHONE'
2417: hz_cust_accounts acc,
2418: hz_parties party,
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,
2689: phone.phone_area_code phone_area_code,
2690: phone.phone_number phone_number,
2691: phone.phone_extension phone_extension
2692: FROM iex_dln_uwq_summary summ,
2693: hz_contact_points phone
2694: WHERE
2695: phone.owner_table_id(+) = summ.party_id
2696: AND phone.owner_table_name(+) = 'HZ_PARTIES'
2697: AND phone.contact_point_type(+) = 'PHONE'
2999: hz_cust_accounts acc,
3000: hz_parties party,
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,
3289: phone.phone_area_code phone_area_code,
3290: phone.phone_number phone_number,
3291: phone.phone_extension phone_extension
3292: FROM iex_dln_uwq_summary summ,
3293: hz_contact_points phone
3294: WHERE
3295: phone.owner_table_id(+) = summ.party_id
3296: AND phone.owner_table_name(+) = 'HZ_PARTIES'
3297: AND phone.contact_point_type(+) = 'PHONE'
3612: hz_cust_accounts acc,
3613: hz_parties party,
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,
3889: phone.phone_area_code phone_area_code,
3890: phone.phone_number phone_number,
3891: phone.phone_extension phone_extension
3892: FROM iex_dln_uwq_summary summ,
3893: hz_contact_points phone
3894: WHERE
3895: phone.owner_table_id(+) = summ.party_id
3896: AND phone.owner_table_name(+) = 'HZ_PARTIES'
3897: AND phone.contact_point_type(+) = 'PHONE'
4190: hz_cust_accounts acc,
4191: hz_parties party,
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,
4484: phone.phone_area_code phone_area_code,
4485: phone.phone_number phone_number,
4486: phone.phone_extension phone_extension
4487: FROM iex_dln_uwq_summary summ,
4488: hz_contact_points phone
4489: WHERE
4490: phone.owner_table_id(+) = summ.party_id
4491: AND phone.owner_table_name(+) = 'HZ_PARTIES'
4492: AND phone.contact_point_type(+) = 'PHONE'
4838: phone.phone_area_code phone_area_code,
4839: phone.phone_number phone_number,
4840: phone.phone_extension phone_extension
4841: FROM
4842: hz_contact_points phone,
4843: iex_dln_uwq_summary ids
4844: WHERE
4845: phone.owner_table_id = ids.party_id
4846: AND phone.owner_table_name = 'HZ_PARTIES'
9735: phone.phone_area_code phone_area_code,
9736: phone.phone_number phone_number,
9737: phone.phone_extension phone_extension
9738: FROM
9739: hz_contact_points phone,
9740: iex_dln_uwq_summary ids,
9741: iex_pop_uwq_summ_gt temp
9742: WHERE
9743: phone.owner_table_id = ids.party_id
11062: phone.phone_area_code phone_area_code,
11063: phone.phone_number phone_number,
11064: phone.phone_extension phone_extension
11065: FROM
11066: hz_contact_points phone,
11067: iex_dln_uwq_summary ids,
11068: iex_pop_uwq_summ_gt temp
11069: WHERE
11070: phone.owner_table_id = ids.party_id
12374: phone.phone_area_code phone_area_code,
12375: phone.phone_number phone_number,
12376: phone.phone_extension phone_extension
12377: FROM
12378: hz_contact_points phone,
12379: iex_pop_uwq_summ_gt temp
12380: WHERE
12381: phone.owner_table_id = temp.object_id
12382: AND phone.owner_table_name = 'HZ_PARTIES'