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

TABLE: GMP.MR_SHDY_DTL

Object Details
Object Name: MR_SHDY_DTL
Object Type: TABLE
Owner: GMP
FND Design Data: TableGMP.MR_SHDY_DTL
Subobject Name:
Status: VALID


Shop day detail. Provides details of the shop day.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MR_SHDY_DTL_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSHOPDAY_NO
ColumnSHIFT_NO
Columns
Name Datatype Length Mandatory Comments
SHOPDAY_NO VARCHAR2 (8) Yes Name of the shop day.
SHIFT_NO NUMBER (5) Yes Shift number in the day.
SHIFT_START NUMBER (10) Yes Shift start time, stored in seconds since midnight.
SHIFT_DURATION NUMBER (10) Yes Shift duration, stored in seconds.
CREATION_DATE DATE
Yes Standard who column
LAST_UPDATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATE_DATE DATE
Yes Standard who column
CREATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
DELETE_MARK NUMBER (5) Yes Standard: 0=Active record (default); 1=Marked for (logical) deletion.
TRANS_CNT NUMBER (10)
Not currently used
TEXT_CODE NUMBER (10)
ID which joins any rows of text in this table to the Text Table for this Module
Query Text

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


SELECT SHOPDAY_NO
,      SHIFT_NO
,      SHIFT_START
,      SHIFT_DURATION
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      DELETE_MARK
,      TRANS_CNT
,      TEXT_CODE
FROM GMP.MR_SHDY_DTL;

Dependencies

[top of page]

GMP.MR_SHDY_DTL does not reference any database object

GMP.MR_SHDY_DTL is referenced by following:

SchemaAPPS
SynonymMR_SHDY_DTL