Product: | ONT - Order Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.OE_DEF_ATTR_RULES_V |
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.DATABASE_OBJECT_NAME = C.DATABASE_OBJECT_NAME
AND R.ATTRIBUTE_CODE = A.ATTRIBUTE_CODE