Product: | FII - Financial Intelligence |
---|---|
Description: | FIIBV_AP_RLSE_RELEASE_LCV is the base view for Release level of Release dimension |
Implementation/DBA Data: | APPS.FIIBV_AP_RLSE_RELEASE_LCV |
SELECT AHC.HOLD_LOOKUP_CODE RELEASE_PK
, AHC.HOLD_TYPE RELEASE_TYPE_FK
, SUBSTRB(EDW_INSTANCE.GET_CODE
, 1
, 40) INSTANCE
, ALC.DISPLAYED_FIELD NAME
, ALC.DISPLAYED_FIELD RELEASE_NAME
, AHC.USER_RELEASEABLE_FLAG USER_RELEASEABLE_FLAG
, AHC.USER_UPDATEABLE_FLAG USER_UPDATEABLE_FLAG
, AHC.POSTABLE_FLAG POSTABLE_FLAG
, AHC.INACTIVE_DATE INACTIVE_DATE
, ALC.DESCRIPTION DESCRIPTION
, AHC.LAST_UPDATE_DATE LAST_UPDATE_DATE
, AHC.CREATION_DATE CREATION_DATE
, NULL DELETION_DATE
, NULL RELEASE_DP
, '_DF:FND:FND_COMMON_LOOKUPS:FND'
FROM AP_LOOKUP_CODES ALC
, AP_HOLD_CODES AHC
, FND_LOOKUP_VALUES FND
WHERE AHC.HOLD_LOOKUP_CODE = ALC.LOOKUP_CODE
AND ALC.LOOKUP_TYPE=FND.LOOKUP_TYPE
AND ALC.LOOKUP_CODE=FND.LOOKUP_CODE
AND ALC.DISPLAYED_FIELD=FND.MEANING
AND (AHC.HOLD_TYPE LIKE '%RELEASE%' OR AHC.HOLD_TYPE = 'SUFFICIENT INFORMATION')
AND ALC.LOOKUP_TYPE = 'HOLD CODE'