Catalogo alp_cat_inv_localizadores

1. Modulo

Inventarios (INV)

---

2. Descripción

Detalle de localizadores, pasillos, racks y sub-inventarios dentro de los almacenes oficiales.

---

3. Columnas

#	Nombre de Columna	Descripción
1	locator_id	Identificador único del localizador (ID interno de Oracle).
2	subinventory_id	Identificador único del subinventario asociado.
3	organization_id	Identificador único de la organización.
4	organization_code	Código alfanumérico que identifica la organización (Org Code).
5	subinventory_code	Código abreviado del subinventario.
6	locator_name	Nombre legible o identificador del localizador.
7	description	Descripción detallada del localizador.
8	segment1	Primer segmento de la estructura de configuración del localizador.
9	enabled_flag	Indicador de estado (Y=Habilitado, N=Deshabilitado).
10	start_date_active	Fecha a partir de la cual el localizador está activo.
11	end_date_active	Fecha de fin de vigencia del localizador.
12	lpn_controlled_flag	Indica si el localizador requiere control mediante LPN (License Plate Number).
13	full_lpn_flag	Indicador de LPN completo.

---

4. Querys

Databricks DEV

select  iil.inventory_location_id locator_id
,   iil.subinventory_id
,   iil.organization_id
,   iop.organizationcode      organization_code
,   iil.subinventory_code
,   iil.locator_name
,   iil.description
,   iil.segment1
,   iil.enabled_flag
,   iil.start_date_active
,   iil.end_date_active
,   iil.lpn_controlled_flag
,   iil.full_lpn_flag
from    cat_master_oracle_fusion.sch_gold_layer.inv_item_locations                          iil
join  cat_master_oracle_fusion.sch_gold_layer.fscm_scm_scmrcs_invorgparametersextractpvo  iop
on  iil.organization_id = iop.organizationid

Databricks UAT

select  iil.inventory_location_id locator_id
,   iil.subinventory_id
,   iil.organization_id
,   iop.organizationcode      organization_code
,   iil.subinventory_code
,   iil.locator_name
,   iil.description
,   iil.segment1
,   iil.enabled_flag
,   iil.start_date_active
,   iil.end_date_active
,   iil.lpn_controlled_flag
,   iil.full_lpn_flag
from    cat_master_oracle_fusion.sch_gold_layer.inv_item_locations_stg                          iil
join  cat_master_oracle_fusion.sch_gold_layer.fscm_scm_scmrcs_invorgparametersextractpvo_stg  iop
on  iil.organization_id = iop.organizationid

Databricks PROD

select  iil.inventory_location_id locator_id
,   iil.subinventory_id
,   iil.organization_id
,   iop.organizationcode      organization_code
,   iil.subinventory_code
,   iil.locator_name
,   iil.description
,   iil.segment1
,   iil.enabled_flag
,   iil.start_date_active
,   iil.end_date_active
,   iil.lpn_controlled_flag
,   iil.full_lpn_flag
from    cat_master_oracle_fusion.sch_gold_layer.inv_item_locations_prd                          iil
join  cat_master_oracle_fusion.sch_gold_layer.fscm_scm_scmrcs_invorgparametersextractpvo_prd  iop
on  iil.organization_id = iop.organizationid

Oracle

select  iil.inventory_location_id locator_id
,   iil.subinventory_id
,   iil.organization_id
,   iop.organization_code     organization_code
,   iil.subinventory_code
,   iil.locator_name
,   iil.description
,   iil.segment1
,   iil.enabled_flag
,   iil.start_date_active
,   iil.end_date_active
,   iil.lpn_controlled_flag
,   iil.full_lpn_flag
from    inv_item_locations  iil
,   inv_org_parameters  iop
where   iil.organization_id = iop.organization_id

---