View: PON_PRICE_ELEMENT_TYPES_VL

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

View Text

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')

Columns