[Home] [Help]
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
Name |
PROJECT_ID |
PROJECT_NUMBER |
PROJECT_NAME |
OPERATING_UNIT |
OPERATING_UNIT_NAME |