[Home] [Help]
360: SELECT K.id,
361: K.contract_number,
362: Q.last_updated_by,
363: Q.created_by
364: FROM OKL_TRX_QUOTES_V Q,
365: OKL_K_HEADERS_FULL_V K
366: WHERE Q.khr_id = K.id
367: AND Q.id = p_quote_id;
368:
381: TRQ.comments comments,
382: KHR.contract_number contract_number,
383: TRQ.last_updated_by last_updated_by
384: FROM OKC_K_HEADERS_B KHR,
385: OKL_TRX_QUOTES_V TRQ,
386: (SELECT SUM(NVL(amount,0)) amount, qte_id FROM OKL_TXL_QUOTE_LINES_V GROUP BY qte_id) QTE
387: WHERE KHR.id = TRQ.khr_id
388: AND QTE.qte_id = TRQ.id
389: AND TRQ.id = p_id;
1058: KHR.contract_number contract_number,
1059: TRQ.comments comments,
1060: TRQ.last_updated_by last_updated_by
1061: FROM OKC_K_HEADERS_B KHR,
1062: OKL_TRX_QUOTES_V TRQ,
1063: (SELECT SUM(NVL(amount,0)) amount, qte_id FROM OKL_TXL_QUOTE_LINES_V GROUP BY qte_id) QTE
1064: WHERE KHR.id = TRQ.khr_id
1065: AND QTE.qte_id = TRQ.id
1066: AND TRQ.id = p_id;
1224: OKL_AM_UTIL_PVT.get_lookup_meaning('OKL_QUOTE_TYPE',OTQ.qtp_code,'N') QUOTE_TYPE,
1225: TO_CHAR(OTQ.CREATION_DATE, 'DD-MON-RRRR') QUOTE_CREATION_DATE,
1226: KHR.CONTRACT_NUMBER CONTRACT_NUMBER,
1227: OTQ.comments COMMENTS
1228: FROM OKL_TRX_QUOTES_V OTQ,
1229: OKL_TXL_QUOTE_LINES_B OTL,
1230: OKC_K_HEADERS_V KHR
1231: WHERE OTQ.ID = p_qte_id
1232: AND OTQ.ID = OTL.QTE_ID
1381: -- Cursor to get the quote details
1382: CURSOR get_qte_details_csr( p_qte_id IN NUMBER) IS
1383: SELECT qtp_code,
1384: qrs_code
1385: FROM OKL_TRX_QUOTES_V
1386: WHERE id = p_qte_id;
1387:
1388: l_term_rec term_rec_type;
1389: l_tcnv_rec tcnv_rec_type;
3087: SELECT K.id,
3088: K.contract_number,
3089: Q.last_updated_by
3090: FROM OKL_K_HEADERS_FULL_V K,
3091: OKL_TRX_QUOTES_V Q
3092: WHERE K.id = Q.khr_id
3093: AND Q.id = p_quote_id;
3094:
3095: l_transaction_id VARCHAR2(2000);
3673: -- get the quote details (if partial or full)
3674: CURSOR l_qte_details_csr (p_qte_id IN NUMBER) IS
3675: SELECT nvl(qte.partial_yn,'N') partial_yn
3676: ,qte.khr_id khr_id -- gboomina added for bug#5265083
3677: FROM okl_trx_quotes_v qte
3678: WHERE qte.id = p_qte_id;
3679:
3680: l_api_version NUMBER := 1;
3681: lx_msg_count NUMBER;
3694: -- rmunjulu EDAT
3695: l_qte_partial_yn VARCHAR2(3);
3696:
3697: -- gboomina Added for bug# 5265083 - Start
3698: l_contract_id okl_trx_quotes_v.khr_id%type;
3699: l_org_id NUMBER;
3700: -- gboomina Bug 5265083 - End
3701: -- for debug logging
3702: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'create_invoice';
4353: AD.CONTRACT_NUMBER CONTRACT_NUMBER,
4354: OTQ.COMMENTS COMMENTS,
4355: OTQ.LAST_UPDATED_BY LAST_UPDATED_BY,
4356: OTQ.KHR_ID KHR_ID
4357: FROM OKL_TRX_QUOTES_V OTQ,
4358: OKL_TXL_QUOTE_LINES_B OTL,
4359: OKL_QUOTE_PARTIES QP,
4360: OKC_K_PARTY_ROLES_V PR,
4361: OKC_K_HEADERS_ALL_B AD
4691: OTQ.COMMENTS COMMENTS,
4692: OTQ.LAST_UPDATED_BY LAST_UPDATED_BY,
4693: OTQ.KHR_ID KHR_ID
4694: ,OTQ.gain_loss gain_loss -- Added for bug 12802662
4695: FROM OKL_TRX_QUOTES_V OTQ,
4696: OKL_TXL_QUOTE_LINES_B OTL,
4697: OKC_K_HEADERS_V AD
4698: WHERE OTQ.ID = c_id
4699: AND OTQ.ID = OTL.QTE_ID
5194: AD.CONTRACT_NUMBER CONTRACT_NUMBER,
5195: OTQ.COMMENTS COMMENTS,
5196: OTQ.LAST_UPDATED_BY LAST_UPDATED_BY,
5197: OTQ.KHR_ID KHR_ID
5198: FROM OKL_TRX_QUOTES_V OTQ,
5199: OKL_TXL_QUOTE_LINES_B OTL,
5200: OKC_K_HEADERS_V AD
5201: WHERE OTQ.ID = c_id
5202: AND OTQ.ID = OTL.QTE_ID
7021: , trx.date_requested
7022: , decode(trx.QTP_CODE, 'TER_PURCHASE', 'Y', 'N') PURCHASE_ASSET
7023: , nvl(early_termination_yn, 'N') EOT
7024: , decode(nvl(partial_yn, 'N'), 'N', 'Y', 'N') COMPLETE_CONTRACT
7025: FROM OKL_TRX_QUOTES_V trx,
7026: OKC_K_HEADERS_V khr
7027: WHERE trx.id = p_qte_id
7028: and trx.QST_CODE = 'DRAFTED'
7029: and trx.khr_id = khr.id;
7557: , decode(nvl(partial_yn, 'N'), 'N', 'Y', 'N') COMPLETE_CONTRACT
7558: , kle.ITEM_DESCRIPTION ASSET_NUMBER
7559: , txl.ASSET_QUANTITY ASSET_QUANTITY
7560: , txl.QUOTE_QUANTITY QUOTE_QUANTITY
7561: FROM OKL_TRX_QUOTES_V trx,
7562: OKL_TXL_QUOTE_LINES_V txl,
7563: OKC_K_HEADERS_V khr,
7564: OKC_K_LINES_V kle
7565: WHERE trx.id = p_qte_id