View: FIIBV_AP_HOLD_HOLD_LCV

Product:	FII - Financial Intelligence
Description:	FIIBV_AP_HOLD_HOLD_LCV is the base view for Hold level of AP Hold dimension
Implementation/DBA Data:	APPS.FIIBV_AP_HOLD_HOLD_LCV

View Text

SELECT AHC.HOLD_LOOKUP_CODE HOLD_PK
, AHC.HOLD_TYPE HOLD_TYPE_FK
, SUBSTRB(EDW_INSTANCE.GET_CODE
, 1
, 40) INSTANCE
, ALC.DISPLAYED_FIELD NAME
, ALC.DISPLAYED_FIELD HOLD_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
, AHC.DESCRIPTION DESCRIPTION
, AHC.LAST_UPDATE_DATE LAST_UPDATE_DATE
, AHC.CREATION_DATE CREATION_DATE
, NULL DELETION_DATE
, NULL HOLD_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 '%HOLD%' OR AHC.HOLD_TYPE = 'INSUFFICIENT INFORMATION')
AND ALC.LOOKUP_TYPE = 'HOLD CODE'

Columns