[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | AHL_SR_NON_ROUTINES_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| 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 |
|---|---|---|---|---|
| SR_INCIDENT_ID | NUMBER | (15) | Yes | Service Request Incident Primary Key |
| SR_INCIDENT_OVN | NUMBER | (9) | Service Request Incident locking sequence number | |
| SR_INCIDENT_NUMBER | VARCHAR2 | (64) | Yes | Service Request Incident Number |
| SR_INCIDENT_STATUS_ID | NUMBER | (15) | Yes | Service Request Incident Status |
| SR_INCIDENT_STATUS | VARCHAR2 | (90) | Status name of the Service Request Incident | |
| SR_INCIDENT_TYPE_ID | NUMBER | (15) | Yes | Service Request Incident Type |
| SR_INCIDENT_TYPE | VARCHAR2 | (90) | Type name of the Service Request Incident | |
| SR_INCIDENT_DATE | DATE | Yes | Logging date of the Service Request Incident | |
| SR_INCIDENT_OCCURRED_DATE | DATE | Actual date of occurance the Service Request Incident | ||
| SR_INCIDENT_URGENCY_ID | NUMBER | (15) | Service Request Incident Urgency | |
| SR_INCIDENT_URGENCY | VARCHAR2 | (90) | Urgency name of the Service Request Incident | |
| SR_INCIDENT_SEVERITY_ID | NUMBER | (15) | Yes | Service Request Incident Severity |
| SR_INCIDENT_SEVERITY | VARCHAR2 | (90) | Severity name of the Service Request Incident | |
| SR_EXPECTED_RESOLUTION_DATE | DATE | Expected resolution date of the Service Request Incident | ||
| SR_CALLER_TYPE | VARCHAR2 | (30) | Type of Service Request Incident Customer | |
| SR_CALLER_TYPE_NAME | VARCHAR2 | (80) | Type name of the Service Request Incident Customer | |
| SR_CUSTOMER_ID | NUMBER | (15) | Service Request Incident Customer | |
| SR_CUSTOMER_NAME | VARCHAR2 | (360) | Yes | Service Request Incident Customer name |
| SR_CONTACT_TYPE | VARCHAR2 | (30) | Type of Service Request Incident Contact | |
| SR_CONTACT_TYPE_NAME | VARCHAR2 | (80) | Type name of Service Request Incident Contact | |
| SR_CONTACT_PARTY_ID | NUMBER | Service Request Incident Contact | ||
| SR_CONTACT_NAME | VARCHAR2 | (360) | Service Request Incident Contact name | |
| SR_RESOLUTION_CODE | VARCHAR2 | (50) | Service Request Incident Resolution Code | |
| SR_RESOLUTION_MEANING | VARCHAR2 | (80) | Resolution of the Service Request Incident | |
| SR_PROBLEM_CODE | VARCHAR2 | (50) | Service Request Incident Problem Code | |
| SR_PROBLEM_MEANING | VARCHAR2 | (80) | Problem Code of the Service Request Incident | |
| SR_PROBLEM_SUMMARY | VARCHAR2 | (240) | Problem Summary of the Service Request Incident | |
| UE_UNIT_EFFECTIVITY_ID | NUMBER | Yes | Unit Effectivity created for the Service Request Incident | |
| UE_OBJECT_VERSION_NUMBER | NUMBER | Yes | Unit Effectivity locking sequence number | |
| UE_CSI_INSTANCE_ID | NUMBER | Yes | Instance for which Unit Effectivity is recorded & Service Request Incident is logged | |
| UE_INSTANCE_NUMBER | VARCHAR2 | (30) | Yes | Instance Number |
| UE_INSTANCE_UOM | VARCHAR2 | (3) | Yes | Unit of Measure of Quantity |
| UE_UNIT_CONFIG_ID | NUMBER | Unit Configuration on which the Instance exists at the time of logging the Service Request Incident | ||
| UE_UNIT_NAME | VARCHAR2 | (80) | Unit Configuration name | |
| UE_MASTER_CONFIG_ID | NUMBER | Master Configuration from which the Unit Configuration is made | ||
| UE_UC_QUAR_FLAG | VARCHAR2 | (1) | Flag to indicate whether unit is quarantined | |
| UE_INVENTORY_ITEM_ID | NUMBER | Yes | Instance Item | |
| UE_ITEM_NUMBER | VARCHAR2 | (40) | Instance Item Number | |
| UE_SERIAL_NUMBER | VARCHAR2 | (30) | Instance Item Serial Number | |
| UE_STATUS_CODE | VARCHAR2 | (30) | Unit Effectivity Status | |
| UE_STATUS | VARCHAR2 | (80) | Status name of the Unit Effectivity | |
| UE_DUE_DATE | DATE | Due Date of the Unit Effectivity | ||
| UE_LOG_SERIES_CODE | VARCHAR2 | (30) | Service Request Incident Log Series Code | |
| UE_LOG_SERIES | VARCHAR2 | (80) | Service Request Incident Log Series | |
| UE_LOG_NUMBER | NUMBER | Service Request Incident unique Log Number | ||
| UE_LOG_CODE_NUMBER | VARCHAR2 | (4000) | Service Request Incident Log Series | |
| UE_FLIGHT_NUMBER | VARCHAR2 | (30) | Flight number on which the Instance exists at the time of logging the Service Request Incident | |
| UE_MEL_CDL_TYPE_CODE | VARCHAR2 | (30) | Type code of MEL/CDL instructions of the Non-Routine | |
| UE_MEL_CDL_TYPE | VARCHAR2 | (80) | Type of MEL/CDL instructions of the Non-Routine | |
| UE_POSITION_PATH_ID | NUMBER | Position path for which Non-routine is associated with MEL/CDL instructions | ||
| UE_POSITION_REF_CODE | VARCHAR2 | (30) | Position Reference of the Position Path | |
| UE_POSITION_REF_MEANING | VARCHAR2 | (80) | Position Reference Meaning of the Position Path | |
| UE_POSITION_REF_DESC | VARCHAR2 | (240) | Position Reference Description of the Position Path | |
| UE_ATA_CODE | VARCHAR2 | (30) | Position ATA Code for which Non-routine is associated with MEL/CDL instructions | |
| UE_ATA_MEANING | VARCHAR2 | (80) | Meaning of the Position ATA Code | |
| UE_ATA_DESC | VARCHAR2 | (240) | Description of the Position ATA Code | |
| UE_ATA_SEQUENCE_ID | NUMBER | ATA Sequence for which Non-routine is associated with MEL/CDL instructions | ||
| UE_ATA_HEADER_ID | NUMBER | MEL/CDL Header of the ATA Sequence | ||
| UE_ATA_HEADER_REVISION | VARCHAR2 | (30) | MEL/CDL Header Revision of the ATA Sequence | |
| UE_ATA_REPAIR_CATEGORY | VARCHAR2 | (90) | Repair Category Name of the ATA Sequence | |
| UE_ATA_REPAIR_TIME | NUMBER | Repair Time Limit (in hours) of the ATA Sequence | ||
| UE_ATA_PC_NODE_NAME | VARCHAR2 | (240) | Product Classification Node Name at which MEL/CDL Header is defined | |
| UE_DEFERRAL_TYPE | VARCHAR2 | (30) | Type of MEL/CDL Qualification of the Non-routine | |
| UE_DEFERRAL_APPR_STATUS | VARCHAR2 | (30) | Status of the MEL/CDL Qualification approval workflow of the Non-routine | |
| UE_APPROVER_NOTES | VARCHAR2 | (4000) | Approver notes for MEL/CDL Approval Workflow. | |
| UE_MEL_CDL_STATUS | VARCHAR2 | (4000) | Status of the MEL/CDL Qualification of the Non-routine | |
| UE_CLEAR_STATION_ORG_ID | NUMBER | Location organization at which the Non-routine is closed / cleared | ||
| UE_CLEAR_STATION_ORG | VARCHAR2 | (3) | Location organization code at which the Non-routine is closed / cleared | |
| UE_CLEAR_STATION_DEPT_ID | NUMBER | Location department at which the Non-routine is closed / cleared | ||
| UE_CLEAR_STATION_DEPT | VARCHAR2 | (10) | Location department code at which the Non-routine is closed / cleared | |
| UE_VISIT_NUMBER | NUMBER | (15) | Visit Number of the Visit wherein Unit Effectivity is planned | |
| UE_VISIT_NAME | VARCHAR2 | (80) | Visit Nameof the Visit wherein Unit Effectivity is planned | |
| UE_VISIT_TASK_NUMBER | NUMBER | (15) | Visit Task Number for the Unit Effectivity | |
| UE_VISIT_TASK_NAME | VARCHAR2 | (80) | Visit Task Name for the Unit Effectivity | |
| UE_VISIT_TASK_QUANTITY | NUMBER | Visit Task Quantity | ||
| SR_IN_VWP_FLAG | VARCHAR2 | (1) | Flag to indicate whether the Unit Effectivitiy is associated to a Visit (i.e. the Non-routine is planned) | |
| SR_IN_PRD_FLAG | VARCHAR2 | (1) | Flag to indicate whether the Unit Effectivity Visit is implemented | |
| UE_ATA_REMARKS | CLOB | (4000) | Remarks of the ATA Sequence | |
| ORIGINATING_WO_ID | NUMBER | Unique Identifier for Originating Work Order. | ||
| ORIGINATING_WO_NAME | VARCHAR2 | (80) | Originating Work Order Name. | |
| UE_VISIT_ID | NUMBER | Unique identifier for Visit. | ||
| WORKORDER_NAME | VARCHAR2 | (80) | Work Order Name. | |
| SCHEDULED_START_DATE | DATE | Scheduled start date of an associated work order. | ||
| UE_VISIT_START_DATE_TIME | DATE | Target Visit Start Date | ||
| UE_VISIT_END_DATE_TIME | DATE | Target Visit End Date | ||
| INCIDENT_CONTEXT | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
| INCIDENT_ATTRIBUTE_1 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| INCIDENT_ATTRIBUTE_2 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| INCIDENT_ATTRIBUTE_3 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| INCIDENT_ATTRIBUTE_4 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| INCIDENT_ATTRIBUTE_5 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| INCIDENT_ATTRIBUTE_6 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| INCIDENT_ATTRIBUTE_7 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| INCIDENT_ATTRIBUTE_8 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| INCIDENT_ATTRIBUTE_9 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| INCIDENT_ATTRIBUTE_10 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| INCIDENT_ATTRIBUTE_11 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| INCIDENT_ATTRIBUTE_12 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| INCIDENT_ATTRIBUTE_13 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| INCIDENT_ATTRIBUTE_14 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| INCIDENT_ATTRIBUTE_15 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| FIRM_PLANNED_FLAG | NUMBER | Work Order firm/planned flag - used for scheduling. | ||
| DURATION | NUMBER | Estimated Duration (if available) | ||
| SERVICE_TYPE_CODE | VARCHAR2 | (30) | Service type code. | |
| SERVICE_TYPE | VARCHAR2 | (80) | Service type meaning. | |
| UE_QA_INSPECTION_TYPE | VARCHAR2 | (150) | QA Inspection Type (for a NonRoutine) | |
| UE_QA_INSPECTION_DESC | VARCHAR2 | (150) | QA Inspection Type Description |
Cut, paste (and edit) the following text to query this object:
SELECT SR_INCIDENT_ID
, SR_INCIDENT_OVN
, SR_INCIDENT_NUMBER
, SR_INCIDENT_STATUS_ID
, SR_INCIDENT_STATUS
, SR_INCIDENT_TYPE_ID
, SR_INCIDENT_TYPE
, SR_INCIDENT_DATE
, SR_INCIDENT_OCCURRED_DATE
, SR_INCIDENT_URGENCY_ID
, SR_INCIDENT_URGENCY
, SR_INCIDENT_SEVERITY_ID
, SR_INCIDENT_SEVERITY
, SR_EXPECTED_RESOLUTION_DATE
, SR_CALLER_TYPE
, SR_CALLER_TYPE_NAME
, SR_CUSTOMER_ID
, SR_CUSTOMER_NAME
, SR_CONTACT_TYPE
, SR_CONTACT_TYPE_NAME
, SR_CONTACT_PARTY_ID
, SR_CONTACT_NAME
, SR_RESOLUTION_CODE
, SR_RESOLUTION_MEANING
, SR_PROBLEM_CODE
, SR_PROBLEM_MEANING
, SR_PROBLEM_SUMMARY
, UE_UNIT_EFFECTIVITY_ID
, UE_OBJECT_VERSION_NUMBER
, UE_CSI_INSTANCE_ID
, UE_INSTANCE_NUMBER
, UE_INSTANCE_UOM
, UE_UNIT_CONFIG_ID
, UE_UNIT_NAME
, UE_MASTER_CONFIG_ID
, UE_UC_QUAR_FLAG
, UE_INVENTORY_ITEM_ID
, UE_ITEM_NUMBER
, UE_SERIAL_NUMBER
, UE_STATUS_CODE
, UE_STATUS
, UE_DUE_DATE
, UE_LOG_SERIES_CODE
, UE_LOG_SERIES
, UE_LOG_NUMBER
, UE_LOG_CODE_NUMBER
, UE_FLIGHT_NUMBER
, UE_MEL_CDL_TYPE_CODE
, UE_MEL_CDL_TYPE
, UE_POSITION_PATH_ID
, UE_POSITION_REF_CODE
, UE_POSITION_REF_MEANING
, UE_POSITION_REF_DESC
, UE_ATA_CODE
, UE_ATA_MEANING
, UE_ATA_DESC
, UE_ATA_SEQUENCE_ID
, UE_ATA_HEADER_ID
, UE_ATA_HEADER_REVISION
, UE_ATA_REPAIR_CATEGORY
, UE_ATA_REPAIR_TIME
, UE_ATA_PC_NODE_NAME
, UE_DEFERRAL_TYPE
, UE_DEFERRAL_APPR_STATUS
, UE_APPROVER_NOTES
, UE_MEL_CDL_STATUS
, UE_CLEAR_STATION_ORG_ID
, UE_CLEAR_STATION_ORG
, UE_CLEAR_STATION_DEPT_ID
, UE_CLEAR_STATION_DEPT
, UE_VISIT_NUMBER
, UE_VISIT_NAME
, UE_VISIT_TASK_NUMBER
, UE_VISIT_TASK_NAME
, UE_VISIT_TASK_QUANTITY
, SR_IN_VWP_FLAG
, SR_IN_PRD_FLAG
, UE_ATA_REMARKS
, ORIGINATING_WO_ID
, ORIGINATING_WO_NAME
, UE_VISIT_ID
, WORKORDER_NAME
, SCHEDULED_START_DATE
, UE_VISIT_START_DATE_TIME
, UE_VISIT_END_DATE_TIME
, INCIDENT_CONTEXT
, INCIDENT_ATTRIBUTE_1
, INCIDENT_ATTRIBUTE_2
, INCIDENT_ATTRIBUTE_3
, INCIDENT_ATTRIBUTE_4
, INCIDENT_ATTRIBUTE_5
, INCIDENT_ATTRIBUTE_6
, INCIDENT_ATTRIBUTE_7
, INCIDENT_ATTRIBUTE_8
, INCIDENT_ATTRIBUTE_9
, INCIDENT_ATTRIBUTE_10
, INCIDENT_ATTRIBUTE_11
, INCIDENT_ATTRIBUTE_12
, INCIDENT_ATTRIBUTE_13
, INCIDENT_ATTRIBUTE_14
, INCIDENT_ATTRIBUTE_15
, FIRM_PLANNED_FLAG
, DURATION
, SERVICE_TYPE_CODE
, SERVICE_TYPE
, UE_QA_INSPECTION_TYPE
, UE_QA_INSPECTION_DESC
FROM APPS.AHL_SR_NON_ROUTINES_V;
APPS
AHL_MC_PATH_POSITION_PVT
- show dependent code
AHL_MEL_CDL_ATA_SEQUENCES
AHL_MEL_CDL_HEADERS
AHL_PC_NODES_B
AHL_REPAIR_CATEGORIES
AHL_UMP_NONROUTINES_PVT
- show dependent code
AHL_UNIT_CONFIG_HEADERS
AHL_UNIT_DEFERRALS_B
AHL_UNIT_DEFERRALS_TL
AHL_UNIT_EFFECTIVITIES_B
AHL_UTILITY_PVT
- show dependent code
AHL_VISITS_B
AHL_VISITS_TL
AHL_VISIT_TASKS_B
AHL_VISIT_TASKS_TL
AHL_WORKORDERS
BOM_DEPARTMENTS
CSI_ITEM_INSTANCES
CS_HZ_SR_CONTACT_POINTS
CS_INCIDENTS_ALL_B
CS_INCIDENTS_ALL_TL
CS_INCIDENT_SEVERITIES_TL
CS_INCIDENT_STATUSES_TL
CS_INCIDENT_TYPES_TL
CS_INCIDENT_URGENCIES_TL
FND_LOOKUP_VALUES
HZ_PARTIES
JTF_NOTES_B
JTF_NOTES_TL
MTL_PARAMETERS
MTL_SYSTEM_ITEMS_KFV
PA_LOOKUPS
PER_ALL_PEOPLE_F
QA_CHAR_VALUE_LOOKUPS
WIP_DISCRETE_JOBS
APPS
AHL_MM_CANNIBALIZATION_PVT
- show dependent code
AHL_PRD_BLK_PARTS_CHANGE_PVT
- show dependent code
AHL_UMP_NONROUTINES_PVT
- show dependent code
|
|
|
|