View: AHL_SEARCH_VISITS_V | Oracle EBS ETRM Search

View: AHL_SEARCH_VISITS_V 12.1.1

AHL - Complex Maintenance Repair and Overhaul·34 columns

This view stores the query to retrieve Visits information by search visits screen

APPS.AHL_SEARCH_VISITS_V·↳ AHL_SIMULATION_PLANS_VL·↳ AHL_UNIT_CONFIG_HEADERS·↳ AHL_VISITS_VL·Explore AHL module →

View: CS_SERVICE_REQUEST_PUB_V 12.1.1

CS - Service·38 columns

Service Request

APPS.CS_SERVICE_REQUEST_PUB_V·↳ CSI_ITEM_INSTANCES·↳ CS_INCIDENTS_ALL_TL·↳ CS_INCIDENTS_B_SEC·Explore CS module →

Table: EAM_WO_SERVICE_ASSOCIATION 12.1.1 standalone

owner EAM·EAM - Enterprise Asset Management·30 columns

Work Order Service Request Association

EAM.EAM_WO_SERVICE_ASSOCIATION·Explore EAM module →

Table: EAM_WO_SERVICE_ASSOCIATION 12.2.2

owner EAM·EAM - Enterprise Asset Management·30 columns

Work Order Service Request Association

EAM.EAM_WO_SERVICE_ASSOCIATION·Explore EAM module →

View: AHL_SEARCH_VISITS_V 12.2.2

AHL - Complex Maintenance Repair and Overhaul·36 columns

This view stores the query to retrieve Visits information by search visits screen

APPS.AHL_SEARCH_VISITS_V·↳ AHL_SIMULATION_PLANS_VL·↳ AHL_UNIT_CONFIG_HEADERS·↳ AHL_VISITS_VL·Explore AHL module →

View: CS_SR_TERRITORY_V 12.2.2

CS - Service·37 columns

This view shows information about Service Request, and this is being used by Territory Management.

APPS.CS_SR_TERRITORY_V·↳ CS_INCIDENTS_ALL_B·↳ CS_INCIDENTS_ALL_TL·↳ HZ_CONTACT_POINTS·Explore CS module →

View: CSP_MO_LINES_V 12.1.1

CSP - Spares Management·98 columns

Move order lines including extra information of Spares Management

APPS.CSP_MO_LINES_V·↳ CSP_MOVEORDER_LINES·↳ CS_INCIDENTS_ALL·↳ JTF_TASKS_B·Explore CSP module →

View: CS_SR_TASK_TERRITORY_V 12.1.1

CS - Service·41 columns

This view shows combined information of Service Request and task , and this is being used by Territory Management.

APPS.CS_SR_TASK_TERRITORY_V·↳ CS_INCIDENTS_ALL_B·↳ CS_INCIDENTS_ALL_TL·↳ HZ_CONTACT_POINTS·Explore CS module →

View: AHL_PP_EMPLOYEE_ASSIGN_V 12.1.1

AHL - Complex Maintenance Repair and Overhaul·66 columns

APPS.AHL_PP_EMPLOYEE_ASSIGN_V·↳ AHL_COMPLETIONS_PVT·↳ AHL_DEPARTMENT_SHIFTS·↳ AHL_OPERATION_RESOURCES·Explore AHL module →

View: AHL_PP_EMPLOYEE_ASSIGN_V 12.2.2

AHL - Complex Maintenance Repair and Overhaul·66 columns

APPS.AHL_PP_EMPLOYEE_ASSIGN_V·↳ AHL_COMPLETIONS_PVT·↳ AHL_DEPARTMENT_SHIFTS·↳ AHL_OPERATION_RESOURCES·Explore AHL module →

View: AHL_VISIT_TASKS_VL 12.1.1

AHL - Complex Maintenance Repair and Overhaul·54 columns

This view stores the query to retrieve Visit Task details

APPS.AHL_VISIT_TASKS_VL·↳ AHL_VISIT_TASKS_B·↳ AHL_VISIT_TASKS_TL·Explore AHL module →

View: EAM_WORK_ORDERS_V 12.1.1

EAM - Enterprise Asset Management·136 columns

View shows all maintenance work orders alongwith the service requests associated to them

