APPS.OKS_ARFETCH_PUB dependencies on RA_CUSTOMER_TRX_LINES

Line 165: ,RA_CUSTOMER_TRX_LINES RALINES

161: ,ratypes.type
162: ,rahdr.trx_date
163: From oks_bill_transactions btn
164: ,oks_bill_txn_lines btxnl
165: ,RA_CUSTOMER_TRX_LINES RALINES
166: ,okc_k_headers_all_b hdr
167: ,RA_CUSTOMER_TRX_ALL RAHDR
168: ,RA_CUST_TRX_TYPES_ALL RATYPES
169: Where btxnl.btn_id = btn.id

Line 204: FROM RA_CUSTOMER_TRX_LINES_ALL CTL

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