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 219: FROM csp_inv_loc_assignments

215: AND acc.user_id = p_userid;
216: /*AND ( msn.current_subinventory_code, msn.current_organization_id ) IN (
217: SELECT subinventory_code
218: , organization_id
219: FROM csp_inv_loc_assignments
220: WHERE resource_id = p_resourceid
221: AND SYSDATE BETWEEN nvl( effective_date_start, SYSDATE )
222: AND nvl( effective_date_end , SYSDATE ));*/
223:

Line 238: FROM csp_inv_loc_assignments

234: AND msn.current_status =3
235: AND ( msn.current_subinventory_code, msn.current_organization_id ) NOT IN (
236: SELECT subinventory_code
237: , organization_id
238: FROM csp_inv_loc_assignments
239: WHERE resource_id = p_resourceid
240: AND SYSDATE BETWEEN nvl( effective_date_start, SYSDATE )
241: AND nvl( effective_date_end , SYSDATE ))
242: UNION