APPS.OKS_ARFETCH_PUB dependencies on RA_CUSTOMER_TRX_LINES

Line 161: ,RA_CUSTOMER_TRX_LINES RALINES

157: ,ratypes.type
158: ,rahdr.trx_date
159: From oks_bill_transactions btn
160: ,oks_bill_txn_lines btxnl
161: ,RA_CUSTOMER_TRX_LINES RALINES
162: ,okc_k_headers_all_b hdr
163: ,RA_CUSTOMER_TRX_ALL RAHDR
164: ,RA_CUST_TRX_TYPES_ALL RATYPES
165: Where btxnl.btn_id = btn.id

Line 200: FROM RA_CUSTOMER_TRX_LINES_ALL CTL

196: WHERE bill_instance_number = p_bill_instance_num;
197:
198: CURSOR l_ra_tax_csr(p_id NUMBER) IS
199: SELECT nvl(sum(ctl.extended_amount),0 )
200: FROM RA_CUSTOMER_TRX_LINES_ALL CTL
201: WHERE CTL.LINK_TO_CUST_TRX_LINE_ID = p_id
202: AND CTL.line_type = 'TAX';
203:
204: