DBA Data[Home] [Help]

APPS.OKL_BPD_TERMINATION_ADJ_PVT dependencies on OKL_TXL_AP_INV_LNS_V

Line 85: -- okl_txl_ap_inv_lns_v instead of okl_trx_ap_invoices_v

81: FROM okl_k_headers khr
82: WHERE khr.id = p_khr_id;
83:
84: -- sjalasut, modified the below cursor to have khr_id be picked up from
85: -- okl_txl_ap_inv_lns_v instead of okl_trx_ap_invoices_v
86: -- changes made as part of OKLR12B disbursements project.
87: CURSOR l_ap_inv_csr(cp_sel_id IN NUMBER) IS
88: select tap.id tap_id
89: ,tap.nettable_yn

Line 127: , okl_txl_ap_inv_lns_v tpl

123: -- 02-NOV-2006 ANSETHUR R12B - Legal Entity
124: ,tap.legal_entity_id
125: from -- okl_cnsld_ar_strms_v lsm -- rmunjulu R12 Billing Fixes: commented
126: okl_trx_ap_invoices_v tap
127: , okl_txl_ap_inv_lns_v tpl
128: , okl_txd_ar_ln_dtls_b tld -- rmunjulu R12 Billing Fixes: added
129: where tap.id = tpl.tap_id
130: -- and tpl.lsm_id = lsm.id -- rmunjulu R12 Billing Fixes: commented
131: and tpl.tld_id = tld.id -- rmunjulu R12 Billing Fixes: added