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: BOM.BOM_COPY_STRUCTURE_REQUEST

Object Details

Object Name:	BOM_COPY_STRUCTURE_REQUEST
Object Type:	TABLE
Owner:	BOM
FND Design Data:	BOM.BOM_COPY_STRUCTURE_REQUEST
Subobject Name:
Status:	VALID

BOM_COPY_STRUCTURE_REQUEST stores the extra information for FND Concurrent requests. These are transaction tables. Used for Multi Org copy. Records in the table is identified by COPY_REQUEST_ID.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
BOM_COPY_STRUCTURE_REQUEST_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	COPY_REQUEST_ID

Columns

Name	Datatype	Length	Mandatory	Comments
COPY_REQUEST_ID	NUMBER		Yes	Unique Identifier of the copy request
SRC_ORG_ID	NUMBER		Yes	Source Structure's Organization Id
SRC_ITEM_ID	NUMBER		Yes	Source Structure's Item Id
SRC_ITEM_REV_ID	NUMBER		Yes	Source Structure's Item Revision Id
SRC_STRUCTURE_NAME	VARCHAR2	(10)		Source Structure's structure name
SRC_EXPLOSION_DATE	DATE		Yes	Explosion Date for the source structure
SRC_FROM_END_ITEM_UNIT_NUMBER	VARCHAR2	(30)		End Item Unit Number for the source structure to filter the components
SRC_TO_END_ITEM_UNIT_NUMBER	VARCHAR2	(30)		End Item Unit Number for the source structure to filter the components
SRC_FROM_END_ITEM_REV_ID	NUMBER			End Item Revision for the source structure to filter the components
SRC_FROM_END_ITEM_MNR_REV_ID	NUMBER			End Item Minor Revision for the source structure to filter the components
SRC_TO_END_ITEM_REV_ID	NUMBER			End Item Revision for the source structure to filter the components
SRC_TO_END_ITEM_MNR_REV_ID	NUMBER			End Item Minor Revision for the source structure to filter the components
SRC_FILTER	NUMBER		Yes	Effectivity Filter for source structure
SRC_ECO_FILTER	VARCHAR2	(10)		ECO Filter for source structure
SRC_BILL_SEQUENCE_ID	NUMBER		Yes	Bill Sequence Id of the source structure
SRC_STRUCTURE_TYPE_ID	NUMBER		Yes	Structure Typd Id of the source structure
SRC_EFFECTIVITY_CONTROL	NUMBER		Yes	Effectivity Control of the source structure
TRGT_ORG_ID	NUMBER		Yes	Target Structure's organization id
TRGT_ITEM_ID	NUMBER		Yes	Target Structure's Item Id
TRGT_ITEM_REV_ID	NUMBER		Yes	Target Structure's Item Revision Id
TRGT_STRUCTURE_NAME	VARCHAR2	(10)		Target Structure's structure name
TRGT_EFFECTIVITY_DATE	DATE		Yes	Target structure's effectivity date for component
TRGT_FROM_END_ITEM_UNIT_NUMBER	VARCHAR2	(30)		Target structure's end item unit number for components
TRGT_TO_END_ITEM_UNIT_NUMBER	VARCHAR2	(30)		Target structure's end item unit number for components
TRGT_FROM_END_ITEM_REV_ID	NUMBER			Target structure's end item revision for components
TRGT_FROM_END_ITEM_MNR_REV_ID	NUMBER			Target structure's end item minor revision for components
TRGT_TO_END_ITEM_REV_ID	NUMBER			Target structure's end item revision for components
TRGT_TO_END_ITEM_MNR_REV_ID	NUMBER			Target structure's end item revision for components
TRGT_BILL_SEQUENCE_ID	NUMBER			Target structure's bill sequence id
TRGT_STRUCTURE_TYPE_ID	NUMBER		Yes	Target structure's structure type id
TRGT_EFFECTIVITY_CONTROL	NUMBER		Yes	Target structure's effectivity control
TRGT_STRUCTURE_DESCRIPTION	VARCHAR2	(240)		Target Structure's Description
LEVELS_TO_COPY	NUMBER		Yes	Number of levels to copy
CPY_EXCLUSIONS	VARCHAR2	(1)	Yes	Flag to specify whether exclusions needs to be copied or not
CPY_ROUTINGS	VARCHAR2	(1)	Yes	Flag to specify whether routings needs to be copied or not
CPY_STRUCTURE_ATTRIBUTES	VARCHAR2	(1)	Yes	Flag to specify whether structure attributes needs to be copied or not
CPY_COMPONENT_ATTRIBUTES	VARCHAR2	(1)	Yes	Flag to specify whether component attributes needs to be copied or not
CPY_STRUCTURE_ATTACHMENTS	VARCHAR2	(1)	Yes	Flag to specify whether structure attachments needs to be copied or not
CPY_REFERENCE_DESIGNATORS	VARCHAR2	(1)	Yes	Flag to specify whether reference designators needs to be copied or not
CPY_SUBSTITUTE_COMPONENTS	VARCHAR2	(1)	Yes	Flag to specify whether substitute components needs to be copied or not
CPY_COMPONENT_OPERATIONS	VARCHAR2	(1)	Yes	Flag to specify whether component operations needs to be copied or not
REQUEST_STATUS	VARCHAR2	(1)	Yes	Copy Request Status
ORG_HIERARCHY_NAME	VARCHAR2	(240)		Organization Hierarchy Name for the copy criteria.
ORG_HIERARCHY_ID	NUMBER			Organization Hierarchy Id of the copy criteria.
CHANGE_NOTICE	VARCHAR2	(10)		Copy Operation will create change notice with this name.
CHANGE_ID	NUMBER			Change Id of the Change Order to which the revised items of this copy operation will be added.
CREATED_BY	NUMBER		Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who Column
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER			Standard Who Column
REQUEST_ID	NUMBER			Standard Request Column
PROGRAM_APPLICATION_ID	NUMBER			Standard Request Column
PROGRAM_ID	NUMBER			Standard Request Column
PROGRAM_UPDATE_DATE	DATE			Standard Request Column

