APPS.QP_CALCULATE_PRICE_PUB dependencies on QP_NPREQ_LDETS_TMP

Line 752: FROM qp_npreq_ldets_tmp

748: IF l_continuous_flag = 'Y' AND QP_PREQ_GRP.G_BREAK_UOM_PRORATION = 'Y'
749: THEN
750: BEGIN
751: SELECT 'Y' INTO l_prorated_flag
752: FROM qp_npreq_ldets_tmp
753: WHERE line_detail_index = p_list_line_index
754: AND break_uom_code IS NOT NULL;
755: EXCEPTION
756: WHEN NO_DATA_FOUND THEN

Line 1544: -- from qp_npreq_ldets_tmp

1540: SELECT accum_context, accum_attribute, accum_attr_run_src_flag, list_line_no
1541: INTO l_accum_context, l_accum_attrib, l_accum_flag, v_list_line_no
1542: FROM qp_list_lines
1543: WHERE list_line_id = p_list_line_id;
1544: -- from qp_npreq_ldets_tmp
1545: -- where created_from_list_line_id = p_list_line_id
1546: -- and rownum = 1;
1547: EXCEPTION
1548: WHEN NO_DATA_FOUND THEN

Line 2294: UPDATE qp_npreq_ldets_tmp

2290: ||' order_qty_operand '|| l_ord_qty_operand
2291: ||' dtl index '|| pbh_adjustments(i).l_related_line_detail_index);
2292: END IF; -- END IF l_debug
2293:
2294: UPDATE qp_npreq_ldets_tmp
2295: --changes for bug 2264566 update adjamt on child lines of manualpbh
2296: SET adjustment_amount = - (pbh_adjustments(i).l_adjustment_amount),
2297: --SET adjustment_amount = l_sign * pbh_adjustments(i).l_adjustment_amount,
2298: line_quantity = nvl(pbh_adjustments(i).l_raw_satisfied_value, -- 5335689

Line 2618: UPDATE qp_npreq_ldets_tmp

2614: || pbh_adjustments(i).l_adjustment_amount
2615: ||' qty '|| pbh_adjustments(i).l_satisfied_value
2616: ||' dtl index '|| pbh_adjustments(i).l_related_line_detail_index);
2617: END IF;
2618: UPDATE qp_npreq_ldets_tmp
2619: --changes for bug 2264566 update adjamt on child lines of manualpbh
2620: SET adjustment_amount = - (pbh_adjustments(i).l_adjustment_amount),
2621: --SET adjustment_amount = l_sign * pbh_adjustments(i).l_adjustment_amount,
2622: line_quantity = pbh_adjustments(i).l_satisfied_value

Line 2656: FROM qp_npreq_ldets_tmp a, QP_LIST_HEADERS_B b

2652: GSA_VIOLATION EXCEPTION;
2653:
2654: CURSOR get_source_system_code IS
2655: SELECT b.SOURCE_SYSTEM_CODE
2656: FROM qp_npreq_ldets_tmp a, QP_LIST_HEADERS_B b
2657: WHERE a.CREATED_FROM_LIST_HEADER_ID = b.LIST_HEADER_ID
2658: AND a.LINE_INDEX = p_line_index
2659: AND a.CREATED_FROM_LIST_LINE_TYPE = 'PLL'
2660: AND a.PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_NEW;