View: EDW_HOLD_MPV

Product:	FII - Financial Intelligence
Description:	EDW_HOLD_MPV is the view for data validity on source side.
Implementation/DBA Data:	APPS.EDW_HOLD_MPV

View Text

SELECT AHC.HOLD_LOOKUP_CODE
, AHC.LAST_UPDATE_DATE
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