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 HZ_PARTIES

Line 295: hz_parties party,

291: ) pending_promises
292:
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,

Line 314: AND phone.owner_table_name(+) = 'HZ_PARTIES'

310: AND objb.object_code = 'IEX_BILLTO'
311: AND party.country = fnd_terr.territory_code(+)
312: AND fnd_terr.LANGUAGE(+) = userenv('LANG')
313: AND phone.owner_table_id(+) = party.party_id
314: AND phone.owner_table_name(+) = 'HZ_PARTIES'
315: AND phone.contact_point_type(+) = 'PHONE'
316: AND phone.primary_by_purpose(+) = 'Y'
317: AND phone.contact_point_purpose(+) = 'COLLECTIONS'
318: AND phone.phone_line_type(+) NOT IN('PAGER', 'FAX')

Line 557: hz_parties party,

553: )
554: ) pending_promises
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,

Line 575: AND phone.owner_table_name(+) = 'HZ_PARTIES'

571: AND objb.object_code = 'IEX_BILLTO'
572: AND party.country = fnd_terr.territory_code(+)
573: AND fnd_terr.LANGUAGE(+) = userenv('LANG')
574: AND phone.owner_table_id(+) = party.party_id
575: AND phone.owner_table_name(+) = 'HZ_PARTIES'
576: AND phone.contact_point_type(+) = 'PHONE'
577: AND phone.primary_by_purpose(+) = 'Y'
578: AND phone.contact_point_purpose(+) = 'COLLECTIONS'
579: AND phone.phone_line_type(+) NOT IN('PAGER', 'FAX')

Line 822: hz_parties party,

818: ) pending_promises
819:
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,

Line 840: AND phone.owner_table_name(+) = 'HZ_PARTIES'

836: AND objb.object_code = 'IEX_ACCOUNT'
837: AND party.country = fnd_terr.territory_code(+)
838: AND fnd_terr.LANGUAGE(+) = userenv('LANG')
839: AND phone.owner_table_id(+) = party.party_id
840: AND phone.owner_table_name(+) = 'HZ_PARTIES'
841: AND phone.contact_point_type(+) = 'PHONE'
842: AND phone.primary_by_purpose(+) = 'Y'
843: AND phone.contact_point_purpose(+) = 'COLLECTIONS'
844: AND phone.phone_line_type(+) NOT IN('PAGER', 'FAX')

Line 1080: hz_parties party,

1076: ) pending_promises
1077:
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,

Line 1097: AND phone.owner_table_name(+) = 'HZ_PARTIES'

1093: AND objb.object_code = 'IEX_ACCOUNT'
1094: AND party.country = fnd_terr.territory_code(+)
1095: AND fnd_terr.LANGUAGE(+) = userenv('LANG')
1096: AND phone.owner_table_id(+) = party.party_id
1097: AND phone.owner_table_name(+) = 'HZ_PARTIES'
1098: AND phone.contact_point_type(+) = 'PHONE'
1099: AND phone.primary_by_purpose(+) = 'Y'
1100: AND phone.contact_point_purpose(+) = 'COLLECTIONS'
1101: AND phone.phone_line_type(+) NOT IN('PAGER', 'FAX')

Line 1329: hz_parties party,

1325: pending_promises
1326:
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,

Line 1347: AND phone.owner_table_name(+) = 'HZ_PARTIES'

1343: AND objb.object_code = 'IEX_CUSTOMER'
1344: AND party.country = fnd_terr.territory_code(+)
1345: AND fnd_terr.LANGUAGE(+) = userenv('LANG')
1346: AND phone.owner_table_id(+) = party.party_id
1347: AND phone.owner_table_name(+) = 'HZ_PARTIES'
1348: AND phone.contact_point_type(+) = 'PHONE'
1349: and phone.primary_by_purpose(+) = 'Y'
1350: AND phone.contact_point_purpose(+) = 'COLLECTIONS'
1351: AND phone.phone_line_type(+) NOT IN('PAGER', 'FAX')

Line 1569: hz_parties party,

1565: pending_promises
1566:
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,

Line 1584: AND phone.owner_table_name(+) = 'HZ_PARTIES'

