View: QP_QUALIFIERS_V

Product:	QP - Advanced Pricing
Description:	View of Qualifier information
Implementation/DBA Data:	APPS.QP_QUALIFIERS_V

View Text

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

Columns