[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
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
4700: AND AD.ID = OTQ.KHR_ID
4701: GROUP BY TO_CHAR(SYSDATE, 'DD-MON-RRRR'),
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
5203: AND AD.ID = OTQ.KHR_ID
5204: GROUP BY TO_CHAR(SYSDATE, 'DD-MON-RRRR'),
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;
7030:
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
7566: and txl.qte_id (+) = trx.id
7567: and trx.QST_CODE = 'DRAFTED'