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 207: FROM iex_score_histories a

203: AND(TRUNC(uwq_active_date) > TRUNC(sysdate))))
204: )
205: pending_delinquencies,
206: (SELECT a.score_value
207: FROM iex_score_histories a
208: WHERE a.creation_date =
209: (SELECT MAX(creation_date)
210: FROM iex_score_histories
211: WHERE score_object_code = 'IEX_BILLTO'

Line 210: FROM iex_score_histories

206: (SELECT a.score_value
207: FROM iex_score_histories a
208: WHERE a.creation_date =
209: (SELECT MAX(creation_date)
210: FROM iex_score_histories
211: WHERE score_object_code = 'IEX_BILLTO'
212: AND score_object_id = trx_summ.site_use_id)
213: AND rownum < 2
214: AND a.score_object_code = 'IEX_BILLTO'

Line 470: FROM iex_score_histories a

466: AND(TRUNC(uwq_active_date) > TRUNC(sysdate))))
467: )
468: pending_delinquencies,
469: (SELECT a.score_value
470: FROM iex_score_histories a
471: WHERE a.creation_date =
472: (SELECT MAX(creation_date)
473: FROM iex_score_histories
474: WHERE score_object_code = 'IEX_BILLTO'

Line 473: FROM iex_score_histories

469: (SELECT a.score_value
470: FROM iex_score_histories a
471: WHERE a.creation_date =
472: (SELECT MAX(creation_date)
473: FROM iex_score_histories
474: WHERE score_object_code = 'IEX_BILLTO'
475: AND score_object_id = trx_summ.site_use_id)
476: AND rownum < 2
477: AND a.score_object_code = 'IEX_BILLTO'

Line 737: FROM iex_score_histories a

733: AND(TRUNC(uwq_active_date) > TRUNC(sysdate))))
734: )
735: pending_delinquencies,
736: (SELECT a.score_value
737: FROM iex_score_histories a
738: WHERE a.creation_date =
739: (SELECT MAX(creation_date)
740: FROM iex_score_histories
741: WHERE score_object_code = 'IEX_ACCOUNT'

Line 740: FROM iex_score_histories

736: (SELECT a.score_value
737: FROM iex_score_histories a
738: WHERE a.creation_date =
739: (SELECT MAX(creation_date)
740: FROM iex_score_histories
741: WHERE score_object_code = 'IEX_ACCOUNT'
742: AND score_object_id = trx_summ.cust_account_id)
743: AND rownum < 2
744: AND a.score_object_code = 'IEX_ACCOUNT'

Line 995: FROM iex_score_histories a

991: AND(TRUNC(uwq_active_date) > TRUNC(sysdate))))
992: )
993: pending_delinquencies,
994: (SELECT a.score_value
995: FROM iex_score_histories a
996: WHERE a.creation_date =
997: (SELECT MAX(creation_date)
998: FROM iex_score_histories
999: WHERE score_object_code = 'IEX_ACCOUNT'

Line 998: FROM iex_score_histories

994: (SELECT a.score_value
995: FROM iex_score_histories a
996: WHERE a.creation_date =
997: (SELECT MAX(creation_date)
998: FROM iex_score_histories
999: WHERE score_object_code = 'IEX_ACCOUNT'
1000: AND score_object_id = trx_summ.cust_account_id)
1001: AND rownum < 2
1002: AND a.score_object_code = 'IEX_ACCOUNT'

Line 1261: FROM iex_score_histories a

1257: AND(TRUNC(uwq_active_date) > TRUNC(sysdate))))
1258: )
1259: pending_delinquencies,
1260: (SELECT a.score_value
1261: FROM iex_score_histories a
1262: WHERE a.creation_date =
1263: (SELECT MAX(creation_date)
1264: FROM iex_score_histories
1265: WHERE score_object_code = 'PARTY'

Line 1264: FROM iex_score_histories

1260: (SELECT a.score_value
1261: FROM iex_score_histories a
1262: WHERE a.creation_date =
1263: (SELECT MAX(creation_date)
1264: FROM iex_score_histories
1265: WHERE score_object_code = 'PARTY'
1266: AND score_object_id = party.party_id)
1267: AND rownum < 2
1268: AND a.score_object_code = 'PARTY'

Line 1501: FROM iex_score_histories a

1497: AND(TRUNC(uwq_active_date) > TRUNC(sysdate))))
1498: )
1499: pending_delinquencies,
1500: (SELECT a.score_value
1501: FROM iex_score_histories a
1502: WHERE a.creation_date =
1503: (SELECT MAX(creation_date)
1504: FROM iex_score_histories
1505: WHERE score_object_code = 'PARTY'

Line 1504: FROM iex_score_histories

1500: (SELECT a.score_value
1501: FROM iex_score_histories a
1502: WHERE a.creation_date =
1503: (SELECT MAX(creation_date)
1504: FROM iex_score_histories
1505: WHERE score_object_code = 'PARTY'
1506: AND score_object_id = party.party_id)
1507: AND rownum < 2
1508: AND a.score_object_code = 'PARTY'

Line 3729: FROM iex_score_histories sh,

3725: GROUP BY del.customer_site_use_id;
3726:
3727: cursor c_billto_score is
3728: SELECT sh.score_object_id, sh.score_value score
3729: FROM iex_score_histories sh,
3730: iex_pop_uwq_summ_gt temp
3731: WHERE sh.creation_date = (SELECT MAX(creation_date)
3732: FROM iex_score_histories sh1
3733: WHERE sh1.score_object_code = 'IEX_BILLTO'

Line 3732: FROM iex_score_histories sh1

3728: SELECT sh.score_object_id, sh.score_value score
3729: FROM iex_score_histories sh,
3730: iex_pop_uwq_summ_gt temp
3731: WHERE sh.creation_date = (SELECT MAX(creation_date)
3732: FROM iex_score_histories sh1
3733: WHERE sh1.score_object_code = 'IEX_BILLTO'
3734: AND sh1.score_object_id = sh.score_object_id)
3735: -- AND rownum < 2
3736: AND sh.score_object_code = 'IEX_BILLTO'

Line 4957: FROM iex_score_histories sh,

4953: GROUP BY del.cust_account_id;
4954:
4955: cursor c_account_score is
4956: SELECT sh.score_object_id, sh.score_value score
4957: FROM iex_score_histories sh,
4958: iex_pop_uwq_summ_gt temp
4959: WHERE sh.creation_date = (SELECT MAX(creation_date)
4960: FROM iex_score_histories sh1
4961: WHERE sh1.score_object_code = 'IEX_ACCOUNT'

Line 4960: FROM iex_score_histories sh1

4956: SELECT sh.score_object_id, sh.score_value score
4957: FROM iex_score_histories sh,
4958: iex_pop_uwq_summ_gt temp
4959: WHERE sh.creation_date = (SELECT MAX(creation_date)
4960: FROM iex_score_histories sh1
4961: WHERE sh1.score_object_code = 'IEX_ACCOUNT'
4962: AND sh1.score_object_id = sh.score_object_id)
4963: -- AND rownum < 2
4964: AND sh.score_object_code = 'IEX_ACCOUNT'

Line 6177: FROM iex_score_histories sh,

6173: GROUP BY del.party_cust_id;
6174:
6175: cursor c_customer_score is
6176: SELECT sh.score_object_id, sh.score_value score
6177: FROM iex_score_histories sh,
6178: iex_pop_uwq_summ_gt temp
6179: WHERE sh.creation_date = (SELECT MAX(creation_date)
6180: FROM iex_score_histories sh1
6181: WHERE sh1.score_object_code = 'PARTY'

Line 6180: FROM iex_score_histories sh1

6176: SELECT sh.score_object_id, sh.score_value score
6177: FROM iex_score_histories sh,
6178: iex_pop_uwq_summ_gt temp
6179: WHERE sh.creation_date = (SELECT MAX(creation_date)
6180: FROM iex_score_histories sh1
6181: WHERE sh1.score_object_code = 'PARTY'
6182: AND sh1.score_object_id = sh.score_object_id)
6183: AND sh.score_object_code = 'PARTY'
6184: AND sh.score_object_id = temp.object_id;