[Home] [Help]
168: -- Version : 1.0
169: -- History : 24-Apr-2009 nikshah created Bug 7140398
170: --
171: -- End of comments
172: FUNCTION is_primary_quote_declined(p_lap_id IN OKL_LEASE_APPLICATIONS_B.ID%TYPE)
173: RETURN BOOLEAN
174: IS
175: is_primary_declined BOOLEAN := FALSE;
176: l_flag NUMBER;
176: l_flag NUMBER;
177: -- Cursor to check if primary quote on the lease app is credit declined
178: CURSOR get_primary_quote_declined IS
179: SELECT 1
180: FROM OKL_LEASE_APPLICATIONS_B LAP
181: , OKL_LEASE_QUOTES_B LSQ
182: WHERE LAP.ID = p_lap_id
183: AND LSQ.PARENT_OBJECT_CODE = 'LEASEAPP'
184: AND LSQ.PARENT_OBJECT_ID = LAP.ID
341: IS
342: SELECT LAP.CR_EXP_DAYS + TRUNC(LAST_UPDATED) APPR_EXP_DATE
343: FROM AR_CMGT_CASE_FOLDERS CCF
344: , AR_CMGT_CREDIT_REQUESTS CCR
345: , OKL_LEASE_APPLICATIONS_B LAP
346: WHERE CCR.CREDIT_REQUEST_ID = CCF.CREDIT_REQUEST_ID
347: AND CCR.SOURCE_COLUMN3 = 'LEASEAPP'
348: AND CCR.SOURCE_COLUMN1 = LAP.ID
349: AND CCF.STATUS = 'CLOSED'
626: l_query_stmt VARCHAR2(100);
627: TYPE l_csr_typ IS REF CURSOR;
628: l_ref_csr l_csr_typ;
629: CURSOR c_get_prefix(c_table_name IN VARCHAR2) IS
630: 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)
631: FROM okl_system_params;
632: l_prefix VARCHAR2(30);
633: l_value VARCHAR(250);
634: BEGIN
696: -- End of comments
697: PROCEDURE populate_ec_rec(
698: p_api_version IN NUMBER,
699: p_init_msg_list IN VARCHAR2,
700: p_lap_id IN OKL_LEASE_APPLICATIONS_B.ID%TYPE,
701: x_return_status OUT NOCOPY VARCHAR2,
702: x_msg_count OUT NOCOPY NUMBER,
703: x_msg_data OUT NOCOPY VARCHAR2,
704: lx_okl_ec_rec IN OUT NOCOPY OKL_ECC_PUB.okl_ec_rec_type)
716: SELECT VALID_FROM VALID_FROM
717: , PROSPECT_ID PROSPECT_ID
718: , CUST_ACCT_ID CUST_ACCT_ID
719: , CURRENCY_CODE CURRENCY_CODE
720: FROM OKL_LEASE_APPLICATIONS_B LAB
721: WHERE LAB.ID = cp_lse_app_id;
722: lse_app_dtls_rec lse_app_dtls_csr%ROWTYPE;
723:
724: --Cursor to obtain the details of lease quote line of Lease App
1051: p_init_msg_list IN VARCHAR2,
1052: x_return_status OUT NOCOPY VARCHAR2,
1053: x_msg_count OUT NOCOPY NUMBER,
1054: x_msg_data OUT NOCOPY VARCHAR2,
1055: p_lap_id IN OKL_LEASE_APPLICATIONS_B.ID%TYPE,
1056: x_lapv_rec OUT NOCOPY lapv_rec_type,
1057: x_lsqv_rec OUT NOCOPY lsqv_rec_type) IS
1058:
1059: -- Variables Declarations
1125: --asawanka bug 4721141 end
1126: --Added Bug 5647107 ssdeshpa start
1127: , LQ.LEGAL_ENTITY_ID LEGAL_ENTITY_ID
1128: --Added Bug 5647107 ssdeshpa start
1129: FROM OKL_LEASE_APPLICATIONS_B LAB
1130: , OKL_LEASE_APPLICATIONS_TL LAT
1131: , OKL_LEASE_QUOTES_B LQ
1132: WHERE LAB.ID = LAT.ID
1133: AND LAT.LANGUAGE = USERENV('LANG')
1504: -- End of comments
1505: PROCEDURE set_in_progress_status(
1506: p_api_version IN NUMBER,
1507: p_init_msg_list IN VARCHAR2,
1508: p_lap_id IN OKL_LEASE_APPLICATIONS_B.ID%TYPE,
1509: p_action IN VARCHAR2,
1510: x_return_status OUT NOCOPY VARCHAR2,
1511: x_msg_count OUT NOCOPY NUMBER,
1512: x_msg_data OUT NOCOPY VARCHAR2)
1690: -- End of comments
1691: PROCEDURE revert_to_orig_status(
1692: p_api_version IN NUMBER,
1693: p_init_msg_list IN VARCHAR2,
1694: p_lap_id IN OKL_LEASE_APPLICATIONS_B.ID%TYPE,
1695: x_return_status OUT NOCOPY VARCHAR2,
1696: x_msg_count OUT NOCOPY NUMBER,
1697: x_msg_data OUT NOCOPY VARCHAR2)
1698: IS
1709: --Cursor to obtain Parent Lease Application Details
1710: CURSOR lse_app_dtls_csr(cp_lse_app_id NUMBER) IS
1711: SELECT PLAB.ID PARENT_LSE_APP_ID
1712: , PLAB.APPLICATION_STATUS PARENT_LSE_APP_STS
1713: FROM OKL_LEASE_APPLICATIONS_B LAB
1714: , OKL_LEASE_APPLICATIONS_B PLAB
1715: WHERE LAB.ID = cp_lse_app_id
1716: AND PLAB.ID = LAB.PARENT_LEASEAPP_ID;
1717: lse_app_dtls_rec lse_app_dtls_csr%ROWTYPE;
1710: CURSOR lse_app_dtls_csr(cp_lse_app_id NUMBER) IS
1711: SELECT PLAB.ID PARENT_LSE_APP_ID
1712: , PLAB.APPLICATION_STATUS PARENT_LSE_APP_STS
1713: FROM OKL_LEASE_APPLICATIONS_B LAB
1714: , OKL_LEASE_APPLICATIONS_B PLAB
1715: WHERE LAB.ID = cp_lse_app_id
1716: AND PLAB.ID = LAB.PARENT_LEASEAPP_ID;
1717: lse_app_dtls_rec lse_app_dtls_csr%ROWTYPE;
1718: BEGIN
1953:
1954: --Cursor to compare the db values of lease app header with the one in rec
1955: CURSOR lap_db_val_csr(cp_lap_id NUMBER, cp_lapv_rec lapv_rec_type) IS
1956: SELECT LAP.REFERENCE_NUMBER REFERENCE_NUMBER
1957: FROM OKL_LEASE_APPLICATIONS_B LAP
1958: WHERE LAP.ID = cp_lap_id
1959: AND NVL(LAP.PROSPECT_ADDRESS_ID, OKL_API.G_MISS_NUM) = NVL(cp_lapv_rec.prospect_address_id, OKL_API.G_MISS_NUM)
1960: AND NVL(LAP.CUST_ACCT_ID, OKL_API.G_MISS_NUM) = NVL(cp_lapv_rec.cust_acct_id, OKL_API.G_MISS_NUM)
1961: AND NVL(LAP.MASTER_LEASE_ID, OKL_API.G_MISS_NUM) = NVL(cp_lapv_rec.master_lease_id, OKL_API.G_MISS_NUM)
2259: ,LAB.CUST_ACCT_ID CUST_ACCT_ID
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
2528: IS
2529: SELECT LAP.ORG_ID ORG_ID
2530: , LAP.VALID_FROM VALID_FROM
2531: , LAP.VALID_TO VALID_TO
2532: FROM OKL_LEASE_APPLICATIONS_B LAP
2533: WHERE LAP.ID = cp_lap_id;
2534: lse_app_dtls_rec lse_app_dtls_csr%ROWTYPE;
2535:
2536: --Cursor to obtain Checklist Header Id and details
2886: -- Procedure Name : lease_app_cre
2887: -- Description : This procedure is a wrapper that creates records for
2888: -- : lease application.
2889: -- Business Rules : This procedure inserts records into the
2890: -- OKL_LEASE_APPLICATIONS_B and _TL table
2891: -- Parameters :
2892: -- Version : 1.0
2893: -- History : 20-MAY-2005 PAGARG created
2894: -- : 09 Feb 2006 PAGARG Bug 4960541 Added call to validations
2926: --Cursor to obtain Checklist Header Id
2927: CURSOR chk_hdr_dtls_csr(cp_lap_id NUMBER)
2928: IS
2929: SELECT LATV.CHECKLIST_ID
2930: FROM OKL_LEASE_APPLICATIONS_B LAP
2931: ,OKL_LEASEAPP_TEMPL_VERSIONS_V LATV
2932: WHERE LAP.LEASEAPP_TEMPLATE_ID = LATV.ID
2933: AND LAP.ID = cp_lap_id;
2934: chk_hdr_dtls_rec chk_hdr_dtls_csr%ROWTYPE;
3616: -- Procedure Name : lease_app_upd
3617: -- Description : This procedure is a wrapper that updates records for
3618: -- : lease application.
3619: -- Business Rules : This procedure updates records into the
3620: -- OKL_LEASE_APPLICATIONS_B and _TL table
3621: -- Parameters :
3622: -- Version : 1.0
3623: -- History : 20-MAY-2005 PAGARG created
3624: --
3666: --cursor to obtain lease app template id used on lease application
3667: CURSOR l_lse_app_tmplt_csr(p_lap_id NUMBER)
3668: IS
3669: SELECT leaseapp_template_id
3670: FROM okl_lease_applications_b LSQ
3671: WHERE ID = p_lap_id;
3672: l_lse_app_tmplt_csr_rec l_lse_app_tmplt_csr%ROWTYPE;
3673:
3674: --Cursor to obtain Checklist Header Id
4297: --Cursor to validate if there is any in process lease application sourced from
4298: --given Lease Quote
4299: CURSOR lap_lsq_uniq_csr(cp_lop_id NUMBER, p_lap_id NUMBER) IS
4300: SELECT REFERENCE_NUMBER
4301: FROM OKL_LEASE_APPLICATIONS_B
4302: --asawanka bug 4936130 changes start
4303: WHERE APPLICATION_STATUS NOT IN ('CR-APPROVED'
4304: ,'CR-REJECTED'
4305: ,'RECOM_NOT_APPROVED'
5491: --Cursor to obtain Checklist Header Id
5492: CURSOR chk_hdr_dtls_csr(cp_lap_id NUMBER)
5493: IS
5494: SELECT LATV.CHECKLIST_ID
5495: FROM OKL_LEASE_APPLICATIONS_B LAP
5496: ,OKL_LEASEAPP_TEMPL_VERSIONS_V LATV
5497: WHERE LAP.LEASEAPP_TEMPLATE_ID = LATV.ID
5498: AND LAP.ID = cp_lap_id;
5499: chk_hdr_dtls_rec chk_hdr_dtls_csr%ROWTYPE;
5502: CURSOR src_lse_app_dtls_csr(cp_lap_id NUMBER)
5503: IS
5504: SELECT LSQ.ID LSQ_ID
5505: FROM OKL_LEASE_QUOTES_B LSQ
5506: , OKL_LEASE_APPLICATIONS_B LAP
5507: WHERE LSQ.PARENT_OBJECT_ID = LAP.ID
5508: AND LSQ.PARENT_OBJECT_CODE = 'LEASEAPP'
5509: AND LSQ.PRIMARY_QUOTE = 'Y'
5510: AND LAP.ID = cp_lap_id;
6627:
6628: --Cursor to obtain Lease Application Details
6629: CURSOR lse_app_dtls_csr(p_lap_id NUMBER) IS
6630: SELECT LAB.REFERENCE_NUMBER
6631: FROM OKL_LEASE_APPLICATIONS_B LAB
6632: WHERE LAB.ID = p_lap_id;
6633: lse_app_dtls_rec lse_app_dtls_csr%ROWTYPE;
6634: BEGIN
6635: l_return_status := OKL_API.G_RET_STS_SUCCESS;
7668: SELECT LSQ.ID LSQ_ID
7669: , LAP.APPLICATION_STATUS LAP_STATUS
7670: , LAP.REFERENCE_NUMBER LAP_NUMBER
7671: FROM OKL_LEASE_QUOTES_B LSQ
7672: , OKL_LEASE_APPLICATIONS_B LAP
7673: WHERE LSQ.PARENT_OBJECT_ID = LAP.ID
7674: AND LSQ.PARENT_OBJECT_CODE = 'LEASEAPP'
7675: AND LSQ.PRIMARY_QUOTE = 'Y'
7676: AND LAP.ID = cp_lap_id;
7942: CURSOR lap_db_val_csr(cp_lap_id NUMBER) IS
7943: SELECT LAB.REFERENCE_NUMBER LEASE_APPL_NUMBER
7944: , LAB.APPLICATION_STATUS APPLICATION_STATUS
7945: , LAB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
7946: FROM OKL_LEASE_APPLICATIONS_B LAB
7947: WHERE LAB.ID = cp_lap_id;
7948: lap_db_val_rec lap_db_val_csr%ROWTYPE;
7949:
7950: BEGIN
8463: CURSOR chk_hdr_dtls_csr(cp_lap_id NUMBER)
8464: IS
8465: --changing the query for bug 5167776
8466: SELECT LATV.CHECKLIST_ID
8467: FROM OKL_LEASE_APPLICATIONS_B LAP
8468: ,OKL_LEASEAPP_TEMPL_VERSIONS_V LATV
8469: WHERE LAP.LEASEAPP_TEMPLATE_ID = LATV.ID
8470: AND LAP.ID = cp_lap_id;
8471: chk_hdr_dtls_rec chk_hdr_dtls_csr%ROWTYPE;
8475: IS
8476: SELECT LSQ.ID LSQ_ID
8477: , CRR.CREDIT_REQUEST_ID
8478: FROM OKL_LEASE_QUOTES_B LSQ
8479: , OKL_LEASE_APPLICATIONS_B LAP
8480: , AR_CMGT_CREDIT_REQUESTS CRR
8481: WHERE LSQ.PARENT_OBJECT_ID = LAP.ID
8482: AND LSQ.PARENT_OBJECT_CODE = 'LEASEAPP'
8483: AND LSQ.PRIMARY_QUOTE = 'Y'
8919: --Cursor to populate Lease Application details from database
8920: CURSOR lap_db_val_csr(cp_lap_id NUMBER) IS
8921: SELECT LAB.REFERENCE_NUMBER LEASE_APPL_NUMBER
8922: , LAB.APPLICATION_STATUS APPLICATION_STATUS
8923: FROM OKL_LEASE_APPLICATIONS_B LAB
8924: WHERE LAB.ID = cp_lap_id;
8925: lap_db_val_rec lap_db_val_csr%ROWTYPE;
8926: BEGIN
8927: l_return_status := OKL_API.G_RET_STS_SUCCESS;
9270: --Cursor to obtain Checklist Header Id
9271: CURSOR chk_hdr_dtls_csr(cp_lap_id NUMBER)
9272: IS
9273: SELECT CHK.ID CHECKLIST_ID
9274: FROM OKL_LEASE_APPLICATIONS_B LAP
9275: , OKL_CHECKLISTS CHK
9276: WHERE CHK.CHECKLIST_OBJ_TYPE_CODE = 'LEASE_APPL'
9277: AND CHK.CHECKLIST_OBJ_ID = LAP.ID
9278: AND LAP.ID = cp_lap_id;
9285: , CRR.CREDIT_REQUEST_ID
9286: , LAP.APPLICATION_STATUS
9287: , LAP.APPLICATION_STATUS APPEAL_SCOPE
9288: FROM OKL_LEASE_QUOTES_B LSQ
9289: , OKL_LEASE_APPLICATIONS_B LAP
9290: , AR_CMGT_CREDIT_REQUESTS CRR
9291: WHERE LSQ.PARENT_OBJECT_ID = LAP.ID
9292: AND LSQ.PARENT_OBJECT_CODE = 'LEASEAPP'
9293: AND LSQ.PRIMARY_QUOTE = 'Y'
9735: IS
9736: SELECT ID
9737: , REFERENCE_NUMBER
9738: , APPLICATION_STATUS
9739: FROM OKL_LEASE_APPLICATIONS_B
9740: WHERE ID <> cp_lap_id
9741: CONNECT BY PARENT_LEASEAPP_ID = PRIOR ID
9742: START WITH ID = cp_lap_id;
9743: child_lse_app_rec child_lse_app_csr%ROWTYPE;
9746: IS
9747: SELECT ID
9748: , REFERENCE_NUMBER
9749: , APPLICATION_STATUS
9750: FROM OKL_LEASE_APPLICATIONS_B
9751: WHERE ID <> cp_lap_id
9752: CONNECT BY PRIOR PARENT_LEASEAPP_ID = ID
9753: START WITH ID = cp_lap_id;
9754: parent_lse_app_rec parent_lse_app_csr%ROWTYPE;
9791:
9792: --Cursor to obtain Lease Application Details
9793: CURSOR lse_app_dtls_csr(p_lap_id NUMBER) IS
9794: SELECT LAB.REFERENCE_NUMBER
9795: FROM OKL_LEASE_APPLICATIONS_B LAB
9796: WHERE LAB.ID = p_lap_id;
9797: lse_app_dtls_rec lse_app_dtls_csr%ROWTYPE;
9798: BEGIN
9799: l_return_status := OKL_API.G_RET_STS_SUCCESS;
10142: -- End of comments
10143: PROCEDURE lease_app_qa_val(
10144: p_api_version IN NUMBER,
10145: p_init_msg_list IN VARCHAR2,
10146: p_lap_id IN OKL_LEASE_APPLICATIONS_B.ID%TYPE,
10147: x_return_status OUT NOCOPY VARCHAR2,
10148: x_msg_count OUT NOCOPY NUMBER,
10149: x_msg_data OUT NOCOPY VARCHAR2,
10150: x_qa_result OUT NOCOPY VARCHAR2)
10272: -- End of comments
10273: PROCEDURE lease_app_price(
10274: p_api_version IN NUMBER,
10275: p_init_msg_list IN VARCHAR2,
10276: p_lap_id IN OKL_LEASE_APPLICATIONS_B.ID%TYPE,
10277: x_return_status OUT NOCOPY VARCHAR2,
10278: x_msg_count OUT NOCOPY NUMBER,
10279: x_msg_data OUT NOCOPY VARCHAR2)
10280: IS
10497: -- End of comments
10498: PROCEDURE set_lease_app_status(
10499: p_api_version IN NUMBER,
10500: p_init_msg_list IN VARCHAR2,
10501: p_lap_id IN OKL_LEASE_APPLICATIONS_B.ID%TYPE,
10502: p_lap_status IN VARCHAR2,
10503: x_return_status OUT NOCOPY VARCHAR2,
10504: x_msg_count OUT NOCOPY NUMBER,
10505: x_msg_data OUT NOCOPY VARCHAR2)
10676: -- End of comments
10677: PROCEDURE set_lease_app_expdays(
10678: p_api_version IN NUMBER,
10679: p_init_msg_list IN VARCHAR2,
10680: p_lap_id IN OKL_LEASE_APPLICATIONS_B.ID%TYPE,
10681: p_lap_expdays IN NUMBER,
10682: x_return_status OUT NOCOPY VARCHAR2,
10683: x_msg_count OUT NOCOPY NUMBER,
10684: x_msg_data OUT NOCOPY VARCHAR2)
11002: -- End of comments
11003: PROCEDURE lease_app_unaccept(
11004: p_api_version IN NUMBER,
11005: p_init_msg_list IN VARCHAR2,
11006: p_lap_id IN OKL_LEASE_APPLICATIONS_B.ID%TYPE,
11007: x_return_status OUT NOCOPY VARCHAR2,
11008: x_msg_count OUT NOCOPY NUMBER,
11009: x_msg_data OUT NOCOPY VARCHAR2)
11010: IS
11020: --Cursor to obtain Lease Application Details
11021: CURSOR lse_app_dtls_csr(p_lse_app_id NUMBER)
11022: IS
11023: SELECT REFERENCE_NUMBER
11024: FROM OKL_LEASE_APPLICATIONS_B LAB
11025: WHERE LAB.ID = p_lse_app_id;
11026: lse_app_dtls_rec lse_app_dtls_csr%ROWTYPE;
11027: BEGIN
11028: l_return_status := OKL_API.G_RET_STS_SUCCESS;
11255: -- End of comments
11256: PROCEDURE create_contract(
11257: p_api_version IN NUMBER,
11258: p_init_msg_list IN VARCHAR2,
11259: p_lap_id IN OKL_LEASE_APPLICATIONS_B.ID%TYPE,
11260: x_return_status OUT NOCOPY VARCHAR2,
11261: x_msg_count OUT NOCOPY NUMBER,
11262: x_msg_data OUT NOCOPY VARCHAR2,
11263: x_chr_id OUT NOCOPY NUMBER,
11272: CURSOR l_lap_dtls_csr(p_lap_id NUMBER)
11273: IS
11274: SELECT LAB.REFERENCE_NUMBER REFERENCE_NUMBER
11275: , LAB.LEASE_OPPORTUNITY_ID LEASE_OPPORTUNITY_ID
11276: FROM OKL_LEASE_APPLICATIONS_B LAB
11277: WHERE LAB.ID = p_lap_id;
11278: l_lap_dtls_rec l_lap_dtls_csr%ROWTYPE;
11279:
11280: BEGIN
11417: -- End of comments
11418: PROCEDURE appeal_recommendations(
11419: p_api_version IN NUMBER,
11420: p_init_msg_list IN VARCHAR2,
11421: p_lap_id IN OKL_LEASE_APPLICATIONS_B.ID%TYPE,
11422: p_cr_dec_apl_flag IN VARCHAR2,
11423: p_exp_date_apl_flag IN VARCHAR2,
11424: p_cr_conds IN NAME_VAL_TBL_TYPE,
11425: p_addl_rcmnds IN NAME_VAL_TBL_TYPE,
11474: , CCR.CREDIT_CLASSIFICATION
11475: , CCR.CUST_ACCOUNT_ID
11476: , LAB.PARENT_LEASEAPP_ID PARENT_LEASEAPP_ID
11477: FROM AR_CMGT_CREDIT_REQUESTS CCR
11478: , OKL_LEASE_APPLICATIONS_B LAB
11479: WHERE SOURCE_COLUMN3 = 'LEASEAPP'
11480: AND SOURCE_COLUMN1 = LAB.PARENT_LEASEAPP_ID
11481: AND LAB.ID = cp_lap_id;
11482: crd_app_data_rec crd_app_data_csr%ROWTYPE;
11811: -- End of comments
11812: PROCEDURE create_contract_val(
11813: p_api_version IN NUMBER,
11814: p_init_msg_list IN VARCHAR2,
11815: p_lap_id IN OKL_LEASE_APPLICATIONS_B.ID%TYPE,
11816: x_return_status OUT NOCOPY VARCHAR2,
11817: x_msg_count OUT NOCOPY NUMBER,
11818: x_msg_data OUT NOCOPY VARCHAR2)
11819: IS
11826: CURSOR l_lap_dtls_csr(p_lap_id NUMBER)
11827: IS
11828: SELECT LAB.REFERENCE_NUMBER REFERENCE_NUMBER
11829: , LAB.LEASE_OPPORTUNITY_ID LEASE_OPPORTUNITY_ID
11830: FROM OKL_LEASE_APPLICATIONS_B LAB
11831: WHERE LAB.ID = p_lap_id;
11832: l_lap_dtls_rec l_lap_dtls_csr%ROWTYPE;
11833:
11834: --Cursor to check if contract already created from lease opp linked to lease app
11837: IS
11838: SELECT LAB.REFERENCE_NUMBER LSE_APP
11839: , LOP.REFERENCE_NUMBER LSE_OPP
11840: , CHR.CONTRACT_NUMBER CONTRACT_NUMBER
11841: FROM OKL_LEASE_APPLICATIONS_B LAB
11842: , OKL_LEASE_APPLICATIONS_B CLAB
11843: , OKL_LEASE_OPPORTUNITIES_B LOP
11844: , OKC_K_HEADERS_B CHR
11845: , OKC_STATUSES_V CSTS
11838: SELECT LAB.REFERENCE_NUMBER LSE_APP
11839: , LOP.REFERENCE_NUMBER LSE_OPP
11840: , CHR.CONTRACT_NUMBER CONTRACT_NUMBER
11841: FROM OKL_LEASE_APPLICATIONS_B LAB
11842: , OKL_LEASE_APPLICATIONS_B CLAB
11843: , OKL_LEASE_OPPORTUNITIES_B LOP
11844: , OKC_K_HEADERS_B CHR
11845: , OKC_STATUSES_V CSTS
11846: WHERE LAB.LEASE_OPPORTUNITY_ID = CLAB.LEASE_OPPORTUNITY_ID
11861: SELECT LSQ.REFERENCE_NUMBER LSE_QTE
11862: , LOP.REFERENCE_NUMBER LSE_OPP
11863: , CHR.CONTRACT_NUMBER CONTRACT_NUMBER
11864: FROM OKL_LEASE_QUOTES_B LSQ
11865: , OKL_LEASE_APPLICATIONS_B CLAB
11866: , OKL_LEASE_OPPORTUNITIES_B LOP
11867: , OKC_K_HEADERS_B CHR
11868: , OKC_STATUSES_V CSTS
11869: WHERE LOP.ID = CLAB.LEASE_OPPORTUNITY_ID