DBA Data[Home] [Help]

APPS.MRP_CL_FUNCTION dependencies on QP_LIST_HEADERS_B

Line 239: from qp_list_headers_b qplh,

235: CURSOR PRICE_D ( p_item_id IN VARCHAR2,
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

Line 261: QP_LIST_HEADERS_B QPLH

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'
265: AND QPA.PRODUCT_ATTRIBUTE = 'PRICING_ATTRIBUTE1'

Line 279: QP_LIST_HEADERS_B QPLH

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'
283: AND QPA.PRODUCT_ATTRIBUTE = 'PRICING_ATTRIBUTE1'