eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: EGO.EGO_ITEM_PEOPLE_INTF

Object Details

Object Name:	EGO_ITEM_PEOPLE_INTF
Object Type:	TABLE
Owner:	EGO
FND Design Data:	EGO.EGO_ITEM_PEOPLE_INTF
Subobject Name:
Status:	VALID

This is the Interface table used for Item People Grants Import.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
EGO_ITEM_PEOPLE_INTF_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	DATA_SET_ID SOURCE_SYSTEM_ID SOURCE_SYSTEM_REFERENCE
EGO_ITEM_PEOPLE_INTF_N2	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	TRANSACTION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
INVENTORY_ITEM_ID	NUMBER	(15)		Inventory item identifier.Foreign key to MTL_SYSTEM_ITEMS_B.Identifier for the Inventory Item on which the Role is to be granted.
ORGANIZATION_ID	NUMBER	(15)		Organization identifier.Foreign key to MTL_SYSTEM_ITEMS_B.Item ID + Organization ID form the Unique Key combination on which Role is to be granted.
GRANTEE_PARTY_ID	NUMBER	(15)		Person ID (or) Group ID (or) Global Party ID who gets the grant on Item ID + Organization ID.
INTERNAL_ROLE_ID	NUMBER	(15)		Identifier for the Role to be granted.
INTERNAL_ROLE_NAME	VARCHAR2	(30)		Internal Role Definition name, which is unique.
LAST_UPDATE_DATE	DATE			Standard Who column.
LAST_UPDATED_BY	NUMBER	(15)		Standard Who column.
CREATION_DATE	DATE			Standard Who column.
CREATED_BY	NUMBER	(15)		Standard Who column.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column.
REQUEST_ID	NUMBER	(15)		Concurrent Program Submission Request ID.
PROGRAM_APPLICATION_ID	NUMBER	(15)		Concurrent Program Application ID.
PROGRAM_ID	NUMBER	(15)		Concurrent Program ID.
PROGRAM_UPDATE_DATE	DATE			Concurrent Program update date. When the concurrent program finishes processing this line, the SYSDATE at that time can be set to this column.
ITEM_NUMBER	VARCHAR2	(81)		Inventory Item Number. Inventory Item ID will be derived from Inventory Item Number.
ORGANIZATION_CODE	VARCHAR2	(3)	Yes	Organization Code. Organization ID will be derived from Organization Code.
DISPLAY_ROLE_NAME	VARCHAR2	(80)	Yes	Display name for the Role.
GRANTEE_TYPE	VARCHAR2	(8)	Yes	Type of Grantee. Valid values are : PERSON, GROUP, GLOBAL.
GRANTEE_NAME	VARCHAR2	(360)		Name of the Grantee. Can be a User Name (or) Group Name (or) All Users depending upon the Grantee Type of PERSON (or) GROUP (or) GLOBAL.
START_DATE	DATE		Yes	Grant start date. Grantee gets access to the item from this date.
END_DATE	DATE			Grant end date. Grantee loses access to the item from this date.
TRANSACTION_TYPE	VARCHAR2	(10)	Yes	Type of transaction. Valid values are : CREATE, UPDATE, SYNC, DELETE.
TRANSACTION_ID	NUMBER	(15)		Unique identifier for the line. It is suggested to retrieve the value for this from EGO_IPI_TRANSACTION_ID_S.
PROCESS_STATUS	NUMBER	(15)		Indicates the status of the line. Valid values are : 1 (To be processed), 2 (In Process), 3 (Error), 4 (Success). Other values are mentioned in the EGO_ITEM_PEOPLE_IMPORT_PKG package spec.
DATA_SET_ID	NUMBER	(15)	Yes	Unique identifier for the subset of data. Each of the lines that are newly uploaded in the interface table, need to be given a unique ID, that will be used during the Concurrent program request submission. It is suggested to retrieve the values from EGO_IPI_DATASET_ID_S.
CHANGE_ID	NUMBER			Unique identifier of change that is created for this row
CHANGE_LINE_ID	NUMBER			Unique identifier change type that is created for this row
SOURCE_SYSTEM_ID	NUMBER			Id of Source System.
SOURCE_SYSTEM_REFERENCE	VARCHAR2	(255)		Unique identifier of a record of Source System.

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 does not reference any database object

EGO.EGO_ITEM_PEOPLE_INTF is referenced by following:

EGO: EGO_ITEM_PEOPLE_INTF#