Product: | PON - Sourcing |
---|---|
Description: | View to access price element type name and description in the session language. |
Implementation/DBA Data: | APPS.PON_PRICE_ELEMENT_TYPES_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')