[Home] [Help]
View: FIIBV_AP_RLSE_RELEASE_TYPE_LCV
Product: | FII - Financial Intelligence |
Description: | FIIBV_AP_RLSE_RELEASE_TYPE_LCV is the base view for Release Type level of Release dimension |
Implementation/DBA Data: |
APPS.FIIBV_AP_RLSE_RELEASE_TYPE_LCV
|
View Text
SELECT LC.LOOKUP_CODE RELEASE_TYPE_PK
, 'ALL' ALL_FK
, SUBSTRB(EDW_INSTANCE.GET_CODE
, 1
, 40) INSTANCE
, LC.DISPLAYED_FIELD NAME
, LC.DISPLAYED_FIELD RELEASE_TYPE
, LC.DESCRIPTION DESCRIPTION
, NVL(LC.START_DATE_ACTIVE
, SYSDATE-1) LAST_UPDATE_DATE
, NVL(LC.START_DATE_ACTIVE
, SYSDATE-1) CREATION_DATE
, NULL DELETION_DATE
, NULL RELEASE_TYPE_DP
, '_DF:FND:FND_COMMON_LOOKUPS:FND'
FROM AP_LOOKUP_CODES LC
, FND_LOOKUP_VALUES FND
WHERE LC.LOOKUP_TYPE = 'HOLD TYPE'
AND LC.LOOKUP_TYPE=FND.LOOKUP_TYPE
AND LC.LOOKUP_CODE=FND.LOOKUP_CODE
AND LC.DISPLAYED_FIELD=FND.MEANING
AND (LC.LOOKUP_CODE LIKE '%RELEASE%' OR LC.LOOKUP_CODE = 'SUFFICIENT INFORMATION')
Columns
Name |
RELEASE_TYPE_PK |
ALL_FK |
INSTANCE |
NAME |
RELEASE_TYPE |
DESCRIPTION |
LAST_UPDATE_DATE |
CREATION_DATE |
DELETION_DATE |
RELEASE_TYPE_DP |
"_DF:FND:_EDW" |