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: INV.MTL_COPY_ORG_INTERFACE

Object Details

Object Name:	MTL_COPY_ORG_INTERFACE
Object Type:	TABLE
Owner:	INV
FND Design Data:	INV.MTL_COPY_ORG_INTERFACE
Subobject Name:
Status:	VALID

Interface Table for the Copy Inventory Organizations Concurrent Program. The GROUP_CODE column is used in Copy Inventory Organizations Standard Concurrent Request to identify a set of rows that describe the organizations to be generated by copying from the model organization. The XML column stores the XML that describes the new organization.
Scope: public
Lifecycle: active
Display Name: Copy Inventory Organization Interface
Product: INV
Category: BUSINESS_ENTITY INV_ORGANIZATION_SETUP

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MTL_COPY_ORG_INTERFACE_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	GROUP_CODE ORGANIZATION_CODE
SYS_IL0000149232C00002$$	LOB	UNIQUE	APPS_TS_INTERFACE

Columns

Name	Datatype	Length	Mandatory	Comments
GROUP_CODE	VARCHAR2	(30)	Yes	Batch identifier
XML	CLOB	(4000)		Data describing a new organization, including deviations from the model organization
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
ORGANIZATION_CODE	VARCHAR2	(3)	Yes	Organization Code for the new organization to be created
STATUS	VARCHAR2	(1)		Success or Failure, updated by Copy Inventory Organization concurrent request
OPTIONS	VARCHAR2	(200)		Input Parameters for the Copy Inventory Organization program with their values
LAST_ENTITY_NUMBER	NUMBER	(2)		Stores the last successfully created entity number when Copy Inventory Organization program fails
SITE_ID	NUMBER			To associate a relationship between the inventory organization and the site once the org is created. It is a foreign key to the site table

Query Text

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


SELECT GROUP_CODE
,      XML
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ORGANIZATION_CODE
,      STATUS
,      OPTIONS
,      LAST_ENTITY_NUMBER
,      SITE_ID
FROM INV.MTL_COPY_ORG_INTERFACE;

Dependencies

[top of page]

INV.MTL_COPY_ORG_INTERFACE does not reference any database object

INV.MTL_COPY_ORG_INTERFACE is referenced by following:

APPS: MTL_COPY_ORG_INTERFACE