View: PJM_PROJECTS_ORG_OU_V

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

View Text

SELECT PP.ORGANIZATION_ID
, P.EXPENDITURE_ORG_ID
, P.PROJECT_ID
, P.PROJECT_NUMBER
, P.PROJECT_NAME
, P.PROJECT_DESCRIPTION
, P.PROJECT_NUMBER_SORT_ORDER
, O.NAME
, P.START_DATE
, P.COMPLETION_DATE
, PP.COSTING_GROUP_ID
, PP.PLANNING_GROUP
FROM PJM_PROJECT_PARAMETERS PP
, ( SELECT P.PROJECT_ID
, P.PROJECT_NUMBER
, P.PROJECT_NAME
, P.PROJECT_DESCRIPTION
, P.PROJECT_NUMBER_SORT_ORDER
, P.START_DATE
, P.COMPLETION_DATE
, 2 SEIBAN_NUMBER_FLAG
, P.ORG_ID
, P.EXPENDITURE_ORG_ID
FROM PA_PROJECTS_ALL_EXPEND_V P UNION ALL SELECT S.PROJECT_ID
, S.PROJECT_NUMBER
, S.PROJECT_NAME
, S.PROJECT_NAME
, S.PROJECT_NUMBER
, TO_DATE(NULL)
, TO_DATE(NULL)
, 1
, S.OPERATING_UNIT
, TO_NUMBER(NULL)
FROM PJM_SEIBAN_NUMBERS S ) P
, HR_ALL_ORGANIZATION_UNITS_TL O
WHERE PP.PROJECT_ID = P.PROJECT_ID
AND O.ORGANIZATION_ID (+) = P.ORG_ID
AND O.LANGUAGE (+) = USERENV('LANG')

Columns