View: OE_PRICING_ENTITIES_V

Product:	QP - Advanced Pricing
Description:	Obsolete
Implementation/DBA Data:	APPS.OE_PRICING_ENTITIES_V

View Text

SELECT OAOAE. ATTRIBUTE_ID ENTITY_ID
, OAOAE. ATTRIBUTE_CODE ENTITY_CODE
, OAOAE. COLUMN_TYPE_CODE COLUMN_TYPE_CODE
, OAOAE. PRICING_RULE_ENABLED_FLAG ENABLED_FLAG
, AOA. TABLE_NAME TABLE_NAME
, AOA. COLUMN_NAME COLUMN_NAME
, AOAT. ATTRIBUTE_LABEL_LONG NAME
FROM AK_OBJECT_ATTRIBUTES_TL AOAT
, AK_OBJECT_ATTRIBUTES AOA
, OE_AK_OBJ_ATTR_EXT OAOAE
WHERE AOAT.LANGUAGE = USERENV('LANG')
AND AOA.ATTRIBUTE_APPLICATION_ID = AOAT. ATTRIBUTE_APPLICATION_ID
AND AOA.ATTRIBUTE_CODE = AOAT. ATTRIBUTE_CODE
AND AOA.DATABASE_OBJECT_NAME = AOAT.DATABASE_OBJECT_NAME
AND OAOAE. PRICING_RULE_ENABLED_FLAG = 'Y'
AND OAOAE.ATTRIBUTE_APPLICATION_ID = AOA. ATTRIBUTE_APPLICATION_ID
AND OAOAE.ATTRIBUTE_CODE = AOA. ATTRIBUTE_CODE
AND OAOAE.DATABASE_OBJECT_NAME = AOA.DATABASE_OBJECT_NAME

Columns