VIEW: APPS.OKL_AM_QUOTE_ANTCPT_BILL_UV

Source

View Text - Preformatted

SELECT qab.amount amount, sty.code stream_name, cle.NAME asset_number, qab.id qab_id, cle.id kle_id, sty.id sty_id, qab.qte_id, qab.sel_date FROM OKL_TXD_QTE_ANTCPT_BILL QAB,OKL_STRM_TYPE_B STY,OKC_K_LINES_V CLE WHERE qab.sty_id = sty.id AND qab.kle_id = cle.id

View Text - HTML Formatted

SELECT QAB.AMOUNT AMOUNT
, STY.CODE STREAM_NAME
, CLE.NAME ASSET_NUMBER
, QAB.ID QAB_ID
, CLE.ID KLE_ID
, STY.ID STY_ID
, QAB.QTE_ID
, QAB.SEL_DATE
FROM OKL_TXD_QTE_ANTCPT_BILL QAB
, OKL_STRM_TYPE_B STY
, OKC_K_LINES_V CLE
WHERE QAB.STY_ID = STY.ID
AND QAB.KLE_ID = CLE.ID