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


VIEW: APPS.AHL_MR_HEADERS_V

Object Details
Object Name: AHL_MR_HEADERS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAHL.AHL_MR_HEADERS_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
MR_HEADER_ID NUMBER
Yes Primary Key for AHL_MR_HEADERS_B, unique identifier of a MR
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 a MR. The Combination of MR Title, Revision and Version Number is unique.
VERSION_NUMBER NUMBER
Yes System Defined Revision number of the MR.
PRECEDING_MR_HEADER_ID NUMBER

The MR_HEADER_ID that precedes this one. Used for dependency calculations.
PRECEDING_MR_TITLE VARCHAR2 (80)
The Title of the MR that precedes this one.
PRECEDING_MR_REVISION VARCHAR2 (30)
User Defined Revision number of the Preceding MR.
CATEGORY_CODE VARCHAR2 (30) Yes User defined Category of the MR. FND Lookup of AHL_FMP_MR_CATEGORY
CATEGORY VARCHAR2 (80) Yes User defined Category description of the MR. FND_LOOKUP_VALUES.meaning
SERVICE_TYPE_CODE VARCHAR2 (3)
Seeded service type of the MR. This is either ON or OFF. FND Lookup of AHL_FMP_MR_SERVICE_TYPE
SERVICE_TYPE VARCHAR2 (80)
User defined Subtype description of the Service Type. FND_LOOKUP_VALUES.meaning
MR_STATUS_CODE VARCHAR2 (30) Yes Seeded revision status of the MR. This is either DRAFT, COMPLETED, APPROVAL_PENDING, APPROVAL_REJECTED or TERMINATED. FND Lookup of AHL_FMP_REVISION_STATUS
STATUS VARCHAR2 (80) Yes Revision status description of the MR. FND_LOOKUP_VALUES.meaning
IMPLEMENT_STATUS_CODE VARCHAR2 (30) Yes Seeded Implement Status of the MR. This is either MANDATORY, OPTIONAL_IMPLEMENT or OPTIONAL_DO_NOT_IMPLEMENT. FND Lookup of AHL_FMP_MR_IMPLEMENT_STATUS
IMPLEMENT_STATUS VARCHAR2 (80) Yes Implement Status description of the MR. FND_LOOKUP_VALUES.meaning
REPETITIVE_FLAG VARCHAR2 (1) Yes Seeded Repetitive flag of MR. This is either Y or N. FND Lookup of AHL_YES_NO_TYPE.
REPETITIVE VARCHAR2 (80) Yes Repetitive flag description of MR. FND_LOOKUP_VALUES.meaning
SHOW_REPETITIVE_CODE VARCHAR2 (4) Yes Seeded Flag which is used to show Repeating MRs in Unit Maintenance Plan. This is either ALL or NEXT. FND Lookup of AHL_FMP_MR_SHOW_REPETITIVE
SHOW_REPETITIVE VARCHAR2 (80) Yes Flag description which is used to show Repeating MRs in Unit Maintenance Plan. FND_LOOKUP_VALUES.meaning
WHICHEVER_FIRST_CODE VARCHAR2 (5) Yes Seeded Flag to determine whether to choose either the first or last due date calculated based on all the Interval / Thresholds defined for this maintenance requirement. This is either FIRST or LAST. FND Lookup of AHL_FMP_THRESHOLD_FIRST
WHICHEVER_FIRST VARCHAR2 (80) Yes Flag description to determine whether to choose either the first or last due date calculated based on all the Interval / Thresholds defined for this maintenance requirement. FND_LOOKUP_VALUES.meaning
COPY_ACCOMPLISHMENT_FLAG VARCHAR2 (1) Yes Flag to indicate whether the last accomplishment of this MR should be copied in "Unit Maintenance Plan" when a new revision is created. This is either Y or N. FND Lookup of AHL_YES_NO_TYPE.
COPY_ACCOMPLISHMENT VARCHAR2 (80) Yes Flag description to indicate whether the last accomplishment of this MR should be copied in "Unit Maintenance Plan" when a new revision is created. FND_LOOKUP_VALUES.meaning
PROGRAM_TYPE_CODE VARCHAR2 (30) Yes User defined Program Type of the MR. FND Lookup of AHL_FMP_MR_PROGRAM_TYPE
PROGRAM_TYPE VARCHAR2 (80) Yes User defined Program Type Description of the MR. FND_LOOKUP_VALUES.meaning
PROGRAM_SUBTYPE_CODE VARCHAR2 (30)
User defined Subtype of the Program Type. FND Lookup of AHL_FMP_MR_PROGRAM_SUBTYPE
PROGRAM_SUBTYPE VARCHAR2 (80)
User defined Subtype description of the Program Type. , FND_LOOKUP_VALUES.meaning
EFFECTIVE_FROM DATE
Yes Effective start date of this MR. Only one revision of MR can be effective at any time instance.
EFFECTIVE_TO DATE

