VIEW: APPS.OE_DEF_ATTR_DEF_RULES_V

Source

View Text - Preformatted

SELECT r.rowid row_id, r.attr_def_rule_id ,r.attr_def_condition_id ,c.condition_id ,r.created_by ,r.creation_date ,r.last_updated_by ,r.last_update_date ,r.database_object_name ,r.attribute_code ,a.column_name ,a.attribute_application_id ,a.attribute_label_long ,r.sequence_no ,r.src_type ,r.system_flag ,r.permanent_flag ,r.src_api_pkg ,r.src_api_fn ,r.src_profile_option ,r.src_constant_value ,r.src_system_variable_expr ,r.src_parameter_name ,r.src_foreign_key_name ,r.src_database_object_name ,r.src_attribute_code ,r.src_sequence_name ,r.last_update_login ,r.attribute_category ,r.attribute1 ,r.attribute2 ,r.attribute3 ,r.attribute4 ,r.attribute5 ,r.attribute6 ,r.attribute7 ,r.attribute8 ,r.attribute9 ,r.attribute10 ,r.attribute11 ,r.attribute12 ,r.attribute13 ,r.attribute14 ,r.attribute15 from oe_def_attr_def_rules r, oe_Def_attr_condns c, ak_object_attributes_vl a WHERE r.attr_def_condition_id = c.attr_def_condition_id and r.database_object_name = a.database_object_name and r.attribute_code = a.attribute_code

View Text - HTML Formatted

SELECT R.ROWID ROW_ID
, R.ATTR_DEF_RULE_ID
, R.ATTR_DEF_CONDITION_ID
, C.CONDITION_ID
, R.CREATED_BY
, R.CREATION_DATE
, R.LAST_UPDATED_BY
, R.LAST_UPDATE_DATE
, R.DATABASE_OBJECT_NAME
, R.ATTRIBUTE_CODE
, A.COLUMN_NAME
, A.ATTRIBUTE_APPLICATION_ID
, A.ATTRIBUTE_LABEL_LONG
, R.SEQUENCE_NO
, R.SRC_TYPE
, R.SYSTEM_FLAG
, R.PERMANENT_FLAG
, R.SRC_API_PKG
, R.SRC_API_FN
, R.SRC_PROFILE_OPTION
, R.SRC_CONSTANT_VALUE
, R.SRC_SYSTEM_VARIABLE_EXPR
, R.SRC_PARAMETER_NAME
, R.SRC_FOREIGN_KEY_NAME
, R.SRC_DATABASE_OBJECT_NAME
, R.SRC_ATTRIBUTE_CODE
, R.SRC_SEQUENCE_NAME
, R.LAST_UPDATE_LOGIN
, R.ATTRIBUTE_CATEGORY
, R.ATTRIBUTE1
, R.ATTRIBUTE2
, R.ATTRIBUTE3
, R.ATTRIBUTE4
, R.ATTRIBUTE5
, R.ATTRIBUTE6
, R.ATTRIBUTE7
, R.ATTRIBUTE8
, R.ATTRIBUTE9
, R.ATTRIBUTE10
, R.ATTRIBUTE11
, R.ATTRIBUTE12
, R.ATTRIBUTE13
, R.ATTRIBUTE14
, R.ATTRIBUTE15
FROM OE_DEF_ATTR_DEF_RULES R
, OE_DEF_ATTR_CONDNS C
, AK_OBJECT_ATTRIBUTES_VL A
WHERE R.ATTR_DEF_CONDITION_ID = C.ATTR_DEF_CONDITION_ID
AND R.DATABASE_OBJECT_NAME = A.DATABASE_OBJECT_NAME
AND R.ATTRIBUTE_CODE = A.ATTRIBUTE_CODE