DBA Data[Home] [Help]

APPS.JAI_PO_OSP_PKG dependencies on QP_LIST_LINES_V

Line 188: FROM qp_list_lines_v pll,

184:
185: --**********************ITEM VALUE*****************************
186: CURSOR c_item_value(cp_item_id NUMBER, cp_vendor NUMBER, cp_vendor_site NUMBER, cp_uom_code Varchar2) IS
187: SELECT pll.operand
188: FROM qp_list_lines_v pll,
189: JAI_CMN_VENDOR_SITES jvs
190: WHERE pll.list_header_id = jvs.price_list_id
191: AND pll.product_attr_value = to_char(cp_item_id)
192: and product_attribute_context = 'ITEM'

Line 201: FROM qp_list_lines_v pll,

197: AND NVL( End_Date_Active, SYSDATE + 1 ) >= SYSDATE;
198: --**********************ITEM VALUE1*****************************
199: CURSOR c_item_value1(cp_item_id NUMBER, cp_vendor NUMBER, cp_uom_code varchar2) IS
200: SELECT pll.operand
201: FROM qp_list_lines_v pll,
202: JAI_CMN_VENDOR_SITES jvs
203: WHERE pll.list_header_id = jvs.price_list_id
204: AND pll.product_attr_value = to_char(cp_item_id)
205: AND product_attribute_context = 'ITEM'