DBA Data[Home] [Help]

APPS.WMS_CROSSDOCK_GRP dependencies on WMS_CROSSDOCK_CRITERIA_VL

Line 132: FROM wms_crossdock_criteria_vl wccv

128: CURSOR c_get_plan_crt_name
129: ( p_crt_id IN NUMBER
130: ) IS
131: SELECT wccv.criterion_name
132: FROM wms_crossdock_criteria_vl wccv
133: WHERE wccv.criterion_id = p_crt_id
134: AND wccv.criterion_type = wms_xdock_utils_pvt.G_CRT_TYPE_PLAN;
135:
136: CURSOR c_get_plan_crt_id

Line 140: FROM wms_crossdock_criteria_vl wccv

136: CURSOR c_get_plan_crt_id
137: ( p_crt_name IN VARCHAR2
138: ) IS
139: SELECT wccv.criterion_id
140: FROM wms_crossdock_criteria_vl wccv
141: WHERE wccv.criterion_name = p_crt_name
142: AND wccv.criterion_type = wms_xdock_utils_pvt.G_CRT_TYPE_PLAN;
143:
144: BEGIN