APPS.OKL_CONTRACT_INFO dependencies on OKL_BPD_TLD_AR_LINES_V

Line 685: FROM okl_bpd_tld_ar_lines_v ocas

681: AND NVL(aps.amount_due_remaining, 0) > 0; */
682:
683: CURSOR days_past_due_csr(p_contract_id IN NUMBER) IS
684: SELECT min(aps.due_date)
685: FROM okl_bpd_tld_ar_lines_v ocas
686: ,ar_payment_schedules aps
687: WHERE ocas.khr_id = p_contract_id
688: AND ocas.customer_trx_id = aps.customer_trx_id
689: AND aps.class = 'INV'

Line 756: FROM okl_bpd_tld_ar_lines_v ocas

752: --and strm.name <>'CURE';
753:
754: CURSOR amount_past_due_csr(p_contract_id IN NUMBER, p_sty_id IN NUMBER) IS
755: SELECT SUM(NVL(aps.amount_due_remaining, 0)) past_due_amount
756: FROM okl_bpd_tld_ar_lines_v ocas
757: ,ar_payment_schedules aps
758: ,okl_strm_type_v strm
759: WHERE ocas.khr_id = p_contract_id
760: AND ocas.customer_trx_id = aps.customer_trx_id

Line 861: FROM OKL_BPD_TLD_AR_LINES_V LSM

857: FROM (SELECT (SYSDATE-due_date) days
858: ,aps.due_date due_date
859: ,SUM(aps.amount_due_original) amt
860: ,lsm.khr_id khr_id
861: FROM OKL_BPD_TLD_AR_LINES_V LSM
862: ,AR_PAYMENT_SCHEDULES APS
863: WHERE lsm.customer_trx_id = aps.customer_trx_id
864: GROUP BY khr_id, due_date ) amount_date
865: WHERE amount_date.days=(SELECT MIN(next_due.days)

Line 870: FROM OKL_BPD_TLD_AR_LINES_V LSM

866: FROM (SELECT (SYSDATE-due_date) days
867: ,aps.due_date due_date
868: ,SUM(aps.amount_due_original) amt
869: ,lsm.khr_id khr_id
870: FROM OKL_BPD_TLD_AR_LINES_V LSM
871: ,AR_PAYMENT_SCHEDULES APS
872: WHERE lsm.customer_trx_id = aps.customer_trx_id
873: GROUP BY khr_id, due_date) next_due
874: WHERE khr_id = p_contract_id

Line 883: FROM okl_bpd_tld_ar_lines_v LSM

879: --dkagrawa changed the cursor as follows for bug#6324572
880: CURSOR next_due_csr IS
881: SELECT SUM(aps.amount_due_original) amt,
882: aps.due_date due_date
883: FROM okl_bpd_tld_ar_lines_v LSM
884: ,AR_PAYMENT_SCHEDULES APS
885: WHERE lsm.customer_trx_id = aps.customer_trx_id
886: AND lsm.khr_id = p_contract_id
887: AND due_date>SYSDATE

Line 953: FROM okl_bpd_tld_ar_lines_v LSM

949: FROM (SELECT (SYSDATE-due_date) days
950: ,aps.due_date due_date
951: ,SUM(aps.amount_due_original) amt
952: ,lsm.khr_id khr_id
953: FROM okl_bpd_tld_ar_lines_v LSM
954: ,AR_PAYMENT_SCHEDULES APS
955: WHERE lsm.customer_trx_id = aps.customer_trx_id
956: GROUP BY khr_id, due_date ) amount_date
957: WHERE amount_date.days=(SELECT MIN(next_due.days)

Line 962: FROM okl_bpd_tld_ar_lines_v LSM

958: FROM (SELECT (SYSDATE-due_date) days
959: ,aps.due_date due_date
960: ,SUM(aps.amount_due_original) amt
961: ,lsm.khr_id khr_id
962: FROM okl_bpd_tld_ar_lines_v LSM
963: ,AR_PAYMENT_SCHEDULES APS
964: WHERE lsm.customer_trx_id = aps.customer_trx_id
965: GROUP BY khr_id, due_date) next_due
966: WHERE khr_id = p_contract_id

Line 974: FROM okl_bpd_tld_ar_lines_v LSM

970: --dkagrawa changed the cursor as follows for bug#6324572
971: CURSOR last_due_csr IS
972: SELECT SUM(aps.amount_due_original) amt,
973: aps.due_date due_date
974: FROM okl_bpd_tld_ar_lines_v LSM
975: ,AR_PAYMENT_SCHEDULES APS
976: WHERE lsm.customer_trx_id = aps.customer_trx_id
977: AND lsm.khr_id = p_contract_id
978: AND due_date<=SYSDATE

Line 1080: FROM okl_bpd_tld_ar_lines_v ocas

1076: --and strm.name <>'CURE'; */
1077:
1078: CURSOR outstanding_rcvble_csr(p_sty_id number) IS
1079: SELECT SUM(NVL(aps.amount_due_remaining, 0)) past_due_amount
1080: FROM okl_bpd_tld_ar_lines_v ocas
1081: ,ar_payment_schedules aps
1082: ,okl_strm_type_v strm
1083: WHERE ocas.khr_id = p_contract_id
1084: AND ocas.customer_trx_id = aps.customer_trx_id