DBA Data[Home] [Help]

VIEW: APPS.QP_DEBUG_REQ_PROD_LINE_ATTRS_V

Source

View Text - Preformatted

SELECT ROWID ROW_ID, REQUEST_ID, LINE_INDEX, LINE_DETAIL_INDEX, LINE_ATTRIBUTE_ID, ATTRIBUTE_LEVEL, ATTRIBUTE_TYPE, LIST_HEADER_ID, LIST_LINE_ID, CONTEXT, ATTRIBUTE, VALUE_FROM, SETUP_VALUE_FROM, SETUP_VALUE_TO, APPLIED_FLAG, PRICING_STATUS_CODE, PRICING_STATUS_TEXT, QUALIFIER_PRECEDENCE, DATATYPE, PRODUCT_UOM_CODE, PROCESSED_CODE, EXCLUDER_FLAG, GROUP_QUANTITY, GROUP_AMOUNT, PRIMARY_UOM_FLAG FROM QP_DEBUG_REQ_LINE_ATTRS WHERE ATTRIBUTE_TYPE='PRODUCT'
View Text - HTML Formatted

SELECT ROWID ROW_ID
, REQUEST_ID
, LINE_INDEX
, LINE_DETAIL_INDEX
, LINE_ATTRIBUTE_ID
, ATTRIBUTE_LEVEL
, ATTRIBUTE_TYPE
, LIST_HEADER_ID
, LIST_LINE_ID
, CONTEXT
, ATTRIBUTE
, VALUE_FROM
, SETUP_VALUE_FROM
, SETUP_VALUE_TO
, APPLIED_FLAG
, PRICING_STATUS_CODE
, PRICING_STATUS_TEXT
, QUALIFIER_PRECEDENCE
, DATATYPE
, PRODUCT_UOM_CODE
, PROCESSED_CODE
, EXCLUDER_FLAG
, GROUP_QUANTITY
, GROUP_AMOUNT
, PRIMARY_UOM_FLAG
FROM QP_DEBUG_REQ_LINE_ATTRS
WHERE ATTRIBUTE_TYPE='PRODUCT'