DBA Data[Home] [Help] [Dependency Information]

VIEW: QP.QP_DEBUG_REQ_RLTD_LINES#

Object Details
Object Name: QP_DEBUG_REQ_RLTD_LINES#
Object Type: VIEW
Owner: QP
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
REQUEST_ID NUMBER
Yes
REQUEST_TYPE_CODE VARCHAR2 (30)
LINE_INDEX NUMBER

LINE_DETAIL_INDEX NUMBER

RELATIONSHIP_TYPE_CODE VARCHAR2 (30)
RELATED_LINE_INDEX NUMBER

RELATED_LINE_DETAIL_INDEX NUMBER

PRICING_STATUS_CODE VARCHAR2 (30)
PRICING_STATUS_TEXT VARCHAR2 (240)
LIST_LINE_ID NUMBER

RELATED_LIST_LINE_ID NUMBER

RELATED_LIST_LINE_TYPE VARCHAR2 (30)
OPERAND_CALCULATION_CODE VARCHAR2 (30)
OPERAND NUMBER

PRICING_GROUP_SEQUENCE NUMBER

RELATIONSHIP_TYPE_DETAIL VARCHAR2 (30)
SETUP_VALUE_FROM NUMBER

SETUP_VALUE_TO NUMBER

QUALIFIER_VALUE NUMBER

ADJUSTMENT_AMOUNT NUMBER

SATISFIED_RANGE_VALUE NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT REQUEST_ID
,      REQUEST_TYPE_CODE
,      LINE_INDEX
,      LINE_DETAIL_INDEX
,      RELATIONSHIP_TYPE_CODE
,      RELATED_LINE_INDEX
,      RELATED_LINE_DETAIL_INDEX
,      PRICING_STATUS_CODE
,      PRICING_STATUS_TEXT
,      LIST_LINE_ID
,      RELATED_LIST_LINE_ID
,      RELATED_LIST_LINE_TYPE
,      OPERAND_CALCULATION_CODE
,      OPERAND
,      PRICING_GROUP_SEQUENCE
,      RELATIONSHIP_TYPE_DETAIL
,      SETUP_VALUE_FROM
,      SETUP_VALUE_TO
,      QUALIFIER_VALUE
,      ADJUSTMENT_AMOUNT
,      SATISFIED_RANGE_VALUE
FROM QP.QP_DEBUG_REQ_RLTD_LINES#;

Dependencies

[top of page]

QP.QP_DEBUG_REQ_RLTD_LINES# references the following:

SchemaQP
TableQP_DEBUG_REQ_RLTD_LINES
QP.QP_DEBUG_REQ_RLTD_LINES# is referenced by following:

SchemaAPPS
SynonymQP_DEBUG_REQ_RLTD_LINES