You are browsing the archive for Oracle Complex Maintenance Repair Overhaul.

Update Document Associations

 

NAME: Update Document Associations
SHORT CODE: AHLDIUPASSO
MODULE: Oracle Complex Maintenance Repair and Overhaul

Description: Concurrent program to update document associations having use latest flag as Yes.
Navigation: Oracle Complex Maintenance Repair and Overhaul Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • p_api_version : API Version

 

Oracle Complex Maintenance Repair Overhaul Tables

Oracle Complex Maintenance, Repair and Overhaul Key Tables:

  • AHL_ALTERNATE_RESOURCES
  • AHL_APPROVAL_API
  • AHL_APPROVAL_RULES_B
  • AHL_APPROVAL_RULES_TL
  • AHL_APPROVERS
  • AHL_CTR_UPDATE_RULES
  • AHL_DEPARTMENT_SHIFTS
  • AHL_DOCUMENTS_B
  • AHL_DOCUMENTS_TL
  • AHL_DOCUMENT_SUB_TYPES
  • AHL_DOC_FILE_ASSOC_B
  • AHL_DOC_FILE_ASSOC_TL
  • AHL_DOC_REVISIONS_B
  • AHL_DOC_REVISIONS_TL
  • AHL_DOC_REVISION_COPIES
  • AHL_DOC_TITLE_ASSOS_B
  • AHL_DOC_TITLE_ASSOS_TL
  • AHL_EVENT_ASSOCIATIONS
  • AHL_ITEM_ASSOCIATIONS_B
  • AHL_ITEM_ASSOCIATIONS_B_H
  • AHL_ITEM_ASSOCIATIONS_TL
  • AHL_ITEM_ASSOCIATIONS_TL_H
  • AHL_ITEM_COMPOSITIONS
  • AHL_ITEM_COMP_DETAILS
  • AHL_ITEM_GROUPS_B
  • AHL_ITEM_GROUPS_B_H
  • AHL_ITEM_GROUPS_TL
  • AHL_ITEM_GROUPS_TL_H
  • AHL_MC_CONFIG_RELATIONS
  • AHL_MC_HEADERS_B
  • AHL_MC_HEADERS_TL
  • AHL_MC_PATH_POSITIONS
  • AHL_MC_PATH_POSITION_NODES
  • AHL_MC_RELATIONSHIPS
  • AHL_MC_RULES_B
  • AHL_MC_RULES_TL
  • AHL_MC_RULE_STATEMENTS
  • AHL_MR_ACTIONS_B
  • AHL_MR_ACTIONS_TL
  • AHL_MR_EFFECTIVITIES
  • AHL_MR_EFFECTIVITY_DTLS
  • AHL_MR_HEADERS_B
  • AHL_MR_HEADERS_TL
  • AHL_MR_INTERVALS
  • AHL_MR_RELATIONSHIPS
  • AHL_MR_ROUTES
  • AHL_MR_ROUTE_SEQUENCES
  • AHL_OPERATIONS_B
  • AHL_OPERATIONS_H_B
  • AHL_OPERATIONS_H_TL
  • AHL_OPERATIONS_TL
  • AHL_OPERATION_PHASES
  • AHL_OPERATION_PHASES_H
  • AHL_OPERATION_RESOURCES
  • AHL_OSP_ORDERS_B
  • AHL_OSP_ORDERS_TL
  • AHL_OSP_ORDER_LINES
  • AHL_OSP_ORDER_LOGS
  • AHL_PART_CHANGES
  • AHL_PC_ASSOCIATIONS
  • AHL_PC_HEADERS_B
  • AHL_PC_HEADERS_TL
  • AHL_PC_NODES_B
  • AHL_PC_NODES_TL
  • AHL_PRODTYPE_ZONES
  • AHL_PROG_TYPE_SUBTYPES
  • AHL_RECIPIENT_DOCUMENTS
  • AHL_RELATIONSHIPS_B
  • AHL_RELATIONSHIPS_TL
  • AHL_RESOURCES
  • AHL_RESOURCE_MAPPINGS
  • AHL_RESOURCE_SKILLS
  • AHL_ROUTES_B
  • AHL_ROUTES_H_B
  • AHL_ROUTES_H_TL
  • AHL_ROUTES_TL
  • AHL_ROUTE_EFFECTIVITIES
  • AHL_ROUTE_OPERATIONS
  • AHL_ROUTE_OPERATIONS_H
  • AHL_RT_OPER_LABOR
  • AHL_RT_OPER_LABOR_H
  • AHL_RT_OPER_MATERIALS
  • AHL_RT_OPER_MATERIALS_H
  • AHL_RT_OPER_RESOURCES
  • AHL_SCHEDULE_MATERIALS
  • AHL_SIMULATION_PLANS_B
  • AHL_SIMULATION_PLANS_TL
  • AHL_SNAPSHOTS
  • AHL_SPACES_B
  • AHL_SPACES_TL
  • AHL_SPACE_ASSIGNMENTS
  • AHL_SPACE_CAPABILITIES
  • AHL_SPACE_UNAVAILABLE_B
  • AHL_SPACE_UNAVAILABLE_TL
  • AHL_STATUS_ORDER_RULES
  • AHL_SUBSCRIPTIONS_B
  • AHL_SUBSCRIPTIONS_TL
  • AHL_SUPPLIER_DOCUMENTS
  • AHL_TASK_LINKS
  • AHL_UC_HEADERS_H
  • AHL_UE_RELATIONSHIPS
  • AHL_UF_DETAILS
  • AHL_UF_HEADERS
  • AHL_UNIT_ACCOMPLISHMNTS
  • AHL_UNIT_CONFIG_HEADERS
  • AHL_UNIT_DEFERRALS_B
  • AHL_UNIT_DEFERRALS_TL
  • AHL_UNIT_EFFECTIVITIES_B
  • AHL_UNIT_EFFECTIVITIES_TL
  • AHL_UNIT_THRESHOLDS
  • AHL_USER_STATUSES_B
  • AHL_USER_STATUSES_TL
  • AHL_VISITS_B
  • AHL_VISITS_TL
  • AHL_VISIT_TASKS_B
  • AHL_VISIT_TASKS_TL
  • AHL_WF_MAPPING
  • AHL_WORKORDERS
  • AHL_WORKORDER_MTL_TXNS
  • AHL_WORKORDER_OPERATIONS
  • AHL_WORKORDER_TXNS
  • AHL_WORK_ASSIGNMENTS
  • AHL_WO_OPERATIONS_TXNS

