APPS.OKL_LTE_CHRG_PVT dependencies on OKL_BPD_AR_INV_LINES_V

Line 119: ,okl_bpd_ar_inv_lines_v lpt1

115: WHERE
116: RACTRX.CUST_TRX_TYPE_ID = RATRXTYPE.CUST_TRX_TYPE_ID
117: and RACTRX.CUSTOMER_TRX_ID = PAY_SCH.CUSTOMER_TRX_ID
118: and RACTRX.ORG_ID = RATRXTYPE.ORG_ID ) lpt
119: ,okl_bpd_ar_inv_lines_v lpt1
120: ,okl_k_headers_full_v khr
121: ,okc_rule_groups_b rgp
122: ,okc_rules_b rul
123: ,okc_rules_b rul_exm

Line 263: ,okl_bpd_ar_inv_lines_v orig_arl

259: WHERE
260: RACTRX.CUST_TRX_TYPE_ID = RATRXTYPE.CUST_TRX_TYPE_ID
261: and RACTRX.CUSTOMER_TRX_ID = PAY_SCH.CUSTOMER_TRX_ID
262: and RACTRX.ORG_ID = RATRXTYPE.ORG_ID ) last_arv
263: ,okl_bpd_ar_inv_lines_v orig_arl
264: ,okl_bpd_ar_inv_lines_v last_arl
265: ,okl_strm_elements_v sel
266: ,okl_k_headers_full_v khr
267: ,okc_rule_groups_b rgp

Line 264: ,okl_bpd_ar_inv_lines_v last_arl

260: RACTRX.CUST_TRX_TYPE_ID = RATRXTYPE.CUST_TRX_TYPE_ID
261: and RACTRX.CUSTOMER_TRX_ID = PAY_SCH.CUSTOMER_TRX_ID
262: and RACTRX.ORG_ID = RATRXTYPE.ORG_ID ) last_arv
263: ,okl_bpd_ar_inv_lines_v orig_arl
264: ,okl_bpd_ar_inv_lines_v last_arl
265: ,okl_strm_elements_v sel
266: ,okl_k_headers_full_v khr
267: ,okc_rule_groups_b rgp
268: ,okc_rules_b rul

Line 451: FROM OKL_BPD_AR_INV_LINES_V

447: CURSOR l_AR_lsm_cur(l_id IN NUMBER,l_contract_id in number) IS
448: SELECT ID
449: , LATE_CHARGE_ASS_YN
450: , LATE_CHARGE_ASSESS_DATE
451: FROM OKL_BPD_AR_INV_LINES_V
452: WHERE RECEIVABLES_INVOICE_ID = l_id
453: AND CONTRACT_ID=l_contract_id
454: FOR UPDATE OF LATE_CHARGE_ASS_YN, LATE_CHARGE_ASSESS_DATE;
455:

Line 534: from okl_bpd_ar_inv_lines_v

530:
531: CURSOR l_receivables_inv_csr (cp_contract_id number, cp_trx_number varchar2)
532: is
533: select RECEIVABLES_INVOICE_ID, CONTRACT_ID
534: from okl_bpd_ar_inv_lines_v
535: where contract_id=cp_contract_id
536: and trx_number=cp_trx_number;
537:
538:

Line 576: FROM okl_bpd_ar_inv_lines_v arl

572:
573: CURSOR c_sec_strm_AR_csr(cp_contract_id in number, cp_con_inv_number IN VARCHAR2) IS
574: SELECT arl.id cnsld_strm_id
575: ,pol.khr_id, pk.kle_id kle_id
576: FROM okl_bpd_ar_inv_lines_v arl
577: ,okl_bpd_ar_invoices_v arv
578: ,okl_pool_contents_v pk
579: ,okl_pools pol
580: WHERE arl.trx_number = cp_con_inv_number

Line 598: FROM okl_bpd_ar_inv_lines_v arl

594: --modified view name, where clause
595:
596: CURSOR c_strm_purpose(cp_stream_id IN NUMBER) IS
597: SELECT sty.stream_type_purpose
598: FROM okl_bpd_ar_inv_lines_v arl
599: ,okl_strm_type_b sty
600: WHERE arl.id = cp_stream_id
601: AND arl.sty_id = sty.id;
602:

Line 608: FROM okl_bpd_ar_inv_lines_v

604: -- Source id of stream element of Late Invoice Cursor
605: ------------------------------------------------------------
606: cursor c_AR_source_sel(cp_contract_number varchar2, cp_trx_number varchar2) is
607: SELECT receivables_invoice_id
608: FROM okl_bpd_ar_inv_lines_v
609: WHERE contract_number = cp_contract_number
610: AND trx_number = cp_trx_number;
611: ---
612: --- END DECLARE