APPS.CSM_INV_LOC_ASS_EVENT_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 51

SELECT au.user_id AS user_id,
       invloc.resource_id AS resource_id,
       invLoc.organization_id AS organization_id,
       invLoc.subinventory_code AS subinventory_code
FROM   csp_inv_loc_assignments invLoc,
       asg_user au
WHERE  invloc.csp_inv_loc_assignment_id = p_csp_inv_loc_assg_id
AND    au.resource_id = invloc.resource_id
AND    au.USER_ID     = au.owner_id;

Line: 104

SELECT subinventory_code,
       organization_id
FROM  csp_inv_loc_assignments
WHERE csp_inv_loc_assignment_id = p_inv_loc_ass_id;

Line: 112

SELECT mil.inventory_location_id, mil.organization_id
FROM mtl_item_locations mil
WHERE mil.subinventory_code = p_subinv_code
AND mil.organization_id = p_organization_id;

Line: 124

       CSM_ACC_PKG.Insert_Acc
       ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
        ,P_ACC_TABLE_NAME         => g_acc_table_name1
        ,P_SEQ_NAME               => g_acc_sequence_name1
        ,P_PK1_NAME               => g_pk1_name1
        ,P_PK1_NUM_VALUE          => p_csp_inv_loc_assignment_id
        ,P_USER_ID                => p_user_id
       );

Line: 134

       CSM_ACC_PKG.Insert_Acc
      ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name2
       ,P_ACC_TABLE_NAME         => g_acc_table_name2
       ,P_SEQ_NAME               => g_acc_sequence_name2
       ,P_PK1_NAME               => g_pk1_name2
       ,P_PK1_CHAR_VALUE         => l_subinventory_code
       ,P_PK2_NAME               => g_pk2_name2
       ,P_PK2_NUM_VALUE          => l_organization_id
       ,P_USER_ID                => p_user_id
      );

Line: 154

       CSM_ACC_PKG.Insert_Acc
       ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name3
        ,P_ACC_TABLE_NAME         => g_acc_table_name3
        ,P_SEQ_NAME               => g_acc_sequence_name3
        ,P_PK1_NAME               => g_pk1_name3
        ,P_PK1_NUM_VALUE         => l_inv_location_id
        ,P_PK2_NAME               => g_pk2_name3
        ,P_PK2_NUM_VALUE          => l_locator_org_id
        ,P_USER_ID                => p_user_id
       );

Line: 190

SELECT cila.organization_id,
       cila.subinventory_code,
       cila.resource_id,
       au.user_id
FROM   csp_inv_loc_assignments cila,
       asg_user au
WHERE  cila.csp_inv_loc_assignment_id = p_csp_inv_loc_assignment_id
AND    au.resource_id = cila.resource_id
AND    au.USER_ID     = au.owner_id;

Line: 243

SELECT subinventory_code,
       organization_id
FROM  csp_inv_loc_assignments
WHERE csp_inv_loc_assignment_id = p_inv_loc_ass_id;

Line: 251

SELECT mil.inventory_location_id, mil.organization_id
FROM mtl_item_locations mil
WHERE mil.subinventory_code = p_subinv_code
AND mil.organization_id = p_organization_id;

Line: 264

        CSM_ACC_PKG.Delete_Acc
        ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
         ,P_ACC_TABLE_NAME         => g_acc_table_name1
         ,P_PK1_NAME               => g_pk1_name1
         ,P_PK1_NUM_VALUE          => p_csp_inv_loc_assignment_id
         ,P_USER_ID                => p_user_id
        );

Line: 273

        CSM_ACC_PKG.Delete_Acc
        ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name2
         ,P_ACC_TABLE_NAME         => g_acc_table_name2
         ,P_PK1_NAME               => g_pk1_name2
         ,P_PK1_CHAR_VALUE         => l_subinventory_code
         ,P_PK2_NAME               => g_pk2_name2
         ,P_PK2_NUM_VALUE          => l_organization_id
         ,P_USER_ID                => p_user_id
        );

Line: 294

       CSM_ACC_PKG.Delete_Acc
       ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name3
        ,P_ACC_TABLE_NAME         => g_acc_table_name3
        ,P_PK1_NAME               => g_pk1_name3
        ,P_PK1_NUM_VALUE         => l_inv_location_id
        ,P_PK2_NAME               => g_pk2_name3
        ,P_PK2_NUM_VALUE          => l_locator_org_id
        ,P_USER_ID                => p_user_id
       );

Line: 329

SELECT acc.access_id,
       acc.user_id
FROM   csm_inv_loc_ass_acc acc,
       csp_inv_loc_assignments cila,
       ASG_USER au
WHERE  acc.csp_inv_loc_assignment_id  = p_csp_inv_loc_assg_id
AND    cila.csp_inv_loc_assignment_id = acc.csp_inv_loc_assignment_id
AND    au.USER_ID  = acc.USER_ID
AND    au.USER_ID  = au.OWNER_ID;

Line: 349

     CSM_ACC_PKG.Update_Acc
       ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
        ,P_ACC_TABLE_NAME         => g_acc_table_name1
        ,P_USER_ID                => l_invLocAsgn_rec.user_id
        ,P_ACCESS_ID              => l_invLocAsgn_rec.access_id
       );