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 IEX_DLN_UWQ_SUMMARY_S

Line 1404: FROM iex_dln_uwq_summary summ,

1400: loc.county county,
1401: fnd_terr.territory_short_name country,
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,

Line 1451: FROM iex_dln_uwq_summary summ,

1447: phone.phone_country_code phone_country_code,
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'

Line 1504: from iex_dln_uwq_summary summ1

1500: where summ.reference_1='1'
1501: and gl.SET_OF_BOOKS_ID = sys.SET_OF_BOOKS_ID
1502: and summ.org_id = sys.org_id
1503: and summ.last_payment_date=(select max(summ1.last_payment_date)
1504: from iex_dln_uwq_summary summ1
1505: where summ1.site_use_id=summ.site_use_id);
1506:
1507: cursor c_billto_bankruptcies is
1508: select summ.party_id,

Line 1511: iex_dln_uwq_summary summ

1507: cursor c_billto_bankruptcies is
1508: select summ.party_id,
1509: COUNT(1) number_of_bankruptcies
1510: FROM iex_bankruptcies bkr,
1511: iex_dln_uwq_summary summ
1512: where bkr.customer_site_use_id=summ.site_use_id
1513: and NVL(BKR.DISPOSITION_CODE,'GRANTED') in ('GRANTED','NEGOTIATION')
1514: group by summ.party_id;
1515:

Line 2041: FROM iex_dln_uwq_summary summ,

2037: loc.county county,
2038: fnd_terr.territory_short_name country,
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,

Line 2087: FROM iex_dln_uwq_summary summ,

2083: phone.phone_country_code phone_country_code,
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'

Line 2162: from iex_dln_uwq_summary summ1

2158: where summ.reference_1='1'
2159: and gl.SET_OF_BOOKS_ID = sys.SET_OF_BOOKS_ID
2160: and summ.org_id = sys.org_id
2161: and summ.last_payment_date=(select max(summ1.last_payment_date)
2162: from iex_dln_uwq_summary summ1
2163: where summ1.site_use_id=summ.site_use_id
2164: --and trunc(summ1.last_update_date)>= trunc(sysdate-1)); -- chnaged for bug 13322580
2165: and summ1.request_id = FND_GLOBAL.CONC_REQUEST_ID); -- Added for bug13452739
2166:

Line 2172: iex_dln_uwq_summary summ

2168: cursor c_billto_bankruptcies_dt is
2169: select summ.party_id,
2170: COUNT(1) number_of_bankruptcies
2171: FROM iex_bankruptcies bkr,
2172: iex_dln_uwq_summary summ
2173: where bkr.customer_site_use_id=summ.site_use_id
2174: and NVL(BKR.DISPOSITION_CODE,'GRANTED') in ('GRANTED','NEGOTIATION')
2175: --AND trunc(summ.last_update_date)>=trunc(sysdate-1) --changed for bug 13322580
2176: AND summ.request_id = FND_GLOBAL.CONC_REQUEST_ID -- Added for bug13452739

Line 2656: FROM iex_dln_uwq_summary summ,

2652: party.county county,
2653: fnd_terr.territory_short_name country,
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

Line 2692: FROM iex_dln_uwq_summary summ,

2688: phone.phone_country_code phone_country_code,
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'

Line 2757: iex_dln_uwq_summary summ

2753: cursor c_acc_bankruptcies is
2754: select summ.party_id,summ.org_id,
2755: COUNT(1) number_of_bankruptcies
2756: FROM iex_bankruptcies bkr,
2757: iex_dln_uwq_summary summ
2758: where bkr.cust_account_id=summ.cust_account_id
2759: and NVL(BKR.DISPOSITION_CODE,'GRANTED') in ('GRANTED','NEGOTIATION')
2760: group by summ.party_id,summ.org_id;
2761:

Line 3254: FROM iex_dln_uwq_summary summ,

3250: party.county county,
3251: fnd_terr.territory_short_name country,
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

Line 3292: FROM iex_dln_uwq_summary summ,

3288: phone.phone_country_code phone_country_code,
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'

Line 3384: iex_dln_uwq_summary summ

