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 258: ,okl_bpd_ar_inv_lines_v orig_arl

254: WHERE
255: RACTRX.CUST_TRX_TYPE_ID = RATRXTYPE.CUST_TRX_TYPE_ID
256: and RACTRX.CUSTOMER_TRX_ID = PAY_SCH.CUSTOMER_TRX_ID
257: and RACTRX.ORG_ID = RATRXTYPE.ORG_ID ) last_arv
258: ,okl_bpd_ar_inv_lines_v orig_arl
259: ,okl_bpd_ar_inv_lines_v last_arl
260: ,okl_strm_elements_v sel
261: ,okl_k_headers_full_v khr
262: ,okc_rule_groups_b rgp

Line 259: ,okl_bpd_ar_inv_lines_v last_arl

255: RACTRX.CUST_TRX_TYPE_ID = RATRXTYPE.CUST_TRX_TYPE_ID
256: and RACTRX.CUSTOMER_TRX_ID = PAY_SCH.CUSTOMER_TRX_ID
257: and RACTRX.ORG_ID = RATRXTYPE.ORG_ID ) last_arv
258: ,okl_bpd_ar_inv_lines_v orig_arl
259: ,okl_bpd_ar_inv_lines_v last_arl
260: ,okl_strm_elements_v sel
261: ,okl_k_headers_full_v khr
262: ,okc_rule_groups_b rgp
263: ,okc_rules_b rul

Line 446: FROM OKL_BPD_AR_INV_LINES_V

442: CURSOR l_AR_lsm_cur(l_id IN NUMBER,l_contract_id in number) IS
443: SELECT ID
444: , LATE_CHARGE_ASS_YN
445: , LATE_CHARGE_ASSESS_DATE
446: FROM OKL_BPD_AR_INV_LINES_V
447: WHERE RECEIVABLES_INVOICE_ID = l_id
448: AND CONTRACT_ID=l_contract_id
449: FOR UPDATE OF LATE_CHARGE_ASS_YN, LATE_CHARGE_ASSESS_DATE;
450:

Line 529: from okl_bpd_ar_inv_lines_v

525:
526: CURSOR l_receivables_inv_csr (cp_contract_id number, cp_trx_number varchar2)
527: is
528: select RECEIVABLES_INVOICE_ID, CONTRACT_ID
529: from okl_bpd_ar_inv_lines_v
530: where contract_id=cp_contract_id
531: and trx_number=cp_trx_number;
532:
533:

Line 571: FROM okl_bpd_ar_inv_lines_v arl

567:
568: CURSOR c_sec_strm_AR_csr(cp_contract_id in number, cp_con_inv_number IN VARCHAR2) IS
569: SELECT arl.id cnsld_strm_id
570: ,pol.khr_id, pk.kle_id kle_id
571: FROM okl_bpd_ar_inv_lines_v arl
572: ,okl_bpd_ar_invoices_v arv
573: ,okl_pool_contents_v pk
574: ,okl_pools pol
575: WHERE arl.trx_number = cp_con_inv_number

Line 593: FROM okl_bpd_ar_inv_lines_v arl

589: --modified view name, where clause
590:
591: CURSOR c_strm_purpose(cp_stream_id IN NUMBER) IS
592: SELECT sty.stream_type_purpose
593: FROM okl_bpd_ar_inv_lines_v arl
594: ,okl_strm_type_b sty
595: WHERE arl.id = cp_stream_id
596: AND arl.sty_id = sty.id;
597:

Line 603: FROM okl_bpd_ar_inv_lines_v

599: -- Source id of stream element of Late Invoice Cursor
600: ------------------------------------------------------------
601: cursor c_AR_source_sel(cp_contract_number varchar2, cp_trx_number varchar2) is
602: SELECT receivables_invoice_id
603: FROM okl_bpd_ar_inv_lines_v
604: WHERE contract_number = cp_contract_number
605: AND trx_number = cp_trx_number;
606: ---
607: --- END DECLARE