APPS.CSM_SERIAL_NUMBERS_EVENT_PKG dependencies on CSP_INV_LOC_ASSIGNMENTS

Line 47: FROM csp_inv_loc_assignments

43: AND current_status =3
44: AND (current_subinventory_code, current_organization_id) IN (
45: SELECT subinventory_code
46: ,organization_id
47: FROM csp_inv_loc_assignments
48: WHERE resource_id = p_resourceid
49: AND SYSDATE BETWEEN nvl( effective_date_start, SYSDATE )
50: AND nvl( effective_date_end , SYSDATE ))
51: );

Line 62: FROM csp_inv_loc_assignments

58: WHERE current_status =3 -- resides in stores + issued out of subinv
59: AND ( current_subinventory_code, current_organization_id ) IN (
60: SELECT subinventory_code
61: ,organization_id
62: FROM csp_inv_loc_assignments
63: WHERE resource_id = p_resourceid
64: AND SYSDATE BETWEEN nvl( effective_date_start, SYSDATE )
65: AND nvl( effective_date_end , SYSDATE ))
66: AND ( inventory_item_id, serial_number, current_organization_id ) NOT IN (

Line 226: FROM csp_inv_loc_assignments

222: AND acc.user_id = p_userid;
223: /*AND ( msn.current_subinventory_code, msn.current_organization_id ) IN (
224: SELECT subinventory_code
225: , organization_id
226: FROM csp_inv_loc_assignments
227: WHERE resource_id = p_resourceid
228: AND SYSDATE BETWEEN nvl( effective_date_start, SYSDATE )
229: AND nvl( effective_date_end , SYSDATE ));*/
230:

Line 245: FROM csp_inv_loc_assignments

241: AND msn.current_status =3
242: AND ( msn.current_subinventory_code, msn.current_organization_id ) NOT IN (
243: SELECT subinventory_code
244: , organization_id
245: FROM csp_inv_loc_assignments
246: WHERE resource_id = p_resourceid
247: AND SYSDATE BETWEEN nvl( effective_date_start, SYSDATE )
248: AND nvl( effective_date_end , SYSDATE ))
249: UNION

Line 290: FROM csp_inv_loc_assignments WHERE resource_id = p_resourceid

286: AND acc.user_id = p_userid
287: AND msn.current_status =3
288: AND ( msn.current_subinventory_code, msn.current_organization_id ) NOT IN (
289: SELECT subinventory_code, organization_id
290: FROM csp_inv_loc_assignments WHERE resource_id = p_resourceid
291: AND SYSDATE BETWEEN nvl( effective_date_start, SYSDATE )AND nvl( effective_date_end , SYSDATE ))
292: UNION
293: SELECT access_id
294: FROM csm_mtl_serial_numbers_acc acc

Line 655: FROM csp_inv_loc_assignments

651: AND serial_number = p_serial_number
652: AND au.user_id = p_user_id
653: AND ( current_subinventory_code, current_organization_id )
654: IN ( SELECT subinventory_code ,organization_id
655: FROM csp_inv_loc_assignments
656: WHERE resource_id = au.resource_id
657: AND resource_type='RS_EMPLOYEE'
658: AND SYSDATE BETWEEN nvl( effective_date_start, SYSDATE ) AND nvl( effective_date_end , SYSDATE ))
659: AND ( inventory_item_id, serial_number, current_organization_id ) NOT IN (