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 1081: (SELECT COUNT(1) FROM iex_promise_details PRO, IEX_DELINQUENCIES_ALL DEL

1077: phone.phone_extension phone_extension,
1078: (SELECT COUNT(1) FROM iex_bankruptcies bkr
1079: WHERE bkr.party_id = party.party_id and NVL(BKR.DISPOSITION_CODE,'GRANTED') in ('GRANTED','NEGOTIATION')) number_of_bankruptcies, -- Changed for bug#7693986
1080:
1081: (SELECT COUNT(1) FROM iex_promise_details PRO, IEX_DELINQUENCIES_ALL DEL
1082: WHERE PRO.CUST_ACCOUNT_ID = TRX_SUMM.CUST_ACCOUNT_ID and del.customer_site_use_id = TRX_SUMM.site_use_ID AND
1083: PRO.STATUS IN ('COLLECTABLE', 'PENDING') AND PRO.STATE = 'BROKEN_PROMISE' AND PRO.AMOUNT_DUE_REMAINING > 0 AND
1084: PRO.DELINQUENCY_ID = DEL.DELINQUENCY_ID(+)
1085: AND (DEL.STATUS --(+) Commented for Bug 6446848 06-Jan-2009 barathsr

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

1086: NOT IN ('CURRENT', 'CLOSE')
1087: or (del.status='CURRENT' and del.source_program_name='IEX_CURR_INV'))--Added for Bug 6446848 06-Jan-2009 barathsr
1088: AND DEL.org_id = trx_summ.org_id) number_of_promises,
1089:
1090: (SELECT SUM(AMOUNT_DUE_REMAINING) FROM iex_promise_details PRO, IEX_DELINQUENCIES_ALL DEL
1091: WHERE PRO.CUST_ACCOUNT_ID = TRX_SUMM.CUST_ACCOUNT_ID and del.customer_site_use_id = TRX_SUMM.site_use_ID AND
1092: PRO.STATUS IN ('COLLECTABLE', 'PENDING') AND PRO.STATE = 'BROKEN_PROMISE' AND PRO.AMOUNT_DUE_REMAINING > 0 AND
1093: PRO.DELINQUENCY_ID = DEL.DELINQUENCY_ID(+)
1094: AND (DEL.STATUS --(+) Commented for Bug 6446848 06-Jan-2009 barathsr

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

1095: NOT IN ('CURRENT', 'CLOSE')
1096: or (del.status='CURRENT' and del.source_program_name='IEX_CURR_INV'))--Added for Bug 6446848 06-Jan-2009 barathsr
1097: AND DEL.org_id = trx_summ.org_id) BROKEN_PROMISE_AMOUNT ,
1098:
1099: (SELECT SUM(PROMISE_AMOUNT) FROM iex_promise_details PRO, IEX_DELINQUENCIES_ALL DEL
1100: WHERE PRO.CUST_ACCOUNT_ID = TRX_SUMM.CUST_ACCOUNT_ID and del.customer_site_use_id = TRX_SUMM.site_use_ID AND
1101: PRO.STATUS IN ('COLLECTABLE', 'PENDING') AND PRO.STATE = 'BROKEN_PROMISE' AND PRO.AMOUNT_DUE_REMAINING > 0 AND
1102: PRO.DELINQUENCY_ID = DEL.DELINQUENCY_ID(+)
1103: AND (DEL.STATUS --(+) Commented for Bug 6446848 06-Jan-2009 barathsr

Line 1111: FROM iex_promise_details PRO, IEX_DELINQUENCIES_ALL DEL

1107:
1108: (SELECT 1 FROM dual WHERE EXISTS
1109: (SELECT 1 FROM dual WHERE EXISTS
1110: (SELECT 1
1111: FROM iex_promise_details PRO, IEX_DELINQUENCIES_ALL DEL
1112: WHERE pro.cust_account_id = trx_summ.cust_account_id
1113: and del.customer_site_use_id = TRX_SUMM.site_use_ID
1114: AND pro.state = 'BROKEN_PROMISE'
1115: AND(pro.uwq_status IS NULL OR pro.uwq_status = 'ACTIVE' OR(TRUNC(pro.uwq_active_date) <= TRUNC(sysdate)

Line 1123: FROM iex_promise_details PRO, IEX_DELINQUENCIES_ALL DEL

1119:
1120: (SELECT 1 FROM dual WHERE EXISTS
1121: (SELECT 1 FROM dual WHERE EXISTS
1122: (SELECT 1
1123: FROM iex_promise_details PRO, IEX_DELINQUENCIES_ALL DEL
1124: WHERE pro.cust_account_id = trx_summ.cust_account_id
1125: and del.customer_site_use_id = TRX_SUMM.site_use_ID
1126: AND pro.state = 'BROKEN_PROMISE'
1127: AND(pro.uwq_status = 'COMPLETE'

Line 1135: FROM iex_promise_details PRO, IEX_DELINQUENCIES_ALL DEL

1131:
1132: (SELECT 1 FROM dual WHERE EXISTS
1133: (SELECT 1 FROM dual WHERE EXISTS
1134: (SELECT 1
1135: FROM iex_promise_details PRO, IEX_DELINQUENCIES_ALL DEL
1136: WHERE pro.cust_account_id = trx_summ.cust_account_id
1137: and del.customer_site_use_id = TRX_SUMM.site_use_ID
1138: AND pro.state = 'BROKEN_PROMISE'
1139: AND(pro.uwq_status = 'PENDING'

Line 1358: FROM iex_promise_details pd,

1354: iex_utilities.get_cache_value('DEFAULT_EXCHANGE_RATE_TYPE', ''), pd.amount_due_remaining)) broken_promise_amount,
1355: SUM(gl_currency_api.convert_amount_sql(pd.currency_code, dln.currency, sysdate,
1356: iex_utilities.get_cache_value('DEFAULT_EXCHANGE_RATE_TYPE', ''), pd.promise_amount)) promise_amount
1357: -- End Bug 14197188 bibeura 26-Jun-2012
1358: FROM iex_promise_details pd,
1359: iex_delinquencies_all del,
1360: iex_dln_uwq_summary dln
1361: WHERE pd.cust_account_id = del.cust_account_id
1362: AND pd.delinquency_id = del.delinquency_id

Line 1377: from iex_promise_details pd,

1373: select del.CUSTOMER_SITE_USE_ID,
1374: max(decode(pd.uwq_status,'PENDING',(decode(sign(TRUNC(pd.uwq_active_date) - TRUNC(sysdate)),1,1)))) pending_promises,
1375: 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,
1376: 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
1377: from iex_promise_details pd,
1378: IEX_DELINQUENCIES_ALL DEL,
1379: iex_dln_uwq_summary dln
1380: WHERE pd.cust_account_id = del.cust_account_id
1381: and pd.delinquency_id = del.delinquency_id

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

1696: phone.phone_number phone_number,
1697: phone.phone_extension phone_extension,
1698: (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
1699:
1700: (SELECT COUNT(1) FROM iex_promise_details PRO, IEX_DELINQUENCIES_ALL DEL
1701: WHERE PRO.CUST_ACCOUNT_ID = TRX_SUMM.CUST_ACCOUNT_ID and del.customer_site_use_id = TRX_SUMM.site_use_ID AND
1702: PRO.STATUS IN ('COLLECTABLE', 'PENDING') AND PRO.STATE = 'BROKEN_PROMISE' AND PRO.AMOUNT_DUE_REMAINING > 0 AND
1703: PRO.DELINQUENCY_ID = DEL.DELINQUENCY_ID(+)
1704: AND (DEL.STATUS --(+) Commented for Bug 6446848 06-Jan-2009 barathsr

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

1705: NOT IN ('CURRENT', 'CLOSE')
1706: or (del.status='CURRENT' and del.source_program_name='IEX_CURR_INV')) --Added for Bug 6446848 06-Jan-2009 barathsr
1707: AND DEL.org_id = trx_summ.org_id) number_of_promises,
1708:
1709: (SELECT SUM(AMOUNT_DUE_REMAINING) FROM iex_promise_details PRO, IEX_DELINQUENCIES_ALL DEL
1710: WHERE PRO.CUST_ACCOUNT_ID = TRX_SUMM.CUST_ACCOUNT_ID and del.customer_site_use_id = TRX_SUMM.site_use_ID AND
1711: PRO.STATUS IN ('COLLECTABLE', 'PENDING') AND PRO.STATE = 'BROKEN_PROMISE' AND PRO.AMOUNT_DUE_REMAINING > 0 AND
1712: PRO.DELINQUENCY_ID = DEL.DELINQUENCY_ID(+)
1713: AND (DEL.STATUS --(+) Commented for Bug 6446848 06-Jan-2009 barathsr

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

1714: NOT IN ('CURRENT', 'CLOSE')
1715: or (del.status='CURRENT' and del.source_program_name='IEX_CURR_INV')) --Added for Bug 6446848 06-Jan-2009 barathsr
1716: AND DEL.org_id = trx_summ.org_id) BROKEN_PROMISE_AMOUNT ,
1717:
1718: (SELECT SUM(PROMISE_AMOUNT) FROM iex_promise_details PRO, IEX_DELINQUENCIES_ALL DEL
1719: WHERE PRO.CUST_ACCOUNT_ID = TRX_SUMM.CUST_ACCOUNT_ID and del.customer_site_use_id = TRX_SUMM.site_use_ID AND
1720: PRO.STATUS IN ('COLLECTABLE', 'PENDING') AND PRO.STATE = 'BROKEN_PROMISE' AND PRO.AMOUNT_DUE_REMAINING > 0 AND
1721: PRO.DELINQUENCY_ID = DEL.DELINQUENCY_ID(+)
1722: AND (DEL.STATUS --(+) Commented for Bug 6446848 06-Jan-2009 barathsr

Line 1730: FROM iex_promise_details PRO, IEX_DELINQUENCIES_ALL DEL

1726:
1727: (SELECT 1 FROM dual WHERE EXISTS
1728: (SELECT 1 FROM dual WHERE EXISTS
1729: (SELECT 1
1730: FROM iex_promise_details PRO, IEX_DELINQUENCIES_ALL DEL
1731: WHERE pro.cust_account_id = trx_summ.cust_account_id
1732: and del.customer_site_use_id = TRX_SUMM.site_use_ID
1733: AND pro.state = 'BROKEN_PROMISE'
1734: AND(pro.uwq_status IS NULL OR pro.uwq_status = 'ACTIVE' OR(TRUNC(pro.uwq_active_date) <= TRUNC(sysdate)

Line 1742: FROM iex_promise_details PRO, IEX_DELINQUENCIES_ALL DEL

1738:
1739: (SELECT 1 FROM dual WHERE EXISTS
1740: (SELECT 1 FROM dual WHERE EXISTS
1741: (SELECT 1
1742: FROM iex_promise_details PRO, IEX_DELINQUENCIES_ALL DEL
1743: WHERE pro.cust_account_id = trx_summ.cust_account_id
1744: and del.customer_site_use_id = TRX_SUMM.site_use_ID
1745: AND pro.state = 'BROKEN_PROMISE'
1746: AND(pro.uwq_status = 'COMPLETE'

Line 1754: FROM iex_promise_details PRO, IEX_DELINQUENCIES_ALL DEL

1750:
1751: (SELECT 1 FROM dual WHERE EXISTS
1752: (SELECT 1 FROM dual WHERE EXISTS
1753: (SELECT 1
1754: FROM iex_promise_details PRO, IEX_DELINQUENCIES_ALL DEL
1755: WHERE pro.cust_account_id = trx_summ.cust_account_id
1756: and del.customer_site_use_id = TRX_SUMM.site_use_ID
1757: AND pro.state = 'BROKEN_PROMISE'
1758: AND(pro.uwq_status = 'PENDING'

Line 1991: FROM iex_promise_details pd,

1987: iex_utilities.get_cache_value('DEFAULT_EXCHANGE_RATE_TYPE', ''), pd.amount_due_remaining)) broken_promise_amount,
1988: SUM(gl_currency_api.convert_amount_sql(pd.currency_code, dln.currency, sysdate,
1989: iex_utilities.get_cache_value('DEFAULT_EXCHANGE_RATE_TYPE', ''), pd.promise_amount)) promise_amount
1990: -- End Bug 14197188 bibeura 26-Jun-2012
1991: FROM iex_promise_details pd,
1992: iex_delinquencies_all del,
1993: iex_dln_uwq_summary dln
1994: WHERE pd.cust_account_id = del.cust_account_id
1995: AND pd.delinquency_id = del.delinquency_id

Line 2012: from iex_promise_details pd,

2008: select del.CUSTOMER_SITE_USE_ID,
2009: max(decode(pd.uwq_status,'PENDING',(decode(sign(TRUNC(pd.uwq_active_date) - TRUNC(sysdate)),1,1)))) pending_promises,
2010: 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,
2011: 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
2012: from iex_promise_details pd,
2013: IEX_DELINQUENCIES_ALL DEL,
2014: iex_dln_uwq_summary dln
2015: WHERE pd.cust_account_id = del.cust_account_id
2016: and pd.delinquency_id = del.delinquency_id

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

2352: phone.phone_number phone_number,
2353: phone.phone_extension phone_extension,
2354: (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
2355:
2356: (SELECT COUNT(1) FROM iex_promise_details PRO, IEX_DELINQUENCIES_all DEL
2357: WHERE PRO.CUST_ACCOUNT_ID = TRX_SUMM.CUST_ACCOUNT_ID AND
2358: PRO.STATUS IN ('COLLECTABLE', 'PENDING') AND PRO.STATE = 'BROKEN_PROMISE' AND PRO.AMOUNT_DUE_REMAINING > 0 AND
2359: PRO.DELINQUENCY_ID = DEL.DELINQUENCY_ID(+)
2360: AND (DEL.STATUS --(+) Commented for Bug 6446848 06-Jan-2009 barathsr

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

2361: NOT IN ('CURRENT', 'CLOSE')
2362: or (del.status='CURRENT' and del.source_program_name='IEX_CURR_INV'))--Added for Bug 6446848 06-Jan-2009 barathsr
2363: AND DEL.org_id = trx_summ.org_id) NUMBER_OF_PROMISES ,
2364:
2365: (SELECT SUM(AMOUNT_DUE_REMAINING) FROM IEX_PROMISE_DETAILS PRO, IEX_DELINQUENCIES_all DEL
2366: WHERE PRO.CUST_ACCOUNT_ID = TRX_SUMM.CUST_ACCOUNT_ID AND
2367: PRO.STATUS IN ('COLLECTABLE', 'PENDING') AND PRO.STATE = 'BROKEN_PROMISE' AND PRO.AMOUNT_DUE_REMAINING > 0 AND
2368: PRO.DELINQUENCY_ID = DEL.DELINQUENCY_ID(+)
2369: AND (DEL.STATUS --(+) Commented for Bug 6446848 06-Jan-2009 barathsr

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

2370: NOT IN ('CURRENT', 'CLOSE')
2371: or (del.status='CURRENT' and del.source_program_name='IEX_CURR_INV'))--Added for Bug 6446848 06-Jan-2009 barathsr
2372: AND DEL.org_id = trx_summ.org_id) BROKEN_PROMISE_AMOUNT ,
2373:
2374: (SELECT SUM(PROMISE_AMOUNT) FROM IEX_PROMISE_DETAILS PRO, IEX_DELINQUENCIES_all DEL
2375: WHERE PRO.CUST_ACCOUNT_ID = TRX_SUMM.CUST_ACCOUNT_ID AND
2376: PRO.STATUS IN ('COLLECTABLE', 'PENDING') AND PRO.STATE = 'BROKEN_PROMISE' AND PRO.AMOUNT_DUE_REMAINING > 0 AND
2377: PRO.DELINQUENCY_ID = DEL.DELINQUENCY_ID(+)
2378: AND (DEL.STATUS --(+) Commented for Bug 6446848 06-Jan-2009 barathsr

Line 2386: FROM iex_promise_details

2382:
2383: (SELECT 1 FROM dual WHERE EXISTS
2384: (SELECT 1 FROM dual WHERE EXISTS
2385: (SELECT 1
2386: FROM iex_promise_details
2387: WHERE cust_account_id = trx_summ.cust_account_id
2388: AND state = 'BROKEN_PROMISE'
2389: AND(uwq_status IS NULL OR uwq_status = 'ACTIVE' OR(TRUNC(uwq_active_date) <= TRUNC(sysdate)
2390: AND uwq_status = 'PENDING')))

Line 2397: FROM iex_promise_details

2393:
2394: (SELECT 1 FROM dual WHERE EXISTS
2395: (SELECT 1 FROM dual WHERE EXISTS
2396: (SELECT 1
2397: FROM iex_promise_details
2398: WHERE cust_account_id = trx_summ.cust_account_id
2399: AND state = 'BROKEN_PROMISE'
2400: AND(uwq_status = 'COMPLETE'
2401: AND(TRUNC(uwq_complete_date) + fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') > TRUNC(sysdate))))

Line 2408: FROM iex_promise_details

2404:
2405: (SELECT 1 FROM dual WHERE EXISTS
2406: (SELECT 1 FROM dual WHERE EXISTS
2407: (SELECT 1
2408: FROM iex_promise_details
2409: WHERE cust_account_id = trx_summ.cust_account_id
2410: AND state = 'BROKEN_PROMISE'
2411: AND(uwq_status = 'PENDING'
2412: AND(TRUNC(uwq_active_date) > TRUNC(sysdate))))

Line 2611: FROM iex_promise_details pd,

2607: iex_utilities.get_cache_value('DEFAULT_EXCHANGE_RATE_TYPE', ''), pd.amount_due_remaining)) broken_promise_amount,
2608: SUM(gl_currency_api.convert_amount_sql(pd.currency_code, dln.currency, sysdate,
2609: iex_utilities.get_cache_value('DEFAULT_EXCHANGE_RATE_TYPE', ''), pd.promise_amount)) promise_amount
2610: -- End Bug 14197188 bibeura 26-Jun-2012
2611: FROM iex_promise_details pd,
2612: iex_delinquencies_all del,
2613: iex_dln_uwq_summary dln
2614: WHERE dln.cust_account_id = del.cust_account_id
2615: AND pd.delinquency_id = del.delinquency_id

Line 2630: from iex_promise_details pd,

2626: select del.CUST_Account_ID,dln.org_id,
2627: max(decode(pd.uwq_status,'PENDING',(decode(sign(TRUNC(pd.uwq_active_date) - TRUNC(sysdate)),1,1)))) pending_promises,
2628: 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,
2629: 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
2630: from iex_promise_details pd,
2631: IEX_DELINQUENCIES_ALL DEL,
2632: iex_dln_uwq_summary dln
2633: WHERE dln.cust_account_id = del.cust_account_id
2634: and pd.delinquency_id = del.delinquency_id

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

2934: phone.phone_number phone_number,
2935: phone.phone_extension phone_extension,
2936: (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
2937:
2938: (SELECT COUNT(1) FROM iex_promise_details PRO, IEX_DELINQUENCIES_all DEL
2939: WHERE PRO.CUST_ACCOUNT_ID = TRX_SUMM.CUST_ACCOUNT_ID AND
2940: PRO.STATUS IN ('COLLECTABLE', 'PENDING') AND PRO.STATE = 'BROKEN_PROMISE' AND PRO.AMOUNT_DUE_REMAINING > 0 AND
2941: PRO.DELINQUENCY_ID = DEL.DELINQUENCY_ID(+)
2942: AND (DEL.STATUS --(+) Commented for Bug 6446848 06-Jan-2009 barathsr

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

2943: NOT IN ('CURRENT', 'CLOSE')
2944: or (del.status='CURRENT' and del.source_program_name='IEX_CURR_INV'))--Added for Bug 6446848 06-Jan-2009 barathsr
2945: AND DEL.org_id = trx_summ.org_id) NUMBER_OF_PROMISES ,
2946:
2947: (SELECT SUM(AMOUNT_DUE_REMAINING) FROM IEX_PROMISE_DETAILS PRO, IEX_DELINQUENCIES_all DEL
2948: WHERE PRO.CUST_ACCOUNT_ID = TRX_SUMM.CUST_ACCOUNT_ID AND
2949: PRO.STATUS IN ('COLLECTABLE', 'PENDING') AND PRO.STATE = 'BROKEN_PROMISE' AND PRO.AMOUNT_DUE_REMAINING > 0 AND
2950: PRO.DELINQUENCY_ID = DEL.DELINQUENCY_ID(+)
2951: AND (DEL.STATUS --(+) Commented for Bug 6446848 06-Jan-2009 barathsr

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

2952: NOT IN ('CURRENT', 'CLOSE')
2953: or (del.status='CURRENT' and del.source_program_name='IEX_CURR_INV'))--Added for Bug 6446848 06-Jan-2009 barathsr
2954: AND DEL.org_id = trx_summ.org_id) BROKEN_PROMISE_AMOUNT ,
2955:
2956: (SELECT SUM(PROMISE_AMOUNT) FROM IEX_PROMISE_DETAILS PRO, IEX_DELINQUENCIES_all DEL
2957: WHERE PRO.CUST_ACCOUNT_ID = TRX_SUMM.CUST_ACCOUNT_ID AND
2958: PRO.STATUS IN ('COLLECTABLE', 'PENDING') AND PRO.STATE = 'BROKEN_PROMISE' AND PRO.AMOUNT_DUE_REMAINING > 0 AND
2959: PRO.DELINQUENCY_ID = DEL.DELINQUENCY_ID(+)
2960: AND (DEL.STATUS --(+) Commented for Bug 6446848 06-Jan-2009 barathsr

Line 2968: FROM iex_promise_details

2964:
2965: (SELECT 1 FROM dual WHERE EXISTS
2966: (SELECT 1 FROM dual WHERE EXISTS
2967: (SELECT 1
2968: FROM iex_promise_details
2969: WHERE cust_account_id = trx_summ.cust_account_id
2970: AND state = 'BROKEN_PROMISE'
2971: AND(uwq_status IS NULL OR uwq_status = 'ACTIVE' OR(TRUNC(uwq_active_date) <= TRUNC(sysdate)
2972: AND uwq_status = 'PENDING')))

Line 2979: FROM iex_promise_details

2975:
2976: (SELECT 1 FROM dual WHERE EXISTS
2977: (SELECT 1 FROM dual WHERE EXISTS
2978: (SELECT 1
2979: FROM iex_promise_details
2980: WHERE cust_account_id = trx_summ.cust_account_id
2981: AND state = 'BROKEN_PROMISE'
2982: AND(uwq_status = 'COMPLETE'
2983: AND(TRUNC(uwq_complete_date) + fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') > TRUNC(sysdate))))

Line 2990: FROM iex_promise_details

2986:
2987: (SELECT 1 FROM dual WHERE EXISTS
2988: (SELECT 1 FROM dual WHERE EXISTS
2989: (SELECT 1
2990: FROM iex_promise_details
2991: WHERE cust_account_id = trx_summ.cust_account_id
2992: AND state = 'BROKEN_PROMISE'
2993: AND(uwq_status = 'PENDING'
2994: AND(TRUNC(uwq_active_date) > TRUNC(sysdate))))

Line 3205: FROM iex_promise_details pd,

3201: iex_utilities.get_cache_value('DEFAULT_EXCHANGE_RATE_TYPE', ''), pd.amount_due_remaining)) broken_promise_amount,
3202: SUM(gl_currency_api.convert_amount_sql(pd.currency_code, dln.currency, sysdate,
3203: iex_utilities.get_cache_value('DEFAULT_EXCHANGE_RATE_TYPE', ''), pd.promise_amount)) promise_amount
3204: -- End Bug 14197188 bibeura 26-Jun-2012
3205: FROM iex_promise_details pd,
3206: iex_delinquencies_all del,
3207: iex_dln_uwq_summary dln
3208: WHERE dln.cust_account_id = del.cust_account_id
3209: AND pd.delinquency_id = del.delinquency_id

Line 3226: from iex_promise_details pd,

3222: select del.CUST_Account_ID,dln.org_id,
3223: max(decode(pd.uwq_status,'PENDING',(decode(sign(TRUNC(pd.uwq_active_date) - TRUNC(sysdate)),1,1)))) pending_promises,
3224: 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,
3225: 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
3226: from iex_promise_details pd,
3227: IEX_DELINQUENCIES_ALL DEL,
3228: iex_dln_uwq_summary dln
3229: WHERE dln.cust_account_id = del.cust_account_id
3230: and pd.delinquency_id = del.delinquency_id

Line 3575: FROM iex_promise_details pd,

3571: (SELECT 1
3572: FROM dual
3573: WHERE EXISTS
3574: (SELECT 1
3575: FROM iex_promise_details pd,
3576: hz_cust_accounts b
3577: WHERE b.party_id = party.party_id
3578: AND pd.cust_account_id = b.cust_account_id
3579: AND pd.state = 'BROKEN_PROMISE'

Line 3588: FROM iex_promise_details pd,

3584: (SELECT 1
3585: FROM dual
3586: WHERE EXISTS
3587: (SELECT 1
3588: FROM iex_promise_details pd,
3589: hz_cust_accounts b
3590: WHERE b.party_id = party.party_id
3591: AND pd.cust_account_id = b.cust_account_id
3592: AND pd.state = 'BROKEN_PROMISE'

Line 3601: FROM iex_promise_details pd,

3597: (SELECT 1
3598: FROM dual
3599: WHERE EXISTS
3600: (SELECT 1
3601: FROM iex_promise_details pd,
3602: hz_cust_accounts b
3603: WHERE b.party_id = party.party_id
3604: AND pd.cust_account_id = b.cust_account_id
3605: and pd.state = 'BROKEN_PROMISE'

Line 3812: FROM iex_promise_details pd,

3808: iex_utilities.get_cache_value('DEFAULT_EXCHANGE_RATE_TYPE', ''), pd.amount_due_remaining)) broken_promise_amount,
3809: SUM(gl_currency_api.convert_amount_sql(pd.currency_code, dln.currency, sysdate,
3810: iex_utilities.get_cache_value('DEFAULT_EXCHANGE_RATE_TYPE', ''), pd.promise_amount)) promise_amount
3811: -- End Bug 14197188 bibeura 26-Jun-2012
3812: FROM iex_promise_details pd,
3813: iex_delinquencies_all del,
3814: iex_dln_uwq_summary dln
3815: WHERE dln.party_id = del.party_cust_id
3816: AND pd.delinquency_id = del.delinquency_id

Line 3832: from iex_promise_details pd,

3828: select del.party_cust_ID,dln.org_id,
3829: max(decode(pd.uwq_status,'PENDING',(decode(sign(TRUNC(pd.uwq_active_date) - TRUNC(sysdate)),1,1)))) pending_promises,
3830: 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,
3831: 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
3832: from iex_promise_details pd,
3833: IEX_DELINQUENCIES_ALL DEL,
3834: iex_dln_uwq_summary dln
3835: WHERE dln.party_id = del.party_cust_id
3836: and pd.delinquency_id = del.delinquency_id

Line 4153: FROM iex_promise_details pd,

4149: (SELECT 1
4150: FROM dual
4151: WHERE EXISTS
4152: (SELECT 1
4153: FROM iex_promise_details pd,
4154: hz_cust_accounts b
4155: WHERE b.party_id = party.party_id
4156: AND pd.cust_account_id = b.cust_account_id
4157: AND pd.state = 'BROKEN_PROMISE'

Line 4166: FROM iex_promise_details pd,

4162: (SELECT 1
4163: FROM dual
4164: WHERE EXISTS
4165: (SELECT 1
4166: FROM iex_promise_details pd,
4167: hz_cust_accounts b
4168: WHERE b.party_id = party.party_id
4169: AND pd.cust_account_id = b.cust_account_id
4170: AND pd.state = 'BROKEN_PROMISE'

Line 4179: FROM iex_promise_details pd,

4175: (SELECT 1
4176: FROM dual
4177: WHERE EXISTS
4178: (SELECT 1
4179: FROM iex_promise_details pd,
4180: hz_cust_accounts b
4181: WHERE b.party_id = party.party_id
4182: AND pd.cust_account_id = b.cust_account_id
4183: and pd.state = 'BROKEN_PROMISE'

Line 4401: FROM iex_promise_details pd,

4397: iex_utilities.get_cache_value('DEFAULT_EXCHANGE_RATE_TYPE', ''), pd.amount_due_remaining)) broken_promise_amount,
4398: SUM(gl_currency_api.convert_amount_sql(pd.currency_code, dln.currency, sysdate,
4399: iex_utilities.get_cache_value('DEFAULT_EXCHANGE_RATE_TYPE', ''), pd.promise_amount)) promise_amount
4400: -- End Bug 14197188 bibeura 26-Jun-2012
4401: FROM iex_promise_details pd,
4402: iex_delinquencies_all del,
4403: iex_dln_uwq_summary dln
4404: WHERE dln.party_id = del.party_cust_id
4405: AND pd.delinquency_id = del.delinquency_id

Line 4423: from iex_promise_details pd,

4419: select del.party_cust_ID,dln.org_id,
4420: max(decode(pd.uwq_status,'PENDING',(decode(sign(TRUNC(pd.uwq_active_date) - TRUNC(sysdate)),1,1)))) pending_promises,
4421: 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,
4422: 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
4423: from iex_promise_details pd,
4424: IEX_DELINQUENCIES_ALL DEL,
4425: iex_dln_uwq_summary dln
4426: WHERE dln.party_id = del.party_cust_id
4427: and pd.delinquency_id = del.delinquency_id

Line 9870: from iex_promise_details pd,

9866: select del.CUSTOMER_SITE_USE_ID,
9867: max(decode(pd.uwq_status,'PENDING',(decode(sign(TRUNC(pd.uwq_active_date) - TRUNC(sysdate)),1,1)))) pending_promises,
9868: 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,
9869: 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
9870: from iex_promise_details pd,
9871: IEX_DELINQUENCIES_ALL DEL,
9872: iex_pop_uwq_summ_gt temp
9873: WHERE pd.cust_account_id = del.cust_account_id
9874: and pd.delinquency_id = del.delinquency_id

Line 9891: FROM iex_promise_details pd,

9887: iex_utilities.get_cache_value('DEFAULT_EXCHANGE_RATE_TYPE','select NVL(FND_PROFILE.VALUE(''IEX_EXCHANGE_RATE_TYPE''),''Corporate'') from dual'), pd.amount_due_remaining)) broken_promise_amount,
9888: SUM(gl_currency_api.convert_amount_sql(pd.currency_code, gl.currency_code, sysdate,
9889: iex_utilities.get_cache_value('DEFAULT_EXCHANGE_RATE_TYPE','select NVL(FND_PROFILE.VALUE(''IEX_EXCHANGE_RATE_TYPE''),''Corporate'') from dual'), pd.promise_amount)) promise_amount
9890: -- End Bug 14197188 bibeura 26-Jun-2012
9891: FROM iex_promise_details pd,
9892: iex_delinquencies_all del,
9893: iex_pop_uwq_summ_gt temp,
9894: ar_system_parameters_all sys ,
9895: gl_sets_of_books gl

Line 11197: from iex_promise_details pd,

11193: select del.cust_account_id,
11194: max(decode(pd.uwq_status,'PENDING',(decode(sign(TRUNC(pd.uwq_active_date) - TRUNC(sysdate)),1,1)))) pending_promises,
11195: 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,
11196: 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
11197: from iex_promise_details pd,
11198: IEX_DELINQUENCIES_ALL DEL,
11199: iex_pop_uwq_summ_gt temp
11200: WHERE pd.cust_account_id = del.cust_account_id
11201: and pd.delinquency_id = del.delinquency_id

Line 11218: FROM iex_promise_details pd,

11214: iex_utilities.get_cache_value('DEFAULT_EXCHANGE_RATE_TYPE','select NVL(FND_PROFILE.VALUE(''IEX_EXCHANGE_RATE_TYPE''),''Corporate'') from dual'), pd.amount_due_remaining)) broken_promise_amount,
11215: SUM(gl_currency_api.convert_amount_sql(pd.currency_code, gl.currency_code, sysdate,
11216: iex_utilities.get_cache_value('DEFAULT_EXCHANGE_RATE_TYPE','select NVL(FND_PROFILE.VALUE(''IEX_EXCHANGE_RATE_TYPE''),''Corporate'') from dual'), pd.promise_amount)) promise_amount
11217: -- End Bug 14197188 bibeura 26-Jun-2012
11218: FROM iex_promise_details pd,
11219: iex_delinquencies_all del,
11220: iex_pop_uwq_summ_gt temp,
11221: ar_system_parameters_all sys ,
11222: gl_sets_of_books gl

Line 12507: from iex_promise_details pd,

12503: select del.party_cust_id,
12504: max(decode(pd.uwq_status,'PENDING',(decode(sign(TRUNC(pd.uwq_active_date) - TRUNC(sysdate)),1,1)))) pending_promises,
12505: 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,
12506: 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
12507: from iex_promise_details pd,
12508: IEX_DELINQUENCIES_ALL DEL,
12509: iex_pop_uwq_summ_gt temp
12510: WHERE pd.cust_account_id = del.cust_account_id
12511: AND pd.delinquency_id = del.delinquency_id

Line 12528: FROM iex_promise_details pd,

12524: iex_utilities.get_cache_value('DEFAULT_EXCHANGE_RATE_TYPE','select NVL(FND_PROFILE.VALUE(''IEX_EXCHANGE_RATE_TYPE''),''Corporate'') from dual'), pd.amount_due_remaining)) broken_promise_amount,
12525: SUM(gl_currency_api.convert_amount_sql(pd.currency_code, gl.currency_code, sysdate,
12526: iex_utilities.get_cache_value('DEFAULT_EXCHANGE_RATE_TYPE','select NVL(FND_PROFILE.VALUE(''IEX_EXCHANGE_RATE_TYPE''),''Corporate'') from dual'), pd.promise_amount)) promise_amount
12527: -- End Bug 14197188 bibeura 26-Jun-2012
12528: FROM iex_promise_details pd,
12529: iex_delinquencies_all del,
12530: iex_pop_uwq_summ_gt temp,
12531: ar_system_parameters_all sys ,
12532: gl_sets_of_books gl