VIEW: APPS.OE_PRICING_ENTITIES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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