Almacenes (alp_cat_inv_almacenes)
1. Modulo
Inventarios (INV)
2. Descripción
Maestro de almacenes físicos, centros de distribución (CEDIS) y plantas de Alpura.
3. Columnas
| No. | Columna | Descripción |
|---|---|---|
| 1 | legal_entity_id | Identificador único de la entidad legal. |
| 2 | business_unit_id | Identificador de la unidad de negocio (Business Unit). |
| 3 | organization_id | Identificador de la organización de inventarios (Inventory Organization). |
| 4 | legal_entity | Nombre de la entidad legal. |
| 5 | legal_entity_identifier | Identificador fiscal o único de la entidad legal. |
| 6 | business_unit | Nombre de la unidad de negocio asociada. |
| 7 | organization_code | Código de la organización de inventarios. |
| 8 | organization_name | Nombre de la organización de inventarios. |
| 9 | location_code | Código de la ubicación física del almacén. |
| 10 | address_line_1 | Dirección línea 1 del almacén. |
| 11 | address_line_2 | Dirección línea 2 del almacén. |
| 12 | address_line_3 | Dirección línea 3 del almacén. |
| 13 | address_line_4 | Dirección línea 4 del almacén. |
| 14 | country | País donde se encuentra el almacén. |
| 15 | postal_code | Código postal del almacén. |
| 16 | region_1 | Región administrativa nivel 1. |
| 17 | region_2 | Región administrativa nivel 2. |
| 18 | region_3 | Región administrativa nivel 3. |
| 19 | town_or_city | Ciudad o municipio donde se ubica el almacén. |
| 20 | inventory_flag | Indicador de habilitación como organización de inventario. |
| 21 | eam_flag | Indicador de habilitación para mantenimiento (EAM). |
| 22 | manufacture_flag | Indicador de habilitación para manufactura/procesos de producción. |
4. Objesto Databricks - Oracle
Nota de Arquitectura: Convención de Nomenclatura
Las entidades listadas en este documento corresponden a la capa final de datos en Databricks. Para identificar la persistencia y el aislamiento de los datos según el ciclo de vida del software, se implementa la siguiente estrategia de sufijos por entorno:
- 🥉 Desarrollo (DEV): Sufijo
_dev(ej.nombre_tabla_dev). - 🥈 Pruebas (UAT): Sufijo
_stg(ej.nombre_tabla_stg). - 🥇 Producción (PROD): Sufijo
_prd(ej.nombre_tabla_prd).
| No. | Databricks | Oracle Fusion | Descripción Operativa / Módulo |
|---|---|---|---|
| 1 | fnd_territories_tl | fnd_territories_tl | Catálogo multi-idioma de países y territorios geográficos. |
| 2 | fscm_scm_scmrcs_invorgparametersextractpvo | inv_org_parameters | Parámetros de configuración de las organizaciones de inventario. |
| 3 | hr_all_organization_units | hr_all_organization_units | Unidades organizacionales, departamentos y estructuras internas. |
| 4 | hr_locations_all | hr_locations_all | Oficinas, plantas, centros de distribución y ubicaciones corporativas. |
| 5 | rcs_mfg_parameters | rcs_mfg_parameters | Parámetros de configuración del módulo de Manufactura (Manufacturing). |
| 6 | xle_entity_profiles | xle_entity_profiles | Perfiles e información regulatoria de las Entidades Legales. |
5. Querys
- Databricks DEV
- Databricks UAT
- Databricks PROD
- Oracle
select iop.legalentityid legal_entity_id
, iop.businessunitid business_unit_id
, iop.organizationid organization_id
, xep.name legal_entity
, xep.legal_entity_identifier
, bu.name business_unit
, iop.organizationcode organization_code
, haou.name organization_name
, hl.location_code location_code
, hl.address_line_1 address_line_1
, hl.address_line_2 address_line_2
, hl.address_line_3 address_line_3
, hl.address_line_4 address_line_4
, ftt.territory_short_name country
, hl.postal_code postal_code
, hl.region_1 region_1
, hl.region_2 region_2
, hl.region_3 region_3
, hl.town_or_city town_or_city
, iop.inventoryflag inventory_flag
, iop.eamenabledflag eam_flag
, rmp.enable_process_flag manufacture_flag
from cat_master_oracle_fusion.sch_gold_layer.fscm_scm_scmrcs_invorgparametersextractpvo_dev iop
join cat_master_oracle_fusion.sch_gold_layer.hr_all_organization_units_dev haou
on iop.organizationid = haou.organization_id
join cat_master_oracle_fusion.sch_gold_layer.hr_all_organization_units_dev bu
on iop.businessunitid = bu.organization_id
join cat_master_oracle_fusion.sch_gold_layer.xle_entity_profiles_dev xep
on iop.legalentityid = xep.legal_entity_id
left join cat_master_oracle_fusion.sch_gold_layer.hr_locations_all_dev hl
on haou.location_id = hl.location_id
left join cat_master_oracle_fusion.sch_gold_layer.rcs_mfg_parameters_dev rmp
on iop.organizationid = rmp.organization_id
left join cat_master_oracle_fusion.sch_gold_layer.fnd_territories_tl_dev ftt
on hl.country = ftt.territory_code
and ftt.language = 'E'
select iop.legalentityid legal_entity_id
, iop.businessunitid business_unit_id
, iop.organizationid organization_id
, xep.name legal_entity
, xep.legal_entity_identifier
, bu.name business_unit
, iop.organizationcode organization_code
, haou.name organization_name
, hl.location_code location_code
, hl.address_line_1 address_line_1
, hl.address_line_2 address_line_2
, hl.address_line_3 address_line_3
, hl.address_line_4 address_line_4
, ftt.territory_short_name country
, hl.postal_code postal_code
, hl.region_1 region_1
, hl.region_2 region_2
, hl.region_3 region_3
, hl.town_or_city town_or_city
, iop.inventoryflag inventory_flag
, iop.eamenabledflag eam_flag
, rmp.enable_process_flag manufacture_flag
from cat_master_oracle_fusion.sch_gold_layer.fscm_scm_scmrcs_invorgparametersextractpvo_stg iop
join cat_master_oracle_fusion.sch_gold_layer.hr_all_organization_units_stg haou
on iop.organizationid = haou.organization_id
join cat_master_oracle_fusion.sch_gold_layer.hr_all_organization_units_stg bu
on iop.businessunitid = bu.organization_id
join cat_master_oracle_fusion.sch_gold_layer.xle_entity_profiles_stg xep
on iop.legalentityid = xep.legal_entity_id
left join cat_master_oracle_fusion.sch_gold_layer.hr_locations_all_stg hl
on haou.location_id = hl.location_id
left join cat_master_oracle_fusion.sch_gold_layer.rcs_mfg_parameters_stg rmp
on iop.organizationid = rmp.organization_id
left join cat_master_oracle_fusion.sch_gold_layer.fnd_territories_tl_stg ftt
on hl.country = ftt.territory_code
and ftt.language = 'E'
select iop.legalentityid legal_entity_id
, iop.businessunitid business_unit_id
, iop.organizationid organization_id
, xep.name legal_entity
, xep.legal_entity_identifier
, bu.name business_unit
, iop.organizationcode organization_code
, haou.name organization_name
, hl.location_code location_code
, hl.address_line_1 address_line_1
, hl.address_line_2 address_line_2
, hl.address_line_3 address_line_3
, hl.address_line_4 address_line_4
, ftt.territory_short_name country
, hl.postal_code postal_code
, hl.region_1 region_1
, hl.region_2 region_2
, hl.region_3 region_3
, hl.town_or_city town_or_city
, iop.inventoryflag inventory_flag
, iop.eamenabledflag eam_flag
, rmp.enable_process_flag manufacture_flag
from cat_master_oracle_fusion.sch_gold_layer.fscm_scm_scmrcs_invorgparametersextractpvo_prd iop
join cat_master_oracle_fusion.sch_gold_layer.hr_all_organization_units_prd haou
on iop.organizationid = haou.organization_id
join cat_master_oracle_fusion.sch_gold_layer.hr_all_organization_units_prd bu
on iop.businessunitid = bu.organization_id
join cat_master_oracle_fusion.sch_gold_layer.xle_entity_profiles_prd xep
on iop.legalentityid = xep.legal_entity_id
left join cat_master_oracle_fusion.sch_gold_layer.hr_locations_all_prd hl
on haou.location_id = hl.location_id
left join cat_master_oracle_fusion.sch_gold_layer.rcs_mfg_parameters_prd rmp
on iop.organizationid = rmp.organization_id
left join cat_master_oracle_fusion.sch_gold_layer.fnd_territories_tl_prd ftt
on hl.country = ftt.territory_code
and ftt.language = 'E'
select iop.legal_entity_id
, iop.business_unit_id
, iop.organization_id
, xep.name legal_entity
, xep.legal_entity_identifier
, bu.name business_unit
, iop.organization_code
, haou.name organization_name
, hl.location_code
, hl.address_line_1
, hl.address_line_2
, hl.address_line_3
, hl.address_line_4
, ftt.territory_short_name country
, hl.postal_code
, hl.region_1
, hl.region_2
, hl.region_3
, hl.town_or_city
, iop.inventory_flag
, iop.eam_enabled_flag eam_flag
, rmp.enable_process_flag manufacture_flag
FROM inv_org_parameters iop
, hr_all_organization_units haou
, hr_all_organization_units bu
, hr_locations hl
, xle_entity_profiles xep
, fnd_territories_tl ftt
, rcs_mfg_parameters rmp
WHERE iop.organization_id = haou.organization_id
AND iop.business_unit_id = bu.organization_id
AND iop.legal_entity_id = xep.legal_entity_id
AND hl.country = ftt.territory_code
AND iop.organization_id = rmp.organization_id
AND ftt.language = 'E'