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]

VIEW: APPS.AHL_SIMULATION_FORECAST_V

Object Details

Object Name:	AHL_SIMULATION_FORECAST_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AHL.AHL_SIMULATION_FORECAST_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
SIMULATION_PLAN_ID	NUMBER		Yes	Simulation Plan Id. Refers to AHL_SIMULATION_PLANS_B.
SIMULATION_UE_ID	NUMBER		Yes	Effectivity Id. Refers to AHL_UE_SIMULATIONS.
DUE_DATE	DATE			Due date calculated for the effectivity.
FLEET_HEADER_ID	NUMBER			Fleet Id. Refers to AHL_FLEET_HEADERS
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'.
UNIT_CONFIG_HEADER_ID	NUMBER			Unit Configuration for which the effectivity is generated.
UNIT	VARCHAR2	(80)		Unit Name
CSI_INSTANCE_ID	NUMBER		Yes	Item Id
SERIAL_NUMBER	VARCHAR2	(30)		Serial Number of the item
ITEM_NAME	VARCHAR2	(40)		Item Name
MASTER_CONFIGURATION	VARCHAR2	(80)		Master Config Name
MC_HEADER_ID	NUMBER			Master Config Id
OPERATING_ORG_ID	NUMBER			Operating Org Id. refers to AHL_UE_ORGS_DEPTS_V
OPERATING_ORG	VARCHAR2	(240)		Operating Org Name
MAINTENANCE_ORG_ID	NUMBER			Maintenance Org Id. refers to AHL_UE_ORGS_DEPTS_V.
MAINTENANCE_ORG	VARCHAR2	(240)		Maintenance Org Name
FLEET_NAME	VARCHAR2	(150)		Fleet Name, if assigned at due date
MR_TITLE	VARCHAR2	(80)		Mantenance Requirement for which the effectivity is generated
MR_HEADER_ID	NUMBER			Maintenance Requirement Id
PROGRAM_TYPE_CODE	VARCHAR2	(30)		Program Type code from Maintenance Requirement
PROGRAM_TYPE	VARCHAR2	(80)		Program Type name
PROGRAM_SUBTYPE_CODE	VARCHAR2	(30)		Program Sub Type code
PROGRAM_SUBTYPE	VARCHAR2	(80)		Program Sub Type name
DOWN_TIME	NUMBER			Down TIme required to perform the Maintenance Requirement
SERVICE_CATEGORY_CODE	NUMBER			Service Category

Query Text

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


SELECT SIMULATION_PLAN_ID
,      SIMULATION_UE_ID
,      DUE_DATE
,      FLEET_HEADER_ID
,      FORECAST_SEQUENCE
,      REPETITIVE_MR_FLAG
,      UNIT_CONFIG_HEADER_ID
,      UNIT
,      CSI_INSTANCE_ID
,      SERIAL_NUMBER
,      ITEM_NAME
,      MASTER_CONFIGURATION
,      MC_HEADER_ID
,      OPERATING_ORG_ID
,      OPERATING_ORG
,      MAINTENANCE_ORG_ID
,      MAINTENANCE_ORG
,      FLEET_NAME
,      MR_TITLE
,      MR_HEADER_ID
,      PROGRAM_TYPE_CODE
,      PROGRAM_TYPE
,      PROGRAM_SUBTYPE_CODE
,      PROGRAM_SUBTYPE
,      DOWN_TIME
,      SERVICE_CATEGORY_CODE
FROM APPS.AHL_SIMULATION_FORECAST_V;

Dependencies

[top of page]

APPS.AHL_SIMULATION_FORECAST_V references the following:

APPS: AHL_FLEET_HEADERS_B; AHL_MC_HEADERS_B; AHL_MR_HEADERS_B; AHL_UE_ORGS_DEPTS_V; AHL_UE_SIMULATIONS; AHL_UNIT_CONFIG_HEADERS; AHL_UTIL_UC_PKG - show dependent code; CSI_ITEM_INSTANCES; FND_GLOBAL - show dependent code; FND_LOOKUPS; HR_ALL_ORGANIZATION_UNITS; HR_GENERAL - show dependent code; HR_SECURITY - show dependent code; MTL_PARAMETERS; MTL_SYSTEM_ITEMS_KFV

APPS.AHL_SIMULATION_FORECAST_V is referenced by following:

APPS: AHL_SIMULATION_PVT - show dependent code