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_LEASE_APP_PVT dependencies on OKL_LEASEAPP_TEMPLATES

Line 2264: ,OKL_LEASEAPP_TEMPLATES LAT

2260: ,LAB.ORG_ID ORG_ID
2261: ,LAB.CREDIT_LINE_ID CREDIT_LINE_ID
2262: ,LSQ.ID LSQ_ID
2263: FROM OKL_LEASE_APPLICATIONS_B LAB
2264: ,OKL_LEASEAPP_TEMPLATES LAT
2265: ,OKL_LEASE_QUOTES_B LSQ
2266: ,OKL_LEASEAPP_TEMPL_VERSIONS_V LATV
2267: WHERE LATV.ID = LAB.LEASEAPP_TEMPLATE_ID
2268: AND LAT.ID = LATV.LEASEAPP_TEMPLATE_ID

Line 3681: ,OKL_LEASEAPP_TEMPLATES LAT

3677: SELECT LATV.CHECKLIST_ID
3678: ,LAT.CREDIT_REVIEW_PURPOSE
3679: ,LAT.CUST_CREDIT_CLASSIFICATION
3680: FROM OKL_LEASEAPP_TEMPL_VERSIONS_V LATV
3681: ,OKL_LEASEAPP_TEMPLATES LAT
3682: WHERE LATV.LEASEAPP_TEMPLATE_ID = LAT.ID
3683: AND LATV.ID = cp_latv_id;
3684: chk_hdr_dtls_rec chk_hdr_dtls_csr%ROWTYPE;
3685:

Line 4225: FROM OKL_LEASEAPP_TEMPLATES LAT

4221:
4222: --Cursor for Lease Application Template details
4223: CURSOR lat_dtls_csr(cp_tmpl_id NUMBER, cp_valid_from DATE) IS
4224: SELECT LAT.NAME LEASEAPP_TMPL_NAME
4225: FROM OKL_LEASEAPP_TEMPLATES LAT
4226: ,OKL_LEASEAPP_TEMPL_VERSIONS_V LATV
4227: WHERE (LATV.VERSION_STATUS <> 'ACTIVE' OR
4228: LATV.VALID_FROM > cp_valid_from OR
4229: NVL(LATV.VALID_TO, TO_DATE('31-12-9999', 'dd-mm-yyyy')) < cp_valid_from)

Line 4268: , OKL_LEASEAPP_TEMPLATES LAT

4264: CURSOR lat_pgm_exist_csr(cp_pgm_agr_id NUMBER) IS
4265: SELECT 'X'
4266: FROM OKC_K_HEADERS_B PGM
4267: , OKL_VP_ASSOCIATIONS_V VPA
4268: , OKL_LEASEAPP_TEMPLATES LAT
4269: , OKL_LEASEAPP_TEMPL_VERSIONS_B LATV
4270: WHERE VPA.CHR_ID = PGM.ID
4271: AND VPA.CRS_ID IS NULL
4272: AND VPA.ASSOC_OBJECT_TYPE_CODE = 'LA_TEMPLATE'

Line 4284: , OKL_LEASEAPP_TEMPLATES LAT

4280: CURSOR lat_pgm_val_csr(cp_pgm_agr_id NUMBER, cp_latv_id NUMBER) IS
4281: SELECT 'X'
4282: FROM OKC_K_HEADERS_B PGM
4283: , OKL_VP_ASSOCIATIONS_V VPA
4284: , OKL_LEASEAPP_TEMPLATES LAT
4285: , OKL_LEASEAPP_TEMPL_VERSIONS_B LATV
4286: WHERE VPA.CHR_ID = PGM.ID
4287: AND VPA.CRS_ID IS NULL
4288: AND VPA.ASSOC_OBJECT_TYPE_CODE = 'LA_TEMPLATE'

Line 4322: , OKL_LEASEAPP_TEMPLATES LAT

4318: IS
4319: SELECT CHECKLIST_NUMBER TEMPLATE_NUMBER
4320: FROM OKL_CHECKLISTS CHK
4321: , OKL_LEASEAPP_TEMPL_VERSIONS_V LATV
4322: , OKL_LEASEAPP_TEMPLATES LAT
4323: WHERE LATV.CHECKLIST_ID = CHK.ID
4324: AND LATV.LEASEAPP_TEMPLATE_ID = LAT.ID
4325: AND ( (p_valid_from NOT BETWEEN NVL(CHK.START_DATE, p_valid_from)
4326: AND NVL(CHK.END_DATE, p_valid_from))

Line 4338: , OKL_LEASEAPP_TEMPLATES LAT

4334: IS
4335: SELECT CHR.CONTRACT_NUMBER TEMPLATE_NUMBER
4336: FROM OKC_K_HEADERS_B CHR
4337: , OKL_LEASEAPP_TEMPL_VERSIONS_V LATV
4338: , OKL_LEASEAPP_TEMPLATES LAT
4339: , OKL_K_HEADERS KHR
4340: , OKC_STATUSES_V STS
4341: WHERE LATV.CONTRACT_TEMPLATE_ID = CHR.ID
4342: AND LATV.LEASEAPP_TEMPLATE_ID = LAT.ID

Line 7369: FROM OKL_LEASEAPP_TEMPLATES LAT

7365:
7366: --Cursor to obtain Lease Application Template Details
7367: CURSOR lat_dtls_csr(cp_lat_id NUMBER) IS
7368: SELECT LAT.NAME LAT_NUMBER
7369: FROM OKL_LEASEAPP_TEMPLATES LAT
7370: ,OKL_LEASEAPP_TEMPL_VERSIONS_V LATV
7371: WHERE LATV.LEASEAPP_TEMPLATE_ID = LAT.ID
7372: AND LATV.ID = cp_lat_id;
7373: lat_dtls_rec lat_dtls_csr%ROWTYPE;