DBA Data[Home] [Help] [Dependency Information]

VIEW: EGO.EGO_ITEM_PEOPLE_INTF#

Object Details
Object Name: EGO_ITEM_PEOPLE_INTF#
Object Type: VIEW
Owner: EGO
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
INVENTORY_ITEM_ID NUMBER (15)
ORGANIZATION_ID NUMBER (15)
GRANTEE_PARTY_ID NUMBER (15)
INTERNAL_ROLE_ID NUMBER (15)
INTERNAL_ROLE_NAME VARCHAR2 (30)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
CREATION_DATE DATE

CREATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
REQUEST_ID NUMBER (15)
PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
PROGRAM_UPDATE_DATE DATE

ITEM_NUMBER VARCHAR2 (81)
ORGANIZATION_CODE VARCHAR2 (3) Yes
DISPLAY_ROLE_NAME VARCHAR2 (80) Yes
GRANTEE_TYPE VARCHAR2 (8) Yes
GRANTEE_NAME VARCHAR2 (360)
START_DATE DATE
Yes
END_DATE DATE

TRANSACTION_TYPE VARCHAR2 (10) Yes
TRANSACTION_ID NUMBER (15)
PROCESS_STATUS NUMBER (15)
DATA_SET_ID NUMBER (15) Yes
CHANGE_ID NUMBER

CHANGE_LINE_ID NUMBER

SOURCE_SYSTEM_ID NUMBER

SOURCE_SYSTEM_REFERENCE VARCHAR2 (255)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      GRANTEE_PARTY_ID
,      INTERNAL_ROLE_ID
,      INTERNAL_ROLE_NAME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ITEM_NUMBER
,      ORGANIZATION_CODE
,      DISPLAY_ROLE_NAME
,      GRANTEE_TYPE
,      GRANTEE_NAME
,      START_DATE
,      END_DATE
,      TRANSACTION_TYPE
,      TRANSACTION_ID
,      PROCESS_STATUS
,      DATA_SET_ID
,      CHANGE_ID
,      CHANGE_LINE_ID
,      SOURCE_SYSTEM_ID
,      SOURCE_SYSTEM_REFERENCE
FROM EGO.EGO_ITEM_PEOPLE_INTF#;

Dependencies

[top of page]

EGO.EGO_ITEM_PEOPLE_INTF# references the following:

SchemaEGO
TableEGO_ITEM_PEOPLE_INTF
EGO.EGO_ITEM_PEOPLE_INTF# is referenced by following:

SchemaAPPS
SynonymEGO_ITEM_PEOPLE_INTF