VIEW: APPS.PA_FCST_PROJ_SHOW_AMT_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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