Product: | PON - Sourcing |
---|---|
Description: | View to show details of the cost factors/price elements in the session language. This view is similar to pon_price_element_types_vl except that its WHERE clause excludes the price element with id -10 corresponding to the item price. Item |
Implementation/DBA Data: | APPS.PON_COST_FACTORS_VL |
SELECT B.ROWID ROW_ID
, B.PRICE_ELEMENT_TYPE_ID
, T.NAME
, T.DESCRIPTION
, B.TRADING_PARTNER_ID
, B.PRICE_ELEMENT_CODE
, B.PRICING_BASIS
, B.ENABLED_FLAG
, B.SYSTEM_FLAG
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.ALLOCATION_BASIS
, B.INVOICE_LINE_TYPE
, B.COST_COMPONENT_CLASS_ID
, B.COST_ANALYSIS_CODE
, B.COST_ACQUISITION_CODE
FROM PON_PRICE_ELEMENT_TYPES_TL T
, PON_PRICE_ELEMENT_TYPES B
WHERE B.PRICE_ELEMENT_TYPE_ID = T.PRICE_ELEMENT_TYPE_ID
AND T.LANGUAGE = USERENV('LANG')
AND B.PRICE_ELEMENT_TYPE_ID <> -10