DBA Data[Home] [Help]

APPS.JAI_PO_OSP_PKG dependencies on QP_LIST_LINES_V

Line 247: FROM qp_list_lines_v pll,

243:
244: --**********************ITEM VALUE*****************************
245: CURSOR c_item_value(cp_item_id NUMBER, cp_vendor NUMBER, cp_vendor_site NUMBER, cp_uom_code Varchar2) IS
246: SELECT pll.operand
247: FROM qp_list_lines_v pll,
248: JAI_CMN_VENDOR_SITES jvs
249: WHERE pll.list_header_id = jvs.price_list_id
250: AND pll.product_attr_value = to_char(cp_item_id)
251: and product_attribute_context = 'ITEM'

Line 260: FROM qp_list_lines_v pll,

256: AND NVL( End_Date_Active, SYSDATE + 1 ) >= SYSDATE;
257: --**********************ITEM VALUE1*****************************
258: CURSOR c_item_value1(cp_item_id NUMBER, cp_vendor NUMBER, cp_uom_code varchar2) IS
259: SELECT pll.operand
260: FROM qp_list_lines_v pll,
261: JAI_CMN_VENDOR_SITES jvs
262: WHERE pll.list_header_id = jvs.price_list_id
263: AND pll.product_attr_value = to_char(cp_item_id)
264: AND product_attribute_context = 'ITEM'