[Home] [Help] [Dependency Information]
Object Name: | AHL_MR_EFFECTIVITIES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AHL.AHL_MR_EFFECTIVITIES_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MR_EFFECTIVITY_ID | NUMBER | Yes | Primary Key for AHL_MR_EFFECTIVITIES. | |
OBJECT_VERSION_NUMBER | NUMBER | Yes | Stores locking sequence number | |
MR_HEADER_ID | NUMBER | Yes | FK to AHL_MR_HEADERS_B | |
INVENTORY_ITEM_ID | NUMBER | Inventory Item ID. FK to MTL_SYSTEM_ITEMS. | ||
ITEM_NUMBER | VARCHAR2 | (40) | Concatenated segments for the Item | |
RELATIONSHIP_ID | NUMBER | Master Configuration Position. FK to AHL_RELATIONSHIPS_B | ||
POSITION_REF_MEANING | VARCHAR2 | (4000) | Master Configuration Position Name | |
POSITION_INVENTORY_ITEM_ID | VARCHAR2 | (40) | Inventory Item ID for the Item which belongs to the Master configuration position. FK to MTL_SYSTEM_ITEMS | |
POSITION_ITEM_NUMBER | VARCHAR2 | (40) | Concatenated segments for the Item which belongs to the Master Configuration Position | |
PC_NODE_ID | NUMBER | Product Classification Node. FK to AHL_PC_NODE_B | ||
PC_NODE_NAME | VARCHAR2 | (240) | Product Classification Node Name | |
NAME | VARCHAR2 | (80) | Yes | Name of the MR Effectivity |
THRESHOLD_DATE | DATE | Calendar Due date for this MR Effectivity. | ||
PROGRAM_DURATION | NUMBER | Program MR's Duration for Preventive Maintenance. | ||
PROGRAM_DURATION_UOM_CODE | VARCHAR2 | (30) | Seeded Duration UOM of Program MR for Preventive Maintenance. FND Lookup of AHL_UMP_TIME_UOM | |
PROGRAM_DURATION_UOM | VARCHAR2 | (80) | Duration UOM description of Program MR for Preventive Maintenance. FND Lookup of AHL_UMP_TIME_UOM | |
DEFAULT_FLAG | VARCHAR2 | (1) | 'Y' or 'N' | |
DEFAULT_FLAG_MEANING | VARCHAR2 | (80) | 'Yes' or 'No' | |
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) | ||
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) |
Cut, paste (and edit) the following text to query this object:
SELECT MR_EFFECTIVITY_ID
, OBJECT_VERSION_NUMBER
, MR_HEADER_ID
, INVENTORY_ITEM_ID
, ITEM_NUMBER
, RELATIONSHIP_ID
, POSITION_REF_MEANING
, POSITION_INVENTORY_ITEM_ID
, POSITION_ITEM_NUMBER
, PC_NODE_ID
, PC_NODE_NAME
, NAME
, THRESHOLD_DATE
, PROGRAM_DURATION
, PROGRAM_DURATION_UOM_CODE
, PROGRAM_DURATION_UOM
, DEFAULT_FLAG
, DEFAULT_FLAG_MEANING
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, APPLICATION_USG_CODE
FROM APPS.AHL_MR_EFFECTIVITIES_V;
|
|
|