VIEW: APPS.PO_MANUAL_MODIFIERS_V

Source

View Text - Preformatted

SELECT qh.name, qh.description, ldets.list_line_type_code, flv.meaning, NVL(ldets.automatic_flag,'N'), qline.line_id, ldets.list_header_id, ldets.list_line_id, rldets.list_line_id, NULL, ldets.override_flag, NULL, NVL(ldets.order_qty_operand,DECODE(ldets.operand_calculation_code,'%',ldets.operand_value, 'LUMPSUM',ldets.operand_value, ldets.operand_value * qline.priced_quantity / NVL(qline.line_quantity,1))), ldets.operand_calculation_code, NVL(ldets.order_qty_adj_amt,ldets.adjustment_amount * NVL(qline.priced_quantity,1) / NVL(qline.line_quantity,1)), ldets.pricing_phase_id, ldets.charge_type_code, ldets.charge_subtype_code, ldets.list_line_no, qh.source_system_code, ldets.expiration_date, ldets.rebate_transaction_type_code, ldets.accrual_flag, ldets.line_quantity, ldets.accrual_conversion_rate, ldets.pricing_group_sequence, ldets.modifier_level_code, ldets.price_break_type_code, ldets.include_on_returns_flag, ldets.operand_value, ldets.adjustment_amount, ldets.line_index, ldets.line_detail_index, ldets.line_detail_type_code FROM qp_ldets_v ldets, qp_preq_lines_tmp qline, qp_list_headers qh, fnd_lookup_values_vl flv, qp_preq_rltd_lines_tmp rltd, qp_ldets_v rldets WHERE ldets.list_header_id = qh.list_header_id AND qline.process_status <> 'NOT_VALID' AND ldets.line_index = qline.line_index AND NVL(ldets.automatic_flag,'N') = 'N' AND ldets.created_from_list_type_code NOT IN ('PRL','AGR') AND ldets.list_line_type_code <> 'PLL' AND flv.lookup_type = 'LIST_LINE_TYPE_CODE' AND flv.lookup_code = ldets.list_line_type_code AND ldets.line_index = rltd.related_line_index (+) AND ldets.line_detail_index = rltd.related_line_detail_index (+) AND rltd.line_index = rldets.line_index (+) AND rltd.line_detail_index = rldets.line_detail_index (+) AND rltd.relationship_type_code (+) = 'PBH_LINE'

View Text - HTML Formatted

SELECT QH.NAME
, QH.DESCRIPTION
, LDETS.LIST_LINE_TYPE_CODE
, FLV.MEANING
, NVL(LDETS.AUTOMATIC_FLAG
, 'N')
, QLINE.LINE_ID
, LDETS.LIST_HEADER_ID
, LDETS.LIST_LINE_ID
, RLDETS.LIST_LINE_ID
, NULL
, LDETS.OVERRIDE_FLAG
, NULL
, NVL(LDETS.ORDER_QTY_OPERAND
, DECODE(LDETS.OPERAND_CALCULATION_CODE
, '%'
, LDETS.OPERAND_VALUE
, 'LUMPSUM'
, LDETS.OPERAND_VALUE
, LDETS.OPERAND_VALUE * QLINE.PRICED_QUANTITY / NVL(QLINE.LINE_QUANTITY
, 1)))
, LDETS.OPERAND_CALCULATION_CODE
, NVL(LDETS.ORDER_QTY_ADJ_AMT
, LDETS.ADJUSTMENT_AMOUNT * NVL(QLINE.PRICED_QUANTITY
, 1) / NVL(QLINE.LINE_QUANTITY
, 1))
, LDETS.PRICING_PHASE_ID
, LDETS.CHARGE_TYPE_CODE
, LDETS.CHARGE_SUBTYPE_CODE
, LDETS.LIST_LINE_NO
, QH.SOURCE_SYSTEM_CODE
, LDETS.EXPIRATION_DATE
, LDETS.REBATE_TRANSACTION_TYPE_CODE
, LDETS.ACCRUAL_FLAG
, LDETS.LINE_QUANTITY
, LDETS.ACCRUAL_CONVERSION_RATE
, LDETS.PRICING_GROUP_SEQUENCE
, LDETS.MODIFIER_LEVEL_CODE
, LDETS.PRICE_BREAK_TYPE_CODE
, LDETS.INCLUDE_ON_RETURNS_FLAG
, LDETS.OPERAND_VALUE
, LDETS.ADJUSTMENT_AMOUNT
, LDETS.LINE_INDEX
, LDETS.LINE_DETAIL_INDEX
, LDETS.LINE_DETAIL_TYPE_CODE
FROM QP_LDETS_V LDETS
, QP_PREQ_LINES_TMP QLINE
, QP_LIST_HEADERS QH
, FND_LOOKUP_VALUES_VL FLV
, QP_PREQ_RLTD_LINES_TMP RLTD
, QP_LDETS_V RLDETS
WHERE LDETS.LIST_HEADER_ID = QH.LIST_HEADER_ID
AND QLINE.PROCESS_STATUS <> 'NOT_VALID'
AND LDETS.LINE_INDEX = QLINE.LINE_INDEX
AND NVL(LDETS.AUTOMATIC_FLAG
, 'N') = 'N'
AND LDETS.CREATED_FROM_LIST_TYPE_CODE NOT IN ('PRL'
, 'AGR')
AND LDETS.LIST_LINE_TYPE_CODE <> 'PLL'
AND FLV.LOOKUP_TYPE = 'LIST_LINE_TYPE_CODE'
AND FLV.LOOKUP_CODE = LDETS.LIST_LINE_TYPE_CODE
AND LDETS.LINE_INDEX = RLTD.RELATED_LINE_INDEX (+)
AND LDETS.LINE_DETAIL_INDEX = RLTD.RELATED_LINE_DETAIL_INDEX (+)
AND RLTD.LINE_INDEX = RLDETS.LINE_INDEX (+)
AND RLTD.LINE_DETAIL_INDEX = RLDETS.LINE_DETAIL_INDEX (+)
AND RLTD.RELATIONSHIP_TYPE_CODE (+) = 'PBH_LINE'