[Home] [Help]
1922: , NULL BREAK_UOM_CONTEXT
1923: , NULL BREAK_UOM_ATTRIBUTE
1924: , NULL PROCESS_CODE -- 3215497
1925: FROM qp_int_lines getline, oe_price_adjustments adj,
1926: qp_int_ldets ldet, oe_price_adj_assocs ass
1927: WHERE QP_PREQ_PUB.G_CHECK_CUST_VIEW_FLAG = QP_PREQ_PUB.G_YES
1928: AND ldet.CREATED_FROM_LIST_LINE_TYPE = 'PRG'
1929: AND ass.price_adjustment_id = ldet.price_adjustment_id
1930: AND ass.rltd_price_adj_id = adj.price_adjustment_id
1939: , QP_PREQ_PUB.G_STATUS_GSA_VIOLATION
1940: , QP_PREQ_PUB.G_STATUS_UNCHANGED)
1941: AND getline.price_flag = QP_PREQ_PUB.G_NO
1942: AND adj.price_adjustment_id NOT IN (SELECT price_adjustment_id
1943: FROM qp_int_ldets);
1944: --(getline.price_flag in (QP_PREQ_PUB.G_YES, QP_PREQ_PUB.G_PHASE,QP_PREQ_PUB.G_CALCULATE_ONLY)
1945: --OR nvl(line.processed_code,'0') = QP_PREQ_PUB.G_BY_ENGINE)
1946: --and line.line_type_code = QP_PREQ_PUB.G_LINE_LEVEL
1947:
4147: AND (line.price_flag IN (QP_PREQ_PUB.G_YES, QP_PREQ_PUB.G_PHASE, QP_PREQ_PUB.G_CALCULATE_ONLY)
4148: OR nvl(line.processed_code, '0') = QP_PREQ_PUB.G_BY_ENGINE)
4149: AND (G_CALCULATE_FLAG = G_CALCULATE_ONLY
4150:
4151: OR EXISTS (SELECT 'Y' FROM qp_int_ldets ldet
4152: WHERE ldet.line_index = line.line_index
4153: AND ldet.pricing_status_code = G_STATUS_NEW
4154: AND ldet.applied_flag = G_YES -- bug 6111048/6328486
4155: AND ldet.process_code IN
4154: AND ldet.applied_flag = G_YES -- bug 6111048/6328486
4155: AND ldet.process_code IN
4156: (G_STATUS_NEW, G_STATUS_UPDATED))
4157: --for bug#3224658
4158: OR EXISTS (SELECT 'Y' FROM qp_int_ldets
4159: WHERE modifier_level_code = 'ORDER'
4160: AND applied_flag = 'YES' -- bug 6628324
4161: AND pricing_status_code = G_STATUS_NEW
4162: AND process_code IN (G_STATUS_NEW, G_STATUS_UPDATED))
4163: OR EXISTS (SELECT 'Y' FROM oe_price_adjustments adj
4164: WHERE line.line_type_code = G_LINE_LEVEL
4165: AND line.line_id = adj.line_id
4166: AND adj.applied_flag = G_YES
4167: AND adj.list_line_id NOT IN (SELECT ldet.created_from_list_line_id FROM qp_int_ldets ldet
4168: WHERE ldet.line_index = line.line_index
4169: AND ldet.pricing_status_code = G_STATUS_NEW
4170: AND ldet.process_code IN (G_STATUS_NEW, G_STATUS_UPDATED)
4171: AND ldet.applied_flag = G_YES))
4172: OR EXISTS (SELECT 'Y' FROM oe_price_adjustments adj
4173: WHERE line.line_type_code = G_ORDER_LEVEL
4174: AND line.line_id = adj.header_id
4175: AND adj.applied_flag = G_YES
4176: AND adj.list_line_id NOT IN (SELECT ldet.created_from_list_line_id FROM qp_int_ldets ldet
4177: WHERE ldet.line_index = line.line_index
4178: AND ldet.pricing_status_code = G_STATUS_NEW
4179: AND ldet.process_code IN (G_STATUS_NEW, G_STATUS_UPDATED)
4180: AND ldet.applied_flag = G_YES))
12672: FROM QP_INT_LINES;
12673:
12674: /*
12675: INDX,QP_PREQ_GRP.populate_output_int.l_ldets_cur,QP_LIST_LINES_PK,LIST_LINE_ID,1
12676: INDX,QP_PREQ_GRP.populate_output_int.l_ldets_cur,QP_INT_LDETS_N4,PRICING_STATUS_CODE,1
12677: INDX,QP_PREQ_GRP.populate_output_int.l_ldets_cur,QP_LIST_HEADERS_B_PK,LIST_HEADER_ID,1
12678: */
12679: CURSOR l_ldets_cur(p_line_index NUMBER) IS
12680: SELECT /*+ ORDERED USE_NL(A B C) l_ldets_cur */
12733: b.EXPIRATION_PERIOD_UOM,
12734: b.COMMENTS,
12735: a.ORDER_QTY_OPERAND,
12736: a.ORDER_QTY_ADJ_AMT
12737: FROM QP_INT_LDETS a,
12738: QP_LIST_LINES b
12739: WHERE a.line_index = p_line_index
12740: AND a.CREATED_FROM_LIST_LINE_ID = b.LIST_LINE_ID
12741: AND a.PRICING_STATUS_CODE = G_STATUS_NEW;