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_UE_ORGS_DEPTS_V

Object Details

Object Name:	AHL_UE_ORGS_DEPTS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AHL.AHL_UE_ORGS_DEPTS_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	Comments
UNIT_EFFECTIVITY_ID	NUMBER		Effectivity Id
SIM_UE_FLAG	CHAR	(1)	Flag to indicate whether simulation plan UE or primary plan UE
UE_MR_HEADER_ID	NUMBER		Maintenance Requirement Id
UE_MR_TITLE	VARCHAR2	(80)	Maintenance Requirement Title
ORG_MR_TITLE	VARCHAR2	(80)	MR Title
UE_FLEET_HEADER_ID	NUMBER		Fleet Header Id
UE_FLEET_NAME	VARCHAR2	(150)	Fleet Name
FLEET_OPERATING_ORG_ID	NUMBER		Operating Org Id of the fleet at the due date
FLEET_DEPT_ID	NUMBER		Department Id of the fleet at the due date
MR_OPERATING_ORG_ID	NUMBER		Operating Org Id of the Maintenance Requirement
MR_OPERATING_ORG_NAME	VARCHAR2	(240)	Operating Org Name
MR_MAINTENANCE_ORG_ID	NUMBER		Maintenance Org Id of the Maintenance Requirement
MR_MAINTENANCE_ORG_NAME	VARCHAR2	(240)	Maintenance Org Name
MR_MAINTENANCE_DEPT_ID	NUMBER		Maintenance Department Id
MR_MAINTENANCE_DEPT_ NAME	VARCHAR2	(240)

Query Text

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


SELECT UNIT_EFFECTIVITY_ID
,      SIM_UE_FLAG
,      UE_MR_HEADER_ID
,      UE_MR_TITLE
,      ORG_MR_TITLE
,      UE_FLEET_HEADER_ID
,      UE_FLEET_NAME
,      FLEET_OPERATING_ORG_ID
,      FLEET_DEPT_ID
,      MR_OPERATING_ORG_ID
,      MR_OPERATING_ORG_NAME
,      MR_MAINTENANCE_ORG_ID
,      MR_MAINTENANCE_ORG_NAME
,      MR_MAINTENANCE_DEPT_ID
,      MR_MAINTENANCE_DEPT_ NAME
FROM APPS.AHL_UE_ORGS_DEPTS_V;

Dependencies

[top of page]

APPS.AHL_UE_ORGS_DEPTS_V references the following:

APPS: AHL_DEPARTMENT_SHIFTS_V; AHL_FLEET_HEADERS_B; AHL_MR_HEADERS_B; AHL_MR_ORGANIZATIONS; AHL_UE_SIMULATIONS; AHL_UNIT_EFFECTIVITIES_B; BOM_DEPARTMENTS; HR_GENERAL - show dependent code; HR_ORGANIZATION_UNITS; HR_SECURITY - show dependent code

APPS.AHL_UE_ORGS_DEPTS_V is referenced by following:

APPS: AHL_SIMULATION_FORECAST_V; AHL_UMP_BOM_PVT - show dependent code