APPS.EAM_WORK_ORDERS_V·↳ BOM_DEPARTMENTS·↳ CSI_ITEM_INSTANCES·↳ CS_INCIDENTS_B_SEC·Explore EAM module →

View: AHL_VISIT_TASKS_V 12.1.1

AHL - Complex Maintenance Repair and Overhaul·53 columns

This view is based Ahl_Visits_vl, Ahl_visit_tasks_vl

APPS.AHL_VISIT_TASKS_V·↳ AHL_SIMULATION_PLANS_B·↳ AHL_VISITS_VL·↳ AHL_VISIT_TASKS_B·Explore AHL module →

Table: AHL_VISITS_B 12.1.1 hub

owner AHL·AHL - Complex Maintenance Repair and Overhaul·53 columns

This table stores information about visits

AHL.AHL_VISITS_B·Explore AHL module →

View: WIP_EAM_WO_SRV_ASSOC_V 12.1.1

WIP - Work in Process·29 columns

APPS.WIP_EAM_WO_SRV_ASSOC_V·↳ BOM_DEPARTMENTS·↳ CSI_ITEM_INSTANCES·↳ EAM_WORK_ORDER_DETAILS_V·Explore WIP module →

View: WIP_EAM_WO_SRV_ASSOC_V 12.2.2

WIP - Work in Process·29 columns

APPS.WIP_EAM_WO_SRV_ASSOC_V·↳ BOM_DEPARTMENTS·↳ CSI_ITEM_INSTANCES·↳ EAM_WORK_ORDER_DETAILS_V·Explore WIP module →

View: AHL_VISITS_VL 12.1.1

AHL - Complex Maintenance Repair and Overhaul·55 columns

This view stores the query to retrieve Visit information

APPS.AHL_VISITS_VL·↳ AHL_VISITS_B·↳ AHL_VISITS_TL·Explore AHL module →

View: AHL_VISIT_TASKS_VL 12.2.2

AHL - Complex Maintenance Repair and Overhaul·64 columns

This view stores the query to retrieve Visit Task details

APPS.AHL_VISIT_TASKS_VL·↳ AHL_VISIT_TASKS_B·↳ AHL_VISIT_TASKS_TL·Explore AHL module →

View: AHL_VISIT_TASKS_V 12.2.2

AHL - Complex Maintenance Repair and Overhaul·58 columns

This view is based Ahl_Visits_vl, Ahl_visit_tasks_vl

APPS.AHL_VISIT_TASKS_V·↳ AHL_SIMULATION_PLANS_B·↳ AHL_VISITS_VL·↳ AHL_VISIT_TASKS_B·Explore AHL module →

View: WIP_EAM_WORK_ORDERS_V 12.1.1

WIP - Work in Process·125 columns

Maintenance Work Orders

APPS.WIP_EAM_WORK_ORDERS_V·↳ BOM_DEPARTMENTS·↳ CSI_ITEM_INSTANCES·↳ EAM_COMMON_UTILITIES_PVT·Explore WIP module →

View: WIP_EAM_WORK_ORDERS_V 12.2.2

WIP - Work in Process·125 columns

Maintenance Work Orders

APPS.WIP_EAM_WORK_ORDERS_V·↳ BOM_DEPARTMENTS·↳ CSI_ITEM_INSTANCES·↳ EAM_COMMON_UTILITIES_PVT·Explore WIP module →

View: CSP_MO_LINES_V 12.2.2

CSP - Spares Management·98 columns

Move order lines including extra information of Spares Management

APPS.CSP_MO_LINES_V·↳ CSP_MOVEORDER_LINES·↳ CS_INCIDENTS_ALL·↳ JTF_TASKS_B·Explore CSP module →

View: AHL_VISITS_VL 12.2.2

AHL - Complex Maintenance Repair and Overhaul·64 columns

This view stores the query to retrieve Visit information

APPS.AHL_VISITS_VL·↳ AHL_VISITS_B·↳ AHL_VISITS_TL·Explore AHL module →

View: CS_SR_TERRITORY_V 12.1.1

CS - Service·37 columns

This view shows information about Service Request, and this is being used by Territory Management.

