APPS.WMS_PICKING_PKG dependencies on MTL_SYSTEM_ITEMS

Line 469: FROM mtl_system_items_b

465: SELECT serial_number_control_code
466: , lot_control_code
467: INTO l_serial_number_control_code
468: , l_lot_control_code
469: FROM mtl_system_items_b
470: WHERE inventory_item_id = l_inventory_item_id
471: AND organization_id = l_org_id;
472:
473: IF (l_debug = 1) THEN

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

Line 2100: FROM mtl_system_items msi

2096: SELECT msi.serial_number_control_code
2097: , msi.lot_control_code
2098: INTO l_serial_ctrl_code
2099: , l_lot_ctrl_code
2100: FROM mtl_system_items msi
2101: WHERE msi.inventory_item_id = l_item_id
2102: AND msi.organization_id =p_organization_id ;
2103:
2104: IF (l_debug = 1) THEN

Line 3942: FROM mtl_system_items_b

3938: SELECT lot_control_code ,
3939: serial_number_control_code
3940: INTO l_lot_control_code ,
3941: l_serial_control_code
3942: FROM mtl_system_items_b
3943: WHERE inventory_item_id = l_mmtt_inventory_item_id
3944: AND organization_id = l_mmtt_organization_id;
3945: x_lot_control_code := l_lot_control_code;
3946: x_serial_control_code := l_serial_control_code;