APPS.MRP_CL_FUNCTION dependencies on QP_PRICING_ATTRIBUTES

Line 241: qp_pricing_attributes qpa

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
245: and qpa.product_attribute_context = 'ITEM'

Line 259: QP_PRICING_ATTRIBUTES QPA ,

255: */
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

Line 277: FROM QP_PRICING_ATTRIBUTES QPA ,

273:
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