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_SPLIT_CONTRACT_PVT dependencies on OKL_TRX_TYPES_TL

Line 1602: okl_trx_types_tl try,

1598: -- To get status of splited transaction Chr id
1599: CURSOR get_trx_id(p_org_sys_id OKC_K_HEADERS_B.ORIG_SYSTEM_ID1%TYPE) IS
1600: SELECT trx.id trx_id
1601: FROM okl_trx_contracts trx,
1602: okl_trx_types_tl try,
1603: okc_k_headers_b CHR
1604: WHERE try.name = 'Split Contract'
1605: AND try.LANGUAGE = 'US'
1606: AND trx.try_id = try.id

Line 1910: okl_trx_types_tl try

1906: -- To get the transaction created for the contract.
1907: CURSOR c_get_trx_id(p_chr_id OKC_K_HEADERS_B.ORIG_SYSTEM_ID1%TYPE) IS
1908: SELECT trx.id trx_id
1909: FROM okl_trx_contracts trx,
1910: okl_trx_types_tl try
1911: WHERE try.name = 'Split Contract'
1912: AND try.LANGUAGE = 'US'
1913: AND trx.try_id = try.id
1914: AND trx.tsu_code IN ('ENTERED','WORKING','WAITING','SUBMITTED')

Line 3336: okl_trx_types_tl try,

3332: SELECT 1
3333: FROM dual
3334: WHERE EXISTS (SELECT 1
3335: FROM okl_trx_contracts trx,
3336: okl_trx_types_tl try,
3337: okl_k_headers khr
3338: WHERE try.name = 'Split Contract'
3339: AND try.LANGUAGE = 'US'
3340: AND trx.try_id = try.id

Line 3361: okl_trx_types_tl try,

3357: SELECT CHR.id chr_id,
3358: sts_code sts_code,
3359: trx.id trx_id
3360: FROM okl_trx_contracts trx,
3361: okl_trx_types_tl try,
3362: okc_k_headers_b CHR
3363: WHERE try.name = 'Split Contract'
3364: AND try.LANGUAGE = 'US'
3365: AND trx.try_id = try.id