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 DUAL

Line 172: FROM dual

168: AND status IN('DELINQUENT', 'PREDELINQUENT')
169: AND org_id = trx_summ.org_id)
170: number_of_delinquencies,
171: (SELECT 1
172: FROM dual
173: WHERE EXISTS
174: (SELECT 1
175: FROM iex_delinquencies_all
176: WHERE customer_site_use_id = trx_summ.site_use_id

Line 184: FROM dual

180: AND uwq_status = 'PENDING')))
181: )
182: active_delinquencies,
183: (SELECT 1
184: FROM dual
185: WHERE EXISTS
186: (SELECT 1
187: FROM iex_delinquencies_all
188: WHERE customer_site_use_id = trx_summ.site_use_id

Line 196: FROM dual

192: AND(TRUNC(uwq_complete_date) + fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') > TRUNC(sysdate))))
193: )
194: complete_delinquencies,
195: (SELECT 1
196: FROM dual
197: WHERE EXISTS
198: (SELECT 1
199: FROM iex_delinquencies_all where customer_site_use_id = trx_summ.site_use_id
200: AND status IN('DELINQUENT', 'PREDELINQUENT')

Line 257: (SELECT 1 FROM dual WHERE EXISTS

253: NOT IN ('CURRENT', 'CLOSE')
254: or (del.status='CURRENT' and del.source_program_name='IEX_CURR_INV'))--Added for Bug 6446848 06-Jan-2009 barathsr
255: AND DEL.org_id = trx_summ.org_id) PROMISE_AMOUNT,
256:
257: (SELECT 1 FROM dual WHERE EXISTS
258: (SELECT 1 FROM dual WHERE EXISTS
259: (SELECT 1
260: FROM iex_promise_details PRO, IEX_DELINQUENCIES_ALL DEL
261: WHERE pro.cust_account_id = trx_summ.cust_account_id

Line 258: (SELECT 1 FROM dual WHERE EXISTS

254: or (del.status='CURRENT' and del.source_program_name='IEX_CURR_INV'))--Added for Bug 6446848 06-Jan-2009 barathsr
255: AND DEL.org_id = trx_summ.org_id) PROMISE_AMOUNT,
256:
257: (SELECT 1 FROM dual WHERE EXISTS
258: (SELECT 1 FROM dual WHERE EXISTS
259: (SELECT 1
260: FROM iex_promise_details PRO, IEX_DELINQUENCIES_ALL DEL
261: WHERE pro.cust_account_id = trx_summ.cust_account_id
262: and del.customer_site_use_id = TRX_SUMM.site_use_ID

Line 269: (SELECT 1 FROM dual WHERE EXISTS

265: AND pro.uwq_status = 'PENDING')))
266: )
267: ) active_promises,
268:
269: (SELECT 1 FROM dual WHERE EXISTS
270: (SELECT 1 FROM dual WHERE EXISTS
271: (SELECT 1
272: FROM iex_promise_details PRO, IEX_DELINQUENCIES_ALL DEL
273: WHERE pro.cust_account_id = trx_summ.cust_account_id

Line 270: (SELECT 1 FROM dual WHERE EXISTS

266: )
267: ) active_promises,
268:
269: (SELECT 1 FROM dual WHERE EXISTS
270: (SELECT 1 FROM dual WHERE EXISTS
271: (SELECT 1
272: FROM iex_promise_details PRO, IEX_DELINQUENCIES_ALL DEL
273: WHERE pro.cust_account_id = trx_summ.cust_account_id
274: and del.customer_site_use_id = TRX_SUMM.site_use_ID

Line 281: (SELECT 1 FROM dual WHERE EXISTS

277: AND(TRUNC(pro.uwq_complete_date) + fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') > TRUNC(sysdate))))
278: )
279: ) complete_promises,
280:
281: (SELECT 1 FROM dual WHERE EXISTS
282: (SELECT 1 FROM dual WHERE EXISTS
283: (SELECT 1
284: FROM iex_promise_details PRO, IEX_DELINQUENCIES_ALL DEL
285: WHERE pro.cust_account_id = trx_summ.cust_account_id

Line 282: (SELECT 1 FROM dual WHERE EXISTS

278: )
279: ) complete_promises,
280:
281: (SELECT 1 FROM dual WHERE EXISTS
282: (SELECT 1 FROM dual WHERE EXISTS
283: (SELECT 1
284: FROM iex_promise_details PRO, IEX_DELINQUENCIES_ALL DEL
285: WHERE pro.cust_account_id = trx_summ.cust_account_id
286: and del.customer_site_use_id = TRX_SUMM.site_use_ID

Line 435: FROM dual

431: AND status IN('DELINQUENT', 'PREDELINQUENT')
432: AND org_id = trx_summ.org_id)
433: number_of_delinquencies,
434: (SELECT 1
435: FROM dual
436: WHERE EXISTS
437: (SELECT 1
438: FROM iex_delinquencies_all
439: WHERE customer_site_use_id = trx_summ.site_use_id

Line 447: FROM dual

443: AND uwq_status = 'PENDING')))
444: )
445: active_delinquencies,
446: (SELECT 1
447: FROM dual
448: WHERE EXISTS
449: (SELECT 1
450: FROM iex_delinquencies_all
451: WHERE customer_site_use_id = trx_summ.site_use_id

Line 459: FROM dual

455: AND(TRUNC(uwq_complete_date) + fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') > TRUNC(sysdate))))
456: )
457: complete_delinquencies,
458: (SELECT 1
459: FROM dual
460: WHERE EXISTS
461: (SELECT 1
462: FROM iex_delinquencies_all where customer_site_use_id = trx_summ.site_use_id
463: AND status IN('DELINQUENT', 'PREDELINQUENT')

Line 520: (SELECT 1 FROM dual WHERE EXISTS

516: NOT IN ('CURRENT', 'CLOSE')
517: or (del.status='CURRENT' and del.source_program_name='IEX_CURR_INV')) --Added for Bug 6446848 06-Jan-2009 barathsr
518: AND DEL.org_id = trx_summ.org_id) PROMISE_AMOUNT,
519:
520: (SELECT 1 FROM dual WHERE EXISTS
521: (SELECT 1 FROM dual WHERE EXISTS
522: (SELECT 1
523: FROM iex_promise_details PRO, IEX_DELINQUENCIES_ALL DEL
524: WHERE pro.cust_account_id = trx_summ.cust_account_id

Line 521: (SELECT 1 FROM dual WHERE EXISTS

517: or (del.status='CURRENT' and del.source_program_name='IEX_CURR_INV')) --Added for Bug 6446848 06-Jan-2009 barathsr
518: AND DEL.org_id = trx_summ.org_id) PROMISE_AMOUNT,
519:
520: (SELECT 1 FROM dual WHERE EXISTS
521: (SELECT 1 FROM dual WHERE EXISTS
522: (SELECT 1
523: FROM iex_promise_details PRO, IEX_DELINQUENCIES_ALL DEL
524: WHERE pro.cust_account_id = trx_summ.cust_account_id
525: and del.customer_site_use_id = TRX_SUMM.site_use_ID

Line 532: (SELECT 1 FROM dual WHERE EXISTS

528: AND pro.uwq_status = 'PENDING')))
529: )
530: ) active_promises,
531:
532: (SELECT 1 FROM dual WHERE EXISTS
533: (SELECT 1 FROM dual WHERE EXISTS
534: (SELECT 1
535: FROM iex_promise_details PRO, IEX_DELINQUENCIES_ALL DEL
536: WHERE pro.cust_account_id = trx_summ.cust_account_id

Line 533: (SELECT 1 FROM dual WHERE EXISTS

529: )
530: ) active_promises,
531:
532: (SELECT 1 FROM dual WHERE EXISTS
533: (SELECT 1 FROM dual WHERE EXISTS
534: (SELECT 1
535: FROM iex_promise_details PRO, IEX_DELINQUENCIES_ALL DEL
536: WHERE pro.cust_account_id = trx_summ.cust_account_id
537: and del.customer_site_use_id = TRX_SUMM.site_use_ID

Line 544: (SELECT 1 FROM dual WHERE EXISTS

540: AND(TRUNC(pro.uwq_complete_date) + fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') > TRUNC(sysdate))))
541: )
542: ) complete_promises,
543:
544: (SELECT 1 FROM dual WHERE EXISTS
545: (SELECT 1 FROM dual WHERE EXISTS
546: (SELECT 1
547: FROM iex_promise_details PRO, IEX_DELINQUENCIES_ALL DEL
548: WHERE pro.cust_account_id = trx_summ.cust_account_id

Line 545: (SELECT 1 FROM dual WHERE EXISTS

541: )
542: ) complete_promises,
543:
544: (SELECT 1 FROM dual WHERE EXISTS
545: (SELECT 1 FROM dual WHERE EXISTS
546: (SELECT 1
547: FROM iex_promise_details PRO, IEX_DELINQUENCIES_ALL DEL
548: WHERE pro.cust_account_id = trx_summ.cust_account_id
549: and del.customer_site_use_id = TRX_SUMM.site_use_ID

Line 702: FROM dual

698: AND status IN('DELINQUENT', 'PREDELINQUENT')
699: AND org_id = trx_summ.org_id)
700: number_of_delinquencies,
701: (SELECT 1
702: FROM dual
703: WHERE EXISTS
704: (SELECT 1
705: FROM iex_delinquencies_all
706: WHERE cust_account_id = trx_summ.cust_account_id

Line 714: FROM dual

710: AND uwq_status = 'PENDING')))
711: )
712: active_delinquencies,
713: (SELECT 1
714: FROM dual
715: WHERE EXISTS
716: (SELECT 1
717: FROM iex_delinquencies_all
718: WHERE cust_account_id = trx_summ.cust_account_id

Line 726: FROM dual

722: AND(TRUNC(uwq_complete_date) + fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') > TRUNC(sysdate))))
723: )
724: complete_delinquencies,
725: (SELECT 1
726: FROM dual
727: WHERE EXISTS
728: (SELECT 1
729: FROM iex_delinquencies_all WHERE cust_account_id = trx_summ.cust_account_id
730: AND status IN('DELINQUENT', 'PREDELINQUENT')

Line 787: (SELECT 1 FROM dual WHERE EXISTS

783: NOT IN ('CURRENT', 'CLOSE')
784: or (del.status='CURRENT' and del.source_program_name='IEX_CURR_INV'))--Added for Bug 6446848 06-Jan-2009 barathsr
785: AND DEL.org_id = trx_summ.org_id) PROMISE_AMOUNT,
786:
787: (SELECT 1 FROM dual WHERE EXISTS
788: (SELECT 1 FROM dual WHERE EXISTS
789: (SELECT 1
790: FROM iex_promise_details
791: WHERE cust_account_id = trx_summ.cust_account_id

Line 788: (SELECT 1 FROM dual WHERE EXISTS

784: or (del.status='CURRENT' and del.source_program_name='IEX_CURR_INV'))--Added for Bug 6446848 06-Jan-2009 barathsr
785: AND DEL.org_id = trx_summ.org_id) PROMISE_AMOUNT,
786:
787: (SELECT 1 FROM dual WHERE EXISTS
788: (SELECT 1 FROM dual WHERE EXISTS
789: (SELECT 1
790: FROM iex_promise_details
791: WHERE cust_account_id = trx_summ.cust_account_id
792: AND state = 'BROKEN_PROMISE'

Line 798: (SELECT 1 FROM dual WHERE EXISTS

794: AND uwq_status = 'PENDING')))
795: )
796: ) active_promises,
797:
798: (SELECT 1 FROM dual WHERE EXISTS
799: (SELECT 1 FROM dual WHERE EXISTS
800: (SELECT 1
801: FROM iex_promise_details
802: WHERE cust_account_id = trx_summ.cust_account_id

Line 799: (SELECT 1 FROM dual WHERE EXISTS

795: )
796: ) active_promises,
797:
798: (SELECT 1 FROM dual WHERE EXISTS
799: (SELECT 1 FROM dual WHERE EXISTS
800: (SELECT 1
801: FROM iex_promise_details
802: WHERE cust_account_id = trx_summ.cust_account_id
803: AND state = 'BROKEN_PROMISE'

Line 809: (SELECT 1 FROM dual WHERE EXISTS

805: AND(TRUNC(uwq_complete_date) + fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') > TRUNC(sysdate))))
806: )
807: ) complete_promises,
808:
809: (SELECT 1 FROM dual WHERE EXISTS
810: (SELECT 1 FROM dual WHERE EXISTS
811: (SELECT 1
812: FROM iex_promise_details
813: WHERE cust_account_id = trx_summ.cust_account_id

Line 810: (SELECT 1 FROM dual WHERE EXISTS

806: )
807: ) complete_promises,
808:
809: (SELECT 1 FROM dual WHERE EXISTS
810: (SELECT 1 FROM dual WHERE EXISTS
811: (SELECT 1
812: FROM iex_promise_details
813: WHERE cust_account_id = trx_summ.cust_account_id
814: AND state = 'BROKEN_PROMISE'

Line 960: FROM dual

956: AND status IN('DELINQUENT', 'PREDELINQUENT')
957: AND org_id = trx_summ.org_id)
958: number_of_delinquencies,
959: (SELECT 1
960: FROM dual
961: WHERE EXISTS
962: (SELECT 1
963: FROM iex_delinquencies_all
964: WHERE cust_account_id = trx_summ.cust_account_id

Line 972: FROM dual

968: AND uwq_status = 'PENDING')))
969: )
970: active_delinquencies,
971: (SELECT 1
972: FROM dual
973: WHERE EXISTS
974: (SELECT 1
975: FROM iex_delinquencies_all
976: WHERE cust_account_id = trx_summ.cust_account_id

Line 984: FROM dual

980: AND(TRUNC(uwq_complete_date) + fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') > TRUNC(sysdate))))
981: )
982: complete_delinquencies,
983: (SELECT 1
984: FROM dual
985: WHERE EXISTS
986: (SELECT 1
987: FROM iex_delinquencies_all WHERE cust_account_id = trx_summ.cust_account_id
988: AND status IN('DELINQUENT', 'PREDELINQUENT')

Line 1045: (SELECT 1 FROM dual WHERE EXISTS

1041: NOT IN ('CURRENT', 'CLOSE')
1042: or (del.status='CURRENT' and del.source_program_name='IEX_CURR_INV'))--Added for Bug 6446848 06-Jan-2009 barathsr
1043: AND DEL.org_id = trx_summ.org_id) PROMISE_AMOUNT,
1044:
1045: (SELECT 1 FROM dual WHERE EXISTS
1046: (SELECT 1 FROM dual WHERE EXISTS
1047: (SELECT 1
1048: FROM iex_promise_details
1049: WHERE cust_account_id = trx_summ.cust_account_id

Line 1046: (SELECT 1 FROM dual WHERE EXISTS

1042: or (del.status='CURRENT' and del.source_program_name='IEX_CURR_INV'))--Added for Bug 6446848 06-Jan-2009 barathsr
1043: AND DEL.org_id = trx_summ.org_id) PROMISE_AMOUNT,
1044:
1045: (SELECT 1 FROM dual WHERE EXISTS
1046: (SELECT 1 FROM dual WHERE EXISTS
1047: (SELECT 1
1048: FROM iex_promise_details
1049: WHERE cust_account_id = trx_summ.cust_account_id
1050: AND state = 'BROKEN_PROMISE'

Line 1056: (SELECT 1 FROM dual WHERE EXISTS

1052: AND uwq_status = 'PENDING')))
1053: )
1054: ) active_promises,
1055:
1056: (SELECT 1 FROM dual WHERE EXISTS
1057: (SELECT 1 FROM dual WHERE EXISTS
1058: (SELECT 1
1059: FROM iex_promise_details
1060: WHERE cust_account_id = trx_summ.cust_account_id

Line 1057: (SELECT 1 FROM dual WHERE EXISTS

1053: )
1054: ) active_promises,
1055:
1056: (SELECT 1 FROM dual WHERE EXISTS
1057: (SELECT 1 FROM dual WHERE EXISTS
1058: (SELECT 1
1059: FROM iex_promise_details
1060: WHERE cust_account_id = trx_summ.cust_account_id
1061: AND state = 'BROKEN_PROMISE'

Line 1067: (SELECT 1 FROM dual WHERE EXISTS

1063: AND(TRUNC(uwq_complete_date) + fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') > TRUNC(sysdate))))
1064: )
1065: ) complete_promises,
1066:
1067: (SELECT 1 FROM dual WHERE EXISTS
1068: (SELECT 1 FROM dual WHERE EXISTS
1069: (SELECT 1
1070: FROM iex_promise_details
1071: WHERE cust_account_id = trx_summ.cust_account_id

Line 1068: (SELECT 1 FROM dual WHERE EXISTS

1064: )
1065: ) complete_promises,
1066:
1067: (SELECT 1 FROM dual WHERE EXISTS
1068: (SELECT 1 FROM dual WHERE EXISTS
1069: (SELECT 1
1070: FROM iex_promise_details
1071: WHERE cust_account_id = trx_summ.cust_account_id
1072: AND state = 'BROKEN_PROMISE'

Line 1225: FROM dual

1221: AND status IN('DELINQUENT', 'PREDELINQUENT')
1222: AND org_id = trx_summ.org_id)
1223: number_of_delinquencies,
1224: (SELECT 1
1225: FROM dual
1226: WHERE EXISTS
1227: (SELECT 1
1228: FROM iex_delinquencies_all
1229: WHERE party_cust_id = party.party_id

Line 1237: FROM dual

1233: AND uwq_status = 'PENDING')))
1234: )
1235: active_delinquencies,
1236: (SELECT 1
1237: FROM dual
1238: WHERE EXISTS
1239: (SELECT 1
1240: FROM iex_delinquencies_all
1241: WHERE party_cust_id = party.party_id

Line 1249: FROM dual

1245: AND(TRUNC(uwq_complete_date) + fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') > TRUNC(sysdate))))
1246: )
1247: complete_delinquencies,
1248: (SELECT 1
1249: FROM dual
1250: WHERE EXISTS
1251: (SELECT 1
1252: FROM iex_delinquencies_all
1253: WHERE party_cust_id = party.party_id

Line 1288: FROM dual

1284: iex_uwq_view_pkg.get_pro_count(party.party_id, NULL, NULL, NULL, trx_summ.org_id) number_of_promises,
1285: iex_uwq_view_pkg.get_broken_prm_amt(party.party_id, NULL, NULL, trx_summ.org_id) broken_promise_amount,
1286: iex_uwq_view_pkg.get_prm_amt(party.party_id, NULL, NULL, trx_summ.org_id) promise_amount,
1287: (SELECT 1
1288: FROM dual
1289: WHERE EXISTS
1290: (SELECT 1
1291: FROM iex_promise_details pd,
1292: hz_cust_accounts b

Line 1301: FROM dual

1297: AND pd.uwq_status = 'PENDING')))
1298: )
1299: active_promises,
1300: (SELECT 1
1301: FROM dual
1302: WHERE EXISTS
1303: (SELECT 1
1304: FROM iex_promise_details pd,
1305: hz_cust_accounts b

Line 1314: FROM dual

1310: AND(TRUNC(pd.uwq_complete_date) + fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') > TRUNC(sysdate))))
1311: )
1312: complete_promises,
1313: (SELECT 1
1314: FROM dual
1315: WHERE EXISTS
1316: (SELECT 1
1317: FROM iex_promise_details pd,
1318: hz_cust_accounts b

Line 1465: FROM dual

1461: AND status IN('DELINQUENT', 'PREDELINQUENT')
1462: AND org_id = trx_summ.org_id)
1463: number_of_delinquencies,
1464: (SELECT 1
1465: FROM dual
1466: WHERE EXISTS
1467: (SELECT 1
1468: FROM iex_delinquencies_all
1469: WHERE party_cust_id = party.party_id

Line 1477: FROM dual

1473: AND uwq_status = 'PENDING')))
1474: )
1475: active_delinquencies,
1476: (SELECT 1
1477: FROM dual
1478: WHERE EXISTS
1479: (SELECT 1
1480: FROM iex_delinquencies_all
1481: WHERE party_cust_id = party.party_id

Line 1489: FROM dual

1485: AND(TRUNC(uwq_complete_date) + fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') > TRUNC(sysdate))))
1486: )
1487: complete_delinquencies,
1488: (SELECT 1
1489: FROM dual
1490: WHERE EXISTS
1491: (SELECT 1
1492: FROM iex_delinquencies_all
1493: WHERE party_cust_id = party.party_id

Line 1528: FROM dual

1524: iex_uwq_view_pkg.get_pro_count(party.party_id, NULL, NULL, NULL, trx_summ.org_id) number_of_promises,
1525: iex_uwq_view_pkg.get_broken_prm_amt(party.party_id, NULL, NULL, trx_summ.org_id) broken_promise_amount,
1526: iex_uwq_view_pkg.get_prm_amt(party.party_id, NULL, NULL, trx_summ.org_id) promise_amount,
1527: (SELECT 1
1528: FROM dual
1529: WHERE EXISTS
1530: (SELECT 1
1531: FROM iex_promise_details pd,
1532: hz_cust_accounts b

Line 1541: FROM dual

1537: AND pd.uwq_status = 'PENDING')))
1538: )
1539: active_promises,
1540: (SELECT 1
1541: FROM dual
1542: WHERE EXISTS
1543: (SELECT 1
1544: FROM iex_promise_details pd,
1545: hz_cust_accounts b

Line 1554: FROM dual

1550: AND(TRUNC(pd.uwq_complete_date) + fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') > TRUNC(sysdate))))
1551: )
1552: complete_promises,
1553: (SELECT 1
1554: FROM dual
1555: WHERE EXISTS
1556: (SELECT 1
1557: FROM iex_promise_details pd,
1558: hz_cust_accounts b