VIEW: APPS.PJM_PROJECTS_ORG_OU_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')