APPS.WMS_WAVEPLAN_TASKS_PVT dependencies on WMS_LICENSE_PLATE_NUMBERS

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

571: END IF;
572:
573: IF g_picked_lpn_visible = 'T' THEN
574: UPDATE wms_waveplan_tasks_temp
575: SET picked_lpn = (SELECT license_plate_number FROM wms_license_plate_numbers WHERE lpn_id = picked_lpn_id)
576: WHERE picked_lpn_id IS NOT NULL
577: AND task_type_id IN (1, 4, 5, 6)
578: AND status_id = 6;
579: END IF;

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

579: END IF;
580:
581: IF g_loaded_lpn_visible = 'T' THEN
582: UPDATE wms_waveplan_tasks_temp
583: SET loaded_lpn = (SELECT license_plate_number FROM wms_license_plate_numbers WHERE lpn_id = loaded_lpn_id)
584: WHERE loaded_lpn_id IS NOT NULL
585: AND task_type_id IN (1, 4, 5, 6)
586: AND status_id = 6;
587: END IF;

Line 592: FROM wms_license_plate_numbers wlpn, mtl_material_transactions mmt

588:
589: IF g_drop_lpn_visible = 'T' THEN
590: UPDATE wms_waveplan_tasks_temp wstt
591: SET drop_lpn = Nvl((select license_plate_number
592: FROM wms_license_plate_numbers wlpn, mtl_material_transactions mmt
593: WHERE wlpn.lpn_id = mmt.transfer_lpn_id
594: AND mmt.transaction_action_id = 50
595: AND mmt.transaction_set_id = wstt.transaction_set_id
596: AND mmt.transaction_quantity > 0),

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

612: END IF;
613:
614: IF g_picked_lpn_visible = 'T' THEN
615: UPDATE wms_waveplan_tasks_temp
616: SET picked_lpn = (SELECT license_plate_number FROM wms_license_plate_numbers WHERE lpn_id = picked_lpn_id)
617: WHERE picked_lpn_id IS NOT NULL
618: AND task_type_id IN (1, 4, 5, 6)
619: AND status_id = 4;
620: END IF;

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

620: END IF;
621:
622: IF g_loaded_lpn_visible = 'T' THEN
623: UPDATE wms_waveplan_tasks_temp
624: SET loaded_lpn = (SELECT license_plate_number FROM wms_license_plate_numbers WHERE lpn_id = loaded_lpn_id)
625: WHERE loaded_lpn_id IS NOT NULL
626: AND task_type_id IN (1, 4, 5, 6)
627: AND status_id = 4;
628: END IF;

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

1985:
1986: IF g_allocated_lpn_visible = 'T' AND NOT p_is_completed
1987: THEN
1988: l_from_generic :=
1989: l_from_generic || ', wms_license_plate_numbers wlpn1 ';
1990: END IF;
1991:
1992: IF g_cartonization_lpn_visible = 'T' AND NOT p_is_completed
1993: THEN

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

1991:
1992: IF g_cartonization_lpn_visible = 'T' AND NOT p_is_completed
1993: THEN
1994: l_from_generic :=
1995: l_from_generic || ', wms_license_plate_numbers wlpn2 ';
1996: END IF;
1997:
1998: IF g_container_item_visible = 'T' AND NOT p_is_completed
1999: THEN

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

2002:
2003: IF g_from_lpn_visible = 'T'
2004: THEN
2005: l_from_generic :=
2006: l_from_generic || ', wms_license_plate_numbers wlpn5 ';
2007: END IF;
2008:
2009: IF g_content_lpn_visible = 'T'
2010: THEN

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

2008:
2009: IF g_content_lpn_visible = 'T'
2010: THEN
2011: l_from_generic :=
2012: l_from_generic || ', wms_license_plate_numbers wlpn3 ';
2013: END IF;
2014:
2015: IF g_to_lpn_visible = 'T'
2016: THEN

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

2014:
2015: IF g_to_lpn_visible = 'T'
2016: THEN
2017: l_from_generic :=
2018: l_from_generic || ', wms_license_plate_numbers wlpn4 ';
2019: END IF;
2020:
2021: IF g_user_task_type_visible = 'T'
2022: THEN