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_SCORE_HISTORIES

Line 1041: FROM iex_score_histories a

1037: )
1038: pending_delinquencies,*/ --9597052
1039: -- Start for the bug#7562130 by PNAVEENK
1040: /* (SELECT a.score_value
1041: FROM iex_score_histories a
1042: WHERE a.creation_date =
1043: (SELECT MAX(creation_date)
1044: FROM iex_score_histories
1045: WHERE score_object_code = 'IEX_BILLTO'

Line 1044: FROM iex_score_histories

1040: /* (SELECT a.score_value
1041: FROM iex_score_histories a
1042: WHERE a.creation_date =
1043: (SELECT MAX(creation_date)
1044: FROM iex_score_histories
1045: WHERE score_object_code = 'IEX_BILLTO'
1046: AND score_object_id = trx_summ.site_use_id)
1047: AND rownum < 2
1048: AND a.score_object_code = 'IEX_BILLTO'

Line 1521: FROM iex_score_histories sh,iex_scores sc

1517: SELECT sh.score_object_id,
1518: sh.score_value score,
1519: sc.score_id,
1520: sc.score_name
1521: FROM iex_score_histories sh,iex_scores sc
1522: WHERE sc.score_id = sh.score_id
1523: and sh.score_object_code = 'IEX_BILLTO'
1524: and (sh.score_object_id,sh.score_object_code,sh.creation_date)
1525: in (SELECT sh1.score_object_id,sh1.score_object_code,MAX(sh1.creation_date)

Line 1526: FROM iex_score_histories sh1,

1522: WHERE sc.score_id = sh.score_id
1523: and sh.score_object_code = 'IEX_BILLTO'
1524: and (sh.score_object_id,sh.score_object_code,sh.creation_date)
1525: in (SELECT sh1.score_object_id,sh1.score_object_code,MAX(sh1.creation_date)
1526: FROM iex_score_histories sh1,
1527: iex_dln_uwq_summary temp
1528: WHERE sh1.score_object_code = 'IEX_BILLTO'
1529: AND sh1.score_object_id = temp.site_use_id
1530: group by sh1.score_object_id,sh1.score_object_code);

Line 1661: FROM iex_score_histories a

1657: )
1658: pending_delinquencies,*/ --9597052
1659: -- Start for the bug#7562130 by PNAVEENK
1660: /* (SELECT a.score_value
1661: FROM iex_score_histories a
1662: WHERE a.creation_date =
1663: (SELECT MAX(creation_date)
1664: FROM iex_score_histories
1665: WHERE score_object_code = 'IEX_BILLTO'

Line 1664: FROM iex_score_histories

1660: /* (SELECT a.score_value
1661: FROM iex_score_histories a
1662: WHERE a.creation_date =
1663: (SELECT MAX(creation_date)
1664: FROM iex_score_histories
1665: WHERE score_object_code = 'IEX_BILLTO'
1666: AND score_object_id = trx_summ.site_use_id)
1667: AND rownum < 2
1668: AND a.score_object_code = 'IEX_BILLTO'

Line 2184: FROM iex_score_histories sh,iex_scores sc

2180: SELECT sh.score_object_id,
2181: sh.score_value score,
2182: sc.score_id,
2183: sc.score_name
2184: FROM iex_score_histories sh,iex_scores sc
2185: WHERE sc.score_id = sh.score_id
2186: and (sh.score_object_id,sh.score_object_code,sh.creation_date)
2187: in (SELECT sh1.score_object_id,sh1.score_object_code,MAX(sh1.creation_date)
2188: FROM iex_score_histories sh1,

Line 2188: FROM iex_score_histories sh1,

2184: FROM iex_score_histories sh,iex_scores sc
2185: WHERE sc.score_id = sh.score_id
2186: and (sh.score_object_id,sh.score_object_code,sh.creation_date)
2187: in (SELECT sh1.score_object_id,sh1.score_object_code,MAX(sh1.creation_date)
2188: FROM iex_score_histories sh1,
2189: iex_dln_uwq_summary temp
2190: WHERE sh1.score_object_code = 'IEX_BILLTO'
2191: AND sh1.score_object_id = temp.site_use_id
2192: --AND trunc(temp.LAST_UPDATE_DATE) >= trunc(sysdate-1) -- chnaged for bug 13322580

Line 2325: FROM iex_score_histories a

2321: pending_delinquencies,
2322:
2323: -- Start for the bug#7562130 by PNAVEENK
2324: /* (SELECT a.score_value
2325: FROM iex_score_histories a
2326: WHERE a.creation_date =
2327: (SELECT MAX(creation_date)
2328: FROM iex_score_histories
2329: WHERE score_object_code = 'IEX_ACCOUNT'

Line 2328: FROM iex_score_histories

2324: /* (SELECT a.score_value
2325: FROM iex_score_histories a
2326: WHERE a.creation_date =
2327: (SELECT MAX(creation_date)
2328: FROM iex_score_histories
2329: WHERE score_object_code = 'IEX_ACCOUNT'
2330: AND score_object_id = trx_summ.cust_account_id)
2331: AND rownum < 2
2332: AND a.score_object_code = 'IEX_ACCOUNT'

Line 2767: FROM iex_score_histories sh,iex_scores sc

2763: SELECT sh.score_object_id,
2764: sh.score_value score,
2765: sc.score_id,
2766: sc.score_name
2767: FROM iex_score_histories sh,iex_scores sc
2768: WHERE sc.score_id = sh.score_id
2769: and sh.score_object_code = 'IEX_ACCOUNT'
2770: and (sh.score_object_id,sh.score_object_code,sh.creation_date)
2771: in (SELECT sh1.score_object_id,sh1.score_object_code,MAX(sh1.creation_date)

Line 2772: FROM iex_score_histories sh1,

2768: WHERE sc.score_id = sh.score_id
2769: and sh.score_object_code = 'IEX_ACCOUNT'
2770: and (sh.score_object_id,sh.score_object_code,sh.creation_date)
2771: in (SELECT sh1.score_object_id,sh1.score_object_code,MAX(sh1.creation_date)
2772: FROM iex_score_histories sh1,
2773: iex_dln_uwq_summary temp
2774: WHERE sh1.score_object_code = 'IEX_ACCOUNT'
2775: AND sh1.score_object_id = temp.cust_account_id
2776: and temp.site_use_id is null

Line 2907: FROM iex_score_histories a

2903: )
2904: pending_delinquencies,
2905: -- Start for the bug#7562130 by PNAVEENK
2906: /* (SELECT a.score_value
2907: FROM iex_score_histories a
2908: WHERE a.creation_date =
2909: (SELECT MAX(creation_date)
2910: FROM iex_score_histories
2911: WHERE score_object_code = 'IEX_ACCOUNT'

Line 2910: FROM iex_score_histories

2906: /* (SELECT a.score_value
2907: FROM iex_score_histories a
2908: WHERE a.creation_date =
2909: (SELECT MAX(creation_date)
2910: FROM iex_score_histories
2911: WHERE score_object_code = 'IEX_ACCOUNT'
2912: AND score_object_id = trx_summ.cust_account_id)
2913: AND rownum < 2
2914: AND a.score_object_code = 'IEX_ACCOUNT'

Line 3396: FROM iex_score_histories sh,iex_scores sc

3392: SELECT sh.score_object_id,
3393: sh.score_value score,
3394: sc.score_id,
3395: sc.score_name
3396: FROM iex_score_histories sh,iex_scores sc
3397: WHERE sc.score_id = sh.score_id
3398: and sh.score_object_code = 'IEX_ACCOUNT'
3399: and (sh.score_object_id,sh.score_object_code,sh.creation_date)
3400: in (SELECT sh1.score_object_id,sh1.score_object_code,MAX(sh1.creation_date)

Line 3401: FROM iex_score_histories sh1,

3397: WHERE sc.score_id = sh.score_id
3398: and sh.score_object_code = 'IEX_ACCOUNT'
3399: and (sh.score_object_id,sh.score_object_code,sh.creation_date)
3400: in (SELECT sh1.score_object_id,sh1.score_object_code,MAX(sh1.creation_date)
3401: FROM iex_score_histories sh1,
3402: iex_dln_uwq_summary temp
3403: WHERE sh1.score_object_code = 'IEX_ACCOUNT'
3404: AND sh1.score_object_id = temp.cust_account_id
3405: and temp.site_use_id is null

Line 3537: FROM iex_score_histories a

3533: pending_delinquencies,
3534:
3535: -- Start for the bug#7562130 by PNAVEENK
3536: /* (SELECT a.score_value
3537: FROM iex_score_histories a
3538: WHERE a.creation_date =
3539: (SELECT MAX(creation_date)
3540: FROM iex_score_histories
3541: WHERE score_object_code = 'PARTY'

Line 3540: FROM iex_score_histories

3536: /* (SELECT a.score_value
3537: FROM iex_score_histories a
3538: WHERE a.creation_date =
3539: (SELECT MAX(creation_date)
3540: FROM iex_score_histories
3541: WHERE score_object_code = 'PARTY'
3542: AND score_object_id = party.party_id)
3543: AND rownum < 2
3544: AND a.score_object_code = 'PARTY'

Line 3973: FROM iex_score_histories sh,iex_scores sc

3969: SELECT sh.score_object_id,
3970: sh.score_value score,
3971: sc.score_id,
3972: sc.score_name
3973: FROM iex_score_histories sh,iex_scores sc
3974: WHERE sc.score_id = sh.score_id
3975: and sh.score_object_code = 'PARTY'
3976: and (sh.score_object_id,sh.score_object_code,sh.creation_date)
3977: in (SELECT sh1.score_object_id,sh1.score_object_code,MAX(sh1.creation_date)

Line 3978: FROM iex_score_histories sh1,

3974: WHERE sc.score_id = sh.score_id
3975: and sh.score_object_code = 'PARTY'
3976: and (sh.score_object_id,sh.score_object_code,sh.creation_date)
3977: in (SELECT sh1.score_object_id,sh1.score_object_code,MAX(sh1.creation_date)
3978: FROM iex_score_histories sh1,
3979: iex_dln_uwq_summary temp
3980: WHERE sh1.score_object_code = 'PARTY'
3981: AND sh1.score_object_id = temp.party_id
3982: and temp.site_use_id is null

Line 4115: FROM iex_score_histories a

4111: )
4112: pending_delinquencies,
4113: -- Start for the bug#7562130 by PNAVEENK
4114: /* (SELECT a.score_value
4115: FROM iex_score_histories a
4116: WHERE a.creation_date =
4117: (SELECT MAX(creation_date)
4118: FROM iex_score_histories
4119: WHERE score_object_code = 'PARTY'

Line 4118: FROM iex_score_histories

4114: /* (SELECT a.score_value
4115: FROM iex_score_histories a
4116: WHERE a.creation_date =
4117: (SELECT MAX(creation_date)
4118: FROM iex_score_histories
4119: WHERE score_object_code = 'PARTY'
4120: AND score_object_id = party.party_id)
4121: AND rownum < 2
4122: AND a.score_object_code = 'PARTY'

Line 4599: FROM iex_score_histories sh,iex_scores sc

4595: SELECT sh.score_object_id,
4596: sh.score_value score,
4597: sc.score_id,
4598: sc.score_name
4599: FROM iex_score_histories sh,iex_scores sc
4600: WHERE sc.score_id = sh.score_id
4601: and sh.score_object_code = 'PARTY'
4602: and (sh.score_object_id,sh.score_object_code,sh.creation_date)
4603: in (SELECT sh1.score_object_id,sh1.score_object_code,MAX(sh1.creation_date)

Line 4604: FROM iex_score_histories sh1,

4600: WHERE sc.score_id = sh.score_id
4601: and sh.score_object_code = 'PARTY'
4602: and (sh.score_object_id,sh.score_object_code,sh.creation_date)
4603: in (SELECT sh1.score_object_id,sh1.score_object_code,MAX(sh1.creation_date)
4604: FROM iex_score_histories sh1,
4605: iex_dln_uwq_summary temp
4606: WHERE sh1.score_object_code = 'PARTY'
4607: AND sh1.score_object_id = temp.party_id
4608: --AND trunc(temp.LAST_UPDATE_DATE) >= trunc(sysdate-1) --changed for bug 13322580

Line 9911: FROM iex_score_histories sh,

9907: GROUP BY del.customer_site_use_id;
9908: -- Start for the bug#7562130 by PNAVEENK
9909: cursor c_billto_score is
9910: SELECT sh.score_object_id, sh.score_value score , sh.score_id, sc.score_name
9911: FROM iex_score_histories sh,
9912: iex_pop_uwq_summ_gt temp,
9913: iex_scores sc
9914: WHERE sh.creation_date = (SELECT MAX(creation_date)
9915: FROM iex_score_histories sh1

Line 9915: FROM iex_score_histories sh1

9911: FROM iex_score_histories sh,
9912: iex_pop_uwq_summ_gt temp,
9913: iex_scores sc
9914: WHERE sh.creation_date = (SELECT MAX(creation_date)
9915: FROM iex_score_histories sh1
9916: WHERE sh1.score_object_code = 'IEX_BILLTO'
9917: AND sh1.score_object_id = sh.score_object_id)
9918: -- AND rownum < 2
9919: AND sh.score_object_code = 'IEX_BILLTO'

Line 11238: FROM iex_score_histories sh,

11234: GROUP BY del.cust_account_id;
11235: -- Start for the bug#7562130 by PNAVEENK
11236: cursor c_account_score is
11237: SELECT sh.score_object_id, sh.score_value score,sh.score_id, sc.score_name
11238: FROM iex_score_histories sh,
11239: iex_pop_uwq_summ_gt temp,
11240: iex_scores sc
11241: WHERE sh.creation_date = (SELECT MAX(creation_date)
11242: FROM iex_score_histories sh1

Line 11242: FROM iex_score_histories sh1

11238: FROM iex_score_histories sh,
11239: iex_pop_uwq_summ_gt temp,
11240: iex_scores sc
11241: WHERE sh.creation_date = (SELECT MAX(creation_date)
11242: FROM iex_score_histories sh1
11243: WHERE sh1.score_object_code = 'IEX_ACCOUNT'
11244: AND sh1.score_object_id = sh.score_object_id)
11245: -- AND rownum < 2
11246: AND sh.score_object_code = 'IEX_ACCOUNT'

Line 12548: FROM iex_score_histories sh,

12544: GROUP BY del.party_cust_id;
12545: -- Start for the bug#7562130 by PNAVEENK
12546: cursor c_customer_score is
12547: SELECT sh.score_object_id, sh.score_value score, sh.score_id, sc.score_name
12548: FROM iex_score_histories sh,
12549: iex_pop_uwq_summ_gt temp,
12550: iex_scores sc
12551: WHERE sh.creation_date = (SELECT MAX(creation_date)
12552: FROM iex_score_histories sh1

Line 12552: FROM iex_score_histories sh1

12548: FROM iex_score_histories sh,
12549: iex_pop_uwq_summ_gt temp,
12550: iex_scores sc
12551: WHERE sh.creation_date = (SELECT MAX(creation_date)
12552: FROM iex_score_histories sh1
12553: WHERE sh1.score_object_code = 'PARTY'
12554: AND sh1.score_object_id = sh.score_object_id)
12555: AND sh.score_object_code = 'PARTY'
12556: AND sh.score_object_id = temp.object_id

Line 14036: FROM iex_score_histories a, iex_scores b

14032: -- Start for the bug#7562130 by PNAVEENK
14033: function cal_score(p_object_id number, p_object_type varchar2, p_select_column varchar2) return varchar2 is
14034: cursor c_score (p_object_id number , p_object_type varchar2) is
14035: SELECT a.score_value, a.score_id, b.score_name
14036: FROM iex_score_histories a, iex_scores b
14037: WHERE a.creation_date =
14038: (SELECT MAX(creation_date)
14039: FROM iex_score_histories
14040: WHERE score_object_code = p_object_type

Line 14039: FROM iex_score_histories

14035: SELECT a.score_value, a.score_id, b.score_name
14036: FROM iex_score_histories a, iex_scores b
14037: WHERE a.creation_date =
14038: (SELECT MAX(creation_date)
14039: FROM iex_score_histories
14040: WHERE score_object_code = p_object_type
14041: AND score_object_id = p_object_id)
14042: AND rownum < 2
14043: AND a.score_object_code = p_object_type