APPS.CSM_SERIAL_NUMBERS_EVENT_PKG dependencies on ASG_USER

Line 431: FROM asg_user

427:
428: CURSOR l_user_id_csr (p_resourceid IN number)
429: IS
430: SELECT user_id
431: FROM asg_user
432: WHERE resource_id = p_resourceid;
433:
434: CURSOR l_usr_rsrc_list_serial
435: IS

Line 439: FROM asg_user_pub_resps aupr,

435: IS
436: SELECT
437: au.resource_id,
438: au.user_id
439: FROM asg_user_pub_resps aupr,
440: asg_user au
441: WHERE aupr.pub_name = 'SERVICEP'
442: AND au.user_name = aupr.user_name
443: AND au.owner_id = au.user_id

Line 440: asg_user au

436: SELECT
437: au.resource_id,
438: au.user_id
439: FROM asg_user_pub_resps aupr,
440: asg_user au
441: WHERE aupr.pub_name = 'SERVICEP'
442: AND au.user_name = aupr.user_name
443: AND au.owner_id = au.user_id
444: AND au.enabled = 'Y';

Line 646: FROM mtl_serial_numbers,asg_user au

642: IS
643: CURSOR received_srl_item
644: IS
645: SELECT csm_mtl_serial_numbers_acc_s.nextval, inventory_item_id, serial_number, current_organization_id,au.user_id
646: FROM mtl_serial_numbers,asg_user au
647: WHERE current_status =3 -- html5 supports only 3
648: AND current_organization_id=p_org_id
649: AND current_subinventory_code = p_subinv_code
650: AND inventory_item_id = p_item_id