APPS.INV_LOC_WMS_PUB dependencies on MTL_SECONDARY_INVENTORIES

Line 622: FROM mtl_secondary_inventories

618: INTO l_subinventory_code,
619: l_alias_enabled,
620: l_sub_alias_uniqueness,
621: l_subinventory_type
622: FROM mtl_secondary_inventories
623: WHERE secondary_inventory_name = p_subinventory_code
624: AND organization_id = l_organization_id;
625:
626: EXCEPTION

Line 947: FROM mtl_secondary_inventories

943: l_status_id := p_status_id;
944: ELSE
945: SELECT NVL(default_loc_status_id, 1)
946: INTO l_status_id
947: FROM mtl_secondary_inventories
948: WHERE organization_id = l_organization_id
949: AND secondary_inventory_name = p_subinventory_code;
950: --DBMS_output.put_line('After selecting the status_id ');
951: END IF;

Line 1522: FROM mtl_item_locations mil, mtl_secondary_inventories msi

1518: -- Retrieve the subinventory type for the sub that the locator is in.
1519: BEGIN
1520: SELECT NVL(msi.subinventory_type, 1)
1521: INTO l_subinventory_type
1522: FROM mtl_item_locations mil, mtl_secondary_inventories msi
1523: WHERE mil.inventory_location_id = l_inventory_location_id
1524: AND mil.organization_id = l_organization_id
1525: AND mil.subinventory_code = msi.secondary_inventory_name
1526: AND msi.organization_id = l_organization_id;

Line 1569: FROM mtl_secondary_inventories

1565: SELECT enable_locator_alias,
1566: enforce_alias_uniqueness
1567: INTO l_alias_enabled,
1568: l_sub_alias_uniqueness
1569: FROM mtl_secondary_inventories
1570: WHERE secondary_inventory_name = l_subinventory_code
1571: AND organization_id = l_organization_id;
1572:
1573: /*

Line 2136: FROM mtl_secondary_inventories

2132: ELSE
2133: BEGIN
2134: SELECT NVL(planning_level, 2)
2135: INTO l_planning_level
2136: FROM mtl_secondary_inventories
2137: WHERE secondary_inventory_name = p_subinventory_code
2138: AND organization_id = l_organization_id;
2139: EXCEPTION
2140: WHEN NO_DATA_FOUND THEN