VIEW: APPS.OKL_AM_REPURCHASE_ASSET_HDR_UV

Source

View Text - Preformatted

SELECT OTQ.ID QUOTE_ID, OTQ.QUOTE_NUMBER QUOTE_NUMBER, OTQ.DATE_EFFECTIVE_FROM DATE_EFFECTIVE_FROM, OTQ.DATE_EFFECTIVE_TO DATE_EFFECTIVE_TO, OTQ.APPROVED_YN APPROVED_YN, OTQ.ACCEPTED_YN ACCEPTED_YN, OTQ.COMMENTS COMMENTS, OKC.CONTRACT_NUMBER CONTRACT_NUMBER, OKC.END_DATE END_DATE, OKC.ID KHR_ID, KLE.NAME ASSET_NUMBER, KLE.ITEM_DESCRIPTION ASSET_DESCRIPTION, KLE.ID KLE_ID, OAR.ID ART_ID, OAR.REPURCHASE_AGMT_YN, OAR.FLOOR_PRICE, FL.MEANING STATUS, to_char(null), okl_am_util_pvt.get_program_partner (OKC.ID), STS.CODE LINE_STS_CODE, STS.MEANING LINE_STATUS, OAR.ORG_ID ORG_ID FROM OKL_TRX_QUOTES_V OTQ,OKC_K_LINES_V KLE,OKC_K_HEADERS_B OKC,OKL_ASSET_RETURNS_V OAR,FND_LOOKUPS FL,OKC_STATUSES_V STS WHERE OTQ.ART_ID (+) = OAR.ID AND OKC.ID = KLE.CHR_ID AND OAR.KLE_ID = KLE.ID AND FL.LOOKUP_TYPE (+) = 'OKL_QUOTE_STATUS' AND FL.LOOKUP_CODE (+) = OTQ.QST_CODE AND KLE.STS_CODE = STS.CODE

View Text - HTML Formatted

SELECT OTQ.ID QUOTE_ID
, OTQ.QUOTE_NUMBER QUOTE_NUMBER
, OTQ.DATE_EFFECTIVE_FROM DATE_EFFECTIVE_FROM
, OTQ.DATE_EFFECTIVE_TO DATE_EFFECTIVE_TO
, OTQ.APPROVED_YN APPROVED_YN
, OTQ.ACCEPTED_YN ACCEPTED_YN
, OTQ.COMMENTS COMMENTS
, OKC.CONTRACT_NUMBER CONTRACT_NUMBER
, OKC.END_DATE END_DATE
, OKC.ID KHR_ID
, KLE.NAME ASSET_NUMBER
, KLE.ITEM_DESCRIPTION ASSET_DESCRIPTION
, KLE.ID KLE_ID
, OAR.ID ART_ID
, OAR.REPURCHASE_AGMT_YN
, OAR.FLOOR_PRICE
, FL.MEANING STATUS
, TO_CHAR(NULL)
, OKL_AM_UTIL_PVT.GET_PROGRAM_PARTNER (OKC.ID)
, STS.CODE LINE_STS_CODE
, STS.MEANING LINE_STATUS
, OAR.ORG_ID ORG_ID
FROM OKL_TRX_QUOTES_V OTQ
, OKC_K_LINES_V KLE
, OKC_K_HEADERS_B OKC
, OKL_ASSET_RETURNS_V OAR
, FND_LOOKUPS FL
, OKC_STATUSES_V STS
WHERE OTQ.ART_ID (+) = OAR.ID
AND OKC.ID = KLE.CHR_ID
AND OAR.KLE_ID = KLE.ID
AND FL.LOOKUP_TYPE (+) = 'OKL_QUOTE_STATUS'
AND FL.LOOKUP_CODE (+) = OTQ.QST_CODE
AND KLE.STS_CODE = STS.CODE