APPS.JAI_PO_OSP_PKG dependencies on JAI_CMN_VENDOR_SITES

Line 248: JAI_CMN_VENDOR_SITES jvs

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

Line 261: JAI_CMN_VENDOR_SITES jvs

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

Line 912: JAI_CMN_VENDOR_SITES jvs

908:
909: CURSOR c_item_value(cp_item_id NUMBER, cp_uom_code VARCHAR2) IS
910: SELECT pll.list_price
911: FROM so_price_list_lines pll,
912: JAI_CMN_VENDOR_SITES jvs
913: WHERE pll.price_list_id = jvs.price_list_id
914: AND pll.inventory_item_id = cp_item_id
915: AND jvs.vendor_id = r_base_trx.vendor_id
916: AND jvs.vendor_site_id = r_base_trx.vendor_site_id

Line 924: JAI_CMN_VENDOR_SITES jvs

920:
921: CURSOR c_item_value1(cp_item_id NUMBER, cp_uom_code VARCHAR2) IS
922: SELECT pll.list_price
923: FROM so_price_list_lines pll,
924: JAI_CMN_VENDOR_SITES jvs
925: WHERE pll.price_list_id = jvs.price_list_id
926: AND pll.inventory_item_id = cp_item_id
927: AND jvs.vendor_id = r_base_trx.vendor_id
928: AND jvs.vendor_site_id = 0