Effective end date of this MR. Only one revision of MR can be effective at any time instance.
REVISION VARCHAR2 (30)
User Defined Revision number of the MR.
DESCRIPTION VARCHAR2 (2000)
Description of the MR
COMMENTS VARCHAR2 (2000)
Comments for 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
TYPE VARCHAR2 (80)
Stores the meaning of type_code
DOWN_TIME NUMBER

The down time for the preventive maintenance
UOM_CODE VARCHAR2 (30)
The UOM_CODE for the MR preventive Maintenance.
UOM VARCHAR2 (80)
UOM meaning of UOM_CODE
SPACE_CATEGORY_CODE VARCHAR2 (30)
Space category code displayed as visit type code in ui
SPACE_CATEGORY VARCHAR2 (80)
Space category is the meaning of space category
BILLING_ITEM_ID NUMBER (15)
Billing item id for non preventive maintenance
BILLING_ORG_ID NUMBER

Inventory Organization ID for the Billing Item.
BILLING_ITEM VARCHAR2 (40)
Billing item concatenated segment
QA_INSPECTION_TYPE_CODE VARCHAR2 (150)
Quality inspection type code
QA_INSPECTION_TYPE VARCHAR2 (150)
Qulity
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
APPLICATION_USG_CODE VARCHAR2 (30)
AUTO_SIGNOFF_FLAG VARCHAR2 (30)
AUTO_SIGNOFF VARCHAR2 (80)
Auto Signoff
COPY_INIT_ACCOMPL_FLAG VARCHAR2 (1)
Flag to copy First Due defintions from previous revision to current revision when MR is approved.
COPY_INIT_ACCOMPLSMNTS VARCHAR2 (80)
Copy Accomplishment Flag Meaning (Yes/No)
COPY_DEFERRALS_FLAG VARCHAR2 (1)
Flag indicating deferral data to be copied to newer revision from previous revision when MR is approved.
COPY_DEFERRALS VARCHAR2 (80)
Copy Deferral Flag meaning (Yes/No).
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
,      PRECEDING_MR_TITLE
,      PRECEDING_MR_REVISION
,      CATEGORY_CODE
,      CATEGORY
,      SERVICE_TYPE_CODE
,      SERVICE_TYPE
,      MR_STATUS_CODE
,      STATUS
,      IMPLEMENT_STATUS_CODE
,      IMPLEMENT_STATUS
,      REPETITIVE_FLAG
,      REPETITIVE
,      SHOW_REPETITIVE_CODE
,      SHOW_REPETITIVE
,      WHICHEVER_FIRST_CODE
,      WHICHEVER_FIRST
,      COPY_ACCOMPLISHMENT_FLAG
,      COPY_ACCOMPLISHMENT
,      PROGRAM_TYPE_CODE
,      PROGRAM_TYPE
,      PROGRAM_SUBTYPE_CODE
,      PROGRAM_SUBTYPE
,      EFFECTIVE_FROM
,      EFFECTIVE_TO
,      REVISION
,      DESCRIPTION
,      COMMENTS
,      SERVICE_REQUEST_TEMPLATE_ID
,      TYPE_CODE
,      TYPE
,      DOWN_TIME
,      UOM_CODE
,      UOM
,      SPACE_CATEGORY_CODE
,      SPACE_CATEGORY
,      BILLING_ITEM_ID
,      BILLING_ORG_ID
,      BILLING_ITEM
,      QA_INSPECTION_TYPE_CODE
,      QA_INSPECTION_TYPE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      APPLICATION_USG_CODE
,      AUTO_SIGNOFF_FLAG
,      AUTO_SIGNOFF
,      COPY_INIT_ACCOMPL_FLAG
,      COPY_INIT_ACCOMPLSMNTS
,      COPY_DEFERRALS_FLAG
,      COPY_DEFERRALS
FROM APPS.AHL_MR_HEADERS_V;

Dependencies

[top of page]

APPS.AHL_MR_HEADERS_V references the following:

SchemaAPPS
SynonymAHL_MR_HEADERS_B
SynonymAHL_MR_HEADERS_TL
SynonymFND_LOOKUP_VALUES
ViewFND_LOOKUP_VALUES_VL
PL/SQL PackageFND_PROFILE - show dependent code
SynonymMTL_SYSTEM_ITEMS_KFV
SynonymQA_CHAR_VALUE_LOOKUPS
APPS.AHL_MR_HEADERS_V is referenced by following:

SchemaAPPS
Package BodyAHL_FMP_MR_HEADER_PVT - show dependent code
ViewAHL_UE_DEFERRAL_DETAILS_V
Package BodyAHL_UMP_UTIL_PKG - show dependent code
Package BodyAHL_VWP_PROJ_PROD_PVT - show dependent code