Query Text

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


SELECT COPY_REQUEST_ID
,      SRC_ORG_ID
,      SRC_ITEM_ID
,      SRC_ITEM_REV_ID
,      SRC_STRUCTURE_NAME
,      SRC_EXPLOSION_DATE
,      SRC_FROM_END_ITEM_UNIT_NUMBER
,      SRC_TO_END_ITEM_UNIT_NUMBER
,      SRC_FROM_END_ITEM_REV_ID
,      SRC_FROM_END_ITEM_MNR_REV_ID
,      SRC_TO_END_ITEM_REV_ID
,      SRC_TO_END_ITEM_MNR_REV_ID
,      SRC_FILTER
,      SRC_ECO_FILTER
,      SRC_BILL_SEQUENCE_ID
,      SRC_STRUCTURE_TYPE_ID
,      SRC_EFFECTIVITY_CONTROL
,      TRGT_ORG_ID
,      TRGT_ITEM_ID
,      TRGT_ITEM_REV_ID
,      TRGT_STRUCTURE_NAME
,      TRGT_EFFECTIVITY_DATE
,      TRGT_FROM_END_ITEM_UNIT_NUMBER
,      TRGT_TO_END_ITEM_UNIT_NUMBER
,      TRGT_FROM_END_ITEM_REV_ID
,      TRGT_FROM_END_ITEM_MNR_REV_ID
,      TRGT_TO_END_ITEM_REV_ID
,      TRGT_TO_END_ITEM_MNR_REV_ID
,      TRGT_BILL_SEQUENCE_ID
,      TRGT_STRUCTURE_TYPE_ID
,      TRGT_EFFECTIVITY_CONTROL
,      TRGT_STRUCTURE_DESCRIPTION
,      LEVELS_TO_COPY
,      CPY_EXCLUSIONS
,      CPY_ROUTINGS
,      CPY_STRUCTURE_ATTRIBUTES
,      CPY_COMPONENT_ATTRIBUTES
,      CPY_STRUCTURE_ATTACHMENTS
,      CPY_REFERENCE_DESIGNATORS
,      CPY_SUBSTITUTE_COMPONENTS
,      CPY_COMPONENT_OPERATIONS
,      REQUEST_STATUS
,      ORG_HIERARCHY_NAME
,      ORG_HIERARCHY_ID
,      CHANGE_NOTICE
,      CHANGE_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM BOM.BOM_COPY_STRUCTURE_REQUEST;

Dependencies

[top of page]

BOM.BOM_COPY_STRUCTURE_REQUEST does not reference any database object

BOM.BOM_COPY_STRUCTURE_REQUEST is referenced by following:

APPS: BOM_COPY_STRUCTURE_REQUEST