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_BTCH_EXP_LEASE_LOAN_PVT dependencies on OKL_TRX_CONTRACTS

Line 1128: FROM okl_trx_contracts trn

1124: -- Get contract termination transaction which is not PROCESSED or CANCELED ie ERROR
1125: CURSOR l_get_k_trn_csr (p_chr_id IN NUMBER) IS
1126: SELECT trn.tmt_status_code status
1127: --akrangan changes for sla tmt_status_code cr
1128: FROM okl_trx_contracts trn
1129: WHERE trn.khr_id = p_chr_id
1130: AND trn.tcn_type IN ('TMT', 'ALT')
1131: --rkuttiya added for 12.1.1 Multi GAAP
1132: AND trn.representation_type = 'PRIMARY'

Line 1335: FROM okl_trx_contracts

1331: tmt_generic_flag1_yn, -- RMUNJULU 2757312 Added
1332: tmt_generic_flag2_yn, -- RMUNJULU 2757312 Added
1333: tmt_generic_flag3_yn, -- RMUNJULU 2757312 Added
1334: qte_id
1335: FROM okl_trx_contracts
1336: WHERE khr_id = p_khr_id
1337: AND tcn_type IN ('TMT', 'ALT', 'EVG')
1338: --rkuttiya added for 12.1.1. Multi GAAP
1339: AND representation_type = 'PRIMARY'

Line 1472: FROM okl_trx_contracts trx

1468: trx.tmt_generic_flag1_yn, -- RMUNJULU 2757312 Added
1469: trx.tmt_generic_flag2_yn, -- RMUNJULU 2757312 Added
1470: trx.tmt_generic_flag3_yn, -- RMUNJULU 2757312 Added
1471: trx.qte_id
1472: FROM okl_trx_contracts trx
1473: WHERE trx.ID = p_trn_id;
1474:
1475: lp_tcnv_rec tcnv_rec_type;
1476: l_trn_exists VARCHAR2 (1) := 'N';

Line 1922: FROM okl_trx_contracts tcn

