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 1146: hz_parties party,

1142: ) pending_promises
1143:
1144: FROM ar_trx_bal_summary trx_summ,
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,

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

1173: and objb.object_code <> 'IEX_DELINQUENCY'--Added for Bug 8707923 27-Jul-2009 barathsr
1174: AND loc.country = fnd_terr.territory_code(+) -- Changed for the bug#8538945
1175: AND fnd_terr.LANGUAGE(+) = userenv('LANG')
1176: AND phone.owner_table_id(+) = party.party_id
1177: AND phone.owner_table_name(+) = 'HZ_PARTIES'
1178: AND phone.contact_point_type(+) = 'PHONE'
1179: AND phone.primary_by_purpose(+) = 'Y'
1180: AND phone.contact_point_purpose(+) = 'COLLECTIONS'
1181: AND phone.phone_line_type(+) NOT IN('PAGER', 'FAX')

Line 1406: hz_parties party,

1402: loc.province province,
1403: loc.postal_code postal_code
1404: FROM iex_dln_uwq_summary summ,
1405: hz_cust_accounts acc,
1406: hz_parties party,
1407: -- hz_party_preferences party_pref, -- Commented for bug13452739
1408: fnd_territories_tl fnd_terr,
1409: hz_cust_site_uses_all site_uses,
1410: hz_cust_acct_sites_all acct_site,

Line 1455: AND phone.owner_table_name = 'HZ_PARTIES'

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'
1457: AND phone.primary_by_purpose = 'Y'
1458: AND phone.contact_point_purpose = 'COLLECTIONS'
1459: AND phone.phone_line_type NOT IN('PAGER', 'FAX')

Line 1764: hz_parties party,

1760: )
1761: ) pending_promises
1762: FROM ar_trx_bal_summary trx_summ,
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,

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

1790: and objb.object_code <> 'IEX_DELINQUENCY'--Added for Bug 8707923 27-Jul-2009 barathsr
1791: AND loc.country = fnd_terr.territory_code(+) -- Changed for the bug#8538945
1792: AND fnd_terr.LANGUAGE(+) = userenv('LANG')
1793: AND phone.owner_table_id(+) = party.party_id
1794: AND phone.owner_table_name(+) = 'HZ_PARTIES'
1795: AND phone.contact_point_type(+) = 'PHONE'
1796: AND phone.primary_by_purpose(+) = 'Y'
1797: AND phone.contact_point_purpose(+) = 'COLLECTIONS'
1798: AND phone.phone_line_type(+) NOT IN('PAGER', 'FAX')

Line 2043: hz_parties party,

2039: loc.province province,
2040: loc.postal_code postal_code
2041: FROM iex_dln_uwq_summary summ,
2042: hz_cust_accounts acc,
2043: hz_parties party,
2044: hz_party_preferences party_pref,
2045: fnd_territories_tl fnd_terr,
2046: hz_cust_site_uses_all site_uses,
2047: hz_cust_acct_sites_all acct_site,

Line 2091: AND phone.owner_table_name = 'HZ_PARTIES'

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'
2093: AND phone.primary_by_purpose = 'Y'
2094: AND phone.contact_point_purpose = 'COLLECTIONS'
2095: AND phone.phone_line_type NOT IN('PAGER', 'FAX')

Line 2418: hz_parties party,

2414: ) pending_promises
2415:
2416: FROM ar_trx_bal_summary trx_summ,
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,

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

2433: and objb.object_code <> 'IEX_DELINQUENCY'--Added for Bug 8707923 27-Jul-2009 barathsr
2434: AND party.country = fnd_terr.territory_code(+)
2435: AND fnd_terr.LANGUAGE(+) = userenv('LANG')
2436: AND phone.owner_table_id(+) = party.party_id
2437: AND phone.owner_table_name(+) = 'HZ_PARTIES'
2438: AND phone.contact_point_type(+) = 'PHONE'
2439: AND phone.primary_by_purpose(+) = 'Y'
2440: AND phone.contact_point_purpose(+) = 'COLLECTIONS'
2441: AND phone.phone_line_type(+) NOT IN('PAGER', 'FAX')

Line 2658: hz_parties party,

2654: party.province province,
2655: party.postal_code postal_code
2656: FROM iex_dln_uwq_summary summ,
2657: hz_cust_accounts acc,
2658: hz_parties party,
2659: hz_party_preferences party_pref,
2660: fnd_territories_tl fnd_terr
2661: WHERE
2662: summ.cust_account_id = acc.cust_account_id

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

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'
2698: AND phone.primary_by_purpose(+) = 'Y'
2699: AND phone.contact_point_purpose(+) = 'COLLECTIONS'
2700: AND phone.phone_line_type(+) NOT IN('PAGER', 'FAX')

