VIEW: APPS.OKL_AM_ASSET_LINES_UV

Source

View Text - Preformatted

SELECT CLEB.ID ID, CLET.NAME NAME, OKHFV.CONTRACT_NUMBER CONTRACT_NUMBER, CLET.ITEM_DESCRIPTION DESCRIPTION, CLEB.CHR_ID CHR_ID, KLE.OEC OEC, OTQV.ID QTE_ID, OTQV.QUOTE_NUMBER QUOTE_NUMBER, TQL.ASSET_VALUE, TQL.RESIDUAL_VALUE, TQL.UNBILLED_RECEIVABLES, TQL.ASSET_QUANTITY, TQL.QUOTE_QUANTITY, TQL.SPLIT_KLE_ID, TQL.SPLIT_KLE_NAME, OTQV.ASSET_VALUE, OTQV.RESIDUAL_VALUE, OTQV.UNBILLED_RECEIVABLES, OTQV.GAIN_LOSS, OTQV.QST_CODE, OTQV.QTP_CODE, TQL.ID TQL_ID FROM OKL_K_LINES KLE,OKC_K_LINES_TL CLET,OKC_K_LINES_B CLEB,OKC_K_HEADERS_B OKHFV,OKL_TRX_QUOTES_ALL_B OTQV,OKL_TXL_QTE_LINES_ALL_B TQL WHERE CLEB.ID = CLET.ID AND CLET.LANGUAGE = userenv('LANG') AND CLEB.ID = KLE.ID AND OKHFV.ID = OTQV.KHR_ID AND TQL.KLE_ID = KLE.ID AND OTQV.ID = TQL.QTE_ID AND TQL.QLT_CODE = 'AMCFIA'

View Text - HTML Formatted

SELECT CLEB.ID ID
, CLET.NAME NAME
, OKHFV.CONTRACT_NUMBER CONTRACT_NUMBER
, CLET.ITEM_DESCRIPTION DESCRIPTION
, CLEB.CHR_ID CHR_ID
, KLE.OEC OEC
, OTQV.ID QTE_ID
, OTQV.QUOTE_NUMBER QUOTE_NUMBER
, TQL.ASSET_VALUE
, TQL.RESIDUAL_VALUE
, TQL.UNBILLED_RECEIVABLES
, TQL.ASSET_QUANTITY
, TQL.QUOTE_QUANTITY
, TQL.SPLIT_KLE_ID
, TQL.SPLIT_KLE_NAME
, OTQV.ASSET_VALUE
, OTQV.RESIDUAL_VALUE
, OTQV.UNBILLED_RECEIVABLES
, OTQV.GAIN_LOSS
, OTQV.QST_CODE
, OTQV.QTP_CODE
, TQL.ID TQL_ID
FROM OKL_K_LINES KLE
, OKC_K_LINES_TL CLET
, OKC_K_LINES_B CLEB
, OKC_K_HEADERS_B OKHFV
, OKL_TRX_QUOTES_ALL_B OTQV
, OKL_TXL_QTE_LINES_ALL_B TQL
WHERE CLEB.ID = CLET.ID
AND CLET.LANGUAGE = USERENV('LANG')
AND CLEB.ID = KLE.ID
AND OKHFV.ID = OTQV.KHR_ID
AND TQL.KLE_ID = KLE.ID
AND OTQV.ID = TQL.QTE_ID
AND TQL.QLT_CODE = 'AMCFIA'