View: PJM_PROJECT_SEIBAN_V

Product:	PJM - Project Manufacturing
Description:	Seiban information for the Web Inquiry.
Implementation/DBA Data:	APPS.PJM_PROJECT_SEIBAN_V

View Text

SELECT SEIB.PROJECT_ID
, SEIB.PROJECT_NUMBER
, SEIB.PROJECT_NAME
, SEIB.OPERATING_UNIT
, ORG.NAME
FROM PJM_SEIBAN_NUMBERS SEIB
, HR_ALL_ORGANIZATION_UNITS_TL ORG
WHERE ORG.ORGANIZATION_ID (+) = SEIB.OPERATING_UNIT
AND ORG.LANGUAGE (+) = USERENV('LANG')

Columns