Catalogo alp_cat_fnd_lookups

1. Modulo

Fundacionales (FND)

---

2. Descripción

Catálogo maestro de llaves, códigos de referencia, listas de selección y valores del sistema.

---

3. Columnas

#	Columna	Descripción
1	type	Tipo de lookup (Lookup Type) que clasifica el conjunto de valores.
2	code	Código del valor del lookup. Identificador técnico del valor dentro del tipo.
3	meaning	Descripción legible del valor del lookup en idioma inglés (language = 'E').
4	set_id	Identificador del conjunto de valores del lookup (Lookup Set ID).
5	tag	Etiqueta adicional del lookup utilizada para mapeos o integraciones externas.
6	view_appl_id	Identificador de la aplicación asociada al lookup (View Application ID).
7	enabled	Indicador de si el valor del lookup está habilitado (Y/N).
8	start_date	Fecha de inicio de vigencia del valor del lookup.
9	end_date	Fecha de fin de vigencia del valor del lookup.

---

4. Querys

Databricks DEV

select  flv.lookuptype        type
,   flv.lookupcode        code
,   flvt.meaning    
,   flv.setid             set_id   
,   flv.tag
,   flv.viewapplicationid view_appl_id
,   flv.enabledflag       enabled
,   flv.startdateactive   start_date
,   flv.enddateactive     end_date
from    cat_master_oracle_fusion.sch_gold_layer.fscm_fin_aes_lookupvaluesextractpvo   flv
join  cat_master_oracle_fusion.sch_gold_layer.fscm_fin_aes_lookupvaluestlextractpvo flvt
on    flv.lookuptype        = flvt.lookuptype
  and flv.lookupcode        = flvt.lookupcode
  and flv.viewapplicationid = flvt.viewapplicationid
      and   flvt.language         = 'E'

Databricks UAT

select  flv.lookuptype        type
,   flv.lookupcode        code
,   flvt.meaning    
,   flv.setid             set_id   
,   flv.tag
,   flv.viewapplicationid view_appl_id
,   flv.enabledflag       enabled
,   flv.startdateactive   start_date
,   flv.enddateactive     end_date
from    cat_master_oracle_fusion.sch_gold_layer.fscm_fin_aes_lookupvaluesextractpvo_stg   flv
join  cat_master_oracle_fusion.sch_gold_layer.fscm_fin_aes_lookupvaluestlextractpvo_stg flvt
on    flv.lookuptype        = flvt.lookuptype
  and flv.lookupcode        = flvt.lookupcode
  and flv.viewapplicationid = flvt.viewapplicationid
      and   flvt.language         = 'E'

Databricks PROD

select  flv.lookuptype        type
,   flv.lookupcode        code
,   flvt.meaning    
,   flv.setid             set_id   
,   flv.tag
,   flv.viewapplicationid view_appl_id
,   flv.enabledflag       enabled
,   flv.startdateactive   start_date
,   flv.enddateactive     end_date
from    cat_master_oracle_fusion.sch_gold_layer.fscm_fin_aes_lookupvaluesextractpvo_prd   flv
join  cat_master_oracle_fusion.sch_gold_layer.fscm_fin_aes_lookupvaluestlextractpvo_prd flvt
on    flv.lookuptype        = flvt.lookuptype
  and flv.lookupcode        = flvt.lookupcode
  and flv.viewapplicationid = flvt.viewapplicationid
      and   flvt.language         = 'E'

Oracle

select  lookup_type         type
,   lookup_code         code
,   meaning    
,   set_id   
,   tag
,   view_application_id view_appl_id
,   enabled_flag        enabled
,   start_date_active   start_date
,   end_date_active     end_date
FROM    fnd_lookup_values
WHERE   language  = 'E'

---