Product: | ENG - Engineering |
---|---|
Description: | Autonumbering information for specific organizations |
Implementation/DBA Data: | APPS.ENG_AUTONUM_ORGS_V |
SELECT EANE.ROWID ROW_ID
, MP.ORGANIZATION_CODE
, OON.NAME ORGANIZATION_NAME
, EANE.USER_ID
, EANE.ORGANIZATION_ID
, EANE.LAST_UPDATE_DATE
, EANE.LAST_UPDATED_BY
, EANE.CREATION_DATE
, EANE.CREATED_BY
, EANE.LAST_UPDATE_LOGIN
, EANE.ALPHA_PREFIX
, EANE.NEXT_AVAILABLE_NUMBER
, EANE.REQUEST_ID
, EANE.PROGRAM_APPLICATION_ID
, EANE.PROGRAM_ID
, EANE.PROGRAM_UPDATE_DATE
FROM ENG_AUTO_NUMBER_ECN EANE
, HR_ALL_ORGANIZATION_UNITS_TL OON
, MTL_PARAMETERS MP
WHERE EANE.ORGANIZATION_ID = OON.ORGANIZATION_ID
AND OON.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND OON.LANGUAGE = USERENV('LANG')