APPS.CSM_MTL_SEC_INV_EVENT_PKG dependencies on MTL_SECONDARY_INVENTORIES

Line 164: OR EXISTS(SELECT 1 FROM mtl_secondary_inventories msi WHERE acc.organization_id=msi.organization_id AND acc.secondary_inventory_name=msi.secondary_inventory_name

160: SELECT acc.access_id, acc.user_id
161: FROM csm_mtl_sec_inv_acc acc
162: WHERE not exists (Select 1 FROM CSM_INTERORG_PARAMETERS_ACC
163: WHERE acc.organization_id IN (FROM_ORGANIZATION_ID,TO_ORGANIZATION_ID) AND USER_ID=acc.user_id)
164: OR EXISTS(SELECT 1 FROM mtl_secondary_inventories msi WHERE acc.organization_id=msi.organization_id AND acc.secondary_inventory_name=msi.secondary_inventory_name
165: AND nvl(msi.disable_date,sysdate+1) 166:
167: CURSOR l_upd_mtl_sec_inv_csr(p_last_upd_date IN date)
168: IS

Line 181: AND EXISTS(SELECT 1 FROM mtl_secondary_inventories msi WHERE csi.organization_id=msi.organization_id AND csi.secondary_inventory_name=msi.secondary_inventory_name

177: select CSM_MTL_SEC_INV_ACC_S.nextval as access_id,au.user_id , csi.organization_id,csi.secondary_inventory_name
178: from csp_sec_inventories csi,asg_user au
179: where au.enabled='Y' and au.multi_platform='Y'
180: --AND csi.CONDITION_TYPE='G'
181: AND EXISTS(SELECT 1 FROM mtl_secondary_inventories msi WHERE csi.organization_id=msi.organization_id AND csi.secondary_inventory_name=msi.secondary_inventory_name
182: AND nvl(msi.disable_date,sysdate+1)>=sysdate)
183: AND EXISTS(SELECT 1 FROM CSM_INTERORG_PARAMETERS_ACC WHERE USER_ID=au.user_id AND csi.organization_id IN (FROM_ORGANIZATION_ID,TO_ORGANIZATION_ID))
184: AND NOT EXISTS(SELECT 1 FROM csm_mtl_sec_inv_acc acc WHERE csi.organization_id=acc.organization_id
185: AND csi.secondary_inventory_name=acc.secondary_inventory_name and acc.user_id=au.user_id);