Product: | ONT - Order Management |
---|---|
Description: | This view stores the elements of the attachment rules. |
Implementation/DBA Data: | APPS.OE_ATTACHMENT_RULE_ELEMENTS_V |
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