VIEW: APPS.PJM_TASKS_MXFR_V

Source

View Text - Preformatted

SELECT PROJECT_ID , TASK_ID , TASK_NUMBER , TASK_NAME , TASK_NUMBER || ' (' || TASK_NAME || ')' , CHARGEABLE_FLAG , 'N' FROM PA_TASKS_ALL_EXPEND_V WHERE EXPENDITURE_ORG_ID = (SELECT ORG_INFORMATION3 FROM HR_ORGANIZATION_INFORMATION WHERE (ORG_INFORMATION_CONTEXT || '') ='Accounting Information' AND ORGANIZATION_ID = FND_PROFILE.VALUE('MFG_ORGANIZATION_ID') ) UNION ALL SELECT DISTINCT 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 PA_PROJECTS_ALL_EXPEND_V WHERE EXPENDITURE_ORG_ID = (SELECT ORG_INFORMATION3 FROM HR_ORGANIZATION_INFORMATION WHERE (ORG_INFORMATION_CONTEXT || '') ='Accounting Information' AND ORGANIZATION_ID = FND_PROFILE.VALUE('MFG_ORGANIZATION_ID') )

View Text - HTML Formatted

SELECT PROJECT_ID
, TASK_ID
, TASK_NUMBER
, TASK_NAME
, TASK_NUMBER || ' (' || TASK_NAME || ')'
, CHARGEABLE_FLAG
, 'N'
FROM PA_TASKS_ALL_EXPEND_V
WHERE EXPENDITURE_ORG_ID = (SELECT ORG_INFORMATION3
FROM HR_ORGANIZATION_INFORMATION
WHERE (ORG_INFORMATION_CONTEXT || '') ='ACCOUNTING INFORMATION'
AND ORGANIZATION_ID = FND_PROFILE.VALUE('MFG_ORGANIZATION_ID') ) UNION ALL SELECT DISTINCT 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 PA_PROJECTS_ALL_EXPEND_V
WHERE EXPENDITURE_ORG_ID = (SELECT ORG_INFORMATION3
FROM HR_ORGANIZATION_INFORMATION
WHERE (ORG_INFORMATION_CONTEXT || '') ='ACCOUNTING INFORMATION'
AND ORGANIZATION_ID = FND_PROFILE.VALUE('MFG_ORGANIZATION_ID') )