APPS.WMS_PICKING_PKG dependencies on MTL_SYSTEM_ITEMS_VL

Line 801: FROM wms_license_plate_numbers l, mtl_system_items_vl k /* Bug 5581528 */

797: , k.concatenated_segments item
798: INTO l_carton_name
799: , l_carton_item_id
800: , l_carton_item_name
801: FROM wms_license_plate_numbers l, mtl_system_items_vl k /* Bug 5581528 */
802: WHERE l.lpn_id = l_cartonization_id
803: AND l.inventory_item_id = k.inventory_item_id
804: AND l.organization_id = k.organization_id;
805:

Line 1111: , mtl_system_items_vl msik /* Bug 5581528 */

1107: , l_template_name --70
1108:
1109: FROM wms_dispatched_tasks wdt
1110: , mtl_material_transactions_temp mmtt
1111: , mtl_system_items_vl msik /* Bug 5581528 */
1112: , mtl_parameters mp
1113: , mtl_txn_request_lines mtrl
1114: , mtl_secondary_inventories msi
1115: WHERE mmtt.transaction_temp_id = l_transaction_temp_id

Line 1218: , mtl_system_items_vl msik /* Bug 5581528 */

1214: , mmtt.operation_plan_id
1215: /* end for LMS project */
1216: FROM wms_dispatched_tasks wdt
1217: , mtl_material_transactions_temp mmtt
1218: , mtl_system_items_vl msik /* Bug 5581528 */
1219: , mtl_parameters mp
1220: , mtl_txn_request_lines mtrl
1221: , mtl_secondary_inventories msi
1222: WHERE mmtt.transaction_temp_id = l_transaction_temp_id

Line 1492: , mtl_system_items_vl msik /* Bug 5581528 */

1488: FROM mtl_material_transactions_temp mmtt
1489: , mtl_secondary_inventories msi
1490: , mtl_item_locations mil
1491: , wms_dispatched_tasks wdt
1492: , mtl_system_items_vl msik /* Bug 5581528 */
1493: WHERE mmtt.organization_id = p_organization_id
1494: AND mmtt.transfer_lpn_id = p_transfer_lpn_id
1495: AND mmtt.transaction_source_type_id = inv_globals.g_sourcetype_inventory
1496: AND mmtt.transaction_action_id = inv_globals.g_action_subxfr

Line 1541: , mtl_system_items_vl msik /* Bug 5581528 */

1537: , to_number(NULL) transfer_to_location --Bug#2756609
1538: FROM mtl_material_transactions_temp mmtt
1539: , mtl_txn_request_lines mtrl
1540: , wms_dispatched_tasks wdt
1541: , mtl_system_items_vl msik /* Bug 5581528 */
1542: WHERE mmtt.organization_id = p_organization_id
1543: AND mmtt.transfer_lpn_id = p_transfer_lpn_id
1544: AND mmtt.transaction_source_type_id = inv_globals.g_sourcetype_wip
1545: AND mmtt.transaction_action_id = inv_globals.g_action_issue

Line 1592: FROM wms_dispatched_tasks wdt, mtl_material_transactions_temp mmtt, mtl_system_items_vl msik /* Bug 5581528 */

1588: , inv_project.get_project_id
1589: , inv_project.get_project_number
1590: , inv_project.get_task_id
1591: , inv_project.get_task_number
1592: FROM wms_dispatched_tasks wdt, mtl_material_transactions_temp mmtt, mtl_system_items_vl msik /* Bug 5581528 */
1593: WHERE wdt.organization_id = p_organization_id
1594: AND wdt.status IN (3, 4)
1595: AND wdt.task_type IN (1, 4, 5, 7)
1596: AND wdt.transaction_temp_id = mmtt.transaction_temp_id