View: PA_FCST_PROJ_SHOW_AMT_V

Product:	PA - Projects
Description:	PA_FCST_PROJ_SHOW_AMT_V is a view that shows project forecasting amount type
Implementation/DBA Data:	APPS.PA_FCST_PROJ_SHOW_AMT_V

View Text

SELECT LOOKUP_CODE
, MEANING FROM PA_LOOKUPS
WHERE LOOKUP_TYPE = 'PA_FORECAST_AMOUNT_TYPE'
AND DECODE(PA_FCST_GLOBAL.GETPROJECTTYPECLASS
, 'CONTRACT'
, DECODE(PA_SECURITY.VIEW_LABOR_COSTS(PA_FCST_GLOBAL.GETPROJECTID)
, 'Y'
, LOOKUP_CODE
, DECODE(LOOKUP_CODE
, 'COST'
, 'X'
, LOOKUP_CODE) )
, DECODE(PA_SECURITY.VIEW_LABOR_COSTS(PA_FCST_GLOBAL.GETPROJECTID)
, 'Y'
, DECODE(LOOKUP_CODE
, 'REVENUE'
, 'X'
, 'MARGIN'
, 'X'
, 'MARGIN_PERCENTAGE'
, 'X'
, LOOKUP_CODE)
, DECODE(LOOKUP_CODE
, 'COST'
, 'X'
, 'REVENUE'
, 'X'
, 'MARGIN'
, 'X'
, 'MARGIN_PERCENTAGE'
, 'X'
, LOOKUP_CODE) ) ) = LOOKUP_CODE

Columns