APPS.OKL_CONTRACT_INFO dependencies on OKL_STRM_TYPE_V

Line 745: ,okl_strm_type_v strm

741: /*CURSOR amount_past_due_csr(p_contract_id IN NUMBER, p_sty_id IN NUMBER) IS
742: SELECT SUM(NVL(aps.amount_due_remaining, 0)) past_due_amount
743: FROM okl_cnsld_ar_strms_b ocas
744: ,ar_payment_schedules aps
745: ,okl_strm_type_v strm
746: WHERE ocas.khr_id = p_contract_id
747: AND ocas.receivables_invoice_id = aps.customer_trx_id
748: AND aps.class ='INV'
749: AND aps.due_date < sysdate

Line 758: ,okl_strm_type_v strm

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
761: AND aps.class ='INV'
762: AND aps.due_date < sysdate

Line 1069: ,okl_strm_type_v strm

1065: /* CURSOR outstanding_rcvble_csr(p_sty_id number) IS
1066: SELECT SUM(NVL(aps.amount_due_remaining, 0)) past_due_amount
1067: FROM okl_cnsld_ar_strms_b ocas
1068: ,ar_payment_schedules aps
1069: ,okl_strm_type_v strm
1070: WHERE ocas.khr_id = p_contract_id
1071: AND ocas.receivables_invoice_id = aps.customer_trx_id
1072: AND aps.class ='INV'
1073: --AND aps.due_date < sysdate

Line 1082: ,okl_strm_type_v strm

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
1085: AND aps.class ='INV'
1086: --AND aps.due_date < sysdate

Line 1187: FROM okl_streams_v asv,okl_strm_type_v bs,okl_strm_elements_v cs

1183:
1184: -- get residual value
1185: CURSOR residual_csr IS
1186: SELECT NVL(SUM(cs.amount),0)
1187: FROM okl_streams_v asv,okl_strm_type_v bs,okl_strm_elements_v cs
1188: WHERE cs.stm_id = asv.id AND bs.id = asv.sty_id
1189: AND bs.name = 'Residual Value'
1190: AND cs.stream_element_date >= SYSDATE
1191: AND asv.khr_id = p_contract_id;

Line 1196: FROM okl_streams_v asv,okl_strm_type_v bs,okl_strm_elements_v cs

1192:
1193: -- get rent value
1194: CURSOR rent_csr IS
1195: SELECT NVL(SUM(cs.amount),0)
1196: FROM okl_streams_v asv,okl_strm_type_v bs,okl_strm_elements_v cs
1197: WHERE cs.stm_id = asv.id AND bs.id = asv.sty_id
1198: AND bs.name = 'Rent'
1199: AND cs.stream_element_date >= SYSDATE
1200: AND asv.khr_id = p_contract_id ;

Line 1204: FROM okl_streams_v asv,okl_strm_type_v bs,okl_strm_elements_v cs

1200: AND asv.khr_id = p_contract_id ;
1201: -- get unearned amount
1202: CURSOR unearned_csr IS
1203: SELECT NVL(SUM(cs.amount),0)
1204: FROM okl_streams_v asv,okl_strm_type_v bs,okl_strm_elements_v cs
1205: WHERE cs.stm_id = asv.id AND bs.id = asv.sty_id
1206: AND bs.name = 'Unearned Income'
1207: AND cs.stream_element_date >= SYSDATE
1208: AND asv.khr_id = p_contract_id ;