View: QP_DEBUG_REQ_RLTD_LINES_V

Product:	QP - Advanced Pricing
Description:	View that joins QP_DEBUG_REQ_LDETS and QP_DEBUG_REQ_RLTD_LINES. It contains information about the related lines.
Implementation/DBA Data:	APPS.QP_DEBUG_REQ_RLTD_LINES_V

View Text

SELECT A.REQUEST_ID
, A.REQUEST_TYPE_CODE
, B.LINE_INDEX
, A.LINE_DETAIL_INDEX
, A.RELATIONSHIP_TYPE_CODE
, B.CREATED_FROM_LIST_HEADER_ID LIST_HEADER_ID
, B.CREATED_FROM_LIST_TYPE_CODE LIST_TYPE_CODE
, B.CREATED_FROM_LIST_LINE_ID LIST_LINE_ID
, B.CREATED_FROM_LIST_LINE_TYPE LIST_LINE_TYPE_CODE
, B.OPERAND_CALCULATION_CODE ARITHMETIC_OPERATOR
, B.OPERAND_VALUE
FROM QP_DEBUG_REQ_RLTD_LINES A
, QP_DEBUG_REQ_LDETS B
WHERE A.REQUEST_ID = B.REQUEST_ID
AND A.LINE_DETAIL_INDEX = B.LINE_DETAIL_INDEX UNION SELECT A.REQUEST_ID
, A.REQUEST_TYPE_CODE
, B.LINE_INDEX
, A.RELATED_LINE_DETAIL_INDEX LINE_DETAIL_INDEX
, A.RELATIONSHIP_TYPE_CODE
, B.CREATED_FROM_LIST_HEADER_ID LIST_HEADER_ID
, B.CREATED_FROM_LIST_TYPE_CODE LIST_TYPE_CODE
, B.CREATED_FROM_LIST_LINE_ID LIST_LINE_ID
, B.CREATED_FROM_LIST_LINE_TYPE LIST_LINE_TYPE_CODE
, B.OPERAND_CALCULATION_CODE ARITHMETIC_OPERATOR
, B.OPERAND_VALUE
FROM QP_DEBUG_REQ_RLTD_LINES A
, QP_DEBUG_REQ_LDETS B
WHERE A.REQUEST_ID = B.REQUEST_ID
AND A.RELATED_LINE_DETAIL_INDEX = B.LINE_DETAIL_INDEX

Columns