3380: cursor c_acc_bankruptcies_dt is
3381: select summ.party_id,summ.org_id,
3382: COUNT(1) number_of_bankruptcies
3383: FROM iex_bankruptcies bkr,
3384: iex_dln_uwq_summary summ
3385: where bkr.cust_account_id=summ.cust_account_id
3386: and NVL(BKR.DISPOSITION_CODE,'GRANTED') in ('GRANTED','NEGOTIATION')
3387: --AND trunc(summ.LAST_UPDATE_DATE) >= trunc(sysdate-1) --changed for bug 13322580
3388: AND summ.request_id = FND_GLOBAL.CONC_REQUEST_ID -- Added for bug13452739

Line 3859: FROM iex_dln_uwq_summary summ,

3855: party.county county,
3856: fnd_terr.territory_short_name country,
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

Line 3892: FROM iex_dln_uwq_summary summ,

3888: phone.phone_country_code phone_country_code,
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'

Line 3962: iex_dln_uwq_summary summ

3958: cursor c_cu_bankruptcies is
3959: select summ.party_id,summ.org_id,
3960: COUNT(1) number_of_bankruptcies
3961: FROM iex_bankruptcies bkr,
3962: iex_dln_uwq_summary summ
3963: where bkr.party_id=summ.party_id
3964: and NVL(BKR.DISPOSITION_CODE,'GRANTED') in ('GRANTED','NEGOTIATION')
3965: and summ.site_use_id is null and summ.cust_account_id is null
3966: group by summ.party_id,summ.org_id;

Line 4452: FROM iex_dln_uwq_summary summ,

4448: party.county county,
4449: fnd_terr.territory_short_name country,
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

Line 4487: FROM iex_dln_uwq_summary summ,

4483: phone.phone_country_code phone_country_code,
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'

Line 4586: iex_dln_uwq_summary summ

4582: cursor c_cu_bankruptcies_dt is
4583: select summ.party_id,summ.org_id,
4584: COUNT(1) number_of_bankruptcies
4585: FROM iex_bankruptcies bkr,
4586: iex_dln_uwq_summary summ
4587: where bkr.party_id=summ.party_id
4588: and NVL(BKR.DISPOSITION_CODE,'GRANTED') in ('GRANTED','NEGOTIATION')
4589: and summ.site_use_id is null and summ.cust_account_id is null
4590: --AND trunc(summ.LAST_UPDATE_DATE) >= trunc(sysdate-1) --changed for bug 13322580

Line 4640: IEX_DLN_UWQ_SUMMARY sum

4636: wkitem.escalated_yn --Added for bug#6981126 by schekuri on 27-Jul-2008
4637: from iex_strategies strat,
4638: iex_strategy_work_items wkitem,
4639: iex_stry_temp_work_items_b stry_temp_wkitem,
4640: IEX_DLN_UWQ_SUMMARY sum
4641: where strat.jtf_object_type = 'PARTY'
4642: AND strat.status_code IN('OPEN', 'ONHOLD')
4643: AND wkitem.strategy_id = strat.strategy_id
4644: AND wkitem.status_code IN('OPEN', 'ONHOLD')

Line 4675: IEX_DLN_UWQ_SUMMARY sum

4671: wkitem.escalated_yn --Added for bug#6981126 by schekuri on 27-Jul-2008
4672: from iex_strategies strat,
4673: iex_strategy_work_items wkitem,
4674: iex_stry_temp_work_items_b stry_temp_wkitem,
4675: IEX_DLN_UWQ_SUMMARY sum
4676: where strat.jtf_object_type ='IEX_ACCOUNT'
4677: AND strat.status_code IN('OPEN', 'ONHOLD')
4678: AND wkitem.strategy_id = strat.strategy_id
4679: AND wkitem.status_code IN('OPEN', 'ONHOLD')

Line 4710: IEX_DLN_UWQ_SUMMARY sum

4706: wkitem.escalated_yn --Added for bug#6981126 by schekuri on 27-Jul-2008
4707: from iex_strategies strat,
4708: iex_strategy_work_items wkitem,
4709: iex_stry_temp_work_items_b stry_temp_wkitem,
4710: IEX_DLN_UWQ_SUMMARY sum
4711: where strat.jtf_object_type = 'IEX_BILLTO'
4712: AND strat.status_code IN('OPEN', 'ONHOLD')
4713: AND wkitem.strategy_id = strat.strategy_id
4714: AND wkitem.status_code IN('OPEN', 'ONHOLD')

