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

TABLE: CS.CS_UPG_SLABS

Object Details
Object Name: CS_UPG_SLABS
Object Type: TABLE
Owner: CS
FND Design Data: TableCS.CS_UPG_SLABS
Subobject Name:
Status: VALID


A control table that is used for data migration. This table is used to specify the ranges in which data will be migrated from the original table to the target table. This holds the starting Id number and the end Id number. Each record is a slab.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
SOURCE_TABLE VARCHAR2 (30) Yes The name of the source table from where data is being migrated.
MODULE VARCHAR2 (30) Yes The module to which the table belongs.
SLAB_NUMBER NUMBER
Yes The serial number of the slab.
SLAB_START NUMBER
Yes The Id of the starting record in the slab.
SLAB_END NUMBER
Yes The Id of the last record in the slab.
CREATED_BY NUMBER
Yes Standard who column.
CREATED_ON DATE
Yes Standard who column.
INVENTORY_MIGRATED_FLAG VARCHAR2 (1)
Use for Inventory On Hand Balance migration indicator flag
Query Text

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


SELECT SOURCE_TABLE
,      MODULE
,      SLAB_NUMBER
,      SLAB_START
,      SLAB_END
,      CREATED_BY
,      CREATED_ON
,      INVENTORY_MIGRATED_FLAG
FROM CS.CS_UPG_SLABS;

Dependencies

[top of page]

CS.CS_UPG_SLABS does not reference any database object

CS.CS_UPG_SLABS is referenced by following:

SchemaAPPS
SynonymCS_UPG_SLABS