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_REPORT

Object Details

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

This private table contains temporary data to construct a Copy Inventory Organization Report. It is populated by a java session and read by Oracle Reports during a single concurrent request; it will only contain data while the request is running.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
SYS_IL0000169169C00007$$	LOB	UNIQUE	APPS_TS_SUMMARY

Columns

Name	Datatype	Length	Mandatory	Comments
GROUP_CODE	VARCHAR2	(30)	Yes	batch identifier
MODEL_ORGANIZATION_CODE	VARCHAR2	(3)		Organization code of the model organization
ORGANIZATION_CODE	VARCHAR2	(3)		Organization code of the new organization
LOCATION_CODE	VARCHAR2	(60)		Location in HR_LOCATIONS_ALL
BUSINESS_GROUP_NAME	VARCHAR2	(240)		Business Group in HR_ALL_ORGANIZATION_UNITS_TL
STATUS	VARCHAR2	(20)		Status
ERROR_MSG	CLOB	(4000)		Error message that corresponds to an unsuccessfully created organization or location, inconsistent entity type, inconsistent entity or inconsistent modified entity
ENTITY_TYPE	VARCHAR2	(50)		Type of object
COPIED_COUNT	NUMBER			The actual number of entities copied from the model organization for a specific entity type
MODIFIED_COUNT	NUMBER			The actual number of entities copied from the model organization, and modified according to the input XML document, for a specific entity type
NEW_COUNT	NUMBER			The actual number of entities newly created according to the input XML document, for a specific entity type
EXPECTED_COPIED_COUNT	NUMBER			The expected number of entities copied from the model organization for a specific entity type
EXPECTED_MODIFIED_COUNT	NUMBER			The expected number of entities copied from the model organization, and modified according to the input XML document, for a specific entity type
EXPECTED_NEW_COUNT	NUMBER			The expected number of entities newly created according to the input XML document, for a specific entity type
ENTITY_NAME	VARCHAR2	(300)		The display name of the entity
FIELD_NAME	VARCHAR2	(100)		The display name of the attribute
ENTITY_INCONSISTENCY	VARCHAR2	(30)		The type of inconsistency of the entity
FIELD_INCONSISTENCY	VARCHAR2	(30)		The type of discrepancy of the field of a modified entity
REC_TYPE	VARCHAR2	(40)	Yes	The content type of the current row
REQUEST_ID	NUMBER			Standard Who Column

Query Text

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


SELECT GROUP_CODE
,      MODEL_ORGANIZATION_CODE
,      ORGANIZATION_CODE
,      LOCATION_CODE
,      BUSINESS_GROUP_NAME
,      STATUS
,      ERROR_MSG
,      ENTITY_TYPE
,      COPIED_COUNT
,      MODIFIED_COUNT
,      NEW_COUNT
,      EXPECTED_COPIED_COUNT
,      EXPECTED_MODIFIED_COUNT
,      EXPECTED_NEW_COUNT
,      ENTITY_NAME
,      FIELD_NAME
,      ENTITY_INCONSISTENCY
,      FIELD_INCONSISTENCY
,      REC_TYPE
,      REQUEST_ID
FROM INV.MTL_COPY_ORG_REPORT;

Dependencies

[top of page]

INV.MTL_COPY_ORG_REPORT does not reference any database object

INV.MTL_COPY_ORG_REPORT is referenced by following:

APPS: MTL_COPY_ORG_REPORT