APPS.WMS_WAVEPLAN_TASKS_PVT dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 675: SET picked_lpn = (SELECT license_plate_number FROM wms_license_plate_numbers WHERE lpn_id = picked_lpn_id)

671: END IF;
672:
673: IF g_picked_lpn_visible = 'T' THEN
674: UPDATE wms_waveplan_tasks_temp
675: SET picked_lpn = (SELECT license_plate_number FROM wms_license_plate_numbers WHERE lpn_id = picked_lpn_id)
676: WHERE picked_lpn_id IS NOT NULL
677: AND task_type_id IN (1, 4, 5, 6)
678: AND status_id = 6;
679: END IF;

Line 683: SET loaded_lpn = (SELECT license_plate_number FROM wms_license_plate_numbers WHERE lpn_id = loaded_lpn_id)

679: END IF;
680:
681: IF g_loaded_lpn_visible = 'T' THEN
682: UPDATE wms_waveplan_tasks_temp
683: SET loaded_lpn = (SELECT license_plate_number FROM wms_license_plate_numbers WHERE lpn_id = loaded_lpn_id)
684: WHERE loaded_lpn_id IS NOT NULL
685: AND task_type_id IN (1, 4, 5, 6)
686: AND status_id = 6;
687: END IF;

Line 692: FROM wms_license_plate_numbers wlpn, mtl_material_transactions mmt

688:
689: IF g_drop_lpn_visible = 'T' THEN
690: UPDATE wms_waveplan_tasks_temp wstt
691: SET drop_lpn = Nvl((select license_plate_number
692: FROM wms_license_plate_numbers wlpn, mtl_material_transactions mmt
693: WHERE wlpn.lpn_id = mmt.transfer_lpn_id
694: AND mmt.transaction_action_id = 50
695: AND mmt.transaction_set_id = wstt.transaction_set_id
696: AND mmt.transaction_quantity > 0),

Line 716: SET picked_lpn = (SELECT license_plate_number FROM wms_license_plate_numbers WHERE lpn_id = picked_lpn_id)

712: END IF;
713:
714: IF g_picked_lpn_visible = 'T' THEN
715: UPDATE wms_waveplan_tasks_temp
716: SET picked_lpn = (SELECT license_plate_number FROM wms_license_plate_numbers WHERE lpn_id = picked_lpn_id)
717: WHERE picked_lpn_id IS NOT NULL
718: AND task_type_id IN (1, 4, 5, 6)
719: AND status_id = 4;
720: END IF;

Line 724: SET loaded_lpn = (SELECT license_plate_number FROM wms_license_plate_numbers WHERE lpn_id = loaded_lpn_id)

720: END IF;
721:
722: IF g_loaded_lpn_visible = 'T' THEN
723: UPDATE wms_waveplan_tasks_temp
724: SET loaded_lpn = (SELECT license_plate_number FROM wms_license_plate_numbers WHERE lpn_id = loaded_lpn_id)
725: WHERE loaded_lpn_id IS NOT NULL
726: AND task_type_id IN (1, 4, 5, 6)
727: AND status_id = 4;
728: END IF;

Line 2290: l_from_generic || ', wms_license_plate_numbers wlpn1 ';

2286:
2287: IF g_allocated_lpn_visible = 'T' AND NOT p_is_completed AND NOT p_is_picknone --ER13869750
2288: THEN
2289: l_from_generic :=
2290: l_from_generic || ', wms_license_plate_numbers wlpn1 ';
2291: END IF;
2292:
2293: IF g_cartonization_lpn_visible = 'T' AND NOT p_is_completed AND NOT p_is_picknone --ER13869750
2294: THEN

Line 2296: l_from_generic || ', wms_license_plate_numbers wlpn2 ';

2292:
2293: IF g_cartonization_lpn_visible = 'T' AND NOT p_is_completed AND NOT p_is_picknone --ER13869750
2294: THEN
2295: l_from_generic :=
2296: l_from_generic || ', wms_license_plate_numbers wlpn2 ';
2297: END IF;
2298:
2299: IF g_container_item_visible = 'T' AND NOT p_is_completed AND NOT p_is_picknone --ER13869750
2300: THEN

Line 2307: l_from_generic || ', wms_license_plate_numbers wlpn5 ';

2303:
2304: IF g_from_lpn_visible = 'T'
2305: THEN
2306: l_from_generic :=
2307: l_from_generic || ', wms_license_plate_numbers wlpn5 ';
2308: END IF;
2309:
2310: IF g_content_lpn_visible = 'T'
2311: THEN

Line 2313: l_from_generic || ', wms_license_plate_numbers wlpn3 ';

2309:
2310: IF g_content_lpn_visible = 'T'
2311: THEN
2312: l_from_generic :=
2313: l_from_generic || ', wms_license_plate_numbers wlpn3 ';
2314: END IF;
2315:
2316: IF g_to_lpn_visible = 'T'
2317: THEN

Line 2319: l_from_generic || ', wms_license_plate_numbers wlpn4 ';

2315:
2316: IF g_to_lpn_visible = 'T'
2317: THEN
2318: l_from_generic :=
2319: l_from_generic || ', wms_license_plate_numbers wlpn4 ';
2320: END IF;
2321:
2322: IF g_user_task_type_visible = 'T'
2323: THEN