VIEW: APPS.OE_ATTACHMENT_RULE_ELEMENTS_V

Source

View Text - Preformatted

SELECT oare.rowid ,oare.rule_element_id ,oare.rule_id ,oare.group_number ,oare.attribute_code ,aka.attribute_label_long ,oare.attribute_value ,aka.column_name ,aka.data_type ,oare.creation_date ,oare.created_by ,oare.last_update_date ,oare.last_updated_by ,oare.last_update_login ,oare.context ,oare.attribute1 ,oare.attribute2 ,oare.attribute3 ,oare.attribute4 ,oare.attribute5 ,oare.attribute6 ,oare.attribute7 ,oare.attribute8 ,oare.attribute9 ,oare.attribute10 ,oare.attribute11 ,oare.attribute12 ,oare.attribute13 ,oare.attribute14 ,oare.attribute15 FROM oe_attachment_rules oar, oe_attachment_rule_elements oare, ak_object_attributes_vl aka WHERE oar.rule_id = oare.rule_id AND oar.database_object_name = aka.database_object_name AND oare.attribute_code = aka.attribute_code

View Text - HTML Formatted

SELECT OARE.ROWID
, OARE.RULE_ELEMENT_ID
, OARE.RULE_ID
, OARE.GROUP_NUMBER
, OARE.ATTRIBUTE_CODE
, AKA.ATTRIBUTE_LABEL_LONG
, OARE.ATTRIBUTE_VALUE
, AKA.COLUMN_NAME
, AKA.DATA_TYPE
, OARE.CREATION_DATE
, OARE.CREATED_BY
, OARE.LAST_UPDATE_DATE
, OARE.LAST_UPDATED_BY
, OARE.LAST_UPDATE_LOGIN
, OARE.CONTEXT
, OARE.ATTRIBUTE1
, OARE.ATTRIBUTE2
, OARE.ATTRIBUTE3
, OARE.ATTRIBUTE4
, OARE.ATTRIBUTE5
, OARE.ATTRIBUTE6
, OARE.ATTRIBUTE7
, OARE.ATTRIBUTE8
, OARE.ATTRIBUTE9
, OARE.ATTRIBUTE10
, OARE.ATTRIBUTE11
, OARE.ATTRIBUTE12
, OARE.ATTRIBUTE13
, OARE.ATTRIBUTE14
, OARE.ATTRIBUTE15
FROM OE_ATTACHMENT_RULES OAR
, OE_ATTACHMENT_RULE_ELEMENTS OARE
, AK_OBJECT_ATTRIBUTES_VL AKA
WHERE OAR.RULE_ID = OARE.RULE_ID
AND OAR.DATABASE_OBJECT_NAME = AKA.DATABASE_OBJECT_NAME
AND OARE.ATTRIBUTE_CODE = AKA.ATTRIBUTE_CODE