1580: AND objb.object_code = 'IEX_CUSTOMER'
1581: AND party.country = fnd_terr.territory_code(+)
1582: AND fnd_terr.LANGUAGE(+) = userenv('LANG')
1583: AND phone.owner_table_id(+) = party.party_id
1584: AND phone.owner_table_name(+) = 'HZ_PARTIES'
1585: AND phone.contact_point_type(+) = 'PHONE'
1586: and phone.primary_by_purpose(+) = 'Y'
1587: AND phone.contact_point_purpose(+) = 'COLLECTIONS'
1588: AND phone.phone_line_type(+) NOT IN('PAGER', 'FAX')

Line 1699: hz_parties party,

1695: fnd_terr.territory_short_name country,
1696: party.province province,
1697: party.postal_code postal_code
1698: FROM
1699: hz_parties party,
1700: iex_dln_uwq_summary ids,
1701: fnd_territories_tl fnd_terr
1702: WHERE
1703: party.party_id = ids.party_id

Line 1720: AND phone.owner_table_name = 'HZ_PARTIES'

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'
1721: AND phone.contact_point_type = 'PHONE'
1722: and phone.primary_by_purpose = 'Y'
1723: AND phone.contact_point_purpose = 'COLLECTIONS'
1724: AND phone.phone_line_type NOT IN('PAGER', 'FAX')

Line 3486: hz_parties party,

3482: party.province province,
3483: party.postal_code postal_code
3484: FROM ar_trx_bal_summary trx_summ,
3485: hz_cust_accounts acc,
3486: hz_parties party,
3487: jtf_objects_b objb,
3488: fnd_territories_tl fnd_terr,
3489: hz_cust_site_uses_all site_uses,
3490: GL_SETS_OF_BOOKS gl,

Line 3579: AND phone.owner_table_name = 'HZ_PARTIES'

3575: iex_dln_uwq_summary ids,
3576: iex_pop_uwq_summ_gt temp
3577: WHERE
3578: phone.owner_table_id = ids.party_id
3579: AND phone.owner_table_name = 'HZ_PARTIES'
3580: AND phone.contact_point_type = 'PHONE'
3581: and phone.primary_by_purpose = 'Y'
3582: AND phone.contact_point_purpose = 'COLLECTIONS'
3583: AND phone.phone_line_type NOT IN('PAGER', 'FAX')

Line 4717: hz_parties party,

4713: party.province province,
4714: party.postal_code postal_code
4715: FROM ar_trx_bal_summary trx_summ,
4716: hz_cust_accounts acc,
4717: hz_parties party,
4718: jtf_objects_b objb,
4719: fnd_territories_tl fnd_terr,
4720: GL_SETS_OF_BOOKS gl,
4721: AR_SYSTEM_PARAMETERS_all sys

Line 4807: AND phone.owner_table_name = 'HZ_PARTIES'

4803: iex_dln_uwq_summary ids,
4804: iex_pop_uwq_summ_gt temp
4805: WHERE
4806: phone.owner_table_id = ids.party_id
4807: AND phone.owner_table_name = 'HZ_PARTIES'
4808: AND phone.contact_point_type = 'PHONE'
4809: and phone.primary_by_purpose = 'Y'
4810: AND phone.contact_point_purpose = 'COLLECTIONS'
4811: AND phone.phone_line_type NOT IN('PAGER', 'FAX')

Line 5944: hz_parties party,

5940: party.province province,
5941: party.postal_code postal_code
5942: FROM ar_trx_bal_summary trx_summ,
5943: hz_cust_accounts acc,
5944: hz_parties party,
5945: jtf_objects_b objb,
5946: fnd_territories_tl fnd_terr,
5947: GL_SETS_OF_BOOKS gl,
5948: AR_SYSTEM_PARAMETERS_all sys

Line 6028: AND phone.owner_table_name = 'HZ_PARTIES'

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'
6029: AND phone.contact_point_type = 'PHONE'
6030: and phone.primary_by_purpose = 'Y'
6031: AND phone.contact_point_purpose = 'COLLECTIONS'
6032: AND phone.phone_line_type NOT IN('PAGER', 'FAX')