[Home] [Help] [Dependency Information]
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 |
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 |
---|---|---|---|---|
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) |
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;
|
|
|