[Home] [Help]
9631: ldets_v.OVERRIDE_FLAG,
9632: ldets_v.operand_value,
9633: ldets_v.adjustment_amount
9634: FROM QP_PREQ_LINES_TMP lines,
9635: QP_LDETS_V ldets_v
9636: WHERE lines.line_index = ldets_v.line_index
9637: AND lines.process_status IN (QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_UNCHANGED)
9638: AND ldets_v.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
9639: AND ldets_v.process_code = QP_PREQ_GRP.G_STATUS_NEW
9949: ldets_v.OVERRIDE_FLAG,
9950: ldets_v.operand_value,
9951: ldets_v.adjustment_amount
9952: FROM QP_PREQ_LINES_TMP lines,
9953: QP_LDETS_V ldets_v
9954: WHERE lines.line_index = ldets_v.line_index
9955: AND ldets_v.modifier_level_code = 'LINE'
9956: AND lines.process_status IN (QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_UNCHANGED)
9957: AND nvl(ldets_v.Calculation_code,'X') <> QP_PREQ_PUB.G_FREEGOOD
10204: ldets_v.OVERRIDE_FLAG,
10205: ldets_v.operand_value,
10206: ldets_v.adjustment_amount
10207: FROM QP_PREQ_LINES_TMP lines,
10208: QP_LDETS_V ldets_v
10209: WHERE lines.line_index = ldets_v.line_index
10210: AND lines.process_status IN (QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_UNCHANGED)
10211: AND ldets_v.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
10212: AND ldets_v.process_code = QP_PREQ_GRP.G_STATUS_NEW
10370: ldets_v.OVERRIDE_FLAG,
10371: ldets_v.operand_value,
10372: ldets_v.adjustment_amount
10373: FROM QP_PREQ_LINES_TMP lines,
10374: QP_LDETS_V ldets_v
10375: WHERE lines.line_index = ldets_v.line_index
10376: AND ldets_v.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
10377: AND ldets_v.process_code = QP_PREQ_GRP.G_STATUS_NEW
10378: AND nvl(ldets_v.created_from_list_type_code,'X') not in ('PRL','AGR')
10865: PRICE_ADJUSTMENT_ID,
10866: NET_AMOUNT_FLAG,
10867: ORDER_QTY_OPERAND,
10868: ORDER_QTY_ADJ_AMT
10869: FROM QP_LDETS_V
10870: WHERE line_index = l_line_index
10871: AND line_detail_index = l_line_detail_index;
10872:
10873: CURSOR C_ADJ_ATTR_DTL(l_line_index NUMBER, l_line_detail_index NUMBER) IS