[Home] [Help]
299: IS
300: SELECT LAP.CR_EXP_DAYS + TRUNC(LAST_UPDATED) APPR_EXP_DATE
301: FROM AR_CMGT_CASE_FOLDERS CCF
302: , AR_CMGT_CREDIT_REQUESTS CCR
303: , OKL_LEASE_APPLICATIONS_B LAP
304: WHERE CCR.CREDIT_REQUEST_ID = CCF.CREDIT_REQUEST_ID
305: AND CCR.SOURCE_COLUMN3 = 'LEASEAPP'
306: AND CCR.SOURCE_COLUMN1 = LAP.ID
307: AND CCF.STATUS = 'CLOSED'
584: l_query_stmt VARCHAR2(100);
585: TYPE l_csr_typ IS REF CURSOR;
586: l_ref_csr l_csr_typ;
587: CURSOR c_get_prefix(c_table_name IN VARCHAR2) IS
588: SELECT DECODE(c_table_name,'OKL_LEASE_QUOTES_B',LSEQTE_SEQ_PREFIX_TXT,'OKL_QUICK_QUOTES_B',QCKQTE_SEQ_PREFIX_TXT,'OKL_LEASE_OPPORTUNITIES_B',LSEOPP_SEQ_PREFIX_TXT,'OKL_LEASE_APPLICATIONS_B',LSEAPP_SEQ_PREFIX_TXT)
589: FROM okl_system_params;
590: l_prefix VARCHAR2(30);
591: l_value VARCHAR(250);
592: BEGIN
654: -- End of comments
655: PROCEDURE populate_ec_rec(
656: p_api_version IN NUMBER,
657: p_init_msg_list IN VARCHAR2,
658: p_lap_id IN OKL_LEASE_APPLICATIONS_B.ID%TYPE,
659: x_return_status OUT NOCOPY VARCHAR2,
660: x_msg_count OUT NOCOPY NUMBER,
661: x_msg_data OUT NOCOPY VARCHAR2,
662: lx_okl_ec_rec IN OUT NOCOPY OKL_ECC_PUB.okl_ec_rec_type)
674: SELECT VALID_FROM VALID_FROM
675: , PROSPECT_ID PROSPECT_ID
676: , CUST_ACCT_ID CUST_ACCT_ID
677: , CURRENCY_CODE CURRENCY_CODE
678: FROM OKL_LEASE_APPLICATIONS_B LAB
679: WHERE LAB.ID = cp_lse_app_id;
680: lse_app_dtls_rec lse_app_dtls_csr%ROWTYPE;
681:
682: --Cursor to obtain the details of lease quote line of Lease App
1009: p_init_msg_list IN VARCHAR2,
1010: x_return_status OUT NOCOPY VARCHAR2,
1011: x_msg_count OUT NOCOPY NUMBER,
1012: x_msg_data OUT NOCOPY VARCHAR2,
1013: p_lap_id IN OKL_LEASE_APPLICATIONS_B.ID%TYPE,
1014: x_lapv_rec OUT NOCOPY lapv_rec_type,
1015: x_lsqv_rec OUT NOCOPY lsqv_rec_type) IS
1016:
1017: -- Variables Declarations
1083: --asawanka bug 4721141 end
1084: --Added Bug 5647107 ssdeshpa start
1085: , LQ.LEGAL_ENTITY_ID LEGAL_ENTITY_ID
1086: --Added Bug 5647107 ssdeshpa start
1087: FROM OKL_LEASE_APPLICATIONS_B LAB
1088: , OKL_LEASE_APPLICATIONS_TL LAT
1089: , OKL_LEASE_QUOTES_B LQ
1090: WHERE LAB.ID = LAT.ID
1091: AND LAT.LANGUAGE = USERENV('LANG')
1462: -- End of comments
1463: PROCEDURE set_in_progress_status(
1464: p_api_version IN NUMBER,
1465: p_init_msg_list IN VARCHAR2,
1466: p_lap_id IN OKL_LEASE_APPLICATIONS_B.ID%TYPE,
1467: p_action IN VARCHAR2,
1468: x_return_status OUT NOCOPY VARCHAR2,
1469: x_msg_count OUT NOCOPY NUMBER,
1470: x_msg_data OUT NOCOPY VARCHAR2)
1648: -- End of comments
1649: PROCEDURE revert_to_orig_status(
1650: p_api_version IN NUMBER,
1651: p_init_msg_list IN VARCHAR2,
1652: p_lap_id IN OKL_LEASE_APPLICATIONS_B.ID%TYPE,
1653: x_return_status OUT NOCOPY VARCHAR2,
1654: x_msg_count OUT NOCOPY NUMBER,
1655: x_msg_data OUT NOCOPY VARCHAR2)
1656: IS
1667: --Cursor to obtain Parent Lease Application Details
1668: CURSOR lse_app_dtls_csr(cp_lse_app_id NUMBER) IS
1669: SELECT PLAB.ID PARENT_LSE_APP_ID
1670: , PLAB.APPLICATION_STATUS PARENT_LSE_APP_STS
1671: FROM OKL_LEASE_APPLICATIONS_B LAB
1672: , OKL_LEASE_APPLICATIONS_B PLAB
1673: WHERE LAB.ID = cp_lse_app_id
1674: AND PLAB.ID = LAB.PARENT_LEASEAPP_ID;
1675: lse_app_dtls_rec lse_app_dtls_csr%ROWTYPE;
1668: CURSOR lse_app_dtls_csr(cp_lse_app_id NUMBER) IS
1669: SELECT PLAB.ID PARENT_LSE_APP_ID
1670: , PLAB.APPLICATION_STATUS PARENT_LSE_APP_STS
1671: FROM OKL_LEASE_APPLICATIONS_B LAB
1672: , OKL_LEASE_APPLICATIONS_B PLAB
1673: WHERE LAB.ID = cp_lse_app_id
1674: AND PLAB.ID = LAB.PARENT_LEASEAPP_ID;
1675: lse_app_dtls_rec lse_app_dtls_csr%ROWTYPE;
1676: BEGIN
1911:
1912: --Cursor to compare the db values of lease app header with the one in rec
1913: CURSOR lap_db_val_csr(cp_lap_id NUMBER, cp_lapv_rec lapv_rec_type) IS
1914: SELECT LAP.REFERENCE_NUMBER REFERENCE_NUMBER
1915: FROM OKL_LEASE_APPLICATIONS_B LAP
1916: WHERE LAP.ID = cp_lap_id
1917: AND NVL(LAP.PROSPECT_ADDRESS_ID, OKL_API.G_MISS_NUM) = NVL(cp_lapv_rec.prospect_address_id, OKL_API.G_MISS_NUM)
1918: AND NVL(LAP.CUST_ACCT_ID, OKL_API.G_MISS_NUM) = NVL(cp_lapv_rec.cust_acct_id, OKL_API.G_MISS_NUM)
1919: AND NVL(LAP.MASTER_LEASE_ID, OKL_API.G_MISS_NUM) = NVL(cp_lapv_rec.master_lease_id, OKL_API.G_MISS_NUM)
2217: ,LAB.CUST_ACCT_ID CUST_ACCT_ID
2218: ,LAB.ORG_ID ORG_ID
2219: ,LAB.CREDIT_LINE_ID CREDIT_LINE_ID
2220: ,LSQ.ID LSQ_ID
2221: FROM OKL_LEASE_APPLICATIONS_B LAB
2222: ,OKL_LEASEAPP_TEMPLATES LAT
2223: ,OKL_LEASE_QUOTES_B LSQ
2224: ,OKL_LEASEAPP_TEMPL_VERSIONS_V LATV
2225: WHERE LATV.ID = LAB.LEASEAPP_TEMPLATE_ID
2486: IS
2487: SELECT LAP.ORG_ID ORG_ID
2488: , LAP.VALID_FROM VALID_FROM
2489: , LAP.VALID_TO VALID_TO
2490: FROM OKL_LEASE_APPLICATIONS_B LAP
2491: WHERE LAP.ID = cp_lap_id;
2492: lse_app_dtls_rec lse_app_dtls_csr%ROWTYPE;
2493:
2494: --Cursor to obtain Checklist Header Id and details
2844: -- Procedure Name : lease_app_cre
2845: -- Description : This procedure is a wrapper that creates records for
2846: -- : lease application.
2847: -- Business Rules : This procedure inserts records into the
2848: -- OKL_LEASE_APPLICATIONS_B and _TL table
2849: -- Parameters :
2850: -- Version : 1.0
2851: -- History : 20-MAY-2005 PAGARG created
2852: -- : 09 Feb 2006 PAGARG Bug 4960541 Added call to validations
2884: --Cursor to obtain Checklist Header Id
2885: CURSOR chk_hdr_dtls_csr(cp_lap_id NUMBER)
2886: IS
2887: SELECT LATV.CHECKLIST_ID
2888: FROM OKL_LEASE_APPLICATIONS_B LAP
2889: ,OKL_LEASEAPP_TEMPL_VERSIONS_V LATV
2890: WHERE LAP.LEASEAPP_TEMPLATE_ID = LATV.ID
2891: AND LAP.ID = cp_lap_id;
2892: chk_hdr_dtls_rec chk_hdr_dtls_csr%ROWTYPE;
3528: -- Procedure Name : lease_app_upd
3529: -- Description : This procedure is a wrapper that updates records for
3530: -- : lease application.
3531: -- Business Rules : This procedure updates records into the
3532: -- OKL_LEASE_APPLICATIONS_B and _TL table
3533: -- Parameters :
3534: -- Version : 1.0
3535: -- History : 20-MAY-2005 PAGARG created
3536: --
3578: --cursor to obtain lease app template id used on lease application
3579: CURSOR l_lse_app_tmplt_csr(p_lap_id NUMBER)
3580: IS
3581: SELECT leaseapp_template_id
3582: FROM okl_lease_applications_b LSQ
3583: WHERE ID = p_lap_id;
3584: l_lse_app_tmplt_csr_rec l_lse_app_tmplt_csr%ROWTYPE;
3585:
3586: --Cursor to obtain Checklist Header Id
4209: --Cursor to validate if there is any in process lease application sourced from
4210: --given Lease Quote
4211: CURSOR lap_lsq_uniq_csr(cp_lop_id NUMBER, p_lap_id NUMBER) IS
4212: SELECT REFERENCE_NUMBER
4213: FROM OKL_LEASE_APPLICATIONS_B
4214: --asawanka bug 4936130 changes start
4215: WHERE APPLICATION_STATUS NOT IN ('CR-APPROVED'
4216: ,'CR-REJECTED'
4217: ,'RECOM_NOT_APPROVED'
5403: --Cursor to obtain Checklist Header Id
5404: CURSOR chk_hdr_dtls_csr(cp_lap_id NUMBER)
5405: IS
5406: SELECT LATV.CHECKLIST_ID
5407: FROM OKL_LEASE_APPLICATIONS_B LAP
5408: ,OKL_LEASEAPP_TEMPL_VERSIONS_V LATV
5409: WHERE LAP.LEASEAPP_TEMPLATE_ID = LATV.ID
5410: AND LAP.ID = cp_lap_id;
5411: chk_hdr_dtls_rec chk_hdr_dtls_csr%ROWTYPE;
5414: CURSOR src_lse_app_dtls_csr(cp_lap_id NUMBER)
5415: IS
5416: SELECT LSQ.ID LSQ_ID
5417: FROM OKL_LEASE_QUOTES_B LSQ
5418: , OKL_LEASE_APPLICATIONS_B LAP
5419: WHERE LSQ.PARENT_OBJECT_ID = LAP.ID
5420: AND LSQ.PARENT_OBJECT_CODE = 'LEASEAPP'
5421: AND LSQ.PRIMARY_QUOTE = 'Y'
5422: AND LAP.ID = cp_lap_id;
6496:
6497: --Cursor to obtain Lease Application Details
6498: CURSOR lse_app_dtls_csr(p_lap_id NUMBER) IS
6499: SELECT LAB.REFERENCE_NUMBER
6500: FROM OKL_LEASE_APPLICATIONS_B LAB
6501: WHERE LAB.ID = p_lap_id;
6502: lse_app_dtls_rec lse_app_dtls_csr%ROWTYPE;
6503: BEGIN
6504: l_return_status := OKL_API.G_RET_STS_SUCCESS;
7537: SELECT LSQ.ID LSQ_ID
7538: , LAP.APPLICATION_STATUS LAP_STATUS
7539: , LAP.REFERENCE_NUMBER LAP_NUMBER
7540: FROM OKL_LEASE_QUOTES_B LSQ
7541: , OKL_LEASE_APPLICATIONS_B LAP
7542: WHERE LSQ.PARENT_OBJECT_ID = LAP.ID
7543: AND LSQ.PARENT_OBJECT_CODE = 'LEASEAPP'
7544: AND LSQ.PRIMARY_QUOTE = 'Y'
7545: AND LAP.ID = cp_lap_id;
7811: CURSOR lap_db_val_csr(cp_lap_id NUMBER) IS
7812: SELECT LAB.REFERENCE_NUMBER LEASE_APPL_NUMBER
7813: , LAB.APPLICATION_STATUS APPLICATION_STATUS
7814: , LAB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
7815: FROM OKL_LEASE_APPLICATIONS_B LAB
7816: WHERE LAB.ID = cp_lap_id;
7817: lap_db_val_rec lap_db_val_csr%ROWTYPE;
7818:
7819: BEGIN
8332: CURSOR chk_hdr_dtls_csr(cp_lap_id NUMBER)
8333: IS
8334: --changing the query for bug 5167776
8335: SELECT LATV.CHECKLIST_ID
8336: FROM OKL_LEASE_APPLICATIONS_B LAP
8337: ,OKL_LEASEAPP_TEMPL_VERSIONS_V LATV
8338: WHERE LAP.LEASEAPP_TEMPLATE_ID = LATV.ID
8339: AND LAP.ID = cp_lap_id;
8340: chk_hdr_dtls_rec chk_hdr_dtls_csr%ROWTYPE;
8344: IS
8345: SELECT LSQ.ID LSQ_ID
8346: , CRR.CREDIT_REQUEST_ID
8347: FROM OKL_LEASE_QUOTES_B LSQ
8348: , OKL_LEASE_APPLICATIONS_B LAP
8349: , AR_CMGT_CREDIT_REQUESTS CRR
8350: WHERE LSQ.PARENT_OBJECT_ID = LAP.ID
8351: AND LSQ.PARENT_OBJECT_CODE = 'LEASEAPP'
8352: AND LSQ.PRIMARY_QUOTE = 'Y'
8788: --Cursor to populate Lease Application details from database
8789: CURSOR lap_db_val_csr(cp_lap_id NUMBER) IS
8790: SELECT LAB.REFERENCE_NUMBER LEASE_APPL_NUMBER
8791: , LAB.APPLICATION_STATUS APPLICATION_STATUS
8792: FROM OKL_LEASE_APPLICATIONS_B LAB
8793: WHERE LAB.ID = cp_lap_id;
8794: lap_db_val_rec lap_db_val_csr%ROWTYPE;
8795: BEGIN
8796: l_return_status := OKL_API.G_RET_STS_SUCCESS;
9139: --Cursor to obtain Checklist Header Id
9140: CURSOR chk_hdr_dtls_csr(cp_lap_id NUMBER)
9141: IS
9142: SELECT CHK.ID CHECKLIST_ID
9143: FROM OKL_LEASE_APPLICATIONS_B LAP
9144: , OKL_CHECKLISTS CHK
9145: WHERE CHK.CHECKLIST_OBJ_TYPE_CODE = 'LEASE_APPL'
9146: AND CHK.CHECKLIST_OBJ_ID = LAP.ID
9147: AND LAP.ID = cp_lap_id;
9154: , CRR.CREDIT_REQUEST_ID
9155: , LAP.APPLICATION_STATUS
9156: , LAP.APPLICATION_STATUS APPEAL_SCOPE
9157: FROM OKL_LEASE_QUOTES_B LSQ
9158: , OKL_LEASE_APPLICATIONS_B LAP
9159: , AR_CMGT_CREDIT_REQUESTS CRR
9160: WHERE LSQ.PARENT_OBJECT_ID = LAP.ID
9161: AND LSQ.PARENT_OBJECT_CODE = 'LEASEAPP'
9162: AND LSQ.PRIMARY_QUOTE = 'Y'
9604: IS
9605: SELECT ID
9606: , REFERENCE_NUMBER
9607: , APPLICATION_STATUS
9608: FROM OKL_LEASE_APPLICATIONS_B
9609: WHERE ID <> cp_lap_id
9610: CONNECT BY PARENT_LEASEAPP_ID = PRIOR ID
9611: START WITH ID = cp_lap_id;
9612: child_lse_app_rec child_lse_app_csr%ROWTYPE;
9615: IS
9616: SELECT ID
9617: , REFERENCE_NUMBER
9618: , APPLICATION_STATUS
9619: FROM OKL_LEASE_APPLICATIONS_B
9620: WHERE ID <> cp_lap_id
9621: CONNECT BY PRIOR PARENT_LEASEAPP_ID = ID
9622: START WITH ID = cp_lap_id;
9623: parent_lse_app_rec parent_lse_app_csr%ROWTYPE;
9660:
9661: --Cursor to obtain Lease Application Details
9662: CURSOR lse_app_dtls_csr(p_lap_id NUMBER) IS
9663: SELECT LAB.REFERENCE_NUMBER
9664: FROM OKL_LEASE_APPLICATIONS_B LAB
9665: WHERE LAB.ID = p_lap_id;
9666: lse_app_dtls_rec lse_app_dtls_csr%ROWTYPE;
9667: BEGIN
9668: l_return_status := OKL_API.G_RET_STS_SUCCESS;
9990: -- End of comments
9991: PROCEDURE lease_app_qa_val(
9992: p_api_version IN NUMBER,
9993: p_init_msg_list IN VARCHAR2,
9994: p_lap_id IN OKL_LEASE_APPLICATIONS_B.ID%TYPE,
9995: x_return_status OUT NOCOPY VARCHAR2,
9996: x_msg_count OUT NOCOPY NUMBER,
9997: x_msg_data OUT NOCOPY VARCHAR2,
9998: x_qa_result OUT NOCOPY VARCHAR2)
10120: -- End of comments
10121: PROCEDURE lease_app_price(
10122: p_api_version IN NUMBER,
10123: p_init_msg_list IN VARCHAR2,
10124: p_lap_id IN OKL_LEASE_APPLICATIONS_B.ID%TYPE,
10125: x_return_status OUT NOCOPY VARCHAR2,
10126: x_msg_count OUT NOCOPY NUMBER,
10127: x_msg_data OUT NOCOPY VARCHAR2)
10128: IS
10345: -- End of comments
10346: PROCEDURE set_lease_app_status(
10347: p_api_version IN NUMBER,
10348: p_init_msg_list IN VARCHAR2,
10349: p_lap_id IN OKL_LEASE_APPLICATIONS_B.ID%TYPE,
10350: p_lap_status IN VARCHAR2,
10351: x_return_status OUT NOCOPY VARCHAR2,
10352: x_msg_count OUT NOCOPY NUMBER,
10353: x_msg_data OUT NOCOPY VARCHAR2)
10524: -- End of comments
10525: PROCEDURE set_lease_app_expdays(
10526: p_api_version IN NUMBER,
10527: p_init_msg_list IN VARCHAR2,
10528: p_lap_id IN OKL_LEASE_APPLICATIONS_B.ID%TYPE,
10529: p_lap_expdays IN NUMBER,
10530: x_return_status OUT NOCOPY VARCHAR2,
10531: x_msg_count OUT NOCOPY NUMBER,
10532: x_msg_data OUT NOCOPY VARCHAR2)
10850: -- End of comments
10851: PROCEDURE lease_app_unaccept(
10852: p_api_version IN NUMBER,
10853: p_init_msg_list IN VARCHAR2,
10854: p_lap_id IN OKL_LEASE_APPLICATIONS_B.ID%TYPE,
10855: x_return_status OUT NOCOPY VARCHAR2,
10856: x_msg_count OUT NOCOPY NUMBER,
10857: x_msg_data OUT NOCOPY VARCHAR2)
10858: IS
10868: --Cursor to obtain Lease Application Details
10869: CURSOR lse_app_dtls_csr(p_lse_app_id NUMBER)
10870: IS
10871: SELECT REFERENCE_NUMBER
10872: FROM OKL_LEASE_APPLICATIONS_B LAB
10873: WHERE LAB.ID = p_lse_app_id;
10874: lse_app_dtls_rec lse_app_dtls_csr%ROWTYPE;
10875: BEGIN
10876: l_return_status := OKL_API.G_RET_STS_SUCCESS;
11103: -- End of comments
11104: PROCEDURE create_contract(
11105: p_api_version IN NUMBER,
11106: p_init_msg_list IN VARCHAR2,
11107: p_lap_id IN OKL_LEASE_APPLICATIONS_B.ID%TYPE,
11108: x_return_status OUT NOCOPY VARCHAR2,
11109: x_msg_count OUT NOCOPY NUMBER,
11110: x_msg_data OUT NOCOPY VARCHAR2,
11111: x_chr_id OUT NOCOPY NUMBER,
11120: CURSOR l_lap_dtls_csr(p_lap_id NUMBER)
11121: IS
11122: SELECT LAB.REFERENCE_NUMBER REFERENCE_NUMBER
11123: , LAB.LEASE_OPPORTUNITY_ID LEASE_OPPORTUNITY_ID
11124: FROM OKL_LEASE_APPLICATIONS_B LAB
11125: WHERE LAB.ID = p_lap_id;
11126: l_lap_dtls_rec l_lap_dtls_csr%ROWTYPE;
11127:
11128: BEGIN
11265: -- End of comments
11266: PROCEDURE appeal_recommendations(
11267: p_api_version IN NUMBER,
11268: p_init_msg_list IN VARCHAR2,
11269: p_lap_id IN OKL_LEASE_APPLICATIONS_B.ID%TYPE,
11270: p_cr_dec_apl_flag IN VARCHAR2,
11271: p_exp_date_apl_flag IN VARCHAR2,
11272: p_cr_conds IN NAME_VAL_TBL_TYPE,
11273: p_addl_rcmnds IN NAME_VAL_TBL_TYPE,
11322: , CCR.CREDIT_CLASSIFICATION
11323: , CCR.CUST_ACCOUNT_ID
11324: , LAB.PARENT_LEASEAPP_ID PARENT_LEASEAPP_ID
11325: FROM AR_CMGT_CREDIT_REQUESTS CCR
11326: , OKL_LEASE_APPLICATIONS_B LAB
11327: WHERE SOURCE_COLUMN3 = 'LEASEAPP'
11328: AND SOURCE_COLUMN1 = LAB.PARENT_LEASEAPP_ID
11329: AND LAB.ID = cp_lap_id;
11330: crd_app_data_rec crd_app_data_csr%ROWTYPE;
11659: -- End of comments
11660: PROCEDURE create_contract_val(
11661: p_api_version IN NUMBER,
11662: p_init_msg_list IN VARCHAR2,
11663: p_lap_id IN OKL_LEASE_APPLICATIONS_B.ID%TYPE,
11664: x_return_status OUT NOCOPY VARCHAR2,
11665: x_msg_count OUT NOCOPY NUMBER,
11666: x_msg_data OUT NOCOPY VARCHAR2)
11667: IS
11674: CURSOR l_lap_dtls_csr(p_lap_id NUMBER)
11675: IS
11676: SELECT LAB.REFERENCE_NUMBER REFERENCE_NUMBER
11677: , LAB.LEASE_OPPORTUNITY_ID LEASE_OPPORTUNITY_ID
11678: FROM OKL_LEASE_APPLICATIONS_B LAB
11679: WHERE LAB.ID = p_lap_id;
11680: l_lap_dtls_rec l_lap_dtls_csr%ROWTYPE;
11681:
11682: --Cursor to check if contract already created from lease opp linked to lease app
11685: IS
11686: SELECT LAB.REFERENCE_NUMBER LSE_APP
11687: , LOP.REFERENCE_NUMBER LSE_OPP
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
11686: SELECT LAB.REFERENCE_NUMBER LSE_APP
11687: , LOP.REFERENCE_NUMBER LSE_OPP
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
11709: SELECT LSQ.REFERENCE_NUMBER LSE_QTE
11710: , LOP.REFERENCE_NUMBER LSE_OPP
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