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 258: mtl_system_items sys

254: AND NOT EXISTS
255: ( SELECT 1
256: FROM mtl_serial_numbers ser,
257: csm_mtl_onhand_qty_acc ohqacc,
258: mtl_system_items sys
259: WHERE ser.current_status in (1,4)
260: AND ohqacc.user_id = acc.user_id
261: AND ser.serial_number = acc.serial_number
262: AND ser.inventory_item_id =acc.inventory_item_id

Line 370: l_user_palm_organization_id mtl_system_items.organization_id%TYPE;

366: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
367: l_all_omfs_palm_resource_list asg_download.user_list;
368: l_valid_omfs_resource_list asg_download.user_list;
369: l_null_palm_omfs_resource_list asg_download.user_list;
370: l_user_palm_organization_id mtl_system_items.organization_id%TYPE;
371: l_usr_list_for_serial asg_download.user_list;
372: l_rsrc_list_for_serial asg_download.user_list;
373: l_last_run_date jtm_con_request_data.last_run_date%TYPE;
374: l_run_date DATE;