293: FROM ar_trx_bal_summary trx_summ,
294: hz_cust_accounts acc,
295: hz_parties party,
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,
555: FROM ar_trx_bal_summary trx_summ,
556: hz_cust_accounts acc,
557: hz_parties party,
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,
820: FROM ar_trx_bal_summary trx_summ,
821: hz_cust_accounts acc,
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,
1078: FROM ar_trx_bal_summary trx_summ,
1079: hz_cust_accounts acc,
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,
1327: FROM ar_trx_bal_summary trx_summ,
1328: hz_cust_accounts acc,
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,
1567: FROM ar_trx_bal_summary trx_summ,
1568: hz_cust_accounts acc,
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,
1712: phone.phone_area_code phone_area_code,
1713: phone.phone_number phone_number,
1714: phone.phone_extension phone_extension
1715: FROM
1716: hz_contact_points phone,
1717: iex_dln_uwq_summary ids
1718: WHERE
1719: phone.owner_table_id = ids.party_id
1720: AND phone.owner_table_name = 'HZ_PARTIES'
3570: phone.phone_area_code phone_area_code,
3571: phone.phone_number phone_number,
3572: phone.phone_extension phone_extension
3573: FROM
3574: hz_contact_points phone,
3575: iex_dln_uwq_summary ids,
3576: iex_pop_uwq_summ_gt temp
3577: WHERE
3578: phone.owner_table_id = ids.party_id
4798: phone.phone_area_code phone_area_code,
4799: phone.phone_number phone_number,
4800: phone.phone_extension phone_extension
4801: FROM
4802: hz_contact_points phone,
4803: iex_dln_uwq_summary ids,
4804: iex_pop_uwq_summ_gt temp
4805: WHERE
4806: phone.owner_table_id = ids.party_id
6020: phone.phone_area_code phone_area_code,
6021: phone.phone_number phone_number,
6022: phone.phone_extension phone_extension
6023: FROM
6024: hz_contact_points phone,
6025: iex_pop_uwq_summ_gt temp
6026: WHERE
6027: phone.owner_table_id = temp.object_id
6028: AND phone.owner_table_name = 'HZ_PARTIES'