Product: | OKS - Service Contracts |
---|---|
Description: | Used for Pricing Qualifier setup for Service Authoring |
Implementation/DBA Data: | APPS.OKS_QUALIFIERS_V |
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