APPS.WMS_TASK_DISPATCH_GEN dependencies on MTL_SYSTEM_ITEMS

Line 1655: FROM mtl_system_items msi

1651: SELECT msi.serial_number_control_code
1652: , msi.lot_control_code
1653: INTO l_serial_code
1654: , l_lot_code
1655: FROM mtl_system_items msi
1656: WHERE msi.inventory_item_id = l_item_id
1657: AND msi.organization_id = p_org_id;
1658:
1659: IF (l_serial_code > 1

Line 1967: FROM mtl_system_items

1963: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1964: BEGIN
1965: SELECT primary_uom_code
1966: INTO l_primary_uom
1967: FROM mtl_system_items
1968: WHERE organization_id = p_organization_id
1969: AND inventory_item_id = p_item_id;
1970:
1971: l_primary_quantity :=

Line 2952: FROM mtl_system_items

2948: , serial_number_control_code
2949: INTO l_primary_uom
2950: , l_lot_code
2951: , l_serial_code
2952: FROM mtl_system_items
2953: WHERE organization_id = p_org_id
2954: AND inventory_item_id = p_item_id;
2955:
2956: SELECT mmtt.transfer_subinventory

Line 7422: FROM mtl_system_items

7418: SELECT lot_control_code
7419: , serial_number_control_code
7420: INTO l_lot_code
7421: , l_serial_code
7422: FROM mtl_system_items
7423: WHERE organization_id = l_org_id
7424: AND inventory_item_id = l_item_id;
7425:
7426: IF (l_debug = 1) THEN

Line 8971: FROM mtl_system_items

8967: SELECT lot_control_code
8968: , serial_number_control_code
8969: INTO l_lot_code
8970: , l_serial_code
8971: FROM mtl_system_items
8972: WHERE organization_id = p_org_id
8973: AND inventory_item_id = l_item_id;
8974:
8975: IF (l_debug = 1) THEN

Line 13016: FROM mtl_system_items msi

13012: SELECT msi.serial_number_control_code
13013: , msi.lot_control_code
13014: INTO l_serial_ctrl_code
13015: , l_lot_ctrl_code
13016: FROM mtl_system_items msi
13017: WHERE msi.inventory_item_id = l_item_id
13018: AND msi.organization_id =p_sign_on_org_id ;
13019:
13020: IF (l_debug = 1) THEN