eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.OKL_AM_QUOTE_LINE_STRM_UV

Source

View Text - Preformatted


SELECT QLSB.ID ID, QLSB.QUOTE_LINE_TYPE_CODE QUOTE_LINE_TYPE_CODE, QLSB.INVOICABLE_YN INVOICABLE_YN, QLSB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, QLSB.STY_ID STY_ID, STY.NAME STY_NAME, STY.DESCRIPTION STY_DESCRIPTION, STY.BILLABLE_YN STY_BILLABLE_YN, STY.TAXABLE_DEFAULT_YN STY_TAXABLE_DEFAULT_YN, FND.LOOKUP_CODE FND_LOOKUP_CODE, FND.MEANING QUOTE_LINE_TYPE_MEANING, QLSB.ORG_ID ORG_ID FROM OKL_QUOTE_LINE_STRM QLSB,FND_LOOKUPS FND,OKL_STRM_TYPE_V STY WHERE QLSB.QUOTE_LINE_TYPE_CODE(+) = FND.LOOKUP_CODE AND FND.LOOKUP_TYPE = 'OKL_QUOTE_LINE_TYPE' AND QLSB.STY_ID = STY.ID(+)

View Text - HTML Formatted

SELECT QLSB.ID ID
, QLSB.QUOTE_LINE_TYPE_CODE QUOTE_LINE_TYPE_CODE
, QLSB.INVOICABLE_YN INVOICABLE_YN
, QLSB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, QLSB.STY_ID STY_ID
, STY.NAME STY_NAME
, STY.DESCRIPTION STY_DESCRIPTION
, STY.BILLABLE_YN STY_BILLABLE_YN
, STY.TAXABLE_DEFAULT_YN STY_TAXABLE_DEFAULT_YN
, FND.LOOKUP_CODE FND_LOOKUP_CODE
, FND.MEANING QUOTE_LINE_TYPE_MEANING
, QLSB.ORG_ID ORG_ID
FROM OKL_QUOTE_LINE_STRM QLSB
, FND_LOOKUPS FND
, OKL_STRM_TYPE_V STY
WHERE QLSB.QUOTE_LINE_TYPE_CODE(+) = FND.LOOKUP_CODE
AND FND.LOOKUP_TYPE = 'OKL_QUOTE_LINE_TYPE'
AND QLSB.STY_ID = STY.ID(+)