APPS.CSM_SYSTEM_ITEM_EVENT_PKG dependencies on CSM_USER_INVENTORY_ORG

Line 369: csm_user_inventory_org user_org,

365: au.user_id,
366: msi.inventory_item_id,
367: msi.organization_id
368: FROM asg_user au,
369: csm_user_inventory_org user_org,
370: mtl_system_items_b msi,
371: CS_BILLING_TYPE_CATEGORIES cbtc
372: WHERE user_org.user_id = au.user_id
373: AND au.user_id = au.owner_id

Line 577: FROM csm_user_inventory_org;

573: -- process inserts
574:
575: -- Check for single organization_id configuration
576: SELECT count(distinct organization_id) into l_org_count
577: FROM csm_user_inventory_org;
578:
579: -- Process separately when all user have same organization_id
580: IF (l_org_count = 1) THEN
581:

Line 584: FROM csm_user_inventory_org

580: IF (l_org_count = 1) THEN
581:
582: -- Choose one user to process
583: SELECT user_id, organization_id into l_su_user_id, l_su_organization_id
584: FROM csm_user_inventory_org
585: WHERE rownum=1;
586:
587: -- Get all the users list
588: IF l_user_id.COUNT > 0 THEN

Line 1174: FROM csm_user_inventory_org

1170: -- Cursor to check already created user with same organization_id
1171: CURSOR l_prev_user_csr (p_user_id NUMBER, p_organization_id NUMBER)
1172: IS
1173: SELECT user_id
1174: FROM csm_user_inventory_org
1175: WHERE organization_id = p_organization_id
1176: AND user_id <> p_user_id
1177: AND rownum = 1;
1178: