Results for “mr_header_id”
50+ results
-
A dummy table to mirror ahl_mr_headers_b. Oracle Internal use only - reserved for future use.
-
A dummy table to mirror ahl_mr_headers_b. Oracle Internal use only - reserved for future use.
-
View: AHL_MR_PC_NODES_V 12.1.1
View based on join of AHL_MR_DETAILS_V, AHL_MR_EFFECTIVITIES to include the PC_NODE_ID defined in the MR effectivities
APPS.AHL_MR_PC_NODES_V·↳ AHL_MR_EFFECTIVITIES·↳ AHL_MR_HEADERS_APP_V·↳ FND_LOOKUP_VALUES_VL·Explore AHL module →
-
View: AHL_MR_ITEMS_V 12.1.1
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 requirements.
APPS.AHL_MR_ITEMS_V·↳ AHL_MR_EFFECTIVITIES·↳ AHL_MR_HEADERS_B·↳ AHL_POSITION_ALTERNATES_V·Explore AHL module →
-
View: AHL_MR_ITEMS_V 12.2.2
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 requirements.
APPS.AHL_MR_ITEMS_V·↳ AHL_MR_EFFECTIVITIES·↳ AHL_MR_HEADERS_B·↳ AHL_POSITION_ALTERNATES_V·Explore AHL module →
-
View: AHL_MR_PC_NODES_V 12.2.2
View based on join of AHL_MR_DETAILS_V, AHL_MR_EFFECTIVITIES to include the PC_NODE_ID defined in the MR effectivities
APPS.AHL_MR_PC_NODES_V·↳ AHL_MR_EFFECTIVITIES·↳ AHL_MR_HEADERS_APP_V·↳ FND_LOOKUP_VALUES_VL·Explore AHL module →
-
View to retrieve the unit effectivities that are associated to a Service Request.
APPS.AHL_SR_UE_ASSOCIATIONS_V·↳ AHL_MR_HEADERS_VL·↳ AHL_UE_RELATIONSHIPS·↳ AHL_UNIT_EFFECTIVITIES_APP_V·Explore AHL module →
-
This table stores the associations of maintenance requirements to routes.
-
View: AHL_MR_ACTIONS_VL 12.2.2
View based on the views AHL_MR_ACTIONS_B and AHL_MR_ACTIONS_TL to include all the codes and their corresponding descriptions.
APPS.AHL_MR_ACTIONS_VL·↳ AHL_MR_ACTIONS_B·↳ AHL_MR_ACTIONS_TL·Explore AHL module →
-
View: AHL_MR_ROUTES_APP_V 12.1.1
APPS.AHL_MR_ROUTES_APP_V·↳ AHL_MR_HEADERS_APP_V·↳ AHL_MR_ROUTES·↳ FND_PROFILE·Explore AHL module →
-
Translation table for maintenance requirement header.
-
View: AHL_MR_ITEM_DETAILS_V 12.1.1
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
APPS.AHL_MR_ITEM_DETAILS_V·↳ AHL_DOCUMENTS_TL·↳ AHL_DOC_REVISIONS_B·↳ AHL_DOC_TITLE_ASSOS_B·Explore AHL module →
-
View: AHL_MR_ROUTES_V 12.1.1
View based on the views AHL_MR_ROUTES and AHL_ROUTES_V to include all the codes and their corresponding descriptions.
APPS.AHL_MR_ROUTES_V·↳ AHL_MR_ROUTES_APP_V·↳ AHL_ROUTES_APP_V·↳ FND_LOOKUP_VALUES_VL·Explore AHL module →
-
View: AHL_MR_DETAILS_V 12.2.2
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.
APPS.AHL_MR_DETAILS_V·↳ AHL_DOCUMENTS_B·↳ AHL_DOCUMENTS_TL·↳ AHL_DOC_REVISIONS_B·Explore AHL module →
-
View: AHL_VISIT_MR_V 12.1.1
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
APPS.AHL_VISIT_MR_V·↳ AHL_MR_HEADERS_VL·↳ AHL_VISITS_VL·↳ AHL_VISIT_TASKS_VL·Explore AHL module →
-
View: AHL_MR_EFFECTIVITIES_V 12.1.1
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
APPS.AHL_MR_EFFECTIVITIES_V·↳ AHL_MC_PATH_POSITION_PVT·↳ AHL_MR_EFFECTIVITIES_APP_V·↳ AHL_PC_NODES_B·Explore AHL module →
-
Translation table for maintenance requirement header.
-
View: AHL_MR_ITEM_DETAILS_V 12.2.2
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
APPS.AHL_MR_ITEM_DETAILS_V·↳ AHL_DOCUMENTS_B·↳ AHL_DOCUMENTS_TL·↳ AHL_DOC_REVISIONS_B·Explore AHL module →
-
View: AHL_VISIT_MR_V 12.2.2
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
APPS.AHL_VISIT_MR_V·↳ AHL_MR_HEADERS_VL·↳ AHL_VISITS_VL·↳ AHL_VISIT_TASKS_VL·Explore AHL module →
-
This table stores the actions associated with each maintenance requirement.
-
View: AHL_MR_INSTANCES_V 12.1.1
View To get all the Maintenance Requirements in Production
APPS.AHL_MR_INSTANCES_V·↳ AHL_COMPLETIONS_PVT·↳ AHL_UE_DEFERRAL_DETAILS_V·↳ AHL_UTILITY_PVT·Explore AHL module →
-
This table stores the associations of maintenance requirements to routes.
-
View to retrieve the unit effectivities that are associated to a Service Request.
APPS.AHL_SR_UE_ASSOCIATIONS_V·↳ AHL_MR_HEADERS_VL·↳ AHL_UE_RELATIONSHIPS·↳ AHL_UNIT_EFFECTIVITIES_APP_V·Explore AHL module →
-
This table stores the parent/child relationships of maintenance requirements.
-
View: AHL_ROUTE_MR_V 12.1.1
This View stores association of complete routes with Active MR's
APPS.AHL_ROUTE_MR_V·↳ AHL_MR_HEADERS_B·↳ AHL_MR_ROUTES·↳ AHL_ROUTES_B·Explore AHL module →
-
View: AHL_ROUTE_MR_V 12.2.2
This View stores association of complete routes with Active MR's
APPS.AHL_ROUTE_MR_V·↳ AHL_MR_HEADERS_B·↳ AHL_MR_ROUTES·↳ AHL_ROUTES_B·Explore AHL module →
-
View: AHL_MR_ACTIONS_V 12.1.1
View based on the views AHL_MR_ACTIONS_VL, FND_LOOKUP_VALUES_VL and QA_PLANS
APPS.AHL_MR_ACTIONS_V·↳ AHL_MR_ACTIONS_VL·↳ FND_LOOKUP_VALUES_VL·↳ QA_PLANS·Explore AHL module →
-
This table stores the effectivity of maintenance requirement.
-
View: AHL_MR_DETAILS_V 12.1.1
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.
APPS.AHL_MR_DETAILS_V·↳ AHL_DOCUMENTS_TL·↳ AHL_DOC_REVISIONS_B·↳ AHL_DOC_TITLE_ASSOS_B·Explore AHL module →
-
This table stores the parent/child relationships of maintenance requirements.
-
Ahl mr visit types Table
-
This table stores association of M&O procedures (Maintenance Requirements of program_type MO_PROC) with ATA sequences.
-
View: AHL_MR_ACTIONS_V 12.2.2
View based on the views AHL_MR_ACTIONS_VL, FND_LOOKUP_VALUES_VL and QA_PLANS
APPS.AHL_MR_ACTIONS_V·↳ AHL_MR_ACTIONS_VL·↳ FND_LOOKUP_VALUES_VL·↳ QA_PLANS·Explore AHL module →
-
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.
APPS.AHL_UNIT_EFFECTIVITIES_APP_V·↳ AHL_UNIT_EFFECTIVITIES_VL·↳ FND_PROFILE·Explore AHL module →
-
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.
APPS.AHL_MR_RELATIONSHIPS_APP_V·↳ AHL_MR_HEADERS_APP_V·↳ AHL_MR_RELATIONSHIPS·↳ FND_PROFILE·Explore AHL module →
-
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.
APPS.AHL_MR_RELATIONSHIPS_APP_V·↳ AHL_MR_HEADERS_APP_V·↳ AHL_MR_RELATIONSHIPS·↳ FND_PROFILE·Explore AHL module →
-
View: AHL_MR_ROUTES_APP_V 12.2.2
APPS.AHL_MR_ROUTES_APP_V·↳ AHL_MR_HEADERS_APP_V·↳ AHL_MR_ROUTES·↳ FND_PROFILE·Explore AHL module →
-
APPS.AHL_SIMULATION_FORECAST_V·↳ AHL_FLEET_HEADERS_B·↳ AHL_MC_HEADERS_B·↳ AHL_MR_HEADERS_B·Explore AHL module →
-
This table stores the effectivity of maintenance requirement.
-
This table stores the actions associated with each maintenance requirement.
-
View: AHL_MR_ACTIONS_VL 12.1.1
View based on the views AHL_MR_ACTIONS_B and AHL_MR_ACTIONS_TL to include all the codes and their corresponding descriptions.
APPS.AHL_MR_ACTIONS_VL·↳ AHL_MR_ACTIONS_B·↳ AHL_MR_ACTIONS_TL·Explore AHL module →
-
View to retrieve the deferral and unit effectivity details.
APPS.AHL_UE_DEFERRAL_DETAILS_V·↳ AHL_MR_HEADERS_V·↳ AHL_UNIT_DEFERRALS_B·↳ AHL_UNIT_EFFECTIVITIES_APP_V·Explore AHL module →
-
View: AHL_MR_HEADERS_APP_V 12.1.1
View based on the table AHL_MR_HEADERS_B and the translated columns from the table AHL_MR_HEADERS_TL
APPS.AHL_MR_HEADERS_APP_V·↳ AHL_MR_HEADERS_VL·↳ FND_PROFILE·Explore AHL module →
-
APPS.AHL_MR_EFFECTIVITIES_APP_V·↳ AHL_MR_EFFECTIVITIES·↳ AHL_MR_HEADERS_APP_V·↳ FND_PROFILE·Explore AHL module →