Line 3000: hz_parties party,

2996: ) pending_promises
2997:
2998: FROM ar_trx_bal_summary trx_summ,
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,

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

3015: and objb.object_code <> 'IEX_DELINQUENCY'--Added for Bug 8707923 27-Jul-2009 barathsr
3016: AND party.country = fnd_terr.territory_code(+)
3017: AND fnd_terr.LANGUAGE(+) = userenv('LANG')
3018: AND phone.owner_table_id(+) = party.party_id
3019: AND phone.owner_table_name(+) = 'HZ_PARTIES'
3020: AND phone.contact_point_type(+) = 'PHONE'
3021: AND phone.primary_by_purpose(+) = 'Y'
3022: AND phone.contact_point_purpose(+) = 'COLLECTIONS'
3023: AND phone.phone_line_type(+) NOT IN('PAGER', 'FAX')

Line 3256: hz_parties party,

3252: party.province province,
3253: party.postal_code postal_code
3254: FROM iex_dln_uwq_summary summ,
3255: hz_cust_accounts acc,
3256: hz_parties party,
3257: hz_party_preferences party_pref,
3258: fnd_territories_tl fnd_terr
3259: WHERE
3260: summ.cust_account_id = acc.cust_account_id

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

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'
3298: AND phone.primary_by_purpose(+) = 'Y'
3299: AND phone.contact_point_purpose(+) = 'COLLECTIONS'
3300: AND phone.phone_line_type(+) NOT IN('PAGER', 'FAX')

Line 3613: hz_parties party,

3609: pending_promises
3610:
3611: FROM ar_trx_bal_summary trx_summ,
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,

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

3629: and objb.object_code <> 'IEX_DELINQUENCY'--Added for Bug 8707923 27-Jul-2009 barathsr
3630: AND party.country = fnd_terr.territory_code(+)
3631: AND fnd_terr.LANGUAGE(+) = userenv('LANG')
3632: AND phone.owner_table_id(+) = party.party_id
3633: AND phone.owner_table_name(+) = 'HZ_PARTIES'
3634: AND phone.contact_point_type(+) = 'PHONE'
3635: and phone.primary_by_purpose(+) = 'Y'
3636: AND phone.contact_point_purpose(+) = 'COLLECTIONS'
3637: AND phone.phone_line_type(+) NOT IN('PAGER', 'FAX')

Line 3743: hz_parties party,

3739: MAX(trx_summ.created_by) created_by,
3740: MAX(trx_summ.last_update_login) last_update_login
3741: FROM ar_trx_bal_summary trx_summ,
3742: hz_cust_accounts acc,
3743: hz_parties party,
3744: hz_party_preferences party_pref,--Added for Bug 8707923 27-Jul-2009 barathsr
3745: jtf_objects_b objb,
3746: GL_SETS_OF_BOOKS gl,
3747: AR_SYSTEM_PARAMETERS_all sys

Line 3861: hz_parties party,

3857: party.province province,
3858: party.postal_code postal_code
3859: FROM iex_dln_uwq_summary summ,
3860: -- hz_cust_accounts acc,
3861: hz_parties party,
3862: hz_party_preferences party_pref,
3863: fnd_territories_tl fnd_terr
3864: WHERE
3865: summ.party_id = party.party_id

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

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'
3898: AND phone.primary_by_purpose(+) = 'Y'
3899: AND phone.contact_point_purpose(+) = 'COLLECTIONS'
3900: AND phone.phone_line_type(+) NOT IN('PAGER', 'FAX')

Line 4191: hz_parties party,

4187: pending_promises
4188:
4189: FROM ar_trx_bal_summary trx_summ,
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,

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

4204: and objb.object_code <> 'IEX_DELINQUENCY'--Added for Bug 8707923 27-Jul-2009 barathsr
4205: AND party.country = fnd_terr.territory_code(+)
4206: AND fnd_terr.LANGUAGE(+) = userenv('LANG')
4207: AND phone.owner_table_id(+) = party.party_id
4208: AND phone.owner_table_name(+) = 'HZ_PARTIES'
4209: AND phone.contact_point_type(+) = 'PHONE'
4210: and phone.primary_by_purpose(+) = 'Y'
4211: AND phone.contact_point_purpose(+) = 'COLLECTIONS'
4212: AND phone.phone_line_type(+) NOT IN('PAGER', 'FAX')

Line 4325: hz_parties party,

