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.OKS_PRICE_BREAKS_V

Source

View Text - Preformatted


SELECT PBR.ROWID ROW_ID, PBR.ID ID, PBR.BSL_ID BSL_ID, PBR.BCL_ID BCL_ID, PBR.CLE_ID CLE_ID, PBR.CHR_ID CHR_ID, PBR.LINE_DETAIL_INDEX lINE_DETAIL_INDEX, PBR.LINE_INDEX LINE_INDEX, PBR.PRICING_CONTEXT PRICING_CONTEXT, PBR.PRICING_METHOD PRICING_METHOD, PBR.QUANTITY_FROM QUANTITY_FROM, PBR.QUANTITY_TO QUANTITY_TO, PBR.QUANTITY QUANTITY, PBR.BREAK_UOM BREAK_UOM, PBR.PRORATE PRORATE, PBR.UNIT_PRICE UNIT_PRICE, PBR.AMOUNT AMOUNT, PBR.PRICE_LIST_ID PRICE_LIST_ID, PBR.VALIDATED_FLAG VALIDATED_FLAG, PBR.STATUS_CODE STATUS_CODE, PBR.STATUS_TEXT STATUS_TEXT, PBR.LOCK_FLAG LOCK_FLAG, PBR.LOCKED_PRICE_LIST_ID LOCKED_PRICE_LIST_ID, PBR.LOCKED_PRICE_LIST_LINE_ID LOCKED_PRICE_LIST_LINE_ID, PBR.PRICE_LIST_LINE_ID PRICE_LIST_LINE_ID, PBR.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, PBR.CREATED_BY CREATED_BY, PBR.CREATION_DATE CREATION_DATE, PBR.LAST_UPDATED_BY LAST_UPDATED_BY, PBR.LAST_UPDATE_DATE LAST_UPDATE_DATE, PBR.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM OKS_PRICE_BREAKS PBR

View Text - HTML Formatted

SELECT PBR.ROWID ROW_ID
, PBR.ID ID
, PBR.BSL_ID BSL_ID
, PBR.BCL_ID BCL_ID
, PBR.CLE_ID CLE_ID
, PBR.CHR_ID CHR_ID
, PBR.LINE_DETAIL_INDEX LINE_DETAIL_INDEX
, PBR.LINE_INDEX LINE_INDEX
, PBR.PRICING_CONTEXT PRICING_CONTEXT
, PBR.PRICING_METHOD PRICING_METHOD
, PBR.QUANTITY_FROM QUANTITY_FROM
, PBR.QUANTITY_TO QUANTITY_TO
, PBR.QUANTITY QUANTITY
, PBR.BREAK_UOM BREAK_UOM
, PBR.PRORATE PRORATE
, PBR.UNIT_PRICE UNIT_PRICE
, PBR.AMOUNT AMOUNT
, PBR.PRICE_LIST_ID PRICE_LIST_ID
, PBR.VALIDATED_FLAG VALIDATED_FLAG
, PBR.STATUS_CODE STATUS_CODE
, PBR.STATUS_TEXT STATUS_TEXT
, PBR.LOCK_FLAG LOCK_FLAG
, PBR.LOCKED_PRICE_LIST_ID LOCKED_PRICE_LIST_ID
, PBR.LOCKED_PRICE_LIST_LINE_ID LOCKED_PRICE_LIST_LINE_ID
, PBR.PRICE_LIST_LINE_ID PRICE_LIST_LINE_ID
, PBR.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, PBR.CREATED_BY CREATED_BY
, PBR.CREATION_DATE CREATION_DATE
, PBR.LAST_UPDATED_BY LAST_UPDATED_BY
, PBR.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PBR.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKS_PRICE_BREAKS PBR