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 OKC_K_HEADERS_B

Line 4154: FROM OKC_K_HEADERS_B CHR

4150: , CHR.STS_CODE
4151: , PSTS.STE_CODE
4152: , CHR.START_DATE START_DATE
4153: , CHR.END_DATE END_DATE
4154: FROM OKC_K_HEADERS_B CHR
4155: , OKC_STATUSES_V PSTS
4156: WHERE CHR.SCS_CODE = 'PROGRAM'
4157: AND CHR.STS_CODE = PSTS.CODE
4158: AND CHR.ID = cp_pgm_agr_id;

Line 4178: FROM OKC_K_HEADERS_B PGM

4174: --Cursor for Lease Application Template and Vendor Program Association validation
4175: --Bug abhsaxen 5158188 for validation of VPA is having any LAT
4176: CURSOR lat_pgm_exist_csr(cp_pgm_agr_id NUMBER) IS
4177: SELECT 'X'
4178: FROM OKC_K_HEADERS_B PGM
4179: , OKL_VP_ASSOCIATIONS_V VPA
4180: , OKL_LEASEAPP_TEMPLATES LAT
4181: , OKL_LEASEAPP_TEMPL_VERSIONS_B LATV
4182: WHERE VPA.CHR_ID = PGM.ID

Line 4194: FROM OKC_K_HEADERS_B PGM

4190: lat_pgm_exist_rec lat_pgm_exist_csr%ROWTYPE;
4191: --Bug 4873205 PAGARG modified the query to validate validation
4192: CURSOR lat_pgm_val_csr(cp_pgm_agr_id NUMBER, cp_latv_id NUMBER) IS
4193: SELECT 'X'
4194: FROM OKC_K_HEADERS_B PGM
4195: , OKL_VP_ASSOCIATIONS_V VPA
4196: , OKL_LEASEAPP_TEMPLATES LAT
4197: , OKL_LEASEAPP_TEMPL_VERSIONS_B LATV
4198: WHERE VPA.CHR_ID = PGM.ID

Line 4248: FROM OKC_K_HEADERS_B CHR

4244: --Validate Contract Template Cursor
4245: CURSOR contract_tmpl_val_csr(p_latv_id NUMBER, p_valid_from DATE)
4246: IS
4247: SELECT CHR.CONTRACT_NUMBER TEMPLATE_NUMBER
4248: FROM OKC_K_HEADERS_B CHR
4249: , OKL_LEASEAPP_TEMPL_VERSIONS_V LATV
4250: , OKL_LEASEAPP_TEMPLATES LAT
4251: , OKL_K_HEADERS KHR
4252: , OKC_STATUSES_V STS

Line 7042: FROM OKC_K_HEADERS_B CHR

7038:
7039: --Cursor to obtain Program Agreement Details
7040: CURSOR pgm_agr_dtls_csr(cp_pgm_agr_id NUMBER) IS
7041: SELECT CONTRACT_NUMBER PROGRAM_AGREEMENT
7042: FROM OKC_K_HEADERS_B CHR
7043: WHERE CHR.ID = cp_pgm_agr_id
7044: AND CHR.SCS_CODE = 'PROGRAM';
7045: pgm_agr_dtls_rec pgm_agr_dtls_csr%ROWTYPE;
7046:

Line 9653: FROM OKC_K_HEADERS_B CHR

9649: --Cursor to Obtain Contract Number created from given lease app
9650: CURSOR contract_dtls_csr(p_lap_id NUMBER)
9651: IS
9652: SELECT CHR.CONTRACT_NUMBER CONTRACT_NUMBER
9653: FROM OKC_K_HEADERS_B CHR
9654: , OKC_STATUSES_V CSTS
9655: WHERE CHR.ORIG_SYSTEM_SOURCE_CODE = 'OKL_LEASE_APP'
9656: AND CHR.STS_CODE = CSTS.CODE
9657: AND CSTS.STE_CODE <> 'CANCELLED'

Line 11692: , OKC_K_HEADERS_B CHR

11688: , CHR.CONTRACT_NUMBER CONTRACT_NUMBER
11689: FROM OKL_LEASE_APPLICATIONS_B LAB
11690: , OKL_LEASE_APPLICATIONS_B CLAB
11691: , OKL_LEASE_OPPORTUNITIES_B LOP
11692: , OKC_K_HEADERS_B CHR
11693: , OKC_STATUSES_V CSTS
11694: WHERE LAB.LEASE_OPPORTUNITY_ID = CLAB.LEASE_OPPORTUNITY_ID
11695: AND LOP.ID = LAB.LEASE_OPPORTUNITY_ID
11696: AND LAB.ID <> CLAB.ID

Line 11715: , OKC_K_HEADERS_B CHR

11711: , CHR.CONTRACT_NUMBER CONTRACT_NUMBER
11712: FROM OKL_LEASE_QUOTES_B LSQ
11713: , OKL_LEASE_APPLICATIONS_B CLAB
11714: , OKL_LEASE_OPPORTUNITIES_B LOP
11715: , OKC_K_HEADERS_B CHR
11716: , OKC_STATUSES_V CSTS
11717: WHERE LOP.ID = CLAB.LEASE_OPPORTUNITY_ID
11718: AND CHR.ORIG_SYSTEM_ID1 = LOP.ID
11719: AND CHR.ORIG_SYSTEM_SOURCE_CODE = 'OKL_QUOTE'