VIEW: APPS.QP_SECONDARY_PRICE_LISTS_V

Source

View Text - Preformatted

SELECT QPHB.ROWID, QPHB.LIST_HEADER_ID, QPQR.QUALIFIER_ATTR_VALUE, QPQR.CREATION_DATE, QPQR.CREATED_BY, QPQR.LAST_UPDATE_DATE, QPQR.LAST_UPDATED_BY, QPQR.LAST_UPDATE_LOGIN, QPHB.PROGRAM_APPLICATION_ID, QPHB.PROGRAM_ID, QPHB.PROGRAM_UPDATE_DATE, QPHB.REQUEST_ID, QPHT.NAME, QPHT.DESCRIPTION, QPHB.COMMENTS, QPQR.QUALIFIER_PRECEDENCE, QPHB.START_DATE_ACTIVE, QPHB.END_DATE_ACTIVE, QPHB.LIST_TYPE_CODE, QPHB.TERMS_ID, QPHB.ROUNDING_FACTOR, QPHB.CURRENCY_CODE, QPHB.SHIP_METHOD_CODE, QPHB.FREIGHT_TERMS_CODE, QPQR.CONTEXT, QPQR.ATTRIBUTE1, QPQR.ATTRIBUTE2, QPQR.ATTRIBUTE3, QPQR.ATTRIBUTE4, QPQR.ATTRIBUTE5, QPQR.ATTRIBUTE6, QPQR.ATTRIBUTE7, QPQR.ATTRIBUTE8, QPQR.ATTRIBUTE9, QPQR.ATTRIBUTE10, QPQR.ATTRIBUTE11, QPQR.ATTRIBUTE12, QPQR.ATTRIBUTE13, QPQR.ATTRIBUTE14, QPQR.ATTRIBUTE15, QPQR.QUALIFIER_ID, QPQR.EXCLUDER_FLAG, QPQR.COMPARISON_OPERATOR_CODE, QPQR.QUALIFIER_CONTEXT, QPQR.QUALIFIER_ATTRIBUTE, QPQR.QUALIFIER_ATTR_VALUE, QPQR.QUALIFIER_GROUPING_NO FROM QP_LIST_HEADERS_B QPHB, QP_LIST_HEADERS_TL QPHT, QP_QUALIFIERS QPQR WHERE QPHB.LIST_HEADER_ID = QPHT.LIST_HEADER_ID AND QPHT.LANGUAGE = userenv('LANG') AND TO_CHAR(QPHB.LIST_HEADER_ID) <> QPQR.QUALIFIER_ATTR_VALUE AND QPHB.LIST_HEADER_ID = QPQR.LIST_HEADER_ID AND QPHB.LIST_TYPE_CODE = 'PRL' AND QPQR.QUALIFIER_RULE_ID IS NULL AND ( ( QPQR.QUALIFIER_CONTEXT = 'MODLIST' AND QPQR.QUALIFIER_ATTRIBUTE = 'QUALIFIER_ATTRIBUTE4') OR ( QPQR.QUALIFIER_CONTEXT = 'ORDER' AND QPQR.QUALIFIER_ATTRIBUTE = 'QUALIFIER_ATTRIBUTE11') )

View Text - HTML Formatted

SELECT QPHB.ROWID
, QPHB.LIST_HEADER_ID
, QPQR.QUALIFIER_ATTR_VALUE
, QPQR.CREATION_DATE
, QPQR.CREATED_BY
, QPQR.LAST_UPDATE_DATE
, QPQR.LAST_UPDATED_BY
, QPQR.LAST_UPDATE_LOGIN
, QPHB.PROGRAM_APPLICATION_ID
, QPHB.PROGRAM_ID
, QPHB.PROGRAM_UPDATE_DATE
, QPHB.REQUEST_ID
, QPHT.NAME
, QPHT.DESCRIPTION
, QPHB.COMMENTS
, QPQR.QUALIFIER_PRECEDENCE
, QPHB.START_DATE_ACTIVE
, QPHB.END_DATE_ACTIVE
, QPHB.LIST_TYPE_CODE
, QPHB.TERMS_ID
, QPHB.ROUNDING_FACTOR
, QPHB.CURRENCY_CODE
, QPHB.SHIP_METHOD_CODE
, QPHB.FREIGHT_TERMS_CODE
, QPQR.CONTEXT
, QPQR.ATTRIBUTE1
, QPQR.ATTRIBUTE2
, QPQR.ATTRIBUTE3
, QPQR.ATTRIBUTE4
, QPQR.ATTRIBUTE5
, QPQR.ATTRIBUTE6
, QPQR.ATTRIBUTE7
, QPQR.ATTRIBUTE8
, QPQR.ATTRIBUTE9
, QPQR.ATTRIBUTE10
, QPQR.ATTRIBUTE11
, QPQR.ATTRIBUTE12
, QPQR.ATTRIBUTE13
, QPQR.ATTRIBUTE14
, QPQR.ATTRIBUTE15
, QPQR.QUALIFIER_ID
, QPQR.EXCLUDER_FLAG
, QPQR.COMPARISON_OPERATOR_CODE
, QPQR.QUALIFIER_CONTEXT
, QPQR.QUALIFIER_ATTRIBUTE
, QPQR.QUALIFIER_ATTR_VALUE
, QPQR.QUALIFIER_GROUPING_NO
FROM QP_LIST_HEADERS_B QPHB
, QP_LIST_HEADERS_TL QPHT
, QP_QUALIFIERS QPQR
WHERE QPHB.LIST_HEADER_ID = QPHT.LIST_HEADER_ID
AND QPHT.LANGUAGE = USERENV('LANG')
AND TO_CHAR(QPHB.LIST_HEADER_ID) <> QPQR.QUALIFIER_ATTR_VALUE
AND QPHB.LIST_HEADER_ID = QPQR.LIST_HEADER_ID
AND QPHB.LIST_TYPE_CODE = 'PRL'
AND QPQR.QUALIFIER_RULE_ID IS NULL
AND ( ( QPQR.QUALIFIER_CONTEXT = 'MODLIST'
AND QPQR.QUALIFIER_ATTRIBUTE = 'QUALIFIER_ATTRIBUTE4') OR ( QPQR.QUALIFIER_CONTEXT = 'ORDER'
AND QPQR.QUALIFIER_ATTRIBUTE = 'QUALIFIER_ATTRIBUTE11') )