1918: AND khr.scs_code IN ('LEASE', 'LOAN')
1919: AND khr.ID NOT IN (
1920: -- Contracts which have unprocessed transactions
1921: SELECT NVL (tcn.khr_id, -9999) khr_id
1922: FROM okl_trx_contracts tcn
1923: WHERE NVL (tcn.tcn_type, '?') IN ('TMT', 'ALT', 'EVG')
1924: -- akrangan bug 5354501 fix added 'EVG'
1925: AND tcn.tmt_status_code NOT IN
1926: ('CANCELED', 'PROCESSED')

Line 1941: FROM okl_trx_contracts tcn

1937: AND NVL (qte.consolidated_yn, 'N') = 'N'
1938: AND qte.khr_id = khr.ID -- rmunjulu PERF
1939: AND qte.ID NOT IN (
1940: SELECT NVL (tcn.qte_id, -9999) qte_id
1941: FROM okl_trx_contracts tcn
1942: WHERE NVL (tcn.tcn_type, '?') IN
1943: ('TMT', 'ALT', 'EVG')
1944: --rkuttiya added for 12.1.1 Multi GAAP
1945: AND tcn.representation_type = 'PRIMARY'

Line 1965: FROM okc_k_headers_v k, okl_trx_contracts t

1961: CURSOR ter_cnt_recy_csr (p_sysdate IN DATE) IS
1962: SELECT k.ID,
1963: k.contract_number,
1964: t.ID trn_id -- RMUNJULU 17-NOV-02 Bug # 2484327 Added
1965: FROM okc_k_headers_v k, okl_trx_contracts t
1966: WHERE NVL (t.tmt_recycle_yn, '?') = 'Y'
1967: AND NVL (t.tmt_status_code, '?') NOT IN ('PROCESSED', 'CANCELED')
1968: --rkuttiya added for 12.1.1 Multi GAAP
1969: AND t.representation_type = 'PRIMARY'

Line 1994: FROM okl_trx_contracts tcn

1990: AND khr.scs_code IN ('LEASE', 'LOAN')
1991: AND khr.ID NOT IN (
1992: -- Contracts which have unprocessed transactions
1993: SELECT NVL (tcn.khr_id, -9999) khr_id
1994: FROM okl_trx_contracts tcn
1995: WHERE NVL (tcn.tcn_type, '?') IN ('TMT', 'ALT', 'EVG')
1996: -- akrangan bug 5354501 fix added 'EVG'
1997: AND tcn.tmt_status_code NOT IN
1998: ('CANCELED', 'PROCESSED')

Line 2012: FROM okl_trx_contracts tcn

2008: AND NVL (qte.consolidated_yn, 'N') = 'N'
2009: AND qte.khr_id = khr.ID -- rmunjulu PERF
2010: AND qte.ID NOT IN (
2011: SELECT NVL (tcn.qte_id, -9999) qte_id
2012: FROM okl_trx_contracts tcn
2013: WHERE NVL (tcn.tcn_type, '?') IN
2014: ('TMT', 'ALT', 'EVG')
2015: -- akrangan bug 5354501 fix added 'EVG'
2016: --rkuttiya added for 12.1.1. Multi GAAP

Line 2029: FROM okc_k_headers_v k, okl_trx_contracts t

2025: CURSOR recy_chr_csr (p_khr_id IN NUMBER, p_sysdate IN DATE) IS
2026: SELECT k.ID,
2027: k.contract_number,
2028: t.ID trn_id
2029: FROM okc_k_headers_v k, okl_trx_contracts t
2030: WHERE k.ID = p_khr_id
2031: AND NVL (t.tmt_recycle_yn, '?') = 'Y'
2032: AND NVL (t.tmt_status_code, '?') NOT IN ('PROCESSED', 'CANCELED')
2033: --akrangan changed for sla tmt_status_Code cr

Line 3699: FROM okl_trx_contracts tcn

3695: -- rmunjulu --start -- added the following or else same record picked twice
3696: AND khr.ID NOT IN (
3697: -- Contracts which have unprocessed transactions
3698: SELECT NVL (tcn.khr_id, -9999) khr_id
3699: FROM okl_trx_contracts tcn
3700: WHERE NVL (tcn.tcn_type, '?') IN
3701: ('TMT', 'ALT', 'EVG')
3702: -- akrangan bug 5354501 fix added 'EVG'
3703: AND tcn.tmt_status_code NOT IN

Line 3719: FROM okl_trx_contracts tcn

3715: AND NVL (qte.consolidated_yn, 'N') = 'N'
3716: AND qte.khr_id = khr.ID -- rmunjulu PERF
3717: AND qte.ID NOT IN (
3718: SELECT NVL (tcn.qte_id, -9999) qte_id
3719: FROM okl_trx_contracts tcn
3720: WHERE NVL (tcn.tcn_type, '?') IN
3721: ('TMT', 'ALT', 'EVG')
3722: -- akrangan bug 5354501 fix added 'EVG'
3723: --rkuttiya added for 12.1.1 Multi GAAP

Line 3733: FROM okc_k_headers_b k, okl_trx_contracts t

3729: UNION
3730: SELECT k.contract_number,
3731: k.ID khr_id,
3732: t.ID trx_id
3733: FROM okc_k_headers_b k, okl_trx_contracts t
3734: WHERE NVL (t.tmt_recycle_yn, '?') = 'Y'
3735: AND NVL (t.tmt_status_code, '?') NOT IN
3736: ('PROCESSED', 'CANCELED')
3737: --akrangan changed for sla tmt_status_Code cr

Line 3763: FROM OKL_TRX_CONTRACTS TCN

3759: WHERE opp.khr_id = KLE.dnz_chr_id
3760: AND KLE.sts_code = ('BOOKED')
3761: AND opp.khr_id NOT IN(
3762: SELECT NVL(TCN.khr_id,-9999) khr_id
3763: FROM OKL_TRX_CONTRACTS TCN
3764: WHERE NVL(TCN.tcn_type,'?') IN ('TMT','ALT','EVG') -- akrangan bug 5354501 fix added 'EVG'
3765: AND TCN.tmt_status_code NOT IN ('CANCELED','PROCESSED')--akrangan changed for sla tmt_status_Code cr
3766: AND TCN.khr_id = opp.khr_id)
3767: AND opp.khr_id NOT IN (

Line 3775: FROM OKL_TRX_CONTRACTS TCN

3771: AND NVL(QTE.consolidated_yn,'N') = 'N'
3772: AND QTE.khr_id = opp.khr_id
3773: AND QTE.id NOT IN (
3774: SELECT NVL(TCN.qte_id,-9999) qte_id
3775: FROM OKL_TRX_CONTRACTS TCN
3776: WHERE NVL(TCN.tcn_type,'?') IN ('TMT','ALT','EVG') -- akrangan bug 5354501 fix added 'EVG'
3777: AND TCN.qte_id = QTE.id))
3778: AND opp.object_type = 'CONT_TERM'
3779: AND opp.assigned_process = p_seq_next

Line 3784: OKL_TRX_CONTRACTS T,

3780: GROUP BY opp.object_value
3781: UNION
3782: SELECT opp.object_value contract_number, count(KLE.id) line_count
3783: FROM okl_parallel_processes opp,
3784: OKL_TRX_CONTRACTS T,
3785: OKC_K_LINES_B KLE
3786: WHERE NVL(T.tmt_recycle_yn,'?') = 'Y'
3787: AND opp.khr_id = KLE.dnz_chr_id
3788: AND KLE.sts_code = 'BOOKED'

Line 3802: FROM okl_trx_contracts_all tcn

3798: WHERE opp.khr_id = kle.dnz_chr_id
3799: AND kle.sts_code = ('BOOKED')
3800: AND opp.khr_id NOT IN (
3801: SELECT NVL (tcn.khr_id, -9999) khr_id
3802: FROM okl_trx_contracts_all tcn
3803: WHERE tcn.tcn_type IN ('TMT', 'ALT', 'EVG')
3804: -- akrangan bug 5354501 fix added 'EVG'
3805: AND tcn.tmt_status_code NOT IN
3806: ('CANCELED', 'PROCESSED')

Line 3820: FROM okl_trx_contracts_all tcn

3816: AND NVL (qte.consolidated_yn, 'N') = 'N'
3817: AND qte.khr_id = opp.khr_id
3818: AND qte.ID NOT IN (
3819: SELECT NVL (tcn.qte_id, -9999) qte_id
3820: FROM okl_trx_contracts_all tcn
3821: WHERE tcn.tcn_type IN ('TMT', 'ALT', 'EVG')
3822: -- akrangan bug 5354501 fix added 'EVG'
3823: --rkuttiya added for 12.1.1 Multi GAAP
3824: AND tcn.representation_type = 'PRIMARY'

Line 3834: okl_trx_contracts t,

3830: UNION
3831: SELECT opp.object_value contract_number,
3832: COUNT (kle.ID) line_count
3833: FROM okl_parallel_processes opp,
3834: okl_trx_contracts t,
3835: okc_k_lines_b kle
3836: WHERE NVL (t.tmt_recycle_yn, '?') = 'Y'
3837: AND opp.khr_id = kle.dnz_chr_id
3838: AND kle.sts_code = 'BOOKED'