FND Design Data [Home] [Help]

View: QP_QUALIFIER_RULES_V

Product: QP - Advanced Pricing
Description: View of Qualifier Rule information
Implementation/DBA Data: ViewAPPS.QP_QUALIFIER_RULES_V
View Text

SELECT QR.ROWID
, QR.QUALIFIER_RULE_ID
, QR.CREATION_DATE
, QR.CREATED_BY
, QR.LAST_UPDATE_DATE
, QR.LAST_UPDATED_BY
, QR.LAST_UPDATE_LOGIN
, QR.PROGRAM_APPLICATION_ID
, QR.PROGRAM_ID
, QR.PROGRAM_UPDATE_DATE
, QR.REQUEST_ID
, QR.NAME
, QR.DESCRIPTION
, QR.CONTEXT
, QR.ATTRIBUTE1
, QR.ATTRIBUTE2
, QR.ATTRIBUTE3
, QR.ATTRIBUTE4
, QR.ATTRIBUTE5
, QR.ATTRIBUTE6
, QR.ATTRIBUTE7
, QR.ATTRIBUTE8
, QR.ATTRIBUTE9
, QR.ATTRIBUTE10
, QR.ATTRIBUTE11
, QR.ATTRIBUTE12
, QR.ATTRIBUTE13
, QR.ATTRIBUTE14
, QR.ATTRIBUTE15
, QQ.QUALIFIER_ID
, QQ.COMPARISON_OPERATOR_CODE
, QQ.QUALIFIER_CONTEXT
, QQ.QUALIFIER_ATTRIBUTE
, QQ.QUALIFIER_GROUPING_NO
, QQ.QUALIFIER_ATTR_VALUE
, QQ.QUALIFIER_ATTR_VALUE_TO
, QQ.START_DATE_ACTIVE
, QQ.END_DATE_ACTIVE
, QQ.QUALIFIER_DATATYPE
, QQ.QUALIFIER_PRECEDENCE
FROM QP_QUALIFIER_RULES QR
, QP_QUALIFIERS QQ
WHERE QR.QUALIFIER_RULE_ID = QQ.QUALIFIER_RULE_ID

Columns

Name
ROW_ID
QUALIFIER_RULE_ID
CREATION_DATE
CREATED_BY
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
REQUEST_ID
NAME
DESCRIPTION
CONTEXT
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
QUALIFIER_ID
COMPARISON_OPERATOR_CODE
QUALIFIER_CONTEXT
QUALIFIER_ATTRIBUTE
QUALIFIER_GROUPING_NO
QUALIFIER_ATTR_VALUE
QUALIFIER_ATTR_VALUE_TO
START_DATE_ACTIVE
END_DATE_ACTIVE
QUALIFIER_DATATYPE
QUALIFIER_PRECEDENCE