APPS.CSM_INV_LOC_ASS_EVENT_PKG dependencies on ASG_USER

Line 56: asg_user au

52: invloc.resource_id AS resource_id,
53: invLoc.organization_id AS organization_id,
54: invLoc.subinventory_code AS subinventory_code
55: FROM csp_inv_loc_assignments invLoc,
56: asg_user au
57: WHERE invloc.csp_inv_loc_assignment_id = p_csp_inv_loc_assg_id
58: AND au.resource_id = invloc.resource_id
59: AND au.USER_ID = au.owner_id;
60:

Line 195: asg_user au

191: cila.subinventory_code,
192: cila.resource_id,
193: au.user_id
194: FROM csp_inv_loc_assignments cila,
195: asg_user au
196: WHERE cila.csp_inv_loc_assignment_id = p_csp_inv_loc_assignment_id
197: AND au.resource_id = cila.resource_id
198: AND au.USER_ID = au.owner_id;
199:

Line 333: ASG_USER au

329: SELECT acc.access_id,
330: acc.user_id
331: FROM csm_inv_loc_ass_acc acc,
332: csp_inv_loc_assignments cila,
333: ASG_USER au
334: WHERE acc.csp_inv_loc_assignment_id = p_csp_inv_loc_assg_id
335: AND cila.csp_inv_loc_assignment_id = acc.csp_inv_loc_assignment_id
336: AND au.USER_ID = acc.USER_ID
337: AND au.USER_ID = au.OWNER_ID;