eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: QP.QP_INT_RLTD_LINES_T#

Source

View Text - Preformatted


select REQUEST_TYPE_CODE REQUEST_TYPE_CODE, LINE_INDEX LINE_INDEX, LINE_DETAIL_INDEX LINE_DETAIL_INDEX, RELATIONSHIP_TYPE_CODE RELATIONSHIP_TYPE_CODE, RELATED_LINE_INDEX RELATED_LINE_INDEX, RELATED_LINE_DETAIL_INDEX RELATED_LINE_DETAIL_INDEX, PRICING_STATUS_CODE PRICING_STATUS_CODE, PRICING_STATUS_TEXT PRICING_STATUS_TEXT, LIST_LINE_ID LIST_LINE_ID, RELATED_LIST_LINE_ID RELATED_LIST_LINE_ID, RELATED_LIST_LINE_TYPE RELATED_LIST_LINE_TYPE, OPERAND_CALCULATION_CODE OPERAND_CALCULATION_CODE, OPERAND OPERAND, PRICING_GROUP_SEQUENCE PRICING_GROUP_SEQUENCE, RELATIONSHIP_TYPE_DETAIL RELATIONSHIP_TYPE_DETAIL, SETUP_VALUE_FROM SETUP_VALUE_FROM, SETUP_VALUE_TO SETUP_VALUE_TO, QUALIFIER_VALUE QUALIFIER_VALUE, ADJUSTMENT_AMOUNT ADJUSTMENT_AMOUNT, SATISFIED_RANGE_VALUE SATISFIED_RANGE_VALUE, REQUEST_ID REQUEST_ID, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN from "QP"."QP_INT_RLTD_LINES_T"

View Text - HTML Formatted

SELECT REQUEST_TYPE_CODE REQUEST_TYPE_CODE
, LINE_INDEX LINE_INDEX
, LINE_DETAIL_INDEX LINE_DETAIL_INDEX
, RELATIONSHIP_TYPE_CODE RELATIONSHIP_TYPE_CODE
, RELATED_LINE_INDEX RELATED_LINE_INDEX
, RELATED_LINE_DETAIL_INDEX RELATED_LINE_DETAIL_INDEX
, PRICING_STATUS_CODE PRICING_STATUS_CODE
, PRICING_STATUS_TEXT PRICING_STATUS_TEXT
, LIST_LINE_ID LIST_LINE_ID
, RELATED_LIST_LINE_ID RELATED_LIST_LINE_ID
, RELATED_LIST_LINE_TYPE RELATED_LIST_LINE_TYPE
, OPERAND_CALCULATION_CODE OPERAND_CALCULATION_CODE
, OPERAND OPERAND
, PRICING_GROUP_SEQUENCE PRICING_GROUP_SEQUENCE
, RELATIONSHIP_TYPE_DETAIL RELATIONSHIP_TYPE_DETAIL
, SETUP_VALUE_FROM SETUP_VALUE_FROM
, SETUP_VALUE_TO SETUP_VALUE_TO
, QUALIFIER_VALUE QUALIFIER_VALUE
, ADJUSTMENT_AMOUNT ADJUSTMENT_AMOUNT
, SATISFIED_RANGE_VALUE SATISFIED_RANGE_VALUE
, REQUEST_ID REQUEST_ID
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM "QP"."QP_INT_RLTD_LINES_T"