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

TABLE: DDD.DDD_ITEM_MAPPING_INFO

Object Details
Object Name: DDD_ITEM_MAPPING_INFO
Object Type: TABLE
Owner: DDD
FND Design Data: TableDDD.DDD_ITEM_MAPPING_INFO
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
DDD_ITEM_MAPPING_INFO_COMP_N NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCOMPONENT_ID
Columns
Name Datatype Length Mandatory Comments
ITEM_CAD_MAP_ID NUMBER
Yes Item CAD map id
COMPONENT_ID NUMBER
Yes Component id
OBJECT_NAME VARCHAR2 (255)
Object name
OBJECT_TYPE NUMBER (18)
Object type
OBJECT_VERSION NUMBER

Object version
CAD_GUID NUMBER

CAD GUID
LAST_UPDATE_DATE DATE

Standard WHO column
LAST_UPDATED_BY VARCHAR2 (255)
Standard WHO column
CREATION_DATE DATE

Standard WHO column
CREATED_BY VARCHAR2 (255)
Standard WHO column
EFFECTIVE_DATE_FROM DATE

Effective date from
EFFECTIVE_DATE_TO DATE

Date effective to
MAP_STATUS NUMBER

Map status
PK1_VALUE VARCHAR2 (150)
Primary key of the object
PK2_VALUE VARCHAR2 (150)
Primary key of the object
PK3_VALUE VARCHAR2 (150)
Primary key of the object
PK4_VALUE VARCHAR2 (150)
Primary key of the object
PK5_VALUE VARCHAR2 (150)
Primary key of the object
Query Text

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


SELECT ITEM_CAD_MAP_ID
,      COMPONENT_ID
,      OBJECT_NAME
,      OBJECT_TYPE
,      OBJECT_VERSION
,      CAD_GUID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      EFFECTIVE_DATE_FROM
,      EFFECTIVE_DATE_TO
,      MAP_STATUS
,      PK1_VALUE
,      PK2_VALUE
,      PK3_VALUE
,      PK4_VALUE
,      PK5_VALUE
FROM DDD.DDD_ITEM_MAPPING_INFO;

Dependencies

[top of page]

DDD.DDD_ITEM_MAPPING_INFO does not reference any database object

DDD.DDD_ITEM_MAPPING_INFO is referenced by following:

SchemaAPPS
SynonymDDD_ITEM_MAPPING_INFO