Complex Maintenance Repair Overhaul Profile Options

Oracle Complex Maintenance Repair Overhaul Repair Profile Options:

PROFILE OPTION SHORT CODE PROFILE OPTION NAME
AHL_MTL_MAT_STATUS_MRB AHL: Material Status – MRB
AHL_UA_MIN_MO_SIZE AHL: Minimum maintenance opportunity duration in minutes required for scheduling a visit
AHL_OSP_IB_SUBTXN_EXC_RETURN AHL: Exchange Order Return IB Transaction SubType
AHL_WORKORDER_TYPE_UNPLANNED AHL: Workorder Type for Unplanned Maintenance
AHL_UMP_MAX_PLANNING_VALUE AHL: Maximum Planning Window (NUMBER)
AHL_WF_COUNTER AHL: Workflow Loop Counter
AHL_PM_INSTALL AHL: Preventive Maintenance Installation
AHL_UMP_MAX_PLANNING_UOM AHL: Maximum Planning Window (UOM).
AHL_WF_TIMEOUT AHL: Workflow Timeout Minutes
AHL_INITIAL_PROJECT_STATUS AHL: Initial Project Status
AHL_VALIDATE_ALT_ITEM_ORG AHL:Validate Alternate Items against Inventory Organization
AHL_PRD_MANUAL_RES_TXN AHL: Technician Role – Enable Manual Resource Transactions
AHL_MCL_M_AND_O_SR_TYPE AHL:Service Request Type used for the M and O Procedures
AHL_OSP_OE_SHIPMENT_PRIORITY AHL: OM Shipment Priority
AHL_OSP_TAX_EXEMPT_REASON AHL: OM Tax Exempt Reason
AHL_OSP_OE_LINE_RET_REASON_CODE AHL: OM Line Return Reason
AHL_VENDOR_SERVICE_DURATION AHL: Vendor Service Duration
AHL_OSP_PO_LINE_TYPE_ID AHL: PO Line Type ID
AHL_OSP_IB_SUBTXN_BOR_SHIP AHL: Borrow Order Ship IB Transaction SubType
AHL_MR_WORKORDER_PREFIX AHL: Workorder Prefix for Maintenance Requirement Workorders
AHL_NR_WORKORDER_PREFIX AHL: Workorder Prefix for Non-Routine Workorders
AHL_WORKORDER_TYPE_DEFAULT AHL: Default Workorder Type
AHL_WORKORDER_TYPE_NONROUTINE AHL:Workorder Type for Non-Routine Maintenance
AHL_WOCARD_TEMPLATE_CODE AHL : Workcard Template Code
AHL_PROJECT_PREFIX AHL: Project Name Prefix
AHL_PROJECT_NUM_PREFIX AHL: Project Number Prefix
AHL_OSP_OWRITE_SVC_DESC AHL: Overwrite PO line description with Item/Serial Number
AHL_OSP_POL_ITEM_PREFIX AHL: PO line description Item number prefix
AHL_OSP_POL_SER_PREFIX AHL: PO line description Serial number prefix
AHL_WORKORDER_TYPE_PLANNED AHL: Workorder Type for Planned Maintenance
AHL_OSP_DEF_PO_DIST AHL: OSP Default PO Distribution Creation
AHL_UA_USE_DEPT_CONFLICT AHL : Consider Department Conflicts
AHL_PRD_OUTPUT_TYPE AHL : Workcard Output Type
AHL_MTL_REQ_NOTIFICATION_ENABLED AHL: Enable workflow Notification for Material Requirements
AHL_TRANSIT_VISIT_DEFAULT_DURATION AHL: Transit Visit Default Duration
AHL_NUMBER_OF_STAGES AHL: Visit Stage Number
AHL_OSP_IB_SUBTXN_BOR_RETURN AHL: Borrow Order Return IB Transaction SubType
AHL_OSP_IB_SUBTXN_EXC_SHIP AHL: Exchange Order Ship IB Transaction SubType
AHL_OSP_IB_SUBTXN_SER_RETURN AHL: Service Order Return IB Transaction SubType
AHL_OSP_IB_SUBTXN_SER_SHIP AHL: Service Order Ship IB Transaction SubType
AHL_OSP_EXPENDITURE_TYPE AHL: OSP Expenditure Type
AHL_OSP_PO_NUMBER_PREFIX AHL: OSP PO Number Prefix
AHL_ENIGMA_WDM_DOC_AVLBL AHL: Enigma WDM Documents associated
AHL_ENIGMA_3C_URL CMRO Enigma Integration URL
AHL_ENIGMA_EM_DOC_AVLBL AHL: Enigma EM Documents associated
AHL_ENIGMA_AMM_DOC_AVLBL AHL: Enigma AMM Documents associated
AHL_ENIGMA_IPC_DOC_AVLBL AHL: Enigma IPC Documents associated
AHL_PRD_SR_CANCELLED_STATUS AHL: Non-Routine Cancellation Status
AHL_BUE_ITEM_CATEGORY_SET AHL:Category Set to limit Item Categories for use by Building Unit Effectivities.
AHL_BPEL_USER_ROLE AHL: BPEL User responsibility
AHL_SR_RESL_CODE_COMP AHL: Enable Resolution Code to be Mandatory
AHL_OSP_INIT_PO_REQ AHL: Initialize Purchase Requisition
AHL_PRD_MTX_RECEPIENT AHL: Validate Recipient for Material Transactions
AHL_MTL_MAT_STATUS_INSPECTION AHL: Material Status – Inspection
AHL_APPLN_USAGE AHL: Application Usage Mode
AHL_PRD_FIRM_PLANNED_FLAG AHL: Create workorders as Firm or Planned
AHL_PRICING_ENABLED AHL: Pricing Enabled
AHL_MR_QA_TXN_NO AHL: Maintenance Requirement Quality Transaction Number
AHL_PRD_TASK_EST_DURATION AHL : Default Estimate Duration
AHL_RM_ROUTE_APPRV_ENABLED AHL: Enable approval workflow for Routes.
AHL_OSP_OE_MIXED_ID AHL: OM Mixed Order Type ID
AHL_NR_WO_OP_PLAN_TYPE AHL: Non-Routine Operation Inspection Type
AHL_PRD_SR_TYPE AHL : Default Service Request Type
AHL_DEFAULT_PA_TEMPLATE_ID AHL: Default Project Template ID
AHL_RM_OPERATION_APPRV_ENABLED AHL: Enable approval workflow for Operations.
AHL_WO_DEFFERAL_PLAN AHL: Job Deferral Inspection Type
AHL_MTL_MAT_STATUS_SERVICABLE AHL: Material Status – Servicable
AHL_PRD_SR_SEVERITY AHL : Default Service Request Severity
AHL_OSP_OE_RETURN_ID AHL: OM Return Line Type ID
AHL_NR_WO_PLAN_TYPE AHL: Non-Routine Job Inspection Type
AHL_PRD_SR_STATUS AHL : Default Service Request Status
AHL_FMP_MR_APPRV_ENABLED AHL: Enable approval workflow for Maintenance Requirement.
AHL_MRB_DISP_PLAN_TYPE AHL: MRB Disposition Inspection Type
AHL_MTL_MAT_STATUS_UNSERVICABLE AHL: Material Status – Unservicable
AHL_OSP_OE_SHIP_ONLY_ID AHL: OM Ship Only Line Type ID
AHL_WO_CTR_READING_PLAN AHL: Counter Reading Plan