APPS.CSM_SERIAL_NUMBERS_EVENT_PKG dependencies on MTL_SYSTEM_ITEMS

Line 82: mtl_system_items sys

78: WHERE ser.current_status IN (1,4) --Not assigned and out of subinv
79: AND EXISTS (
80: SELECT 'x'
81: FROM csm_mtl_onhand_qty_acc ohqacc,
82: mtl_system_items sys
83: WHERE ohqacc.inventory_item_id = ser.inventory_item_id
84: AND ohqacc.organization_id = ser.current_organization_id
85: AND ohqacc.user_id = p_userid
86: AND ohqacc.inventory_item_id = sys.inventory_item_id

Line 265: mtl_system_items sys

261: AND NOT EXISTS
262: ( SELECT 1
263: FROM mtl_serial_numbers ser,
264: csm_mtl_onhand_qty_acc ohqacc,
265: mtl_system_items sys
266: WHERE ser.current_status in (1,4)
267: AND ohqacc.user_id = acc.user_id
268: AND ser.serial_number = acc.serial_number
269: AND ser.inventory_item_id =acc.inventory_item_id

Line 412: l_user_palm_organization_id mtl_system_items.organization_id%TYPE;

408: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
409: l_all_omfs_palm_resource_list asg_download.user_list;
410: l_valid_omfs_resource_list asg_download.user_list;
411: l_null_palm_omfs_resource_list asg_download.user_list;
412: l_user_palm_organization_id mtl_system_items.organization_id%TYPE;
413: l_usr_list_for_serial asg_download.user_list;
414: l_rsrc_list_for_serial asg_download.user_list;
415: l_last_run_date jtm_con_request_data.last_run_date%TYPE;
416: l_run_date DATE;