APPS.WMS_CACHE SQL Statements

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

Line: 109

      SELECT  wsm.rule_id ,
              wsm.partial_success_allowed_flag
        FROM  wms_strategy_members  wsm ,
	      wms_rules_b		 wrb
      WHERE wsm.strategy_id  = p_strategy_id
        AND wrb.rule_id 	    = wsm.rule_id
        AND wrb.enabled_flag = 'Y'
        AND wms_datecheck_pvt.date_valid (l_org_id,
				        wsm.date_type_code,
				        wsm.date_type_from,
				        wsm.date_type_to,
				        wsm.effective_from,
				        wsm.effective_to) = 'Y' ;

Line: 146

      SELECT wsb.organization_id ,
          NVL(wsb.over_allocation_mode, 1) ,
            wsb.tolerance_value
      INTO   l_org_id,
	           x_over_alloc_mode,
             x_tolerance
      FROM   wms_strategies_b  wsb
      WHERE wsb.strategy_id  = p_strategy_id;

Line: 193

    strategy_tbl.DELETE;