APPS.INV_MWB_CONTROLLER SQL Statements

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

Line: 184

         inv_mwb_globals.g_multiple_loc_selected := 'TRUE';

Line: 186

         inv_mwb_globals.g_multiple_loc_selected := 'FALSE';

Line: 263

				SELECT DECODE(wms_enabled_flag, 'Y', 1, 0)
					INTO inv_mwb_globals.g_wms_enabled_flag
					FROM mtl_parameters
				 WHERE organization_id = NVL(p_tree_organization_id, inv_mwb_globals.g_organization_id);

Line: 299

      inv_mwb_globals.g_inserted_under_org := 'N';

Line: 301

      IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
         initialize;

Line: 378

      DELETE FROM mtl_mwb_gtmp;