Line 5479: (IEX_DLN_UWQ_SUMMARY_S.nextval,

5475: ,PROGRAM_APPLICATION_ID
5476: ,OBJECT_VERSION_NUMBER)
5477:
5478: VALUES
5479: (IEX_DLN_UWQ_SUMMARY_S.nextval,
5480: L_ORG_ID(i),
5481: L_IEU_OBJECT_FUNCTION(i),
5482: L_IEU_OBJECT_PARAMETERS(i),
5483: L_IEU_MEDIA_TYPE_UUID(i),

Line 10071: delete from iex_dln_uwq_summary summ

10067: else
10068: NULL;
10069: end if;
10070:
10071: delete from iex_dln_uwq_summary summ
10072: where exists(select 1
10073: from iex_pop_uwq_summ_gt gt,hz_cust_site_uses_all hcsua,hz_cust_acct_sites_all hcasa,hz_cust_accounts hca
10074: where gt.object_id=hcsua.site_use_id
10075: and hcsua.cust_acct_site_id=hcasa.cust_acct_site_id

Line 10298: (IEX_DLN_UWQ_SUMMARY_S.nextval,

10294: ,PROGRAM_ID
10295: ,PROGRAM_APPLICATION_ID
10296: ,OBJECT_VERSION_NUMBER)
10297: VALUES
10298: (IEX_DLN_UWQ_SUMMARY_S.nextval,
10299: L_ORG_ID(i),
10300: L_IEU_OBJECT_FUNCTION(i),
10301: L_IEU_OBJECT_PARAMETERS(i),
10302: L_IEU_MEDIA_TYPE_UUID(i),

Line 11393: delete from iex_dln_uwq_summary summ

11389: else
11390: null;
11391: end if;
11392:
11393: delete from iex_dln_uwq_summary summ
11394: where exists(select 1
11395: from iex_pop_uwq_summ_gt gt,hz_cust_accounts hca
11396: where gt.object_id=hca.cust_account_id
11397: and hca.party_id=summ.party_id

Line 11615: (IEX_DLN_UWQ_SUMMARY_S.nextval,

11611: ,PROGRAM_ID
11612: ,PROGRAM_APPLICATION_ID
11613: ,OBJECT_VERSION_NUMBER)
11614: VALUES
11615: (IEX_DLN_UWQ_SUMMARY_S.nextval,
11616: L_ORG_ID(i),
11617: L_IEU_OBJECT_FUNCTION(i),
11618: L_IEU_OBJECT_PARAMETERS(i),
11619: L_IEU_MEDIA_TYPE_UUID(i),

Line 12702: delete from iex_dln_uwq_summary summ

12698: else
12699: null;
12700: end if;
12701:
12702: delete from iex_dln_uwq_summary summ
12703: where exists(select 1
12704: from iex_pop_uwq_summ_gt gt
12705: where gt.object_id=summ.party_id
12706: and summ.cust_account_id is null

Line 12922: (IEX_DLN_UWQ_SUMMARY_S.nextval,

12918: ,PROGRAM_ID
12919: ,PROGRAM_APPLICATION_ID
12920: ,OBJECT_VERSION_NUMBER)
12921: VALUES
12922: (IEX_DLN_UWQ_SUMMARY_S.nextval,
12923: L_ORG_ID(i),
12924: L_IEU_OBJECT_FUNCTION(i),
12925: L_IEU_OBJECT_PARAMETERS(i),
12926: L_IEU_MEDIA_TYPE_UUID(i),

Line 13858: update IEX_DLN_UWQ_SUMMARY set

13854:
13855: if p_fmode = 'PARTY' then
13856:
13857: forall n in l_amount1.FIRST .. l_amount1.LAST
13858: update IEX_DLN_UWQ_SUMMARY set
13859: AGING_amount1 = nvl(l_amount1(n),0),
13860: AGING_COUNT1 = nvl(l_count1(n),0),
13861: AGING_amount2 = nvl(l_amount2(n),0),
13862: AGING_COUNT2 = nvl(l_count2(n),0),

Line 13879: update IEX_DLN_UWQ_SUMMARY set

13875: and site_use_id is null
13876: AND org_id = l_org_id(n);
13877: elsif p_fmode = 'CUST' then
13878: forall n in l_amount1.FIRST .. l_amount1.LAST
13879: update IEX_DLN_UWQ_SUMMARY set
13880: AGING_amount1 = nvl(l_amount1(n),0),
13881: AGING_COUNT1 = nvl(l_count1(n),0),
13882: AGING_amount2 = nvl(l_amount2(n),0),
13883: AGING_COUNT2 = nvl(l_count2(n),0),

Line 13900: update IEX_DLN_UWQ_SUMMARY set

13896: and site_use_id is null
13897: AND org_id = l_org_id(n);
13898: else
13899: forall n in l_amount1.FIRST .. l_amount1.LAST
13900: update IEX_DLN_UWQ_SUMMARY set
13901: AGING_amount1 = nvl(l_amount1(n),0),
13902: AGING_COUNT1 = nvl(l_count1(n),0),
13903: AGING_amount2 = nvl(l_amount2(n),0),
13904: AGING_COUNT2 = nvl(l_count2(n),0),

Line 13955: update IEX_DLN_UWQ_SUMMARY set

13951: if l_amount1.count> 0 then
13952: j :=1;
13953: if p_fmode = 'PARTY' then
13954: forall n in l_amount1.FIRST .. l_amount1.LAST
13955: update IEX_DLN_UWQ_SUMMARY set
13956: AGING_amount1 = nvl(l_amount1(n),0),
13957: AGING_COUNT1 = nvl(l_count1(n),0),
13958: AGING_amount2 = nvl(l_amount2(n),0),
13959: AGING_COUNT2 = nvl(l_count2(n),0),

Line 13977: update IEX_DLN_UWQ_SUMMARY set

13973: AND org_id = l_org_id(n);
13974:
13975: elsif p_fmode = 'CUST' then
13976: forall n in l_amount1.FIRST .. l_amount1.LAST
13977: update IEX_DLN_UWQ_SUMMARY set
13978: AGING_amount1 = nvl(l_amount1(n),0),
13979: AGING_COUNT1 = nvl(l_count1(n),0),
13980: AGING_amount2 = nvl(l_amount2(n),0),
13981: AGING_COUNT2 = nvl(l_count2(n),0),

Line 13998: update IEX_DLN_UWQ_SUMMARY set

13994: and site_use_id is null
13995: AND org_id = l_org_id(n);
13996: else
13997: forall n in l_amount1.FIRST .. l_amount1.LAST
13998: update IEX_DLN_UWQ_SUMMARY set
13999: AGING_amount1 = nvl(l_amount1(n),0),
14000: AGING_COUNT1 = nvl(l_count1(n),0),
14001: AGING_amount2 = nvl(l_amount2(n),0),
14002: AGING_COUNT2 = nvl(l_count2(n),0),

Line 14105: update iex_dln_uwq_summary set

14101: temp := temp+1;
14102:
14103: if temp = l_max_fetches then
14104: forall i in l_cases_count.FIRST .. l_cases_count.LAST
14105: update iex_dln_uwq_summary set
14106: cases_count = nvl(l_cases_count(i),0),
14107: del_cases_count = nvl(l_del_cases_count(i),0),
14108: contracts_count = nvl(l_contracts_count(i),0),
14109: del_contracts_count = nvl(l_del_contracts_count(i),0)

Line 14124: update iex_dln_uwq_summary set

14120: end if;
14121:
14122: end loop; -- end loop r_contract
14123: forall i in l_cases_count.FIRST .. l_cases_count.LAST
14124: update iex_dln_uwq_summary set
14125: cases_count = nvl(l_cases_count(i),0),
14126: del_cases_count = nvl(l_del_cases_count(i),0),
14127: contracts_count = nvl(l_contracts_count(i),0),
14128: del_contracts_count = nvl(l_del_contracts_count(i),0)