FND Design Data [Home] [Help]

View: OKS_QUALIFIERS_V

Product: OKS - Service Contracts
Description: Used for Pricing Qualifier setup for Service Authoring
Implementation/DBA Data: ViewAPPS.OKS_QUALIFIERS_V
View Text

SELECT QUAB.QUALIFIER_ID QUALIFIER_ID
, QUAB.REQUEST_ID REQUEST_ID
, QUAB.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, QUAB.PROGRAM_ID PROGRAM_ID
, QUAB.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, QUAB.QUALIFIER_GROUPING_NO QUALIFIER_GROUPING_NO
, QUAB.QUALIFIER_CONTEXT QUALIFIER_CONTEXT
, QUAB.QUALIFIER_ATTRIBUTE QUALIFIER_ATTRIBUTE
, QUAB.QUALIFIER_ATTR_VALUE QUALIFIER_ATTR_VALUE
, QUAB.COMPARISON_OPERATOR_CODE COMPARISON_OPERATOR_CODE
, QUAB.EXCLUDER_FLAG EXCLUDER_FLAG
, QUAB.QUALIFIER_RULE_ID QUALIFIER_RULE_ID
, QUAB.START_DATE_ACTIVE START_DATE_ACTIVE
, QUAB.END_DATE_ACTIVE END_DATE_ACTIVE
, QUAB.CREATED_FROM_RULE_ID CREATED_FROM_RULE_ID
, QUAB.QUALIFIER_PRECEDENCE QUALIFIER_PRECEDENCE
, QUAB.LIST_HEADER_ID LIST_HEADER_ID
, QUAB.LIST_LINE_ID LIST_LINE_ID
, QUAB.QUALIFIER_DATATYPE QUALIFIER_DATATYPE
, QUAB.QUALIFIER_ATTR_VALUE_TO QUALIFIER_ATTR_VALUE_TO
, QUAB.CREATED_BY CREATED_BY
, QUAB.CREATION_DATE CREATION_DATE
, QUAB.LAST_UPDATED_BY LAST_UPDATED_BY
, QUAB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, QUAB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, QUAB.CONTEXT CONTEXT
, QUAB.ATTRIBUTE1 ATTRIBUTE1
, QUAB.ATTRIBUTE2 ATTRIBUTE2
, QUAB.ATTRIBUTE3 ATTRIBUTE3
, QUAB.ATTRIBUTE4 ATTRIBUTE4
, QUAB.ATTRIBUTE5 ATTRIBUTE5
, QUAB.ATTRIBUTE6 ATTRIBUTE6
, QUAB.ATTRIBUTE7 ATTRIBUTE7
, QUAB.ATTRIBUTE8 ATTRIBUTE8
, QUAB.ATTRIBUTE9 ATTRIBUTE9
, QUAB.ATTRIBUTE10 ATTRIBUTE10
, QUAB.ATTRIBUTE11 ATTRIBUTE11
, QUAB.ATTRIBUTE12 ATTRIBUTE12
, QUAB.ATTRIBUTE13 ATTRIBUTE13
, QUAB.ATTRIBUTE14 ATTRIBUTE14
, QUAB.ATTRIBUTE15 ATTRIBUTE15
, QUAB.ACTIVE_FLAG ACTIVE_FLAG
, QUAB.LIST_TYPE_CODE LIST_TYPE_CODE
, QUAB.QUAL_ATTR_VALUE_FROM_NUMBER QUAL_ATTR_VALUE_FROM_NUMBER
, QUAB.QUAL_ATTR_VALUE_TO_NUMBER QUAL_ATTR_VALUE_TO_NUMBER
FROM OKS_QUALIFIERS QUAB

Columns

Name
QUALIFIER_ID
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
QUALIFIER_GROUPING_NO
QUALIFIER_CONTEXT
QUALIFIER_ATTRIBUTE
QUALIFIER_ATTR_VALUE
COMPARISON_OPERATOR_CODE
EXCLUDER_FLAG
QUALIFIER_RULE_ID
START_DATE_ACTIVE
END_DATE_ACTIVE
CREATED_FROM_RULE_ID
QUALIFIER_PRECEDENCE
LIST_HEADER_ID
LIST_LINE_ID
QUALIFIER_DATATYPE
QUALIFIER_ATTR_VALUE_TO
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
CONTEXT
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
ACTIVE_FLAG
LIST_TYPE_CODE
QUAL_ATTR_VALUE_FROM_NUMBER
QUAL_ATTR_VALUE_TO_NUMBER