VIEW: APPS.QP_DEBUG_REQ_RLTD_LINES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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