[Home] [Help]
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
1233: AND KHR.ID = OTQ.KHR_ID
1234: GROUP BY TO_CHAR(SYSDATE, 'DD-MON-RRRR'),
4392: OALV.SERIAL_NUMBER SERIAL_NUMBER,
4393: OALV.MODEL_NUMBER MODEL_NUMBER
4394: FROM OKL_K_LINES_FULL_V CLEV,
4395: OKX_ASSET_LINES_V OALV,
4396: OKC_K_HEADERS_V OKHV,
4397: OKC_LINE_STYLES_V LSEV,
4398: FA_CATEGORIES_VL FAC ,
4399: OKL_AM_ASSET_LINES_UV AL
4400: WHERE CLEV.ID = OALV.PARENT_LINE_ID
4692: OTQ.LAST_UPDATED_BY LAST_UPDATED_BY,
4693: OTQ.KHR_ID KHR_ID
4694: FROM OKL_TRX_QUOTES_V OTQ,
4695: OKL_TXL_QUOTE_LINES_B OTL,
4696: OKC_K_HEADERS_V AD
4697: WHERE OTQ.ID = c_id
4698: AND OTQ.ID = OTL.QTE_ID
4699: AND AD.ID = OTQ.KHR_ID
4700: GROUP BY TO_CHAR(SYSDATE, 'DD-MON-RRRR'),
5194: OTQ.LAST_UPDATED_BY LAST_UPDATED_BY,
5195: OTQ.KHR_ID KHR_ID
5196: FROM OKL_TRX_QUOTES_V OTQ,
5197: OKL_TXL_QUOTE_LINES_B OTL,
5198: OKC_K_HEADERS_V AD
5199: WHERE OTQ.ID = c_id
5200: AND OTQ.ID = OTL.QTE_ID
5201: AND AD.ID = OTQ.KHR_ID
5202: GROUP BY TO_CHAR(SYSDATE, 'DD-MON-RRRR'),
7020: , decode(trx.QTP_CODE, 'TER_PURCHASE', 'Y', 'N') PURCHASE_ASSET
7021: , nvl(early_termination_yn, 'N') EOT
7022: , decode(nvl(partial_yn, 'N'), 'N', 'Y', 'N') COMPLETE_CONTRACT
7023: FROM OKL_TRX_QUOTES_V trx,
7024: OKC_K_HEADERS_V khr
7025: WHERE trx.id = p_qte_id
7026: and trx.QST_CODE = 'DRAFTED'
7027: and trx.khr_id = khr.id;
7028:
7557: , txl.ASSET_QUANTITY ASSET_QUANTITY
7558: , txl.QUOTE_QUANTITY QUOTE_QUANTITY
7559: FROM OKL_TRX_QUOTES_V trx,
7560: OKL_TXL_QUOTE_LINES_V txl,
7561: OKC_K_HEADERS_V khr,
7562: OKC_K_LINES_V kle
7563: WHERE trx.id = p_qte_id
7564: and txl.qte_id (+) = trx.id
7565: and trx.QST_CODE = 'DRAFTED'