APPS.WMS_PICKING_PKG dependencies on MTL_SYSTEM_ITEMS

Line 631: FROM mtl_system_items_b

627: SELECT serial_number_control_code
628: , lot_control_code
629: INTO l_serial_number_control_code
630: , l_lot_control_code
631: FROM mtl_system_items_b
632: WHERE inventory_item_id = l_inventory_item_id
633: AND organization_id = l_org_id;
634:
635: IF (l_debug = 1) THEN

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

962: , k.concatenated_segments item
963: INTO l_carton_name
964: , l_carton_item_id
965: , l_carton_item_name
966: FROM wms_license_plate_numbers l, mtl_system_items_vl k /* Bug 5581528 */
967: WHERE l.lpn_id = l_cartonization_id
968: AND l.inventory_item_id = k.inventory_item_id
969: AND l.organization_id = k.organization_id;
970:

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

1352: , l_allocate_lot_flag --71 -- Added for 14699845 (Flexible Lot Allocation)
1353: , NVL(mmtt.fulfillment_base, 'P') -- MUOM:SK (72)
1354: FROM wms_dispatched_tasks wdt
1355: , mtl_material_transactions_temp mmtt
1356: , mtl_system_items_vl msik /* Bug 5581528 */
1357: , mtl_parameters mp
1358: , mtl_txn_request_lines mtrl
1359: , mtl_secondary_inventories msi
1360: WHERE mmtt.transaction_temp_id = l_transaction_temp_id

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

1474: , mmtt.operation_plan_id
1475: /* end for LMS project */
1476: FROM wms_dispatched_tasks wdt
1477: , mtl_material_transactions_temp mmtt
1478: , mtl_system_items_vl msik /* Bug 5581528 */
1479: , mtl_parameters mp
1480: , mtl_txn_request_lines mtrl
1481: , mtl_secondary_inventories msi
1482: WHERE mmtt.transaction_temp_id = l_transaction_temp_id

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

1748: FROM mtl_material_transactions_temp mmtt
1749: , mtl_secondary_inventories msi
1750: , mtl_item_locations mil
1751: , wms_dispatched_tasks wdt
1752: , mtl_system_items_vl msik /* Bug 5581528 */
1753: WHERE mmtt.organization_id = p_organization_id
1754: AND mmtt.transfer_lpn_id = p_transfer_lpn_id
1755: AND mmtt.transaction_source_type_id = inv_globals.g_sourcetype_inventory
1756: AND mmtt.transaction_action_id = inv_globals.g_action_subxfr

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

1797: , to_number(NULL) transfer_to_location --Bug#2756609
1798: FROM mtl_material_transactions_temp mmtt
1799: , mtl_txn_request_lines mtrl
1800: , wms_dispatched_tasks wdt
1801: , mtl_system_items_vl msik /* Bug 5581528 */
1802: WHERE mmtt.organization_id = p_organization_id
1803: AND mmtt.transfer_lpn_id = p_transfer_lpn_id
1804: AND mmtt.transaction_source_type_id = inv_globals.g_sourcetype_wip
1805: AND mmtt.transaction_action_id = inv_globals.g_action_issue

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

1848: , inv_project.get_project_id
1849: , inv_project.get_project_number
1850: , inv_project.get_task_id
1851: , inv_project.get_task_number
1852: FROM wms_dispatched_tasks wdt, mtl_material_transactions_temp mmtt, mtl_system_items_vl msik /* Bug 5581528 */
1853: WHERE wdt.organization_id = p_organization_id
1854: AND wdt.status IN (3, 4)
1855: AND wdt.task_type IN (1, 4, 5, 7)
1856: AND wdt.transaction_temp_id = mmtt.transaction_temp_id

Line 2360: FROM mtl_system_items msi

2356: SELECT msi.serial_number_control_code
2357: , msi.lot_control_code
2358: INTO l_serial_ctrl_code
2359: , l_lot_ctrl_code
2360: FROM mtl_system_items msi
2361: WHERE msi.inventory_item_id = l_item_id
2362: AND msi.organization_id =p_organization_id ;
2363:
2364: IF (l_debug = 1) THEN

Line 4370: FROM mtl_system_items_b

4366: SELECT lot_control_code ,
4367: serial_number_control_code
4368: INTO l_lot_control_code ,
4369: l_serial_control_code
4370: FROM mtl_system_items_b
4371: WHERE inventory_item_id = l_mmtt_inventory_item_id
4372: AND organization_id = l_mmtt_organization_id;
4373: x_lot_control_code := l_lot_control_code;
4374: x_serial_control_code := l_serial_control_code;