DBA Data[Home] [Help]

APPS.MRP_CL_FUNCTION dependencies on QP_LIST_LINES

Line 228: * scan on the index QP_LIST_LINES_U1, instead it will now do a unique scan

224: and nvl(sopl.end_date_active, sysdate+1);
225: */
226:
227: /* For the bug # 2070983, adding + 0 to qpl.list_header_id to avoid the range
228: * scan on the index QP_LIST_LINES_U1, instead it will now do a unique scan
229: * on the index QP_LIST_LINES_PK
230: */
231:
232: /* For Bug 2113445, converting rounding factor to follow OM rounding convention

Line 229: * on the index QP_LIST_LINES_PK

225: */
226:
227: /* For the bug # 2070983, adding + 0 to qpl.list_header_id to avoid the range
228: * scan on the index QP_LIST_LINES_U1, instead it will now do a unique scan
229: * on the index QP_LIST_LINES_PK
230: */
231:
232: /* For Bug 2113445, converting rounding factor to follow OM rounding convention
233: by multiplying it by -1

Line 240: qp_list_lines qpl,

236: p_uom_code IN VARCHAR2) IS
237: /*
238: select round(operand,-1*(nvl(qplh.rounding_factor,2)))
239: from qp_list_headers_b qplh,
240: qp_list_lines qpl,
241: qp_pricing_attributes qpa
242: where qplh.list_header_id = p_price_list_id
243: and qpl.list_header_id + 0 = qplh.list_header_id
244: and qpl.list_line_id = qpa.list_line_id

Line 260: QP_LIST_LINES QPL,

256: /* For Bug 2230228, based on QP Teams suggestion*/
257: SELECT ROUND(QPL.OPERAND,-1 * (NVL(QPLH.ROUNDING_FACTOR,2)))
258: FROM
259: QP_PRICING_ATTRIBUTES QPA ,
260: QP_LIST_LINES QPL,
261: QP_LIST_HEADERS_B QPLH
262: WHERE QPA.PRICING_PHASE_ID = 1
263: AND QPA.QUALIFICATION_IND = 4
264: AND QPA.PRODUCT_ATTRIBUTE_CONTEXT = 'ITEM'

Line 278: QP_LIST_LINES QPL,

274: CURSOR PRICE_D_NULL_UOM( p_item_id IN VARCHAR2)
275: IS
276: SELECT ROUND(QPL.OPERAND,-1 * (NVL(QPLH.ROUNDING_FACTOR,2)))
277: FROM QP_PRICING_ATTRIBUTES QPA ,
278: QP_LIST_LINES QPL,
279: QP_LIST_HEADERS_B QPLH
280: WHERE QPA.PRICING_PHASE_ID = 1
281: AND QPA.QUALIFICATION_IND = 4
282: AND QPA.PRODUCT_ATTRIBUTE_CONTEXT = 'ITEM'