eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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:	GMP.MR_SHCL_HDR
Subobject Name:
Status:	VALID

Shop calendar header.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MR_SHCL_HDR_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	CALENDAR_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:

APPS: MR_SHCL_HDR