View: PJM_TASKS_MXFR_V

Product:	PJM - Project Manufacturing
Description:
Implementation/DBA Data:	APPS.PJM_TASKS_MXFR_V

View Text

SELECT PROJECT_ID
, TASK_ID
, TASK_NUMBER
, TASK_NAME
, TASK_NUMBER || ' (' || TASK_NAME || ')'
, CHARGEABLE_FLAG
, 'N'
FROM PA_TASKS_EXPEND_V UNION ALL SELECT PP.PROJECT_ID
, 0
, FND_MESSAGE_CACHE.GET_STRING('PJM'
, 'MXFR-PROJECT LEVEL')
, FND_MESSAGE_CACHE.GET_STRING('PJM'
, 'MXFR-PROJECT LEVEL')
, FND_MESSAGE_CACHE.GET_STRING('PJM'
, 'MXFR-PROJECT LEVEL')
, 'Y'
, 'N'
FROM PJM_PROJECT_PARAMETERS PP
, PJM_ORG_PARAMETERS OP
WHERE OP.ORGANIZATION_ID = FND_PROFILE.VALUE('MFG_ORGANIZATION_ID')
AND OP.PROJECT_CONTROL_LEVEL = 1
AND PP.ORGANIZATION_ID = OP.ORGANIZATION_ID

Columns