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

TABLE: CSI.CSI_CTR_UPLOAD_INSTANCES

Object Details
Object Name: CSI_CTR_UPLOAD_INSTANCES
Object Type: TABLE
Owner: CSI
FND Design Data: TableCSI.CSI_CTR_UPLOAD_INSTANCES
Subobject Name:
Status: VALID


This is a staging table for holding counter information to be uploaded in the Counter Instance main tables. These counter instance could come from different sources identified by the Source_Transaction_Type.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
UPLOAD_INSTANCE_ID NUMBER
Yes Upload Instance Id
SOURCE_OBJECT_ID NUMBER
Yes Source Object Id
SOURCE_OBJECT_CODE VARCHAR2 (30) Yes Source Object Code
ITEM_ID NUMBER

Item Inventory Id
ORG_ID NUMBER

Organization Id
STATUS VARCHAR2 (30)
Status
ERROR_MESSAGE VARCHAR2 (240)
Error Message
LAST_UPDATE_DATE DATE
Yes Standard WHO Columns
LAST_UPDATED_BY NUMBER
Yes Standard WHO Columns
LAST_UPDATE_LOGIN NUMBER

Standard WHO Columns
CREATION_DATE DATE
Yes Standard WHO Columns
CREATED_BY NUMBER
Yes Standard WHO Columns
Query Text

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


SELECT UPLOAD_INSTANCE_ID
,      SOURCE_OBJECT_ID
,      SOURCE_OBJECT_CODE
,      ITEM_ID
,      ORG_ID
,      STATUS
,      ERROR_MESSAGE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
FROM CSI.CSI_CTR_UPLOAD_INSTANCES;

Dependencies

[top of page]

CSI.CSI_CTR_UPLOAD_INSTANCES does not reference any database object

CSI.CSI_CTR_UPLOAD_INSTANCES is referenced by following:

SchemaCSI
ViewCSI_CTR_UPLOAD_INSTANCES#