APPS.INV_LOC_WMS_PUB dependencies on MTL_SECONDARY_INVENTORIES

Line 564: FROM mtl_secondary_inventories

560: INTO l_subinventory_code,
561: l_alias_enabled,
562: l_sub_alias_uniqueness,
563: l_subinventory_type
564: FROM mtl_secondary_inventories
565: WHERE secondary_inventory_name = p_subinventory_code
566: AND organization_id = l_organization_id;
567:
568: EXCEPTION

Line 879: FROM mtl_secondary_inventories

875: l_status_id := p_status_id;
876: ELSE
877: SELECT NVL(default_loc_status_id, 1)
878: INTO l_status_id
879: FROM mtl_secondary_inventories
880: WHERE organization_id = l_organization_id
881: AND secondary_inventory_name = p_subinventory_code;
882: --DBMS_output.put_line('After selecting the status_id ');
883: END IF;

Line 1439: FROM mtl_item_locations mil, mtl_secondary_inventories msi

1435: -- Retrieve the subinventory type for the sub that the locator is in.
1436: BEGIN
1437: SELECT NVL(msi.subinventory_type, 1)
1438: INTO l_subinventory_type
1439: FROM mtl_item_locations mil, mtl_secondary_inventories msi
1440: WHERE mil.inventory_location_id = l_inventory_location_id
1441: AND mil.organization_id = l_organization_id
1442: AND mil.subinventory_code = msi.secondary_inventory_name
1443: AND msi.organization_id = l_organization_id;

Line 1486: FROM mtl_secondary_inventories

1482: SELECT enable_locator_alias,
1483: enforce_alias_uniqueness
1484: INTO l_alias_enabled,
1485: l_sub_alias_uniqueness
1486: FROM mtl_secondary_inventories
1487: WHERE secondary_inventory_name = l_subinventory_code
1488: AND organization_id = l_organization_id;
1489:
1490: /*

Line 2040: FROM mtl_secondary_inventories

2036: ELSE
2037: BEGIN
2038: SELECT NVL(planning_level, 2)
2039: INTO l_planning_level
2040: FROM mtl_secondary_inventories
2041: WHERE secondary_inventory_name = p_subinventory_code
2042: AND organization_id = l_organization_id;
2043: EXCEPTION
2044: WHEN NO_DATA_FOUND THEN