[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:
4128: AND (line.price_flag IN (QP_PREQ_PUB.G_YES, QP_PREQ_PUB.G_PHASE, QP_PREQ_PUB.G_CALCULATE_ONLY)
4129: OR nvl(line.processed_code, '0') = QP_PREQ_PUB.G_BY_ENGINE)
4130: AND (G_CALCULATE_FLAG = G_CALCULATE_ONLY
4131:
4132: OR EXISTS (SELECT 'Y' FROM qp_int_ldets ldet
4133: WHERE ldet.line_index = line.line_index
4134: AND ldet.pricing_status_code = G_STATUS_NEW
4135: AND ldet.applied_flag = G_YES -- bug 6111048/6328486
4136: AND ldet.process_code IN
4135: AND ldet.applied_flag = G_YES -- bug 6111048/6328486
4136: AND ldet.process_code IN
4137: (G_STATUS_NEW, G_STATUS_UPDATED))
4138: --for bug#3224658
4139: OR EXISTS (SELECT 'Y' FROM qp_int_ldets
4140: WHERE modifier_level_code = 'ORDER'
4141: AND applied_flag = 'YES' -- bug 6628324
4142: AND pricing_status_code = G_STATUS_NEW
4143: AND process_code IN (G_STATUS_NEW, G_STATUS_UPDATED))
4144: OR EXISTS (SELECT 'Y' FROM oe_price_adjustments adj
4145: WHERE line.line_type_code = G_LINE_LEVEL
4146: AND line.line_id = adj.line_id
4147: AND adj.applied_flag = G_YES
4148: AND adj.list_line_id NOT IN (SELECT ldet.created_from_list_line_id FROM qp_int_ldets ldet
4149: WHERE ldet.line_index = line.line_index
4150: AND ldet.pricing_status_code = G_STATUS_NEW
4151: AND ldet.process_code IN (G_STATUS_NEW, G_STATUS_UPDATED)
4152: AND ldet.applied_flag = G_YES))
4153: OR EXISTS (SELECT 'Y' FROM oe_price_adjustments adj
4154: WHERE line.line_type_code = G_ORDER_LEVEL
4155: AND line.line_id = adj.header_id
4156: AND adj.applied_flag = G_YES
4157: AND adj.list_line_id NOT IN (SELECT ldet.created_from_list_line_id FROM qp_int_ldets ldet
4158: WHERE ldet.line_index = line.line_index
4159: AND ldet.pricing_status_code = G_STATUS_NEW
4160: AND ldet.process_code IN (G_STATUS_NEW, G_STATUS_UPDATED)
4161: AND ldet.applied_flag = G_YES))
12515: FROM QP_INT_LINES;
12516:
12517: /*
12518: INDX,QP_PREQ_GRP.populate_output_int.l_ldets_cur,QP_LIST_LINES_PK,LIST_LINE_ID,1
12519: INDX,QP_PREQ_GRP.populate_output_int.l_ldets_cur,QP_INT_LDETS_N4,PRICING_STATUS_CODE,1
12520: INDX,QP_PREQ_GRP.populate_output_int.l_ldets_cur,QP_LIST_HEADERS_B_PK,LIST_HEADER_ID,1
12521: */
12522: CURSOR l_ldets_cur(p_line_index NUMBER) IS
12523: SELECT /*+ ORDERED USE_NL(A B C) l_ldets_cur */
12576: b.EXPIRATION_PERIOD_UOM,
12577: b.COMMENTS,
12578: a.ORDER_QTY_OPERAND,
12579: a.ORDER_QTY_ADJ_AMT
12580: FROM QP_INT_LDETS a,
12581: QP_LIST_LINES b
12582: WHERE a.line_index = p_line_index
12583: AND a.CREATED_FROM_LIST_LINE_ID = b.LIST_LINE_ID
12584: AND a.PRICING_STATUS_CODE = G_STATUS_NEW;