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_PROMISE_DETAILS

Line 230: (SELECT COUNT(1) FROM iex_promise_details PRO, IEX_DELINQUENCIES_ALL DEL

226: phone.phone_number phone_number,
227: phone.phone_extension phone_extension,
228: (SELECT COUNT(1) FROM iex_bankruptcies bkr WHERE bkr.party_id = party.party_id and NVL(BKR.DISPOSITION_CODE,'GRANTED') in ('GRANTED','NEGOTIATION')) number_of_bankruptcies, -- Changed for bug#7693986
229:
230: (SELECT COUNT(1) FROM iex_promise_details PRO, IEX_DELINQUENCIES_ALL DEL
231: WHERE PRO.CUST_ACCOUNT_ID = TRX_SUMM.CUST_ACCOUNT_ID and del.customer_site_use_id = TRX_SUMM.site_use_ID AND
232: PRO.STATUS IN ('COLLECTABLE', 'PENDING') AND PRO.STATE = 'BROKEN_PROMISE' AND PRO.AMOUNT_DUE_REMAINING > 0 AND
233: PRO.DELINQUENCY_ID = DEL.DELINQUENCY_ID(+)
234: AND (DEL.STATUS --(+) Commented for Bug 6446848 06-Jan-2009 barathsr

Line 239: (SELECT SUM(AMOUNT_DUE_REMAINING) FROM iex_promise_details PRO, IEX_DELINQUENCIES_ALL DEL

235: NOT IN ('CURRENT', 'CLOSE')
236: or (del.status='CURRENT' and del.source_program_name='IEX_CURR_INV'))--Added for Bug 6446848 06-Jan-2009 barathsr
237: AND DEL.org_id = trx_summ.org_id) number_of_promises,
238:
239: (SELECT SUM(AMOUNT_DUE_REMAINING) FROM iex_promise_details PRO, IEX_DELINQUENCIES_ALL DEL
240: WHERE PRO.CUST_ACCOUNT_ID = TRX_SUMM.CUST_ACCOUNT_ID and del.customer_site_use_id = TRX_SUMM.site_use_ID AND
241: PRO.STATUS IN ('COLLECTABLE', 'PENDING') AND PRO.STATE = 'BROKEN_PROMISE' AND PRO.AMOUNT_DUE_REMAINING > 0 AND
242: PRO.DELINQUENCY_ID = DEL.DELINQUENCY_ID(+)
243: AND (DEL.STATUS --(+) Commented for Bug 6446848 06-Jan-2009 barathsr

Line 248: (SELECT SUM(PROMISE_AMOUNT) FROM iex_promise_details PRO, IEX_DELINQUENCIES_ALL DEL

244: NOT IN ('CURRENT', 'CLOSE')
245: or (del.status='CURRENT' and del.source_program_name='IEX_CURR_INV'))--Added for Bug 6446848 06-Jan-2009 barathsr
246: AND DEL.org_id = trx_summ.org_id) BROKEN_PROMISE_AMOUNT ,
247:
248: (SELECT SUM(PROMISE_AMOUNT) FROM iex_promise_details PRO, IEX_DELINQUENCIES_ALL DEL
249: WHERE PRO.CUST_ACCOUNT_ID = TRX_SUMM.CUST_ACCOUNT_ID and del.customer_site_use_id = TRX_SUMM.site_use_ID AND
250: PRO.STATUS IN ('COLLECTABLE', 'PENDING') AND PRO.STATE = 'BROKEN_PROMISE' AND PRO.AMOUNT_DUE_REMAINING > 0 AND
251: PRO.DELINQUENCY_ID = DEL.DELINQUENCY_ID(+)
252: AND (DEL.STATUS --(+) Commented for Bug 6446848 06-Jan-2009 barathsr

Line 260: FROM iex_promise_details PRO, IEX_DELINQUENCIES_ALL DEL

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
263: AND pro.state = 'BROKEN_PROMISE'
264: AND(pro.uwq_status IS NULL OR pro.uwq_status = 'ACTIVE' OR(TRUNC(pro.uwq_active_date) <= TRUNC(sysdate)

Line 272: FROM iex_promise_details PRO, IEX_DELINQUENCIES_ALL DEL

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
275: AND pro.state = 'BROKEN_PROMISE'
276: AND(pro.uwq_status = 'COMPLETE'

Line 284: FROM iex_promise_details PRO, IEX_DELINQUENCIES_ALL DEL

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
287: AND pro.state = 'BROKEN_PROMISE'
288: AND(pro.uwq_status = 'PENDING'

Line 493: (SELECT COUNT(1) FROM iex_promise_details PRO, IEX_DELINQUENCIES_ALL DEL

489: phone.phone_number phone_number,
490: phone.phone_extension phone_extension,
491: (SELECT COUNT(1) FROM iex_bankruptcies bkr WHERE bkr.party_id = party.party_id and NVL(BKR.DISPOSITION_CODE,'GRANTED') in ('GRANTED','NEGOTIATION')) number_of_bankruptcies, -- Changed for bug#7693986
492:
493: (SELECT COUNT(1) FROM iex_promise_details PRO, IEX_DELINQUENCIES_ALL DEL
494: WHERE PRO.CUST_ACCOUNT_ID = TRX_SUMM.CUST_ACCOUNT_ID and del.customer_site_use_id = TRX_SUMM.site_use_ID AND
495: PRO.STATUS IN ('COLLECTABLE', 'PENDING') AND PRO.STATE = 'BROKEN_PROMISE' AND PRO.AMOUNT_DUE_REMAINING > 0 AND
496: PRO.DELINQUENCY_ID = DEL.DELINQUENCY_ID(+)
497: AND (DEL.STATUS --(+) Commented for Bug 6446848 06-Jan-2009 barathsr

Line 502: (SELECT SUM(AMOUNT_DUE_REMAINING) FROM iex_promise_details PRO, IEX_DELINQUENCIES_ALL DEL

498: NOT IN ('CURRENT', 'CLOSE')
499: or (del.status='CURRENT' and del.source_program_name='IEX_CURR_INV')) --Added for Bug 6446848 06-Jan-2009 barathsr
500: AND DEL.org_id = trx_summ.org_id) number_of_promises,
501:
502: (SELECT SUM(AMOUNT_DUE_REMAINING) FROM iex_promise_details PRO, IEX_DELINQUENCIES_ALL DEL
503: WHERE PRO.CUST_ACCOUNT_ID = TRX_SUMM.CUST_ACCOUNT_ID and del.customer_site_use_id = TRX_SUMM.site_use_ID AND
504: PRO.STATUS IN ('COLLECTABLE', 'PENDING') AND PRO.STATE = 'BROKEN_PROMISE' AND PRO.AMOUNT_DUE_REMAINING > 0 AND
505: PRO.DELINQUENCY_ID = DEL.DELINQUENCY_ID(+)
506: AND (DEL.STATUS --(+) Commented for Bug 6446848 06-Jan-2009 barathsr

Line 511: (SELECT SUM(PROMISE_AMOUNT) FROM iex_promise_details PRO, IEX_DELINQUENCIES_ALL DEL

507: NOT IN ('CURRENT', 'CLOSE')
508: or (del.status='CURRENT' and del.source_program_name='IEX_CURR_INV')) --Added for Bug 6446848 06-Jan-2009 barathsr
509: AND DEL.org_id = trx_summ.org_id) BROKEN_PROMISE_AMOUNT ,
510:
511: (SELECT SUM(PROMISE_AMOUNT) FROM iex_promise_details PRO, IEX_DELINQUENCIES_ALL DEL
512: WHERE PRO.CUST_ACCOUNT_ID = TRX_SUMM.CUST_ACCOUNT_ID and del.customer_site_use_id = TRX_SUMM.site_use_ID AND
513: PRO.STATUS IN ('COLLECTABLE', 'PENDING') AND PRO.STATE = 'BROKEN_PROMISE' AND PRO.AMOUNT_DUE_REMAINING > 0 AND
514: PRO.DELINQUENCY_ID = DEL.DELINQUENCY_ID(+)
515: AND (DEL.STATUS --(+) Commented for Bug 6446848 06-Jan-2009 barathsr

Line 523: FROM iex_promise_details PRO, IEX_DELINQUENCIES_ALL DEL

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
526: AND pro.state = 'BROKEN_PROMISE'
527: AND(pro.uwq_status IS NULL OR pro.uwq_status = 'ACTIVE' OR(TRUNC(pro.uwq_active_date) <= TRUNC(sysdate)

Line 535: FROM iex_promise_details PRO, IEX_DELINQUENCIES_ALL DEL

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
538: AND pro.state = 'BROKEN_PROMISE'
539: AND(pro.uwq_status = 'COMPLETE'

Line 547: FROM iex_promise_details PRO, IEX_DELINQUENCIES_ALL DEL

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
550: AND pro.state = 'BROKEN_PROMISE'
551: AND(pro.uwq_status = 'PENDING'

Line 760: (SELECT COUNT(1) FROM iex_promise_details PRO, IEX_DELINQUENCIES_all DEL

756: phone.phone_number phone_number,
757: phone.phone_extension phone_extension,
758: (SELECT COUNT(1) FROM iex_bankruptcies bkr WHERE bkr.party_id = party.party_id and NVL(BKR.DISPOSITION_CODE,'GRANTED') in ('GRANTED','NEGOTIATION')) number_of_bankruptcies, -- Changed for bug#7693986
759:
760: (SELECT COUNT(1) FROM iex_promise_details PRO, IEX_DELINQUENCIES_all DEL
761: WHERE PRO.CUST_ACCOUNT_ID = TRX_SUMM.CUST_ACCOUNT_ID AND
762: PRO.STATUS IN ('COLLECTABLE', 'PENDING') AND PRO.STATE = 'BROKEN_PROMISE' AND PRO.AMOUNT_DUE_REMAINING > 0 AND
763: PRO.DELINQUENCY_ID = DEL.DELINQUENCY_ID(+)
764: AND (DEL.STATUS --(+) Commented for Bug 6446848 06-Jan-2009 barathsr

Line 769: (SELECT SUM(AMOUNT_DUE_REMAINING) FROM IEX_PROMISE_DETAILS PRO, IEX_DELINQUENCIES_all DEL

765: NOT IN ('CURRENT', 'CLOSE')
766: or (del.status='CURRENT' and del.source_program_name='IEX_CURR_INV'))--Added for Bug 6446848 06-Jan-2009 barathsr
767: AND DEL.org_id = trx_summ.org_id) NUMBER_OF_PROMISES ,
768:
769: (SELECT SUM(AMOUNT_DUE_REMAINING) FROM IEX_PROMISE_DETAILS PRO, IEX_DELINQUENCIES_all DEL
770: WHERE PRO.CUST_ACCOUNT_ID = TRX_SUMM.CUST_ACCOUNT_ID AND
771: PRO.STATUS IN ('COLLECTABLE', 'PENDING') AND PRO.STATE = 'BROKEN_PROMISE' AND PRO.AMOUNT_DUE_REMAINING > 0 AND
772: PRO.DELINQUENCY_ID = DEL.DELINQUENCY_ID(+)
773: AND (DEL.STATUS --(+) Commented for Bug 6446848 06-Jan-2009 barathsr

Line 778: (SELECT SUM(PROMISE_AMOUNT) FROM IEX_PROMISE_DETAILS PRO, IEX_DELINQUENCIES_all DEL

774: NOT IN ('CURRENT', 'CLOSE')
775: or (del.status='CURRENT' and del.source_program_name='IEX_CURR_INV'))--Added for Bug 6446848 06-Jan-2009 barathsr
776: AND DEL.org_id = trx_summ.org_id) BROKEN_PROMISE_AMOUNT ,
777:
778: (SELECT SUM(PROMISE_AMOUNT) FROM IEX_PROMISE_DETAILS PRO, IEX_DELINQUENCIES_all DEL
779: WHERE PRO.CUST_ACCOUNT_ID = TRX_SUMM.CUST_ACCOUNT_ID AND
780: PRO.STATUS IN ('COLLECTABLE', 'PENDING') AND PRO.STATE = 'BROKEN_PROMISE' AND PRO.AMOUNT_DUE_REMAINING > 0 AND
781: PRO.DELINQUENCY_ID = DEL.DELINQUENCY_ID(+)
782: AND (DEL.STATUS --(+) Commented for Bug 6446848 06-Jan-2009 barathsr

Line 790: FROM iex_promise_details

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'
793: AND(uwq_status IS NULL OR uwq_status = 'ACTIVE' OR(TRUNC(uwq_active_date) <= TRUNC(sysdate)
794: AND uwq_status = 'PENDING')))

Line 801: FROM iex_promise_details

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'
804: AND(uwq_status = 'COMPLETE'
805: AND(TRUNC(uwq_complete_date) + fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') > TRUNC(sysdate))))

Line 812: FROM iex_promise_details

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'
815: AND(uwq_status = 'PENDING'
816: AND(TRUNC(uwq_active_date) > TRUNC(sysdate))))

Line 1018: (SELECT COUNT(1) FROM iex_promise_details PRO, IEX_DELINQUENCIES_all DEL

1014: phone.phone_number phone_number,
1015: phone.phone_extension phone_extension,
1016: (SELECT COUNT(1) FROM iex_bankruptcies bkr WHERE bkr.party_id = party.party_id and NVL(BKR.DISPOSITION_CODE,'GRANTED') in ('GRANTED','NEGOTIATION')) number_of_bankruptcies, -- Changed for bug#7693986
1017:
1018: (SELECT COUNT(1) FROM iex_promise_details PRO, IEX_DELINQUENCIES_all DEL
1019: WHERE PRO.CUST_ACCOUNT_ID = TRX_SUMM.CUST_ACCOUNT_ID AND
1020: PRO.STATUS IN ('COLLECTABLE', 'PENDING') AND PRO.STATE = 'BROKEN_PROMISE' AND PRO.AMOUNT_DUE_REMAINING > 0 AND
1021: PRO.DELINQUENCY_ID = DEL.DELINQUENCY_ID(+)
1022: AND (DEL.STATUS --(+) Commented for Bug 6446848 06-Jan-2009 barathsr

Line 1027: (SELECT SUM(AMOUNT_DUE_REMAINING) FROM IEX_PROMISE_DETAILS PRO, IEX_DELINQUENCIES_all DEL

1023: NOT IN ('CURRENT', 'CLOSE')
1024: or (del.status='CURRENT' and del.source_program_name='IEX_CURR_INV'))--Added for Bug 6446848 06-Jan-2009 barathsr
1025: AND DEL.org_id = trx_summ.org_id) NUMBER_OF_PROMISES ,
1026:
1027: (SELECT SUM(AMOUNT_DUE_REMAINING) FROM IEX_PROMISE_DETAILS PRO, IEX_DELINQUENCIES_all DEL
1028: WHERE PRO.CUST_ACCOUNT_ID = TRX_SUMM.CUST_ACCOUNT_ID AND
1029: PRO.STATUS IN ('COLLECTABLE', 'PENDING') AND PRO.STATE = 'BROKEN_PROMISE' AND PRO.AMOUNT_DUE_REMAINING > 0 AND
1030: PRO.DELINQUENCY_ID = DEL.DELINQUENCY_ID(+)
1031: AND (DEL.STATUS --(+) Commented for Bug 6446848 06-Jan-2009 barathsr

Line 1036: (SELECT SUM(PROMISE_AMOUNT) FROM IEX_PROMISE_DETAILS PRO, IEX_DELINQUENCIES_all DEL

1032: NOT IN ('CURRENT', 'CLOSE')
1033: or (del.status='CURRENT' and del.source_program_name='IEX_CURR_INV'))--Added for Bug 6446848 06-Jan-2009 barathsr
1034: AND DEL.org_id = trx_summ.org_id) BROKEN_PROMISE_AMOUNT ,
1035:
1036: (SELECT SUM(PROMISE_AMOUNT) FROM IEX_PROMISE_DETAILS PRO, IEX_DELINQUENCIES_all DEL
1037: WHERE PRO.CUST_ACCOUNT_ID = TRX_SUMM.CUST_ACCOUNT_ID AND
1038: PRO.STATUS IN ('COLLECTABLE', 'PENDING') AND PRO.STATE = 'BROKEN_PROMISE' AND PRO.AMOUNT_DUE_REMAINING > 0 AND
1039: PRO.DELINQUENCY_ID = DEL.DELINQUENCY_ID(+)
1040: AND (DEL.STATUS --(+) Commented for Bug 6446848 06-Jan-2009 barathsr

Line 1048: FROM iex_promise_details

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'
1051: AND(uwq_status IS NULL OR uwq_status = 'ACTIVE' OR(TRUNC(uwq_active_date) <= TRUNC(sysdate)
1052: AND uwq_status = 'PENDING')))

Line 1059: FROM iex_promise_details

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'
1062: AND(uwq_status = 'COMPLETE'
1063: AND(TRUNC(uwq_complete_date) + fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') > TRUNC(sysdate))))

Line 1070: FROM iex_promise_details

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'
1073: AND(uwq_status = 'PENDING'
1074: AND(TRUNC(uwq_active_date) > TRUNC(sysdate))))

Line 1291: FROM iex_promise_details pd,

1287: (SELECT 1
1288: FROM dual
1289: WHERE EXISTS
1290: (SELECT 1
1291: FROM iex_promise_details pd,
1292: hz_cust_accounts b
1293: WHERE b.party_id = party.party_id
1294: AND pd.cust_account_id = b.cust_account_id
1295: AND pd.state = 'BROKEN_PROMISE'

Line 1304: FROM iex_promise_details pd,

1300: (SELECT 1
1301: FROM dual
1302: WHERE EXISTS
1303: (SELECT 1
1304: FROM iex_promise_details pd,
1305: hz_cust_accounts b
1306: WHERE b.party_id = party.party_id
1307: AND pd.cust_account_id = b.cust_account_id
1308: AND pd.state = 'BROKEN_PROMISE'

Line 1317: FROM iex_promise_details pd,

1313: (SELECT 1
1314: FROM dual
1315: WHERE EXISTS
1316: (SELECT 1
1317: FROM iex_promise_details pd,
1318: hz_cust_accounts b
1319: WHERE b.party_id = party.party_id
1320: AND pd.cust_account_id = b.cust_account_id
1321: and pd.state = 'BROKEN_PROMISE'

Line 1531: FROM iex_promise_details pd,

1527: (SELECT 1
1528: FROM dual
1529: WHERE EXISTS
1530: (SELECT 1
1531: FROM iex_promise_details pd,
1532: hz_cust_accounts b
1533: WHERE b.party_id = party.party_id
1534: AND pd.cust_account_id = b.cust_account_id
1535: AND pd.state = 'BROKEN_PROMISE'

Line 1544: FROM iex_promise_details pd,

1540: (SELECT 1
1541: FROM dual
1542: WHERE EXISTS
1543: (SELECT 1
1544: FROM iex_promise_details pd,
1545: hz_cust_accounts b
1546: WHERE b.party_id = party.party_id
1547: AND pd.cust_account_id = b.cust_account_id
1548: AND pd.state = 'BROKEN_PROMISE'

Line 1557: FROM iex_promise_details pd,

1553: (SELECT 1
1554: FROM dual
1555: WHERE EXISTS
1556: (SELECT 1
1557: FROM iex_promise_details pd,
1558: hz_cust_accounts b
1559: WHERE b.party_id = party.party_id
1560: AND pd.cust_account_id = b.cust_account_id
1561: and pd.state = 'BROKEN_PROMISE'

Line 3698: from iex_promise_details pd,

3694: select del.CUSTOMER_SITE_USE_ID,
3695: max(decode(pd.uwq_status,'PENDING',(decode(sign(TRUNC(pd.uwq_active_date) - TRUNC(sysdate)),1,1)))) pending_promises,
3696: max(decode(pd.uwq_status,'COMPLETE',(decode(sign(TRUNC(pd.uwq_complete_date) + fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') - TRUNC(sysdate)),1,1)))) complete_promises,
3697: max(decode(pd.uwq_status,NULL,1,'ACTIVE',1,'PENDING',(decode(sign(TRUNC(pd.uwq_active_date) - TRUNC(sysdate)),-1,1,0,1)))) active_promises
3698: from iex_promise_details pd,
3699: IEX_DELINQUENCIES_ALL DEL,
3700: iex_pop_uwq_summ_gt temp
3701: WHERE pd.cust_account_id = del.cust_account_id
3702: and pd.delinquency_id = del.delinquency_id

Line 3713: FROM iex_promise_details pd,

3709: SELECT del.customer_site_use_id,
3710: COUNT(1) number_of_promises,
3711: SUM(amount_due_remaining) broken_promise_amount,
3712: SUM(promise_amount) promise_amount
3713: FROM iex_promise_details pd,
3714: iex_delinquencies_all del,
3715: iex_pop_uwq_summ_gt temp
3716: WHERE pd.cust_account_id = del.cust_account_id
3717: AND pd.delinquency_id = del.delinquency_id

Line 4926: from iex_promise_details pd,

4922: select del.cust_account_id,
4923: max(decode(pd.uwq_status,'PENDING',(decode(sign(TRUNC(pd.uwq_active_date) - TRUNC(sysdate)),1,1)))) pending_promises,
4924: max(decode(pd.uwq_status,'COMPLETE',(decode(sign(TRUNC(pd.uwq_complete_date) + fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') - TRUNC(sysdate)),1,1)))) complete_promises,
4925: max(decode(pd.uwq_status,NULL,1,'ACTIVE',1,'PENDING',(decode(sign(TRUNC(pd.uwq_active_date) - TRUNC(sysdate)),-1,1,0,1)))) active_promises
4926: from iex_promise_details pd,
4927: IEX_DELINQUENCIES_ALL DEL,
4928: iex_pop_uwq_summ_gt temp
4929: WHERE pd.cust_account_id = del.cust_account_id
4930: and pd.delinquency_id = del.delinquency_id

Line 4941: FROM iex_promise_details pd,

4937: SELECT del.cust_account_id,
4938: COUNT(1) number_of_promises,
4939: SUM(amount_due_remaining) broken_promise_amount,
4940: SUM(promise_amount) promise_amount
4941: FROM iex_promise_details pd,
4942: iex_delinquencies_all del,
4943: iex_pop_uwq_summ_gt temp
4944: WHERE pd.cust_account_id = del.cust_account_id
4945: AND pd.delinquency_id = del.delinquency_id

Line 6146: from iex_promise_details pd,

6142: select del.party_cust_id,
6143: max(decode(pd.uwq_status,'PENDING',(decode(sign(TRUNC(pd.uwq_active_date) - TRUNC(sysdate)),1,1)))) pending_promises,
6144: max(decode(pd.uwq_status,'COMPLETE',(decode(sign(TRUNC(pd.uwq_complete_date) + fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') - TRUNC(sysdate)),1,1)))) complete_promises,
6145: max(decode(pd.uwq_status,NULL,1,'ACTIVE',1,'PENDING',(decode(sign(TRUNC(pd.uwq_active_date) - TRUNC(sysdate)),-1,1,0,1)))) active_promises
6146: from iex_promise_details pd,
6147: IEX_DELINQUENCIES_ALL DEL,
6148: iex_pop_uwq_summ_gt temp
6149: WHERE pd.cust_account_id = del.cust_account_id
6150: AND pd.delinquency_id = del.delinquency_id

Line 6161: FROM iex_promise_details pd,

6157: SELECT del.party_cust_id,
6158: COUNT(1) number_of_promises,
6159: SUM(amount_due_remaining) broken_promise_amount,
6160: SUM(promise_amount) promise_amount
6161: FROM iex_promise_details pd,
6162: iex_delinquencies_all del,
6163: iex_pop_uwq_summ_gt temp
6164: WHERE pd.cust_account_id = del.cust_account_id
6165: AND pd.delinquency_id = del.delinquency_id