[Home] [Help]
View: ENG_AUTONUM_ALL_ORGS_V
Product: | ENG - Engineering |
Description: | Autonumbering information for all organizations, not specific organizations |
Implementation/DBA Data: |
APPS.ENG_AUTONUM_ALL_ORGS_V
|
View Text
SELECT EANE.ROWID ROW_ID
, 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
, EANE.CHANGE_TYPE_ID
FROM ENG_AUTO_NUMBER_ECN EANE
WHERE EANE.ORGANIZATION_ID IS NULL
Columns
Name |
ROW_ID |
USER_ID |
ORGANIZATION_ID |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_LOGIN |
ALPHA_PREFIX |
NEXT_AVAILABLE_NUMBER |
REQUEST_ID |
PROGRAM_APPLICATION_ID |
PROGRAM_ID |
PROGRAM_UPDATE_DATE |
CHANGE_TYPE_ID |