APPS.JAI_PO_OSP_PKG dependencies on JAI_CMN_VENDOR_SITES

Line 189: JAI_CMN_VENDOR_SITES jvs

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'
193: AND jvs.vendor_id = cp_vendor

Line 202: JAI_CMN_VENDOR_SITES jvs

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'
206: AND jvs.vendor_id = cp_vendor

Line 791: JAI_CMN_VENDOR_SITES jvs

787:
788: CURSOR c_item_value(cp_item_id NUMBER, cp_uom_code VARCHAR2) IS
789: SELECT pll.list_price
790: FROM so_price_list_lines pll,
791: JAI_CMN_VENDOR_SITES jvs
792: WHERE pll.price_list_id = jvs.price_list_id
793: AND pll.inventory_item_id = cp_item_id
794: AND jvs.vendor_id = r_base_trx.vendor_id
795: AND jvs.vendor_site_id = r_base_trx.vendor_site_id

Line 803: JAI_CMN_VENDOR_SITES jvs

799:
800: CURSOR c_item_value1(cp_item_id NUMBER, cp_uom_code VARCHAR2) IS
801: SELECT pll.list_price
802: FROM so_price_list_lines pll,
803: JAI_CMN_VENDOR_SITES jvs
804: WHERE pll.price_list_id = jvs.price_list_id
805: AND pll.inventory_item_id = cp_item_id
806: AND jvs.vendor_id = r_base_trx.vendor_id
807: AND jvs.vendor_site_id = 0