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_PARTY_PREFERENCES

Line 1147: hz_party_preferences party_pref,--Added for Bug 8707923 27-Jul-2009 barathsr

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,
1151: hz_cust_site_uses_all site_uses,

Line 1296: hz_party_preferences party_pref

1292: GL_SETS_OF_BOOKS gl,
1293: AR_SYSTEM_PARAMETERS_all sys,
1294: jtf_objects_b objb,
1295: hz_cust_accounts acc,
1296: hz_party_preferences party_pref
1297: where
1298: P_MODE = 'CP'
1299: AND trx_summ.reference_1 = '1'
1300: AND objb.object_code = 'IEX_BILLTO'

Line 1407: -- hz_party_preferences party_pref, -- Commented for bug13452739

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,
1411: hz_party_sites party_site,

Line 1765: hz_party_preferences party_pref,--Added for Bug 8707923 27-Jul-2009 barathsr

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,
1769: hz_cust_site_uses_all site_uses,

Line 1920: hz_party_preferences party_pref

1916: GL_SETS_OF_BOOKS gl,
1917: AR_SYSTEM_PARAMETERS_all sys,
1918: jtf_objects_b objb,
1919: hz_cust_accounts acc,
1920: hz_party_preferences party_pref
1921: where
1922: P_MODE = 'CP'
1923: AND trx_summ.reference_1 = '1'
1924: AND objb.object_code = 'IEX_BILLTO'

Line 2044: hz_party_preferences party_pref,

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,
2048: hz_party_sites party_site,

Line 2419: hz_party_preferences party_pref,--Added for Bug 8707923 27-Jul-2009 barathsr

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,
2423: hz_customer_profiles prf,

Line 2545: hz_party_preferences party_pref,--Added for Bug 8707923 27-Jul-2009 barathsr

2541: MAX(trx_summ.created_by) created_by,
2542: MAX(trx_summ.last_update_login) last_update_login
2543: FROM ar_trx_bal_summary trx_summ,
2544: hz_cust_accounts acc,
2545: hz_party_preferences party_pref,--Added for Bug 8707923 27-Jul-2009 barathsr
2546: jtf_objects_b objb,
2547: GL_SETS_OF_BOOKS gl,
2548: AR_SYSTEM_PARAMETERS_all sys
2549: WHERE

Line 2659: hz_party_preferences party_pref,

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
2663: AND acc.party_id = party.party_id

Line 3001: hz_party_preferences party_pref,--Added for Bug 8707923 27-Jul-2009 barathsr

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,
3005: hz_customer_profiles prf,

Line 3137: hz_party_preferences party_pref,--Added for Bug 8707923 27-Jul-2009 barathsr

3133: MAX(trx_summ.created_by) created_by,
3134: MAX(trx_summ.last_update_login) last_update_login
3135: FROM ar_trx_bal_summary trx_summ,
3136: hz_cust_accounts acc,
3137: hz_party_preferences party_pref,--Added for Bug 8707923 27-Jul-2009 barathsr
3138: jtf_objects_b objb,
3139: GL_SETS_OF_BOOKS gl,
3140: AR_SYSTEM_PARAMETERS_all sys
3141: WHERE

Line 3257: hz_party_preferences party_pref,

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
3261: AND acc.party_id = party.party_id

Line 3614: hz_party_preferences party_pref,--Added for Bug 8707923 27-Jul-2009 barathsr

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,
3618: hz_customer_profiles prf,

Line 3744: hz_party_preferences party_pref,--Added for Bug 8707923 27-Jul-2009 barathsr

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
3748:

Line 3862: hz_party_preferences party_pref,

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
3866: AND party.country = fnd_terr.territory_code(+)

Line 4192: hz_party_preferences party_pref,--Added for Bug 8707923 27-Jul-2009 barathsr

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,
4196: hz_customer_profiles prf,

Line 4326: hz_party_preferences party_pref,--Added for Bug 8707923 27-Jul-2009 barathsr

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
4330:

Line 4455: hz_party_preferences party_pref,

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
4459: AND party.country = fnd_terr.territory_code(+)

Line 10051: select del.customer_site_use_id,'IEX_BILLTO',del.org_id from iex_delinquencies del,hz_party_preferences party_pref

10047: delete from iex_pop_uwq_summ_gt;
10048:
10049: FND_FILE.PUT_LINE(FND_FILE.LOG,'Insert into bill_to gt');
10050: insert into iex_pop_uwq_summ_gt(object_id,object_type,org_id)
10051: select del.customer_site_use_id,'IEX_BILLTO',del.org_id from iex_delinquencies del,hz_party_preferences party_pref
10052: where del.status in ('DELINQUENT','PRE-DELINQUENT')
10053: and del.party_cust_id=party_pref.party_id(+)
10054: and party_pref.module(+)='COLLECTIONS'
10055: and party_pref.category(+)='COLLECTIONS LEVEL'

Line 11373: select del.cust_account_id,'IEX_ACCOUNT',del.org_id from iex_delinquencies del,hz_party_preferences party_pref

11369: delete from iex_pop_uwq_summ_gt;
11370: -- End Bug #6251657 bibeura 25-OCT-2007
11371: FND_FILE.PUT_LINE(FND_FILE.LOG,'Insert into account gt');
11372: insert into iex_pop_uwq_summ_gt(object_id,object_type,org_id)
11373: select del.cust_account_id,'IEX_ACCOUNT',del.org_id from iex_delinquencies del,hz_party_preferences party_pref
11374: where del.status in ('DELINQUENT','PRE-DELINQUENT')
11375: and del.party_cust_id=party_pref.party_id(+)
11376: and party_pref.module(+)='COLLECTIONS'
11377: and party_pref.category(+)='COLLECTIONS LEVEL'

Line 12682: select del.party_cust_id,'PARTY',del.org_id from iex_delinquencies del,hz_party_preferences party_pref

12678: delete from iex_pop_uwq_summ_gt;
12679: FND_FILE.PUT_LINE(FND_FILE.LOG,'Insert into customer gt');
12680:
12681: insert into iex_pop_uwq_summ_gt(object_id,object_type,org_id)
12682: select del.party_cust_id,'PARTY',del.org_id from iex_delinquencies del,hz_party_preferences party_pref
12683: where del.status in ('DELINQUENT','PRE-DELINQUENT')
12684: and del.party_cust_id=party_pref.party_id(+)
12685: and party_pref.module(+)='COLLECTIONS'
12686: and party_pref.category(+)='COLLECTIONS LEVEL'