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_UE_SIMULATIONS

Object Details

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

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AHL_UE_SIMULATIONS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	UNIT_CONFIG_HEADER_ID
AHL_UE_SIMULATIONS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FLEET_HEADER_ID
AHL_UE_SIMULATIONS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CSI_ITEM_INSTANCE_ID
AHL_UE_SIMULATIONS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	MR_HEADER_ID
AHL_UE_SIMULATIONS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SIMULATION_PLAN_ID DUE_DATE
AHL_UE_SIMULATIONS_U1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SIMULATION_UE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
SIMULATION_UE_ID	NUMBER		Yes	Simulation Unit Effectivity Id
SIMULATION_PLAN_ID	NUMBER		Yes	FK to AHL_SIMULATION_PLANS_B
CSI_ITEM_INSTANCE_ID	NUMBER		Yes	Item instance Id
MR_HEADER_ID	NUMBER			Maintenance Header Id. FK to AHL_MR_HEADERS_B
FLEET_HEADER_ID	NUMBER			FK to AHL_FLEET_HEADERS_B
UNIT_CONFIG_HEADER_ID	NUMBER			Unit Config Header Id
DUE_DATE	DATE			Due Date derived for the Effectivity
STATUS_CODE	VARCHAR2	(30)		Lookup codes defined in FND_LOOKUPS with lookup type = 'AHL_UNIT_EFFECTIVITY_STATUS'.
OBJECT_VERSION_NUMBER	NUMBER		Yes	Stores locking sequence number
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER		Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER			Standard Who Column
SECURITY_GROUP_ID	NUMBER			Used in application hosting
MR_EFFECTIVITY_ID	NUMBER			FK to AHL_MR_EFFECTIVITIES. This effectivity got triggered from FMP module
MR_INTERVAL_ID	NUMBER			FK to AHL_MR_INTERVALS. This is the threshold that was used to calculate the due date for this instance's mr effectivity
DUE_COUNTER_VALUE	NUMBER			The Counter Value (for the Counter associated to the MR_interval_id) at which this MR needs to be done
FORECAST_SEQUENCE	NUMBER			The sequence number in case of multiple instances of the same maintenance requirement for the same item instance in order of duedates ascending
REPETITIVE_MR_FLAG	VARCHAR2	(1)		This will be set to 'Y' if the MR is from repetitivity else will b set to 'N'.
TOLERANCE_FLAG	VARCHAR2	(1)		This will be set to 'Y' if the associated Visit has a "Start Date" that is out of the range of tolerance allowance
MESSAGE_CODE	VARCHAR2	(100)		Message Code
DATE_RUN	DATE			The date of estimated due date calculation and repetitive interval
PRECEDING_UE_ID	NUMBER			The effectivity ID of the preceding Unit Effectivity.
EARLIEST_DUE_DATE	DATE			The forecasted earliest due date. This is calculated based on the threhold's tolerance setup in Fleet Maintenance Program
LATEST_DUE_DATE	DATE			The forecasted latest due date. This is calculated based on the threhold's tolerance setup in Fleet Maintenance Program
DEFER_FROM_UE_ID	NUMBER			Link to the 'deferred from' unit effectivity ID.
CS_INCIDENT_ID	NUMBER			Foreign key to CS_INCIDENTS_ALL_B
COUNTER_ID	NUMBER			Indicates the Counter that triggered the due date in cases where counter based Initial Due or Deferral thresholds have been defined
UNIT_EFFECTIVITY_ID	NUMBER			FK to AHL_UNIT_EFFECTIVITIES_B
ORIGINATOR_UE_ID	NUMBER			This is the originators(parents) Unit effectivity record to which this unit effectivity is a child of.
PARENT_UE_ID	NUMBER			Parent UE Id
MANUALLY_PLANNED_FLAG	VARCHAR2	(1)		Plan shows whether the UE is planned manually

Query Text

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


SELECT SIMULATION_UE_ID
,      SIMULATION_PLAN_ID
,      CSI_ITEM_INSTANCE_ID
,      MR_HEADER_ID
,      FLEET_HEADER_ID
,      UNIT_CONFIG_HEADER_ID
,      DUE_DATE
,      STATUS_CODE
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
,      MR_EFFECTIVITY_ID
,      MR_INTERVAL_ID
,      DUE_COUNTER_VALUE
,      FORECAST_SEQUENCE
,      REPETITIVE_MR_FLAG
,      TOLERANCE_FLAG
,      MESSAGE_CODE
,      DATE_RUN
,      PRECEDING_UE_ID
,      EARLIEST_DUE_DATE
,      LATEST_DUE_DATE
,      DEFER_FROM_UE_ID
,      CS_INCIDENT_ID
,      COUNTER_ID
,      UNIT_EFFECTIVITY_ID
,      ORIGINATOR_UE_ID
,      PARENT_UE_ID
,      MANUALLY_PLANNED_FLAG
FROM AHL.AHL_UE_SIMULATIONS;

Dependencies

[top of page]

AHL.AHL_UE_SIMULATIONS does not reference any database object

AHL.AHL_UE_SIMULATIONS is referenced by following:

AHL: AHL_UE_SIMULATIONS#