You are browsing the archive for AHL.

by oracleguru

Oracle Complex Maintenance Repair Overhaul Tables

ORACLE APPS COMMUNITY > Tutorial > AHL

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

Tags: , No Comments »

by oracleguru

Complex Maintenance Repair Overhaul Profile Options

ORACLE APPS COMMUNITY > Tutorial > AHL

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

Tags: , No Comments »

by oracleguru

Complex Maintenance Repair and Overhaul Concurrent Programs

ORACLE APPS COMMUNITY > Tutorial > AHL

Oracle Complex Maintenance Repair and Overhaul Concurrent Programs

CONCURRENT PROGRAM SHORT CODE CONCURRENT PROGRAM NAME
AHLUEFF Building Unit Effectivities
AHLOSPPO PO Synch All OSPs
AHLPMUEFF Building Unit Effectivities (Preventive Maintenance)
AHL_RA_ANZ_PRC Reliability Analyzer Process
AHLPRDWC Generate Workcards
AHLPRDCLWO Close Work Order Sync Program
AHLPCUEFF Building Unit Effectivities (Product Classification)
AHLUMATF Build Material Stream for Planned Maintenance
AHLWUEFF Building Unit Effectivities(Worker)
AHLFMPTRMP Process Terminated Maintenace Requirements

Tags: No Comments »