VIEW: APPS.QP_ARCH_SECND_PRICE_LISTS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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