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: AHL.AHL_MR_HEADERS_B

Object Details

Object Name:	AHL_MR_HEADERS_B
Object Type:	TABLE
Owner:	AHL
FND Design Data:	AHL.AHL_MR_HEADERS_B
Subobject Name:
Status:	VALID

This table stores the maintenance requirement header information.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AHL_MR_HEADERS_B_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	MR_HEADER_ID
AHL_MR_HEADERS_B_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	TITLE VERSION_NUMBER APPLICATION_USG_CODE
AHL_MR_HEADERS_B_N2	FUNCTION-BASED NORMAL	NONUNIQUE	APPS_TS_TX_IDX	UPPER("TITLE")
AHL_MR_HEADERS_B_N3	NORMAL	NONUNIQUE	APPS_TS_SEED	TITLE MR_STATUS_CODE EFFECTIVE_TO EFFECTIVE_FROM VERSION_NUMBER
AHL_MR_HEADERS_B_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TYPE_CODE
AHL_MR_HEADERS_B_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	APPLICATION_USG_CODE
AHL_MR_HEADERS_B_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PRECEDING_MR_HEADER_ID

Columns

Name	Datatype	Length	Mandatory	Comments
MR_HEADER_ID	NUMBER		Yes	Primary key, unique identifier of a maintenance requirement
OBJECT_VERSION_NUMBER	NUMBER		Yes	Stores locking sequence number
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
TITLE	VARCHAR2	(80)	Yes	User defined name of the MR
VERSION_NUMBER	NUMBER		Yes	System defined revision number of the MR
PRECEDING_MR_HEADER_ID	NUMBER			The MR_HEADER_ID that presides this one, used for dependency calculations
CATEGORY_CODE	VARCHAR2	(30)	Yes	User defined category of the MR
SERVICE_TYPE_CODE	VARCHAR2	(3)		Seeded service type of the MR, either ON or OFF
MR_STATUS_CODE	VARCHAR2	(30)	Yes	Seeded revision status code of the MR, either DRAFT, COMPLETED, APPROVAL_PENDING or APPROVAL_REJECTED
IMPLEMENT_STATUS_CODE	VARCHAR2	(30)	Yes	Implementation status code
REPETITIVE_FLAG	VARCHAR2	(1)	Yes	Seeded repetitive flag of the MR, either YES or NO
SHOW_REPETITIVE_CODE	VARCHAR2	(4)	Yes	Seeded flag which is used to show repeating MRs in Unit Maintenance Plan, either ALL or NEXT
COPY_ACCOMPLISHMENT_FLAG	VARCHAR2	(1)	Yes	Flag to indicate whether the last accomplishment of the MR should be copied to Unit Maintenance Plan when a new revision is created, either Y or N
WHICHEVER_FIRST_CODE	VARCHAR2	(5)	Yes	Flag to determine whether to choose either the first or last due date calculated on all Intervals/Threshold defined for the MR, either FIRST or LAST
PROGRAM_TYPE_CODE	VARCHAR2	(30)	Yes	User defined program type code of the MR
PROGRAM_SUBTYPE_CODE	VARCHAR2	(30)		User defined program sub type of the MR
EFFECTIVE_FROM	DATE		Yes	Effective start date of the MR
EFFECTIVE_TO	DATE			Effective end date of the MR
REVISION	VARCHAR2	(30)		User defined revision number of the MR
SERVICE_REQUEST_TEMPLATE_ID	NUMBER			To store the service request template association for Preventive Maintenance
TYPE_CODE	VARCHAR2	(30)		Seeded type of Preventive Maintenance, either PROGRAM or ACTIVITY
DOWN_TIME	NUMBER			The down time for the maintenance requirements
UOM_CODE	VARCHAR2	(30)		UOM of down_time
SECURITY_GROUP_ID	NUMBER			Used in application hosting
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure defining column
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment column
QA_INSPECTION_TYPE	VARCHAR2	(150)		Quality Inspection Type
BILLING_ITEM_ID	NUMBER	(15)		Billing item Id fkey from mtl_system_items_b_kfv for costing purpose
BILLING_ORG_ID	NUMBER			Inventory Organization ID for the Billing Item.
SPACE_CATEGORY_CODE	VARCHAR2	(30)		Space category code shown in ui as visit type code
APPLICATION_USG_CODE	VARCHAR2	(30)		Application Usage Code refers to AHL_APPLN_USAGE profile value
AUTO_SIGNOFF_FLAG	VARCHAR2	(30)		Auto Signoff Flag Used for Deffering a workorder in production module
COPY_INIT_ACCOMPL_FLAG	VARCHAR2	(1)		Copy First Due definitions from previous revision to current revision when revision is approved.
COPY_DEFERRALS_FLAG	VARCHAR2	(1)		Copy Deferrals from previous revision to current revision when revision is approved.
TERMINATION_REQUIRED_FLAG	VARCHAR2	(1)		Termination Required Flag
WARRANTY_TEMPLATE_ID	NUMBER			Warranty Template
SERVICE_CATEGORY_RANK	NUMBER			Rank for the Service Category

Query Text

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


SELECT MR_HEADER_ID
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      TITLE
,      VERSION_NUMBER
,      PRECEDING_MR_HEADER_ID
,      CATEGORY_CODE
,      SERVICE_TYPE_CODE
,      MR_STATUS_CODE
,      IMPLEMENT_STATUS_CODE
,      REPETITIVE_FLAG
,      SHOW_REPETITIVE_CODE
,      COPY_ACCOMPLISHMENT_FLAG
,      WHICHEVER_FIRST_CODE
,      PROGRAM_TYPE_CODE
,      PROGRAM_SUBTYPE_CODE
,      EFFECTIVE_FROM
,      EFFECTIVE_TO
,      REVISION
,      SERVICE_REQUEST_TEMPLATE_ID
,      TYPE_CODE
,      DOWN_TIME
,      UOM_CODE
,      SECURITY_GROUP_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      QA_INSPECTION_TYPE
,      BILLING_ITEM_ID
,      BILLING_ORG_ID
,      SPACE_CATEGORY_CODE
,      APPLICATION_USG_CODE
,      AUTO_SIGNOFF_FLAG
,      COPY_INIT_ACCOMPL_FLAG
,      COPY_DEFERRALS_FLAG
,      TERMINATION_REQUIRED_FLAG
,      WARRANTY_TEMPLATE_ID
,      SERVICE_CATEGORY_RANK
FROM AHL.AHL_MR_HEADERS_B;

Dependencies

[top of page]

AHL.AHL_MR_HEADERS_B does not reference any database object

AHL.AHL_MR_HEADERS_B is referenced by following:

AHL: AHL_MR_HEADERS_B#