[Home] [Help]
224: phone.phone_country_code phone_country_code,
225: phone.phone_area_code phone_area_code,
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
487: phone.phone_country_code phone_country_code,
488: phone.phone_area_code phone_area_code,
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
754: phone.phone_country_code phone_country_code,
755: phone.phone_area_code phone_area_code,
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
1012: phone.phone_country_code phone_country_code,
1013: phone.phone_area_code phone_area_code,
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
1278: phone.phone_country_code phone_country_code,
1279: phone.phone_area_code phone_area_code,
1280: phone.phone_number phone_number,
1281: phone.phone_extension phone_extension,
1282: (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
1283:
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,
1518: phone.phone_country_code phone_country_code,
1519: phone.phone_area_code phone_area_code,
1520: phone.phone_number phone_number,
1521: phone.phone_extension phone_extension,
1522: (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
1523:
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,
3761:
3762: cursor c_bankruptcies is
3763: select sua.site_use_id,
3764: COUNT(1) number_of_bankruptcies
3765: FROM iex_bankruptcies bkr,hz_cust_accounts ca,
3766: hz_cust_acct_sites cas,hz_cust_site_uses_all sua
3767: where sua.site_use_id in (select object_id from iex_pop_uwq_summ_gt)
3768: and bkr.party_id=ca.party_id
3769: and ca.cust_account_id=cas.cust_account_id
4989:
4990: cursor c_bankruptcies is
4991: select ca.cust_account_id,
4992: COUNT(1) number_of_bankruptcies
4993: FROM iex_bankruptcies bkr,hz_cust_accounts ca
4994: where ca.cust_account_id in (select object_id from iex_pop_uwq_summ_gt)
4995: and bkr.party_id=ca.party_id
4996: and NVL(BKR.DISPOSITION_CODE,'GRANTED') in ('GRANTED','NEGOTIATION') -- Changed for bug#7693986
4997: group by ca.cust_account_id;
6212:
6213: cursor c_bankruptcies is
6214: select bkr.party_id,
6215: COUNT(1) number_of_bankruptcies
6216: FROM iex_bankruptcies bkr
6217: where bkr.party_id in (select object_id from iex_pop_uwq_summ_gt)
6218: and NVL(BKR.DISPOSITION_CODE,'GRANTED') in ('GRANTED','NEGOTIATION') -- Changed for bug#7693986
6219: group by bkr.party_id;
6220: