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_AM_BAL_WRITEOFF_PVT dependencies on OKL_TRX_AR_ADJSTS_V

Line 550: FROM OKL_TRX_AR_ADJSTS_V BAL,

546:
547: -- Check if close balances already done thru termination
548: CURSOR get_termination_trn_csr (p_khr_id IN NUMBER) IS
549: SELECT TRN.id
550: FROM OKL_TRX_AR_ADJSTS_V BAL,
551: OKL_TRX_CONTRACTS TRN
552: WHERE TRN.khr_id = p_khr_id
553: AND TRN.tcn_type = 'TMT'
554: AND BAL.tcn_id = TRN.id;

Line 1921: FROM OKL_TRX_AR_ADJSTS_V BAL,

1917: AND CHR.sts_code IN ('TERMINATED','EXPIRED') -- TERMINATED/EXPIRED
1918: AND trunc(CHR.date_terminated) <= TRUNC(p_date) -- Ended
1919: AND CHR.id NOT IN (-- balance writeoffs already done when contract was fully terminated
1920: SELECT TRN.khr_id
1921: FROM OKL_TRX_AR_ADJSTS_V BAL,
1922: OKL_TRX_CONTRACTS TRN
1923: WHERE BAL.tcn_id = TRN.id
1924: AND TRN.tcn_type = 'TMT' -- full termination
1925: AND TRN.khr_id = CHR.id