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


TABLE: GMP.MR_SHCL_HDR

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


Shop calendar header.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MR_SHCL_HDR_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCALENDAR_ID
Columns
Name Datatype Length Mandatory Comments
CALENDAR_ID NUMBER (10) Yes Surrogate key for the shop calendar.
CALENDAR_NO VARCHAR2 (16) Yes Name of the shop calendar.
CALENDAR_DESC VARCHAR2 (40) Yes Description of the shop calendar.
ACTIVE_IND NUMBER (5) Yes Whetether calendar is active. 0=Inactive; 1=Active.
DAY1 VARCHAR2 (8)
Identifies the default type of shop day for Sundays.
DAY2 VARCHAR2 (8)
Identifies the default type of shop day for Mondays.
DAY3 VARCHAR2 (8)
Identifies the default type of shop day for Tuesdays.
DAY4 VARCHAR2 (8)
Identifies the default type of shop day for Wednesdays.
DAY5 VARCHAR2 (8)
Identifies the default type of shop day for Thursdays.
DAY6 VARCHAR2 (8)
Identifies the default type of shop day for Fridays.
DAY7 VARCHAR2 (8)
Identifies the default type of shop day for Saturdays.
CREATION_DATE DATE
Yes Standard who column
CREATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATE_DATE DATE
Yes Standard who column
LAST_UPDATED_BY NUMBER (15) Yes Standard who column
TEXT_CODE NUMBER (10)
ID which joins any rows of text in this table to the Text Table for this Module
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
IN_USE NUMBER (10)
Not currently used
DELETE_MARK NUMBER (5) Yes Standard: 0=Active record (default); 1=Marked for (logical) deletion.
DAILY_WORK_HOURS NUMBER

This is the column that identifies the Average Work hours for a work day
Query Text

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


SELECT CALENDAR_ID
,      CALENDAR_NO
,      CALENDAR_DESC
,      ACTIVE_IND
,      DAY1
,      DAY2
,      DAY3
,      DAY4
,      DAY5
,      DAY6
,      DAY7
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      TEXT_CODE
,      LAST_UPDATE_LOGIN
,      IN_USE
,      DELETE_MARK
,      DAILY_WORK_HOURS
FROM GMP.MR_SHCL_HDR;

Dependencies

[top of page]

GMP.MR_SHCL_HDR does not reference any database object

GMP.MR_SHCL_HDR is referenced by following:

SchemaGMP
ViewMR_SHCL_HDR#