APPS.CS_SR_TERRITORY_V·↳ CS_INCIDENTS_ALL_B·↳ CS_INCIDENTS_ALL_TL·↳ HZ_CONTACT_POINTS·Explore CS module →

View: CS_SERVICE_REQUEST_PUB_V 12.2.2

CS - Service·38 columns

Service Request

APPS.CS_SERVICE_REQUEST_PUB_V·↳ CSI_ITEM_INSTANCES·↳ CS_INCIDENTS_ALL_TL·↳ CS_INCIDENTS_B_SEC·Explore CS module →

View: CS_SR_TASK_TERRITORY_V 12.2.2

CS - Service·41 columns

This view shows combined information of Service Request and task , and this is being used by Territory Management.

APPS.CS_SR_TASK_TERRITORY_V·↳ CS_INCIDENTS_ALL_B·↳ CS_INCIDENTS_ALL_TL·↳ HZ_CONTACT_POINTS·Explore CS module →

View: EAM_WORK_ORDERS_V 12.2.2

EAM - Enterprise Asset Management·138 columns

View shows all maintenance work orders along with the work requests/service requests associated to them.

APPS.EAM_WORK_ORDERS_V·↳ BOM_DEPARTMENTS·↳ CSI_ITEM_INSTANCES·↳ CS_INCIDENTS_B_SEC·Explore EAM module →

Table: AHL_VISIT_TASKS_B 12.1.1 hub

owner AHL·AHL - Complex Maintenance Repair and Overhaul·51 columns

This table stores information about visit tasks

AHL.AHL_VISIT_TASKS_B·Explore AHL module →

Table: AHL_VISIT_TASKS_B 12.2.2 hub

owner AHL·AHL - Complex Maintenance Repair and Overhaul·61 columns

This table stores information about visit tasks

AHL.AHL_VISIT_TASKS_B·Explore AHL module →

Table: AHL_VISITS_B 12.2.2 hub

owner AHL·AHL - Complex Maintenance Repair and Overhaul·63 columns

This table stores information about visits

AHL.AHL_VISITS_B·Explore AHL module →

VIEW: IEM.IEM_RT_INTERACTIONS# 12.2.2

VIEW: EAM.EAM_WO_SERVICE_ASSOCIATION# 12.2.2

APPS.AHL_MM_CANNIBALIZATION_PVT SQL Statements 12.2.2

PACKAGE: APPS.AHL_MM_CANNIBALIZATION_PVT 12.2.2 PVT API

used by 1

PACKAGE BODY: APPS.AHL_MM_CANNIBALIZATION_PVT 12.2.2 PVT API

used by 1

PACKAGE BODY: APPS.AHL_VWP_MR_CST_PR_PVT 12.2.2 PVT API

used by 3

VIEW: AHL.AHL_VISITS_B# 12.2.2

PACKAGE: APPS.AHL_VWP_MR_CST_PR_PVT 12.2.2 PVT API

used by 3

VIEW: AHL.AHL_VISIT_TASKS_B# 12.2.2

PACKAGE BODY: APPS.EAM_REQUEST_UTILITY_PVT 12.1.1 PVT API

used by 1

PACKAGE: APPS.EAM_REQUEST_UTILITY_PVT 12.1.1 PVT API

used by 1

PACKAGE: APPS.AHL_VWP_MR_CST_PR_PVT 12.1.1 PVT API

used by 3

PACKAGE BODY: APPS.AHL_VWP_MR_CST_PR_PVT 12.1.1 PVT API

used by 3

PACKAGE BODY: APPS.EAM_REQUEST_UTILITY_PVT 12.2.2 PVT API

used by 1

PACKAGE: APPS.EAM_REQUEST_UTILITY_PVT 12.2.2 PVT API

used by 1

VIEW: EAM.EAM_WO_SERVICE_ASSOCIATION# 12.2.2

owner EAM

TABLE: EAM.EAM_WO_SERVICE_ASSOCIATION 12.1.1

owner EAM

TABLE: EAM.EAM_WO_SERVICE_ASSOCIATION 12.2.2

owner EAM

APPS.EAM_REQUEST_UTILITY_PVT SQL Statements 12.1.1

VIEW: IEM.IEM_RT_INTERACTIONS# 12.2.2

owner IEM

Results for “service_request_id”