Search Results application_usg_code
-
View: AHL_MR_HEADERS_APP_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AHL.AHL_MR_HEADERS_APP_V, object_name:AHL_MR_HEADERS_APP_V, status:VALID, product: AHL - Complex Maintenance Repair and Overhaul , description: View based on the table AHL_MR_HEADERS_B and the translated columns from the table AHL_MR_HEADERS_TL , implementation_dba_data: APPS.AHL_MR_HEADERS_APP_V ,
-
View: AHL_MR_HEADERS_APP_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AHL.AHL_MR_HEADERS_APP_V, object_name:AHL_MR_HEADERS_APP_V, status:VALID, product: AHL - Complex Maintenance Repair and Overhaul , description: View based on the table AHL_MR_HEADERS_B and the translated columns from the table AHL_MR_HEADERS_TL , implementation_dba_data: APPS.AHL_MR_HEADERS_APP_V ,
-
View: AHL_ROUTES_B_KFV
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AHL.AHL_ROUTES_B_KFV, object_name:AHL_ROUTES_B_KFV, status:VALID, product: AHL - Complex Maintenance Repair and Overhaul , description: Key Flexfield automatically generated KFV view , implementation_dba_data: APPS.AHL_ROUTES_B_KFV ,
-
View: AHL_UNIT_EFFECTIVITIES_APP_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AHL.AHL_UNIT_EFFECTIVITIES_APP_V, object_name:AHL_UNIT_EFFECTIVITIES_APP_V, status:VALID, product: AHL - Complex Maintenance Repair and Overhaul , description: This view stores the query to retrieve unit effectivities information based on the base( AHL_UNIT_EFFECTIVITIES_B ) and TL ( AHL_UNIT_EFFECTIVITIES_TL ) tables striped by the language and application usage code. , implementation_dba_data: APPS.AHL_UNIT_EFFECTIVITIES_APP_V ,
-
View: AHL_ROUTES_B_KFV
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AHL.AHL_ROUTES_B_KFV, object_name:AHL_ROUTES_B_KFV, status:VALID, product: AHL - Complex Maintenance Repair and Overhaul , description: Key Flexfield automatically generated KFV view , implementation_dba_data: APPS.AHL_ROUTES_B_KFV ,
-
View: AHL_UNIT_EFFECTIVITIES_APP_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AHL.AHL_UNIT_EFFECTIVITIES_APP_V, object_name:AHL_UNIT_EFFECTIVITIES_APP_V, status:VALID, product: AHL - Complex Maintenance Repair and Overhaul , description: This view stores the query to retrieve unit effectivities information based on the base( AHL_UNIT_EFFECTIVITIES_B ) and TL ( AHL_UNIT_EFFECTIVITIES_TL ) tables striped by the language and application usage code. , implementation_dba_data: APPS.AHL_UNIT_EFFECTIVITIES_APP_V ,
-
View: AHL_MR_ROUTES_APP_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AHL.AHL_MR_ROUTES_APP_V, object_name:AHL_MR_ROUTES_APP_V, status:VALID, product: AHL - Complex Maintenance Repair and Overhaul , implementation_dba_data: APPS.AHL_MR_ROUTES_APP_V ,
-
View: AHL_MR_ROUTES_APP_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AHL.AHL_MR_ROUTES_APP_V, object_name:AHL_MR_ROUTES_APP_V, status:VALID, product: AHL - Complex Maintenance Repair and Overhaul , implementation_dba_data: APPS.AHL_MR_ROUTES_APP_V ,
-
View: AHL_MR_EFFECTIVITIES_APP_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AHL.AHL_MR_EFFECTIVITIES_APP_V, object_name:AHL_MR_EFFECTIVITIES_APP_V, status:VALID, product: AHL - Complex Maintenance Repair and Overhaul , implementation_dba_data: APPS.AHL_MR_EFFECTIVITIES_APP_V ,
-
Table: AHL_MR_HEADERS_B
12.1.1
owner:AHL, object_type:TABLE, fnd_design_data:AHL.AHL_MR_HEADERS_B, object_name:AHL_MR_HEADERS_B, status:VALID, product: AHL - Complex Maintenance Repair and Overhaul , description: This table stores the maintenance requirement header information. , implementation_dba_data: AHL.AHL_MR_HEADERS_B ,
-
View: AHL_MR_ROUTE_SEQUENCES_APP_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AHL.AHL_MR_ROUTE_SEQUENCES_APP_V, object_name:AHL_MR_ROUTE_SEQUENCES_APP_V, status:VALID, product: AHL - Complex Maintenance Repair and Overhaul , implementation_dba_data: APPS.AHL_MR_ROUTE_SEQUENCES_APP_V ,
-
Table: AHL_MR_HEADERS_B
12.2.2
owner:AHL, object_type:TABLE, fnd_design_data:AHL.AHL_MR_HEADERS_B, object_name:AHL_MR_HEADERS_B, status:VALID, product: AHL - Complex Maintenance Repair and Overhaul , description: This table stores the maintenance requirement header information. , implementation_dba_data: AHL.AHL_MR_HEADERS_B ,
-
View: AHL_MR_ROUTE_SEQUENCES_APP_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AHL.AHL_MR_ROUTE_SEQUENCES_APP_V, object_name:AHL_MR_ROUTE_SEQUENCES_APP_V, status:VALID, product: AHL - Complex Maintenance Repair and Overhaul , implementation_dba_data: APPS.AHL_MR_ROUTE_SEQUENCES_APP_V ,
-
View: AHL_MR_RELATIONSHIPS_APP_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AHL.AHL_MR_RELATIONSHIPS_APP_V, object_name:AHL_MR_RELATIONSHIPS_APP_V, status:VALID, product: AHL - Complex Maintenance Repair and Overhaul , description: 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. , implementation_dba_data: APPS.AHL_MR_RELATIONSHIPS_APP_V ,
-
View: AHL_MR_INTERVALS_APP_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AHL.AHL_MR_INTERVALS_APP_V, object_name:AHL_MR_INTERVALS_APP_V, status:VALID, product: AHL - Complex Maintenance Repair and Overhaul , implementation_dba_data: APPS.AHL_MR_INTERVALS_APP_V ,
-
View: AHL_MR_RELATIONSHIPS_APP_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AHL.AHL_MR_RELATIONSHIPS_APP_V, object_name:AHL_MR_RELATIONSHIPS_APP_V, status:VALID, product: AHL - Complex Maintenance Repair and Overhaul , description: 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. , implementation_dba_data: APPS.AHL_MR_RELATIONSHIPS_APP_V ,
-
View: AHL_MR_EFFECTIVITIES_APP_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AHL.AHL_MR_EFFECTIVITIES_APP_V, object_name:AHL_MR_EFFECTIVITIES_APP_V, status:VALID, product: AHL - Complex Maintenance Repair and Overhaul , implementation_dba_data: APPS.AHL_MR_EFFECTIVITIES_APP_V ,
-
View: AHL_WF_MAPPING_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AHL.AHL_WF_MAPPING_V, object_name:AHL_WF_MAPPING_V, status:VALID, product: AHL - Complex Maintenance Repair and Overhaul , description: This view stores the query to retrieve Work flow information , implementation_dba_data: APPS.AHL_WF_MAPPING_V ,
-
View: AHL_MR_INTERVALS_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AHL.AHL_MR_INTERVALS_V, object_name:AHL_MR_INTERVALS_V, status:VALID, product: AHL - Complex Maintenance Repair and Overhaul , description: View based on the views AHL_MR_INTERVALS,CS_COUNTERS, and MTL_UNITS_OF_MEASURE_VL , implementation_dba_data: APPS.AHL_MR_INTERVALS_V ,
-
View: AHL_MR_INTERVALS_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AHL.AHL_MR_INTERVALS_V, object_name:AHL_MR_INTERVALS_V, status:VALID, product: AHL - Complex Maintenance Repair and Overhaul , description: View based on the views AHL_MR_INTERVALS,CS_COUNTERS, and MTL_UNITS_OF_MEASURE_VL , implementation_dba_data: APPS.AHL_MR_INTERVALS_V ,
-
View: AHL_MR_INTERVALS_APP_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AHL.AHL_MR_INTERVALS_APP_V, object_name:AHL_MR_INTERVALS_APP_V, status:VALID, product: AHL - Complex Maintenance Repair and Overhaul , implementation_dba_data: APPS.AHL_MR_INTERVALS_APP_V ,
-
View: AHL_MR_EFFECTIVITY_DTLS_APP_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AHL.AHL_MR_EFFECTIVITY_DTLS_APP_V, object_name:AHL_MR_EFFECTIVITY_DTLS_APP_V, status:VALID, product: AHL - Complex Maintenance Repair and Overhaul , implementation_dba_data: APPS.AHL_MR_EFFECTIVITY_DTLS_APP_V ,
-
View: AHL_WF_MAPPING_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AHL.AHL_WF_MAPPING_V, object_name:AHL_WF_MAPPING_V, status:VALID, product: AHL - Complex Maintenance Repair and Overhaul , description: This view stores the query to retrieve Work flow information , implementation_dba_data: APPS.AHL_WF_MAPPING_V ,
-
View: AHL_MR_EFFECTIVITY_DTLS_APP_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AHL.AHL_MR_EFFECTIVITY_DTLS_APP_V, object_name:AHL_MR_EFFECTIVITY_DTLS_APP_V, status:VALID, product: AHL - Complex Maintenance Repair and Overhaul , implementation_dba_data: APPS.AHL_MR_EFFECTIVITY_DTLS_APP_V ,
-
View: AHL_MR_ROUTES_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AHL.AHL_MR_ROUTES_V, object_name:AHL_MR_ROUTES_V, status:VALID, product: AHL - Complex Maintenance Repair and Overhaul , description: View based on the views AHL_MR_ROUTES and AHL_ROUTES_V to include all the codes and their corresponding descriptions. , implementation_dba_data: APPS.AHL_MR_ROUTES_V ,
-
View: AHL_MR_ROUTES_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AHL.AHL_MR_ROUTES_V, object_name:AHL_MR_ROUTES_V, status:VALID, product: AHL - Complex Maintenance Repair and Overhaul , description: View based on the views AHL_MR_ROUTES and AHL_ROUTES_V to include all the codes and their corresponding descriptions. , implementation_dba_data: APPS.AHL_MR_ROUTES_V ,
-
View: AHL_APPROVAL_RULES_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AHL.AHL_APPROVAL_RULES_V, object_name:AHL_APPROVAL_RULES_V, status:VALID, product: AHL - Complex Maintenance Repair and Overhaul , description: This view stores the query relates to approval rules information , implementation_dba_data: APPS.AHL_APPROVAL_RULES_V ,
-
View: AHL_APPROVAL_RULES_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AHL.AHL_APPROVAL_RULES_V, object_name:AHL_APPROVAL_RULES_V, status:VALID, product: AHL - Complex Maintenance Repair and Overhaul , description: This view stores the query relates to approval rules information , implementation_dba_data: APPS.AHL_APPROVAL_RULES_V ,
-
View: AHL_UNIT_EFFECTIVITIES_VL
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AHL.AHL_UNIT_EFFECTIVITIES_VL, object_name:AHL_UNIT_EFFECTIVITIES_VL, status:VALID, product: AHL - Complex Maintenance Repair and Overhaul , description: This view stores the query to retrieve unit effectivities information based on the base( AHL_UNIT_EFFECTIVITIES_B ) and TL ( AHL_UNIT_EFFECTIVITIES_TL ) tables. , implementation_dba_data: APPS.AHL_UNIT_EFFECTIVITIES_VL ,
-
View: AHL_APPROVAL_RULES_VL
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AHL.AHL_APPROVAL_RULES_VL, object_name:AHL_APPROVAL_RULES_VL, status:VALID, product: AHL - Complex Maintenance Repair and Overhaul , description: This view stores the query relates to approval rules information , implementation_dba_data: APPS.AHL_APPROVAL_RULES_VL ,
-
View: AHL_APPROVAL_RULES_VL
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AHL.AHL_APPROVAL_RULES_VL, object_name:AHL_APPROVAL_RULES_VL, status:VALID, product: AHL - Complex Maintenance Repair and Overhaul , description: This view stores the query relates to approval rules information , implementation_dba_data: APPS.AHL_APPROVAL_RULES_VL ,
-
View: AHL_MR_HEADERS_VL
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AHL.AHL_MR_HEADERS_VL, object_name:AHL_MR_HEADERS_VL, status:VALID, product: AHL - Complex Maintenance Repair and Overhaul , description: View based on the table AHL_MR_HEADERS_B and the translated columns from the table AHL_MR_HEADERS_TL , implementation_dba_data: APPS.AHL_MR_HEADERS_VL ,
-
View: AHL_MR_HEADERS_VL
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AHL.AHL_MR_HEADERS_VL, object_name:AHL_MR_HEADERS_VL, status:VALID, product: AHL - Complex Maintenance Repair and Overhaul , description: View based on the table AHL_MR_HEADERS_B and the translated columns from the table AHL_MR_HEADERS_TL , implementation_dba_data: APPS.AHL_MR_HEADERS_VL ,
-
View: AHL_MR_EFFECTIVITIES_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AHL.AHL_MR_EFFECTIVITIES_V, object_name:AHL_MR_EFFECTIVITIES_V, status:VALID, product: AHL - Complex Maintenance Repair and Overhaul , description: 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 , implementation_dba_data: APPS.AHL_MR_EFFECTIVITIES_V ,
-
View: AHL_UNIT_EFFECTIVITIES_VL
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AHL.AHL_UNIT_EFFECTIVITIES_VL, object_name:AHL_UNIT_EFFECTIVITIES_VL, status:VALID, product: AHL - Complex Maintenance Repair and Overhaul , description: This view stores the query to retrieve unit effectivities information based on the base( AHL_UNIT_EFFECTIVITIES_B ) and TL ( AHL_UNIT_EFFECTIVITIES_TL ) tables. , implementation_dba_data: APPS.AHL_UNIT_EFFECTIVITIES_VL ,
-
View: AHL_MR_EFFECTIVITIES_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AHL.AHL_MR_EFFECTIVITIES_V, object_name:AHL_MR_EFFECTIVITIES_V, status:VALID, product: AHL - Complex Maintenance Repair and Overhaul , description: 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 , implementation_dba_data: APPS.AHL_MR_EFFECTIVITIES_V ,
-
View: AHL_ROUTES_APP_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AHL.AHL_ROUTES_APP_V, object_name:AHL_ROUTES_APP_V, status:VALID, product: AHL - Complex Maintenance Repair and Overhaul , description: View based on the table AHL_ROUTES_B and the translated columns from the table AHL_ROUTES_TL. , implementation_dba_data: APPS.AHL_ROUTES_APP_V ,
-
View: AHL_ROUTES_APP_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AHL.AHL_ROUTES_APP_V, object_name:AHL_ROUTES_APP_V, status:VALID, product: AHL - Complex Maintenance Repair and Overhaul , description: View based on the table AHL_ROUTES_B and the translated columns from the table AHL_ROUTES_TL. , implementation_dba_data: APPS.AHL_ROUTES_APP_V ,
-
View: AHL_MR_ITEM_DETAILS_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AHL.AHL_MR_ITEM_DETAILS_V, object_name:AHL_MR_ITEM_DETAILS_V, status:VALID, product: AHL - Complex Maintenance Repair and Overhaul , description: 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 requirement. This view is used by the Search MR UI to search by the associated item number along with othe , implementation_dba_data: APPS.AHL_MR_ITEM_DETAILS_V ,
-
View: AHL_MR_DETAILS_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AHL.AHL_MR_DETAILS_V, object_name:AHL_MR_DETAILS_V, status:VALID, product: AHL - Complex Maintenance Repair and Overhaul , description: 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_ASSOS_B & AHL_DOCUMENTS_VL to include the originating document. This View is used for Search MR. , implementation_dba_data: APPS.AHL_MR_DETAILS_V ,
-
View: AHL_MR_ITEM_DETAILS_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AHL.AHL_MR_ITEM_DETAILS_V, object_name:AHL_MR_ITEM_DETAILS_V, status:VALID, product: AHL - Complex Maintenance Repair and Overhaul , description: 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 requirement. This view is used by the Search MR UI to search by the associated item number along with othe , implementation_dba_data: APPS.AHL_MR_ITEM_DETAILS_V ,
-
View: AHL_MR_DETAILS_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AHL.AHL_MR_DETAILS_V, object_name:AHL_MR_DETAILS_V, status:VALID, product: AHL - Complex Maintenance Repair and Overhaul , description: 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_ASSOS_B & AHL_DOCUMENTS_VL to include the originating document. This View is used for Search MR. , implementation_dba_data: APPS.AHL_MR_DETAILS_V ,
-
View: AHL_ROUTES_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AHL.AHL_ROUTES_V, object_name:AHL_ROUTES_V, status:VALID, product: AHL - Complex Maintenance Repair and Overhaul , description: View based on the views AHL_ROUTES_VL and FND_LOOKUP_VALUES_VL to include all the corresponding descriptions of the codes. , implementation_dba_data: APPS.AHL_ROUTES_V ,
-
View: AHL_ROUTES_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AHL.AHL_ROUTES_V, object_name:AHL_ROUTES_V, status:VALID, product: AHL - Complex Maintenance Repair and Overhaul , description: View based on the views AHL_ROUTES_VL and FND_LOOKUP_VALUES_VL to include all the corresponding descriptions of the codes. , implementation_dba_data: APPS.AHL_ROUTES_V ,
-
View: AHL_UE_DEFERRAL_DETAILS_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AHL.AHL_UE_DEFERRAL_DETAILS_V, object_name:AHL_UE_DEFERRAL_DETAILS_V, status:VALID, product: AHL - Complex Maintenance Repair and Overhaul , description: View to retrieve the deferral and unit effectivity details. , implementation_dba_data: APPS.AHL_UE_DEFERRAL_DETAILS_V ,
-
View: AHL_UE_DEFERRAL_DETAILS_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AHL.AHL_UE_DEFERRAL_DETAILS_V, object_name:AHL_UE_DEFERRAL_DETAILS_V, status:VALID, product: AHL - Complex Maintenance Repair and Overhaul , description: View to retrieve the deferral and unit effectivity details. , implementation_dba_data: APPS.AHL_UE_DEFERRAL_DETAILS_V ,
-
View: AHL_MR_HEADERS_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AHL.AHL_MR_HEADERS_V, object_name:AHL_MR_HEADERS_V, status:VALID, product: AHL - Complex Maintenance Repair and Overhaul , description: 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_MR_HEADERS_B to get the Preceding MR Title & Revision. , implementation_dba_data: APPS.AHL_MR_HEADERS_V ,
-
View: AHL_MR_HEADERS_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AHL.AHL_MR_HEADERS_V, object_name:AHL_MR_HEADERS_V, status:VALID, product: AHL - Complex Maintenance Repair and Overhaul , description: 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_MR_HEADERS_B to get the Preceding MR Title & Revision. , implementation_dba_data: APPS.AHL_MR_HEADERS_V ,
-
View: AHL_UNIT_EFFECTIVITIES_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AHL.AHL_UNIT_EFFECTIVITIES_V, object_name:AHL_UNIT_EFFECTIVITIES_V, status:VALID, product: AHL - Complex Maintenance Repair and Overhaul , description: This view stores the query to retrieve unit effectivities information based on the Maintainance Requirements defined in Fleet Maintainance Program and item instances available in Install Base for a position (node). , implementation_dba_data: APPS.AHL_UNIT_EFFECTIVITIES_V ,
-
View: AHL_UNIT_EFFECTIVITIES_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AHL.AHL_UNIT_EFFECTIVITIES_V, object_name:AHL_UNIT_EFFECTIVITIES_V, status:VALID, product: AHL - Complex Maintenance Repair and Overhaul , description: This view stores the query to retrieve unit effectivities information based on the Maintainance Requirements defined in Fleet Maintainance Program and item instances available in Install Base for a position (node). , implementation_dba_data: APPS.AHL_UNIT_EFFECTIVITIES_V ,