eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_CS_LC_CONTRACT_PVT dependencies on RA_CUSTOMER_TRX_ALL

Line 323: select distinct b.customer_trx_id from ra_customer_trx_all b, ra_customer_trx_lines_all a

319: ar.cash_receipt_id = app.cash_receipt_id
320: AND ar.pay_from_customer = p_customer_id
321: AND customer_trx_id in
322: (
323: select distinct b.customer_trx_id from ra_customer_trx_all b, ra_customer_trx_lines_all a
324: where a.interface_line_attribute6=(select contract_number from okc_k_headers_b where id=p_contract_id)
325: and a.customer_trx_id=b.customer_trx_id
326: )
327: ORDER BY receipt_date DESC; */

Line 341: from ra_customer_trx_all b, ra_customer_trx_lines_all a

337: AND exists
338: (
339: select 'x' --distinct b.customer_trx_id
340: --select distinct b.customer_trx_id
341: from ra_customer_trx_all b, ra_customer_trx_lines_all a
342: where a.interface_line_attribute6=(select contract_number from okc_k_headers_all_b where id=p_contract_id)
343: and a.customer_trx_id=b.customer_trx_id
344: and a.customer_trx_id = app.customer_trx_id
345: )

Line 1960: RA_CUSTOMER_TRX_ALL RACTRX,

1956:
1957: /* CURSOR c_get_total_adjusted(cp_khr_id IN NUMBER) IS
1958: SELECT SUM(NVL(APS.AMOUNT_ADJUSTED,0)) AMOUNT_ADJUSTED
1959: FROM AR_PAYMENT_SCHEDULES_ALL APS,
1960: RA_CUSTOMER_TRX_ALL RACTRX,
1961: RA_CUSTOMER_TRX_LINES_ALL RACTRX_LINE,
1962: OKC_K_HEADERS_B OKC
1963: WHERE RACTRX.CUSTOMER_TRX_ID = APS.CUSTOMER_TRX_ID
1964: AND RACTRX.CUSTOMER_TRX_ID = RACTRX_LINE.CUSTOMER_TRX_ID