DBA Data[Home] [Help]

APPS.WMS_RULES_WORKBENCH_PVT dependencies on WMS_CROSSDOCK_CRITERIA_VL

Line 116: FROM wms_crossdock_criteria_vl

112: IF (p_return_type_code = 'V' ) then
113: IF(p_rule_type_code = 10) THEN
114: SELECT criterion_name
115: INTO l_return_type_name
116: FROM wms_crossdock_criteria_vl
117: WHERE criterion_id=p_return_type_id
118: AND criterion_type = 1 ;
119: return l_return_type_name;
120: ELSIF (p_rule_type_code = 11) THEN

Line 123: FROM wms_crossdock_criteria_vl

119: return l_return_type_name;
120: ELSIF (p_rule_type_code = 11) THEN
121: SELECT criterion_name
122: INTO l_return_type_name
123: FROM wms_crossdock_criteria_vl
124: WHERE criterion_id=p_return_type_id
125: AND criterion_type = 2;
126: return l_return_type_name;
127: ELSIF (p_rule_type_code = 5) THEN