VIEW: APPS.QPFV_QUALIFIERS

Source

View Text - Preformatted

SELECT LIST_HEADER_ID ,LIST_LINE_ID ,QUALIFIER_CONTEXT ,QP_QP_Form_Pricing_Attr.Get_Attribute('QP_ATTR_DEFNS_QUALIFIER',QUALIFIER_CONTEXT,QUALIFIER_ATTRIBUTE) ,QP_QP_Form_Pricing_Attr.Get_Attribute_Value('QP_ATTR_DEFNS_QUALIFIER',QUALIFIER_CONTEXT,QUALIFIER_ATTRIBUTE,QUALIFIER_ATTR_VALUE) ,QP_QP_Form_Pricing_Attr.Get_Attribute_Value('QP_ATTR_DEFNS_QUALIFIER',QUALIFIER_CONTEXT,QUALIFIER_ATTRIBUTE,QUALIFIER_ATTR_VALUE_TO) ,QUALIFIER_GROUPING_NO ,START_DATE_ACTIVE ,END_DATE_ACTIVE ,CREATED_FROM_RULE_ID ,QUALIFIER_PRECEDENCE ,COMPARISON_OPERATOR_CODE ,'_LA:COMPARISON_OPERATOR_CODE:QP_LOOKUPS:COMPARISON_OPERATOR:MEANING' ,QUALIFIER_ID ,CREATION_DATE ,CREATED_BY ,LAST_UPDATE_DATE ,LAST_UPDATED_BY , '_DF:QP:QP_QUALIFIERS:QP_QUALIFIERS' ,ORIG_SYS_HEADER_REF ,ORIG_SYS_LINE_REF ,ORIG_SYS_QUALIFIER_REF from qp_qualifiers WHERE list_header_id is not null WITH READ ONLY

View Text - HTML Formatted

SELECT LIST_HEADER_ID
, LIST_LINE_ID
, QUALIFIER_CONTEXT
, QP_QP_FORM_PRICING_ATTR.GET_ATTRIBUTE('QP_ATTR_DEFNS_QUALIFIER'
, QUALIFIER_CONTEXT
, QUALIFIER_ATTRIBUTE)
, QP_QP_FORM_PRICING_ATTR.GET_ATTRIBUTE_VALUE('QP_ATTR_DEFNS_QUALIFIER'
, QUALIFIER_CONTEXT
, QUALIFIER_ATTRIBUTE
, QUALIFIER_ATTR_VALUE)
, QP_QP_FORM_PRICING_ATTR.GET_ATTRIBUTE_VALUE('QP_ATTR_DEFNS_QUALIFIER'
, QUALIFIER_CONTEXT
, QUALIFIER_ATTRIBUTE
, QUALIFIER_ATTR_VALUE_TO)
, QUALIFIER_GROUPING_NO
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, CREATED_FROM_RULE_ID
, QUALIFIER_PRECEDENCE
, COMPARISON_OPERATOR_CODE
, '_LA:COMPARISON_OPERATOR_CODE:QP_LOOKUPS:COMPARISON_OPERATOR:MEANING'
, QUALIFIER_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, '_DF:QP:QP_QUALIFIERS:QP_QUALIFIERS'
, ORIG_SYS_HEADER_REF
, ORIG_SYS_LINE_REF
, ORIG_SYS_QUALIFIER_REF
FROM QP_QUALIFIERS
WHERE LIST_HEADER_ID IS NOT NULL WITH READ ONLY