AHL Views (153)

AHL - Complex Maintenance Repair and Overhaul — documented views from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

View	Description
`AHL_ALL_WORKORDERS_V`	Workorders View for Production Module Restricted by Operating Unit id. No restriction for masterworkorders and workorders created for costin
`AHL_ALTERNATE_RESOURCES_V`
`AHL_APPROVAL_RULES_V`	This view stores the query relates to approval rules information
`AHL_APPROVAL_RULES_VL`	This view stores the query relates to approval rules information
`AHL_APPROVERS_TYPE_V`	This view stores the query relates to approver types information
`AHL_APPROVERS_V`	This view stores the query relates to approvers information
`AHL_CSI_INSTANCE_RELNS_V`	This view contains the instance id, its immediate parent(if exists) and root instance id ( i.e. instance id for unit instances).
`AHL_DEPARTMENT_SHIFTS_V`	This view stores the query relating to Department Shifts
`AHL_DOCUMENTS_V`	This view is based on AHL_DOCUMENTS_B,AHL_DOCUMENTS_TL,FND tables.Document View
`AHL_DOCUMENTS_VL`	This view is based on AHL_DOCUMENTS_B and AHL_DOCUMENTS_TL tables.
`AHL_DOCUMENT_ASSOS_V`	Its a view based on AHL_DOCUMENTS_VL, AHL_DOC_TITLE_ASSOS_VL, AHL_DOC_REVISIONS_B ,FND_LOOKUP_VALUES_VL
`AHL_DOC_FILE_ASSOC_V`	This view defintion stores the File uploaded with Document ID and Revision
`AHL_DOC_FILE_ASSOC_VL`	The view defiintions joins TL and B tables of the AHL_DOC_FILE_ASSOC
`AHL_DOC_REVISIONS_V`	Documents Revision View
`AHL_DOC_REVISIONS_VL`	This view is based on AHL_DOC_REVISIONS_B and AHL_DOC_REVISIONS_TL tables.
`AHL_DOC_TITLE_ASSOS_VL`	This view is based on AHL_DOC_TITLE_ASSOS_B and AHL_DOC_TITLE_ASSOS_TL tables.
`AHL_DOC_TYPE_ASSOS_V`	This view is based on AHL_DOCUMENTS_VL, AHL_DOC_REVISIONS_B, FND_LOOKUP_VALUES_VL, and AHL_DOC_TITLE_ASSOS_VL. This stores information relat
`AHL_DUMMY_V`	Dummy View for AK Regions.
`AHL_FLEET_HEADERS_VL`
`AHL_HZ_PER_EMPLOYEES_V`	This stores employee information.
`AHL_HZ_PO_SUPPLIERS_V`	This stores supplier information.
`AHL_ITEM_ASSOCIATIONS_V`	Item group association view links Item groups with MTL Items.
`AHL_ITEM_ASSOCIATIONS_VL`	This view is based on item_associations_b + item_associations_tl table.
`AHL_ITEM_CLASS_UOM_V`	This view retrieves items and all the UOMs which are in the same UOM class as the base UOM of the item.
`AHL_ITEM_COMP_DETAIL_V`	Item Composition Details V joins Item Groups, UOm Class and MTL table for Name and Description
`AHL_ITEM_COMP_V`	Item Composition V joins Lookup meaning and Codes and MTL table for Item Name
`AHL_ITEM_GROUPS_V`	Item Groups V joins Lookup meaning and Codes
`AHL_ITEM_GROUPS_VL`	View based on the table AHL_ITEM_GROUPS_B and the translated columns from the table AHL_ITEM_GROUPS_TL.
`AHL_JOB_OPER_MATERIALS_V`
`AHL_JTF_RS_EMP_V`	This view stores the query relating to employees in JTF resources
`AHL_MASTER_CONFIG_DETAILS_V`	This view gives all details about the Mater Configuration Header and Nodes, and also some information about the item groups associated with
`AHL_MC_HEADERS_V`	This view gives Master Configuration header information with the respective lookups columns resolved into meanings.
`AHL_MC_HEADERS_VL`	This view gives both translation-independent and translatable Master Configuration header information.
`AHL_MC_RELATIONSHIPS_V`	This view gives Master Configuration node details with respective lookup columns resolved into meanings.
`AHL_MC_RULES_VL`	This view gives both translation-independent and translatable MC rule header information.
`AHL_MM_WRK_ORDER_RESERVTN_V`
`AHL_MR_ACTIONS_V`	View based on the views AHL_MR_ACTIONS_VL, FND_LOOKUP_VALUES_VL and QA_PLANS
`AHL_MR_ACTIONS_VL`	View based on the views AHL_MR_ACTIONS_B and AHL_MR_ACTIONS_TL to include all the codes and their corresponding descriptions.
`AHL_MR_DETAILS_V`	View based on the views AHL_MR_HEADERS_V with a)AHL_MR_RELATIONSHIPS_V to include the Parent Title & Revision and with b)AHL_DOC_TITLE_ASSO
`AHL_MR_EFFECTIVITIES_APP_V`
`AHL_MR_EFFECTIVITIES_V`	View based on the views AHL_MR_EFFECTIVITIES,AHL_MASTER_CONFIG_DETAILS_V,MTL_SYSTEM_ITEMS_KFV,AHL_PC_NODES_B and AHL_POSITION_ALTERNATES_V
`AHL_MR_EFFECTIVITY_DTLS_APP_V`
`AHL_MR_EFFECTIVITY_DTLS_V`	View based on the views AHL_MR_EFFECTIVITY_DTLS,FND_TERRITORIES_VL,FND_LOOKUP_VALUES_VL,MTL_MANUFACTURERS
`AHL_MR_HEADERS_APP_V`	View based on the table AHL_MR_HEADERS_B and the translated columns from the table AHL_MR_HEADERS_TL
`AHL_MR_HEADERS_V`	View based on the views AHL_MR_HEADERS_VL with FND_LOOKUP_VALUES_VL to include all the corresponding descriptions of the codes and with AHL_
`AHL_MR_HEADERS_VL`	View based on the table AHL_MR_HEADERS_B and the translated columns from the table AHL_MR_HEADERS_TL
`AHL_MR_INSTANCES_V`	View To get all the Maintenance Requirements in Production
`AHL_MR_INST_RELATIONSHIPS_V`	View to describe the Relationship between Maintenance Requirements in Production
`AHL_MR_INTERVALS_APP_V`
`AHL_MR_INTERVALS_V`	View based on the views AHL_MR_INTERVALS,CS_COUNTERS, and MTL_UNITS_OF_MEASURE_VL
`AHL_MR_ITEMS_V`	View based on join of AHL_MR_EFFECTIVTIES_B, AHL_POSITION_ALTERNATES_V & MTL_SYSTEM_ITEMS_KFV to get the affected items for all maintenance
`AHL_MR_ITEM_DETAILS_V`	View based on join of AHL_MR_DETAILS_V, AHL_MR_ITEMS_V so that, each row corresponds to a unique Item Effectivity for the Maintenance requir
`AHL_MR_PC_NODES_V`	View based on join of AHL_MR_DETAILS_V, AHL_MR_EFFECTIVITIES to include the PC_NODE_ID defined in the MR effectivities
`AHL_MR_RELATIONSHIPS_APP_V`	View based on the table AHL_MR_RELATIONSHIPS with AHL_MR_HEADERS_VL to get the MR Titles & Revision Numbers of the Parent and Child MRs.
`AHL_MR_RELATIONSHIPS_V`	View based on the table AHL_MR_RELATIONSHIPS with AHL_MR_HEADERS_VL to get the MR Titles & Revision Numbers of the Parent and Child MRs.
`AHL_MR_ROUTES_APP_V`
`AHL_MR_ROUTES_V`	View based on the views AHL_MR_ROUTES and AHL_ROUTES_V to include all the codes and their corresponding descriptions.
`AHL_MR_ROUTE_SEQUENCES_APP_V`
`AHL_MTL_ITEMS_NON_OU_V`	This view retrieves items from all inventory organizations. Not necessary to be in the same Operating Unit.
`AHL_MTL_ITEMS_OU_V`	This view retrieves items from all inventory organizations which are under an operating unit.
`AHL_NR_PROFILE_DETAILS_V`
`AHL_OPERATIONS_B_KFV`	Key flexfield automatically generated KFV view
`AHL_OPERATIONS_H_VL`	View based on the table AHL_OPERATIONS_H_B and the translated columns from the table AHL_OPERATIONS_H_TL.
`AHL_OPERATIONS_V`	View based on the views AHL_OPERATIONS_VL and FND_LOOKUP_VALUES_VL to include all the codes and their corresponding descriptions.
`AHL_OPERATIONS_VL`	View based on the table AHL_OPERATIONS_B and the translated columns from the table AHL_OPERATIONS_TL.
`AHL_OPERATION_PHASES_V`	View based on the table AHL_OPERATION_PHASES and the view FND_LOOKUP_VALUES_VL to include all the corresponding descriptions of the codes.
`AHL_OSP_ORDERS_V`	View to retrieve all OSP order information about an OSP order including values for keys by joining AHL_OSP_ORDERS_VL, PO_HEADERS_V, OE_ORDER
`AHL_OSP_ORDERS_VL`	View to retrieve all OSP order information about an OSP order from AHL_OSP_ORDERS_Band AHL_OSP_ORDERS_TL.
`AHL_OSP_ORDER_LINES_V`	This View queries all the inforamtion related to ORDER LINES. The information is retrieved from the table AHL_OSP_ORDER_LINES and the view
`AHL_OWNER_DETAILS_V`	This view stores the query to retrieve valid owners for an Unit Configuration.
`AHL_OWNER_LOCATIONS_V`	This view stores the query to retrieve valid owners for an Unit Configuration.
`AHL_PC_ASSOCIATIONS_V`	This view contains info of Item/Unit associated to PC Node
`AHL_PC_HEADERS_V`	View based on AHL_PC_HEADERS_VL and FND_LOOKUPS
`AHL_PC_HEADERS_VL`	View based on the table AHL_PC_HEADERS_B and the translated columns from the table AHL_PC_HEADERS_TL
`AHL_PC_HEADER_DETAILS_V`	View Based on PC Header, PC Nodes ,FMP and MR views.
`AHL_PC_NODES_VL`	View Based on AHL_PC_NODES_B and AHL_PC_NODES_TL
`AHL_PC_TREE_V`	This view has PC Tree info
`AHL_PLANNING_FACTORS_V`
`AHL_PLAN_VISITS_V`	This view stores the query relates to simulation plans and visit detail information
`AHL_POSITION_ALTERNATES_V`	View based on the tables AHL_RELATIONSHIPS_B and AHL_ITEM_ASSOCIATIONS_B
`AHL_PP_ASSIGNMENT_V`
`AHL_PP_EMPLOYEE_ASSIGN_V`
`AHL_PP_REQUIREMENT_V`
`AHL_PP_RESRC_REQ_ASG_V`
`AHL_PRODTYPE_ZONES_V`	View based on the table AHL_PRODTYPE_ZONES and the view FND_LOOKUP_VALUES_VL to include all the corresponding descriptions of the codes.
`AHL_PROG_TYPE_SUBTYPES_V`	View based on the views AHL_PROG_TYPE_SUBTYPES,FND_LOOKUP_VALUES_VL and FND_LOOKUP_VALUES_VL
`AHL_REFERENCE_DOC_V`	This view is based on AHL_DOCUMENTS_VL, AHL_DOC_REVISIONS_B, FND_LOOKUP_VALUES_VL, and AHL_DOC_TITLE_ASSOS_VL. This stores information relat
`AHL_RELATIONSHIPS_VL`	View based on the table AHL_RELATIONSHIPS_B and the translated columns from the table AHL_RELATIONSHIPS_TL.
`AHL_RESOURCES_V`
`AHL_RESOURCE_MAPPINGS_V`
`AHL_RESOURCE_SKILLS_V`	Obsolete
`AHL_ROUTES_APP_V`	View based on the table AHL_ROUTES_B and the translated columns from the table AHL_ROUTES_TL.
`AHL_ROUTES_B_KFV`	Key Flexfield automatically generated KFV view
`AHL_ROUTES_H_VL`	View based on the table AHL_ROUTES_H_B and the translated columns from the table AHL_ROUTES_H_TL.
`AHL_ROUTES_V`	View based on the views AHL_ROUTES_VL and FND_LOOKUP_VALUES_VL to include all the corresponding descriptions of the codes.
`AHL_ROUTES_VL`	View based on the table AHL_ROUTES_B and the translated columns from the table AHL_ROUTES_TL.
`AHL_ROUTE_EFFECTIVITIES_V`	View based on the views AHL_ROUTE_EFFECTIVITIES , AHL.AHL_MC_HEADERS_V, AHL.AHL_ROUTES_V and AHL_MTL_ITEMS_NON_OU_V to get effectivities
`AHL_ROUTE_MR_V`	This View stores association of complete routes with Active MR's
`AHL_ROUTE_OPERATIONS_V`	View based on the table AHL_ROUTE_OPERATIONS and the view AHL_OPERATIONS_VL to include some attributes of the operations.
`AHL_RT_OPER_DEPENDENCIES_V`
`AHL_RT_OPER_LABOR_V`	View based on the table AHL_RT_OPER_LABOR and the view FND_LOOKUP_VALUES_VL to include all the corresponding descriptions of the codes.
`AHL_RT_OPER_MATERIALS_V`	View based on the table AHL_RT_OPER_MATERIALS and two other columns CONCATENATED_SEGMENTS and DESCRIPTION from the view AHL_MTL_ITEMS_OU_V.
`AHL_RT_OPER_RESOURCES_V`	View based on the table AHL_RT_OPER_RESOURCES and the view FND_LOOKUP_VALUES_VL to include all the corresponding descriptions of the codes.
`AHL_SCHEDULE_MATERIALS_V`
`AHL_SEARCH_TEMPLATES_V`	This view stores the query to retrieve Templates information by search template screen
`AHL_SEARCH_TEMPLATE_TASK_V`	This view stores the query to retrieve Templates task information by search template tasks screen
`AHL_SEARCH_VISITS_V`	This view stores the query to retrieve Visits information by search visits screen
`AHL_SEARCH_VISIT_TASK_V`	This view stores the query to retrieve Visits task information by search visit tasks screen
`AHL_SERIAL_NUMBER_CHANGE_V`	View based on Serial Number change history
`AHL_SIMULATION_FORECAST_V`
`AHL_SIMULATION_PLANS_VL`	View based on ahl_simulation_plans_b & ahl_simulation_plans_tl
`AHL_SPACES_VL`	View based on ahl_simulation_plans_b & ahl_simulation_plans_tl
`AHL_SPACE_CAPBLTS_V`	This view stores the query relates to space and its capabilities
`AHL_SPACE_ORG_DETAILS_V`	This view stores the query relates to space restriction information
`AHL_SPACE_UNAVABL_V`	This view stores the query relates to space restriction information
`AHL_SPACE_UNAVAILABLE_VL`	This view stores the query relates to space restriction information
`AHL_SR_UE_ASSOCIATIONS_V`	View to retrieve the unit effectivities that are associated to a Service Request.
`AHL_SUBSCRIPTIONS_VL`	This view is based on AHL_SUBSCRIPTIONS_B and AHL_SUBSCRIPTIONS_TL tables.
`AHL_UC_HEADER_PATHS_V`	This view stores the unit/subunit position/header/instance information.
`AHL_UE_DEFERRAL_DETAILS_V`	View to retrieve the deferral and unit effectivity details.
`AHL_UE_ORGS_DEPTS_V`
`AHL_UNIT_ALTERNATES_V`	This view stores the query to retrieve alternate item instances available in Install Base for a position (node) as defined by Master Configu
`AHL_UNIT_CONFIG_HEADERS_V`	This view includes all the information related to unit configuration headers, master configuration headers, and the hierarchy of uc and its
`AHL_UNIT_DEFERRALS_VL`	This view stores the query to retrieve unit deferral information based on the base table ( AHL_UNIT_DEFERRALS_B ) and TL ( AHL_UNIT_DEFERR
`AHL_UNIT_DETAILS_V`	This view stores the query to retrieve Unit Configuration node details ( item and position information ).
`AHL_UNIT_EFFECTIVITIES_APP_V`	This view stores the query to retrieve unit effectivities information based on the base( AHL_UNIT_EFFECTIVITIES_B ) and TL ( AHL_UNIT_EFFE
`AHL_UNIT_EFFECTIVITIES_V`	This view stores the query to retrieve unit effectivities information based on the Maintainance Requirements defined in Fleet Maintainance
`AHL_UNIT_EFFECTIVITIES_VL`	This view stores the query to retrieve unit effectivities information based on the base( AHL_UNIT_EFFECTIVITIES_B ) and TL ( AHL_UNIT_EFFE
`AHL_UNIT_HEADER_DETAILS_V`	This view stores the query to retrieve valid Unit Configuration header details.
`AHL_UNIT_INSTALLED_DETAILS_V`	This view stores the query to retrieve Install Base item instance details.
`AHL_USER_STATUSES_V`	This view stores user status information along with lookup type and meaning
`AHL_USER_STATUSES_VL`	This view stores user status information
`AHL_UTILIZATION_FORECAST_V`	This view holds the utilization forecast header information and utilization forcast details.
`AHL_VISITS_INFO_V`	This view stores the query to retrieve Visit information
`AHL_VISITS_VL`	This view stores the query to retrieve Visit information
`AHL_VISIT_DETAILS_V`	This view stores the query to retrieve Visit details (ITEM,INSTANCE, ORGANIZATION, DEPARTMENT, UNIT information)
`AHL_VISIT_MR_V`	This view is used to query data from AHL_VISITS_VL,AHL_VISIT_TASKS_V,MTL_SYSTEM_ITEMS_B,CSI_ITEM_INSTANCES,AHL_MR_HEADERS_VL
`AHL_VISIT_TASKS_V`	This view is based Ahl_Visits_vl, Ahl_visit_tasks_vl
`AHL_VISIT_TASKS_VL`	This view stores the query to retrieve Visit Task details
`AHL_VISIT_TASK_MATRL_V`	This view stores the query to retrieve Work flow nformation
`AHL_VISIT_TYPES_VL`
`AHL_VISIT_TYPE_STAGES_VL`
`AHL_VWP_ROLLUP_COSTS_V`	This view query is used to retreive data from CST_EAM_ROLLUP_COSTS table.
`AHL_WARRANTY_CLAIMS_VL`
`AHL_WARRANTY_CONTRACTS_VL`
`AHL_WARRANTY_CONT_CTR_VL`
`AHL_WARRANTY_TEMPLATES_VL`
`AHL_WARRANTY_TMPL_CTR_VL`
`AHL_WF_MAPPING_V`	This view stores the query to retrieve Work flow information
`AHL_WIP_RESOURCE_TXNS_V`	View based on workorder resource transactions
`AHL_WORKORDERS_OSP_V`	Workorders View for Outside Processing module. Excludes Master Workorders.
`AHL_WORKORDERS_V`	Workorders View for Production Module Restricted by Operating Unit id. Restriction for masterworkorders and workorders created for costing
`AHL_WORKORDER_OPERATIONS_V`	Ahl WorkOrder Operations view.