[Home] [Help]
9648: ldets_v.OVERRIDE_FLAG,
9649: ldets_v.operand_value,
9650: ldets_v.adjustment_amount
9651: FROM QP_PREQ_LINES_TMP lines,
9652: QP_LDETS_V ldets_v
9653: WHERE lines.line_index = ldets_v.line_index
9654: AND lines.process_status IN (QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_UNCHANGED)
9655: AND ldets_v.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
9656: AND ldets_v.process_code = QP_PREQ_GRP.G_STATUS_NEW
9966: ldets_v.OVERRIDE_FLAG,
9967: ldets_v.operand_value,
9968: ldets_v.adjustment_amount
9969: FROM QP_PREQ_LINES_TMP lines,
9970: QP_LDETS_V ldets_v
9971: WHERE lines.line_index = ldets_v.line_index
9972: AND ldets_v.modifier_level_code = 'LINE'
9973: AND lines.process_status IN (QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_UNCHANGED)
9974: AND nvl(ldets_v.Calculation_code,'X') <> QP_PREQ_PUB.G_FREEGOOD
10221: ldets_v.OVERRIDE_FLAG,
10222: ldets_v.operand_value,
10223: ldets_v.adjustment_amount
10224: FROM QP_PREQ_LINES_TMP lines,
10225: QP_LDETS_V ldets_v
10226: WHERE lines.line_index = ldets_v.line_index
10227: AND lines.process_status IN (QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_UNCHANGED)
10228: AND ldets_v.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
10229: AND ldets_v.process_code = QP_PREQ_GRP.G_STATUS_NEW
10387: ldets_v.OVERRIDE_FLAG,
10388: ldets_v.operand_value,
10389: ldets_v.adjustment_amount
10390: FROM QP_PREQ_LINES_TMP lines,
10391: QP_LDETS_V ldets_v
10392: WHERE lines.line_index = ldets_v.line_index
10393: AND ldets_v.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
10394: AND ldets_v.process_code = QP_PREQ_GRP.G_STATUS_NEW
10395: AND nvl(ldets_v.created_from_list_type_code,'X') not in ('PRL','AGR')
10882: PRICE_ADJUSTMENT_ID,
10883: NET_AMOUNT_FLAG,
10884: ORDER_QTY_OPERAND,
10885: ORDER_QTY_ADJ_AMT
10886: FROM QP_LDETS_V
10887: WHERE line_index = l_line_index
10888: AND line_detail_index = l_line_detail_index;
10889:
10890: CURSOR C_ADJ_ATTR_DTL(l_line_index NUMBER, l_line_detail_index NUMBER) IS