4321: MAX(trx_summ.created_by) created_by,
4322: MAX(trx_summ.last_update_login) last_update_login
4323: FROM ar_trx_bal_summary trx_summ,
4324: hz_cust_accounts acc,
4325: hz_parties party,
4326: hz_party_preferences party_pref,--Added for Bug 8707923 27-Jul-2009 barathsr
4327: jtf_objects_b objb,
4328: GL_SETS_OF_BOOKS gl,
4329: AR_SYSTEM_PARAMETERS_all sys

Line 4454: hz_parties party,

4450: party.province province,
4451: party.postal_code postal_code
4452: FROM iex_dln_uwq_summary summ,
4453: -- hz_cust_accounts acc,
4454: hz_parties party,
4455: hz_party_preferences party_pref,
4456: fnd_territories_tl fnd_terr
4457: WHERE
4458: summ.party_id = party.party_id

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

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'
4493: AND phone.primary_by_purpose(+) = 'Y'
4494: AND phone.contact_point_purpose(+) = 'COLLECTIONS'
4495: AND phone.phone_line_type(+) NOT IN('PAGER', 'FAX')

Line 4796: hz_parties party,

4792: fnd_terr.territory_short_name country,
4793: party.province province,
4794: party.postal_code postal_code
4795: FROM
4796: hz_parties party,
4797: iex_dln_uwq_summary ids,
4798: fnd_territories_tl fnd_terr
4799: WHERE
4800: party.party_id = ids.party_id

Line 4846: AND phone.owner_table_name = 'HZ_PARTIES'

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'
4847: AND phone.contact_point_type = 'PHONE'
4848: and phone.primary_by_purpose = 'Y'
4849: AND phone.contact_point_purpose = 'COLLECTIONS'
4850: AND phone.phone_line_type NOT IN('PAGER', 'FAX')

Line 9624: hz_parties party,

9620: loc.postal_code postal_code
9621: -- end for the bug#8538945
9622: FROM ar_trx_bal_summary trx_summ,
9623: hz_cust_accounts acc,
9624: hz_parties party,
9625: jtf_objects_b objb,
9626: fnd_territories_tl fnd_terr,
9627: hz_cust_site_uses_all site_uses,
9628: GL_SETS_OF_BOOKS gl,

Line 9744: AND phone.owner_table_name = 'HZ_PARTIES'

9740: iex_dln_uwq_summary ids,
9741: iex_pop_uwq_summ_gt temp
9742: WHERE
9743: phone.owner_table_id = ids.party_id
9744: AND phone.owner_table_name = 'HZ_PARTIES'
9745: AND phone.contact_point_type = 'PHONE'
9746: and phone.primary_by_purpose = 'Y'
9747: AND phone.contact_point_purpose = 'COLLECTIONS'
9748: AND phone.phone_line_type NOT IN('PAGER', 'FAX')

Line 10972: hz_parties party,

10968: party.province province,
10969: party.postal_code postal_code
10970: FROM ar_trx_bal_summary trx_summ,
10971: hz_cust_accounts acc,
10972: hz_parties party,
10973: jtf_objects_b objb,
10974: fnd_territories_tl fnd_terr,
10975: GL_SETS_OF_BOOKS gl,
10976: AR_SYSTEM_PARAMETERS_all sys

Line 11071: AND phone.owner_table_name = 'HZ_PARTIES'

11067: iex_dln_uwq_summary ids,
11068: iex_pop_uwq_summ_gt temp
11069: WHERE
11070: phone.owner_table_id = ids.party_id
11071: AND phone.owner_table_name = 'HZ_PARTIES'
11072: AND phone.contact_point_type = 'PHONE'
11073: and phone.primary_by_purpose = 'Y'
11074: AND phone.contact_point_purpose = 'COLLECTIONS'
11075: AND phone.phone_line_type NOT IN('PAGER', 'FAX')

Line 12289: hz_parties party,

12285: party.province province,
12286: party.postal_code postal_code
12287: FROM ar_trx_bal_summary trx_summ,
12288: hz_cust_accounts acc,
12289: hz_parties party,
12290: jtf_objects_b objb,
12291: fnd_territories_tl fnd_terr,
12292: GL_SETS_OF_BOOKS gl,
12293: AR_SYSTEM_PARAMETERS_all sys

Line 12382: AND phone.owner_table_name = 'HZ_PARTIES'

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'
12383: AND phone.contact_point_type = 'PHONE'
12384: and phone.primary_by_purpose = 'Y'
12385: AND phone.contact_point_purpose = 'COLLECTIONS'
12386: AND phone.phone_line_type NOT IN('PAGER', 'FAX')