eTRM uses javascript that opens and focuses a separate window to display reports.
Your browser does not appear to support javascript. This should not prevent you from using
eTRM but it does mean the window focus feature will not work. Please check the contents of
other windows on your desktop if you click on a link that does not appear to do anything.
Oracle eBusiness Suite Technical Reference
Release 11i - Copyright (c) 2001 - 2005 Oracle
This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is
provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and
other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to
safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or
a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential
Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c)
restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was
disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends
or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or
by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this
TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.
The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter,
please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is'
with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements.
Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this
TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's
responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the
Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs.
Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose.
Restricted Rights Legend
This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and
use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the
applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal
Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this
TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500
Oracle Parkway, Redwood City, CA 94065.
Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™,
.comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM,
GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™,
NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™,
On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE ®, Oracle Business OnLine®,
OracleDevConnect SM, Oracle® Discoverer™,
Oracle® Expert™, Oracle Financials®, OracleGOLD SM,
OracleIncident SM, OracleJSP™,
OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURY SM,
OracleMetaLink SM, Oraclemetals SM, OracleMobile™, Oracle Names®,
Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®,
Oracle OpenWorld®, OraclePLATINUM SM,
Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®,
Oracle Quality®, Oracle Secure Network Services®, OracleSILVER SM,
Oracle® SQL/Services™, Oracle® SQL*TutorSM,
OracleSTERLING SM, Oracle Store®,
Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™,
PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®,
Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®,
Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™,
Secure Access 2.0™, Secure Network Services®, Security Without Compromise™,
SellingPoint®, SQL*Plus®, Tutor™ are trademarks or
registered trademarks of Oracle. Other names may be trademarks of their respective owners.
The absence of a product or service name, slogan, or logo from this list does not constitute a
waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan,
or logo.
eTRM - AHL Tables and Views
TABLE - AHL.AHL_ALTERNATE_RESOURCES
TABLE - AHL.AHL_APPLICABLE_INSTANCES
TABLE - AHL.AHL_APPLICABLE_MRS
TABLE - AHL.AHL_APPLICABLE_MRS1
TABLE - AHL.AHL_APPROVAL_API
TABLE - AHL.AHL_APPROVAL_RULES_B
TABLE - AHL.AHL_APPROVAL_RULES_TL
TABLE - AHL.AHL_APPROVERS
TABLE - AHL.AHL_AUTOVISIT_HIERARCHY
TABLE - AHL.AHL_AUTOVST_SNPSHT_HDR
TABLE - AHL.AHL_BUE_WORKER_DATA
TABLE - AHL.AHL_BUILD_GOALS
TABLE - AHL.AHL_CONFIG_COMPONENTS
TABLE - AHL.AHL_CONFIG_COMPONENTS1
TABLE - AHL.AHL_CTR_UPDATE_RULES
TABLE - AHL.AHL_DEPARTMENT_SHIFTS
TABLE - AHL.AHL_DEPT_RESOURCE_CAPACITY
TABLE - AHL.AHL_DOCUMENTS_B
TABLE - AHL.AHL_DOCUMENTS_TL
TABLE - AHL.AHL_DOCUMENT_SUB_TYPES
TABLE - AHL.AHL_DOC_FILE_ASSOC_B
TABLE - AHL.AHL_DOC_FILE_ASSOC_TL
TABLE - AHL.AHL_DOC_REVISIONS_B
TABLE - AHL.AHL_DOC_REVISIONS_TL
TABLE - AHL.AHL_DOC_REVISION_COPIES
TABLE - AHL.AHL_DOC_TITLE_ASSOS_B
TABLE - AHL.AHL_DOC_TITLE_ASSOS_TL
TABLE - AHL.AHL_ENIGMA_JCG_DETAILS
TABLE - AHL.AHL_ENIGMA_OP_INTERFACE
TABLE - AHL.AHL_ENIGMA_PROCESS_LOG
TABLE - AHL.AHL_ENIGMA_RT_INTERFACE
TABLE - AHL.AHL_EVENT_ASSOCIATIONS
TABLE - AHL.AHL_FLEET_DOWNTIMES
TABLE - AHL.AHL_FLEET_HEADERS_B
TABLE - AHL.AHL_FLEET_HEADERS_TL
TABLE - AHL.AHL_FLEET_RECONFIG_MRS
TABLE - AHL.AHL_FLEET_UNIT_ASSOCS
TABLE - AHL.AHL_FLEET_UTILIZATION
TABLE - AHL.AHL_FLEET_UTLZN_FORECAST
TABLE - AHL.AHL_INV_SERVICE_ITEM_RELS
TABLE - AHL.AHL_ITEM_ASSOCIATIONS_B
TABLE - AHL.AHL_ITEM_ASSOCIATIONS_B_H
TABLE - AHL.AHL_ITEM_ASSOCIATIONS_TL
TABLE - AHL.AHL_ITEM_ASSOCIATIONS_TL_H
TABLE - AHL.AHL_ITEM_COMPOSITIONS
TABLE - AHL.AHL_ITEM_COMP_DETAILS
TABLE - AHL.AHL_ITEM_GROUPS_B
TABLE - AHL.AHL_ITEM_GROUPS_B_H
TABLE - AHL.AHL_ITEM_GROUPS_TL
TABLE - AHL.AHL_ITEM_GROUPS_TL_H
TABLE - AHL.AHL_ITEM_VENDOR_RELS
TABLE - AHL.AHL_MC_CONFIG_RELATIONS
TABLE - AHL.AHL_MC_HEADERS_B
TABLE - AHL.AHL_MC_HEADERS_TL
TABLE - AHL.AHL_MC_PATH_POSITIONS
TABLE - AHL.AHL_MC_PATH_POSITION_NODES
TABLE - AHL.AHL_MC_RELATIONSHIPS
TABLE - AHL.AHL_MC_RULES_B
TABLE - AHL.AHL_MC_RULES_TL
TABLE - AHL.AHL_MC_RULE_STATEMENTS
TABLE - AHL.AHL_MEL_CDL_ATA_SEQUENCES
TABLE - AHL.AHL_MEL_CDL_HEADERS
TABLE - AHL.AHL_MEL_CDL_MO_PROCEDURES
TABLE - AHL.AHL_MEL_CDL_RELATIONSHIPS
TABLE - AHL.AHL_MM_TXN_INTERFACE
TABLE - AHL.AHL_MR_ACTIONS_B
TABLE - AHL.AHL_MR_ACTIONS_TL
TABLE - AHL.AHL_MR_EFFECTIVITIES
TABLE - AHL.AHL_MR_EFFECTIVITY_DTLS
TABLE - AHL.AHL_MR_EFFECTIVITY_EXT_DTLS
TABLE - AHL.AHL_MR_HEADERS_B
TABLE - AHL.AHL_MR_HEADERS_TL
TABLE - AHL.AHL_MR_INTERVALS
TABLE - AHL.AHL_MR_ORGANIZATIONS
TABLE - AHL.AHL_MR_RELATIONSHIPS
TABLE - AHL.AHL_MR_ROUTES
TABLE - AHL.AHL_MR_ROUTE_SEQUENCES
TABLE - AHL.AHL_MR_VISIT_TYPES
TABLE - AHL.AHL_NR_PROFILE_DETAILS
TABLE - AHL.AHL_NR_PROFILE_HEADERS
TABLE - AHL.AHL_OPERATIONS_B
TABLE - AHL.AHL_OPERATIONS_H_B
TABLE - AHL.AHL_OPERATIONS_H_TL
TABLE - AHL.AHL_OPERATIONS_TL
TABLE - AHL.AHL_OPERATION_PHASES
TABLE - AHL.AHL_OPERATION_PHASES_H
TABLE - AHL.AHL_OPERATION_RESOURCES
TABLE - AHL.AHL_OPER_VST_AUTOCREATE
TABLE - AHL.AHL_OSP_ORDERS_B
TABLE - AHL.AHL_OSP_ORDERS_TL
TABLE - AHL.AHL_OSP_ORDER_LINES
TABLE - AHL.AHL_OSP_ORDER_LOGS
TABLE - AHL.AHL_PART_CHANGES
TABLE - AHL.AHL_PC_ASSOCIATIONS
TABLE - AHL.AHL_PC_HEADERS_B
TABLE - AHL.AHL_PC_HEADERS_TL
TABLE - AHL.AHL_PC_NODES_B
TABLE - AHL.AHL_PC_NODES_TL
TABLE - AHL.AHL_PLANNING_FACTORS
TABLE - AHL.AHL_PRD_DISPOSITIONS_B
TABLE - AHL.AHL_PRD_DISPOSITIONS_B_H
TABLE - AHL.AHL_PRD_DISPOSITIONS_TL
TABLE - AHL.AHL_PRD_DISPOSITIONS_TL_H
TABLE - AHL.AHL_PRD_DISP_MTL_TXNS
TABLE - AHL.AHL_PRD_MB_UC_DETAILS
TABLE - AHL.AHL_PRODTYPE_ZONES
TABLE - AHL.AHL_PROG_TYPE_SUBTYPES
TABLE - AHL.AHL_RA_CTR_ASSOCIATIONS
TABLE - AHL.AHL_RA_DEFINITION_DTLS
TABLE - AHL.AHL_RA_DEFINITION_HDR
TABLE - AHL.AHL_RA_FCT_ASSOCIATIONS
TABLE - AHL.AHL_RA_SETUPS
TABLE - AHL.AHL_RECIPIENT_DOCUMENTS
TABLE - AHL.AHL_RELATIONSHIPS_B
TABLE - AHL.AHL_RELATIONSHIPS_TL
TABLE - AHL.AHL_REPAIR_CATEGORIES
TABLE - AHL.AHL_REQ_SUPPLY_SCHEDULE
TABLE - AHL.AHL_RESOURCES
TABLE - AHL.AHL_RESOURCE_MAPPINGS
TABLE - AHL.AHL_RESOURCE_SKILLS
TABLE - AHL.AHL_ROUTES_B
TABLE - AHL.AHL_ROUTES_H_B
TABLE - AHL.AHL_ROUTES_H_TL
TABLE - AHL.AHL_ROUTES_TL
TABLE - AHL.AHL_ROUTE_EFFECTIVITIES
TABLE - AHL.AHL_ROUTE_OPERATIONS
TABLE - AHL.AHL_ROUTE_OPERATIONS_H
TABLE - AHL.AHL_RT_OPER_ACCESS_PANELS
TABLE - AHL.AHL_RT_OPER_DEPENDENCIES
TABLE - AHL.AHL_RT_OPER_INTERFACE
TABLE - AHL.AHL_RT_OPER_LABOR
TABLE - AHL.AHL_RT_OPER_LABOR_H
TABLE - AHL.AHL_RT_OPER_MATERIALS
TABLE - AHL.AHL_RT_OPER_MATERIALS_H
TABLE - AHL.AHL_RT_OPER_RESOURCES
TABLE - AHL.AHL_SB_POSITION_RULES
TABLE - AHL.AHL_SB_RULE_ITEMS
TABLE - AHL.AHL_SCHEDULE_MATERIALS
TABLE - AHL.AHL_SIMULATION_PLANS_B
TABLE - AHL.AHL_SIMULATION_PLANS_TL
TABLE - AHL.AHL_SNAPSHOTS
TABLE - AHL.AHL_SPACES_B
TABLE - AHL.AHL_SPACES_TL
TABLE - AHL.AHL_SPACE_ASSIGNMENTS
TABLE - AHL.AHL_SPACE_CAPABILITIES
TABLE - AHL.AHL_SPACE_UNAVAILABLE_B
TABLE - AHL.AHL_SPACE_UNAVAILABLE_TL
TABLE - AHL.AHL_STAGE_LINKS
TABLE - AHL.AHL_STATUS_ORDER_RULES
TABLE - AHL.AHL_SUBSCRIPTIONS_B
TABLE - AHL.AHL_SUBSCRIPTIONS_TL
TABLE - AHL.AHL_SUPPLIER_DOCUMENTS
TABLE - AHL.AHL_TASK_LINKS
TABLE - AHL.AHL_TEMP_UNIT_EFFECTIVITIES1
TABLE - APPS.AHL_UC_DETAILS_FOR_HGRID
TABLE - AHL.AHL_UC_HEADERS_H
TABLE - AHL.AHL_UE_RELATIONSHIPS
TABLE - AHL.AHL_UE_SIMULATIONS
TABLE - AHL.AHL_UF_DETAILS
TABLE - AHL.AHL_UF_HEADERS
TABLE - AHL.AHL_UMP_MAINT_REQMNTS
TABLE - AHL.AHL_UMP_MATERIAL_REQMNTS
TABLE - AHL.AHL_UMP_RESOURCE_REQMNTS
TABLE - AHL.AHL_UNIT_ACCOMPLISHMNTS
TABLE - AHL.AHL_UNIT_CONFIG_HEADERS
TABLE - AHL.AHL_UNIT_DEFERRALS_B
TABLE - AHL.AHL_UNIT_DEFERRALS_TL
TABLE - AHL.AHL_UNIT_EFFECTIVITIES_B
TABLE - AHL.AHL_UNIT_EFFECTIVITIES_TL
TABLE - AHL.AHL_UNIT_SCHEDULES
TABLE - AHL.AHL_UNIT_THRESHOLDS
TABLE - AHL.AHL_USER_STATUSES_B
TABLE - AHL.AHL_USER_STATUSES_TL
TABLE - AHL.AHL_VENDOR_CERTIFICATIONS
TABLE - AHL.AHL_VENDOR_CUSTOMER_RELS
TABLE - AHL.AHL_VISITS_B
TABLE - AHL.AHL_VISITS_TL
TABLE - AHL.AHL_VISIT_INST_ROUTINGS
TABLE - AHL.AHL_VISIT_IR_UC_DETAILS
TABLE - AHL.AHL_VISIT_STAGE_TYP_ASOC
TABLE - AHL.AHL_VISIT_TASKS_B
TABLE - AHL.AHL_VISIT_TASKS_TL
TABLE - AHL.AHL_VISIT_TYPES_B
TABLE - AHL.AHL_VISIT_TYPES_TL
TABLE - AHL.AHL_VISIT_TYPE_STAGES_B
TABLE - AHL.AHL_VISIT_TYPE_STAGES_TL
TABLE - AHL.AHL_VST_TYP_STAGE_LINKS
TABLE - AHL.AHL_VST_TYP_STG_TYP_ASOC
TABLE - AHL.AHL_VWP_STAGES_B
TABLE - AHL.AHL_VWP_STAGES_TL
TABLE - AHL.AHL_WARRANTY_CLAIMS_B
TABLE - AHL.AHL_WARRANTY_CLAIMS_TL
TABLE - AHL.AHL_WARRANTY_CONTRACTS_B
TABLE - AHL.AHL_WARRANTY_CONTRACTS_TL
TABLE - AHL.AHL_WARRANTY_CONT_CTR_B
TABLE - AHL.AHL_WARRANTY_CONT_CTR_TL
TABLE - AHL.AHL_WARRANTY_ENTITLEMENTS
TABLE - AHL.AHL_WARRANTY_TEMPLATES_B
TABLE - AHL.AHL_WARRANTY_TEMPLATES_TL
TABLE - AHL.AHL_WARRANTY_TMPL_CTR_B
TABLE - AHL.AHL_WARRANTY_TMPL_CTR_TL
TABLE - AHL.AHL_WARRANTY_TMPL_ITEMS
TABLE - AHL.AHL_WBS_RULES
TABLE - AHL.AHL_WF_MAPPING
TABLE - AHL.AHL_WORKORDERS
TABLE - AHL.AHL_WORKORDER_MTL_TXNS
TABLE - AHL.AHL_WORKORDER_OPERATIONS
TABLE - AHL.AHL_WORKORDER_TXNS
TABLE - AHL.AHL_WORK_ASSIGNMENTS
TABLE - AHL.AHL_WORK_LOGIN_TIMES
TABLE - AHL.AHL_WO_OPERATIONS_RELN
TABLE - AHL.AHL_WO_OPERATIONS_TXNS
VIEW - APPS.AHL_ALL_WORKORDERS_V
VIEW - APPS.AHL_ALTERNATE_RESOURCES_V
VIEW - APPS.AHL_APPROVAL_RULES_V
VIEW - APPS.AHL_APPROVAL_RULES_VL
VIEW - APPS.AHL_APPROVERS_TYPE_V
VIEW - APPS.AHL_APPROVERS_V
VIEW - APPS.AHL_CSI_INSTANCE_RELNS_V
VIEW - APPS.AHL_DEPARTMENT_SHIFTS_V
VIEW - APPS.AHL_DOCUMENTS_V
VIEW - APPS.AHL_DOCUMENTS_VL
VIEW - APPS.AHL_DOCUMENT_ASSOS_V
VIEW - APPS.AHL_DOC_FILE_ASSOC_V
VIEW - APPS.AHL_DOC_FILE_ASSOC_VL
VIEW - APPS.AHL_DOC_REVISIONS_V
VIEW - APPS.AHL_DOC_REVISIONS_VL
VIEW - APPS.AHL_DOC_TITLE_ASSOS_VL
VIEW - APPS.AHL_DOC_TYPE_ASSOS_V
VIEW - APPS.AHL_DUMMY_V
VIEW - APPS.AHL_FLEET_HEADERS_VL
VIEW - APPS.AHL_HZ_PER_EMPLOYEES_V
VIEW - APPS.AHL_HZ_PO_SUPPLIERS_V
VIEW - APPS.AHL_ITEM_ASSOCIATIONS_V
VIEW - APPS.AHL_ITEM_ASSOCIATIONS_VL
VIEW - APPS.AHL_ITEM_CLASS_UOM_V
VIEW - APPS.AHL_ITEM_COMP_DETAIL_V
VIEW - APPS.AHL_ITEM_COMP_V
VIEW - APPS.AHL_ITEM_GROUPS_V
VIEW - APPS.AHL_ITEM_GROUPS_VL
VIEW - APPS.AHL_JOB_OPER_MATERIALS_V
VIEW - APPS.AHL_JTF_RS_EMP_V
VIEW - APPS.AHL_MASTER_CONFIG_DETAILS_V
VIEW - APPS.AHL_MC_HEADERS_V
VIEW - APPS.AHL_MC_HEADERS_VL
VIEW - APPS.AHL_MC_RELATIONSHIPS_V
VIEW - APPS.AHL_MC_RULES_VL
VIEW - APPS.AHL_MM_WRK_ORDER_RESERVTN_V
VIEW - APPS.AHL_MR_ACTIONS_V
VIEW - APPS.AHL_MR_ACTIONS_VL
VIEW - APPS.AHL_MR_DETAILS_V
VIEW - APPS.AHL_MR_EFFECTIVITIES_APP_V
VIEW - APPS.AHL_MR_EFFECTIVITIES_V
VIEW - APPS.AHL_MR_EFFECTIVITY_DTLS_APP_V
VIEW - APPS.AHL_MR_EFFECTIVITY_DTLS_V
VIEW - APPS.AHL_MR_HEADERS_APP_V
VIEW - APPS.AHL_MR_HEADERS_V
VIEW - APPS.AHL_MR_HEADERS_VL
VIEW - APPS.AHL_MR_INSTANCES_V
VIEW - APPS.AHL_MR_INST_RELATIONSHIPS_V
VIEW - APPS.AHL_MR_INTERVALS_APP_V
VIEW - APPS.AHL_MR_INTERVALS_V
VIEW - APPS.AHL_MR_ITEMS_V
VIEW - APPS.AHL_MR_ITEM_DETAILS_V
VIEW - APPS.AHL_MR_PC_NODES_V
VIEW - APPS.AHL_MR_RELATIONSHIPS_APP_V
VIEW - APPS.AHL_MR_RELATIONSHIPS_V
VIEW - APPS.AHL_MR_ROUTES_APP_V
VIEW - APPS.AHL_MR_ROUTES_V
VIEW - APPS.AHL_MR_ROUTE_SEQUENCES_APP_V
VIEW - APPS.AHL_MTL_ITEMS_NON_OU_V
VIEW - APPS.AHL_MTL_ITEMS_OU_V
VIEW - APPS.AHL_NR_PROFILE_DETAILS_V
VIEW - APPS.AHL_OPERATIONS_B_KFV
VIEW - APPS.AHL_OPERATIONS_H_VL
VIEW - APPS.AHL_OPERATIONS_V
VIEW - APPS.AHL_OPERATIONS_VL
VIEW - APPS.AHL_OPERATION_PHASES_V
VIEW - APPS.AHL_OSP_ORDERS_V
VIEW - APPS.AHL_OSP_ORDERS_VL
VIEW - APPS.AHL_OSP_ORDER_LINES_V
VIEW - APPS.AHL_OWNER_DETAILS_V
VIEW - APPS.AHL_OWNER_LOCATIONS_V
VIEW - APPS.AHL_PC_ASSOCIATIONS_V
VIEW - APPS.AHL_PC_HEADERS_V
VIEW - APPS.AHL_PC_HEADERS_VL
VIEW - APPS.AHL_PC_HEADER_DETAILS_V
VIEW - APPS.AHL_PC_NODES_VL
VIEW - APPS.AHL_PC_TREE_V
VIEW - APPS.AHL_PLANNING_FACTORS_V
VIEW - APPS.AHL_PLAN_VISITS_V
VIEW - APPS.AHL_POSITION_ALTERNATES_V
VIEW - APPS.AHL_PP_ASSIGNMENT_V
VIEW - APPS.AHL_PP_EMPLOYEE_ASSIGN_V
VIEW - APPS.AHL_PP_REQUIREMENT_V
VIEW - APPS.AHL_PP_RESRC_REQ_ASG_V
VIEW - APPS.AHL_PRODTYPE_ZONES_V
VIEW - APPS.AHL_PROG_TYPE_SUBTYPES_V
VIEW - APPS.AHL_REFERENCE_DOC_V
VIEW - APPS.AHL_RELATIONSHIPS_VL
VIEW - APPS.AHL_RESOURCES_V
VIEW - APPS.AHL_RESOURCE_MAPPINGS_V
VIEW - APPS.AHL_RESOURCE_SKILLS_V
VIEW - APPS.AHL_ROUTES_APP_V
VIEW - APPS.AHL_ROUTES_B_KFV
VIEW - APPS.AHL_ROUTES_H_VL
VIEW - APPS.AHL_ROUTES_V
VIEW - APPS.AHL_ROUTES_VL
VIEW - APPS.AHL_ROUTE_EFFECTIVITIES_V
VIEW - APPS.AHL_ROUTE_MR_V
VIEW - APPS.AHL_ROUTE_OPERATIONS_V
VIEW - APPS.AHL_RT_OPER_DEPENDENCIES_V
VIEW - APPS.AHL_RT_OPER_LABOR_V
VIEW - APPS.AHL_RT_OPER_MATERIALS_V
VIEW - APPS.AHL_RT_OPER_RESOURCES_V
VIEW - APPS.AHL_SCHEDULE_MATERIALS_V
VIEW - APPS.AHL_SEARCH_TEMPLATES_V
VIEW - APPS.AHL_SEARCH_TEMPLATE_TASK_V
VIEW - APPS.AHL_SEARCH_VISITS_V
VIEW - APPS.AHL_SEARCH_VISIT_TASK_V
VIEW - APPS.AHL_SERIAL_NUMBER_CHANGE_V
VIEW - APPS.AHL_SIMULATION_FORECAST_V
VIEW - APPS.AHL_SIMULATION_PLANS_VL
VIEW - APPS.AHL_SPACES_VL
VIEW - APPS.AHL_SPACE_CAPBLTS_V
VIEW - APPS.AHL_SPACE_ORG_DETAILS_V
VIEW - APPS.AHL_SPACE_UNAVABL_V
VIEW - APPS.AHL_SPACE_UNAVAILABLE_VL
VIEW - APPS.AHL_SR_UE_ASSOCIATIONS_V
VIEW - APPS.AHL_SUBSCRIPTIONS_VL
VIEW - APPS.AHL_UC_HEADER_PATHS_V
VIEW - APPS.AHL_UE_DEFERRAL_DETAILS_V
VIEW - APPS.AHL_UE_ORGS_DEPTS_V
VIEW - APPS.AHL_UNIT_ALTERNATES_V
VIEW - APPS.AHL_UNIT_CONFIG_HEADERS_V
VIEW - APPS.AHL_UNIT_DEFERRALS_VL
VIEW - APPS.AHL_UNIT_DETAILS_V
VIEW - APPS.AHL_UNIT_EFFECTIVITIES_APP_V
VIEW - APPS.AHL_UNIT_EFFECTIVITIES_V
VIEW - APPS.AHL_UNIT_EFFECTIVITIES_VL
VIEW - APPS.AHL_UNIT_HEADER_DETAILS_V
VIEW - APPS.AHL_UNIT_INSTALLED_DETAILS_V
VIEW - APPS.AHL_USER_STATUSES_V
VIEW - APPS.AHL_USER_STATUSES_VL
VIEW - APPS.AHL_UTILIZATION_FORECAST_V
VIEW - APPS.AHL_VISITS_INFO_V
VIEW - APPS.AHL_VISITS_VL
VIEW - APPS.AHL_VISIT_DETAILS_V
VIEW - APPS.AHL_VISIT_MR_V
VIEW - APPS.AHL_VISIT_TASKS_V
VIEW - APPS.AHL_VISIT_TASKS_VL
VIEW - APPS.AHL_VISIT_TASK_MATRL_V
VIEW - APPS.AHL_VISIT_TYPES_VL
VIEW - APPS.AHL_VISIT_TYPE_STAGES_VL
VIEW - APPS.AHL_VWP_ROLLUP_COSTS_V
VIEW - APPS.AHL_WARRANTY_CLAIMS_VL
VIEW - APPS.AHL_WARRANTY_CONTRACTS_VL
VIEW - APPS.AHL_WARRANTY_CONT_CTR_VL
VIEW - APPS.AHL_WARRANTY_TEMPLATES_VL
VIEW - APPS.AHL_WARRANTY_TMPL_CTR_VL
VIEW - APPS.AHL_WF_MAPPING_V
VIEW - APPS.AHL_WIP_RESOURCE_TXNS_V
VIEW - APPS.AHL_WORKORDERS_OSP_V
VIEW - APPS.AHL_WORKORDERS_V
VIEW - APPS.AHL_WORKORDER_OPERATIONS_V
Table: AHL_ALTERNATE_RESOURCES
Description: This table stores the alternate ASO resources for the resource requirements.
Primary Key: AHL_ALTERNATE_RESOURCES_PK
ALTERNATE_RESOURCE_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_ALTERNATE_RESOURCES.RT_OPER_RESOURCE_ID
AHL_RT_OPER_RESOURCES
AHL_ALTERNATE_RESOURCES.ASO_RESOURCE_ID
AHL_RESOURCES
[top of page]
AHL.AHL_ALTERNATE_RESOURCES does not reference any database object
AHL.AHL_ALTERNATE_RESOURCES is referenced by following:
AHL
VIEW - AHL_ALTERNATE_RESOURCES#
[top of page]
Table: AHL_APPLICABLE_INSTANCES
[top of page]
AHL.AHL_APPLICABLE_INSTANCES does not reference any database object
AHL.AHL_APPLICABLE_INSTANCES is referenced by following:
APPS
SYNONYM - AHL_APPLICABLE_INSTANCES
[top of page]
Table: AHL_APPLICABLE_MRS
[top of page]
AHL.AHL_APPLICABLE_MRS does not reference any database object
AHL.AHL_APPLICABLE_MRS is not referenced by any database object
[top of page]
Table: AHL_APPLICABLE_MRS1
[top of page]
AHL.AHL_APPLICABLE_MRS1 does not reference any database object
AHL.AHL_APPLICABLE_MRS1 is referenced by following:
APPS
SYNONYM - AHL_APPLICABLE_MRS
SYNONYM - AHL_APPLICABLE_MRS1
[top of page]
Table: AHL_APPROVAL_API
Description: This table stores information about apis for approval rules
Primary Key: AHL_APPROVAL_APU_PK
APPROVAL_API_ID
[top of page]
AHL.AHL_APPROVAL_API does not reference any database object
AHL.AHL_APPROVAL_API is referenced by following:
AHL
VIEW - AHL_APPROVAL_API#
[top of page]
Table: AHL_APPROVAL_RULES_B
Description: This table stores information about approval rules
Primary Key: AHL_APPROVAL_RULES_B_PK
APPROVAL_RULE_ID
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AHL_APPROVAL_RULES_TL.APPROVAL_RULE_ID
AHL_APPROVAL_RULES_B
AHL_APPROVERS.APPROVAL_RULE_ID
AHL_APPROVAL_RULES_B
[top of page]
AHL.AHL_APPROVAL_RULES_B does not reference any database object
AHL.AHL_APPROVAL_RULES_B is referenced by following:
AHL
VIEW - AHL_APPROVAL_RULES_B#
[top of page]
Table: AHL_APPROVAL_RULES_TL
Description: This table stores information about translated columns for approval rules
Primary Key: AHL_APPROVAL_RULES_TL_PK
APPROVAL_RULE_ID
LANGUAGE
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_APPROVAL_RULES_TL.APPROVAL_RULE_ID
AHL_APPROVAL_RULES_B
[top of page]
AHL.AHL_APPROVAL_RULES_TL does not reference any database object
AHL.AHL_APPROVAL_RULES_TL is referenced by following:
AHL
VIEW - AHL_APPROVAL_RULES_TL#
[top of page]
Table: AHL_APPROVERS
Description: This table stores information about approvers
Primary Key: AHL_APPROVERS_PK
APPROVAL_APPROVER_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_APPROVERS.APPROVAL_RULE_ID
AHL_APPROVAL_RULES_B
[top of page]
AHL.AHL_APPROVERS does not reference any database object
AHL.AHL_APPROVERS is referenced by following:
AHL
VIEW - AHL_APPROVERS#
[top of page]
Table: AHL_AUTOVISIT_HIERARCHY
[top of page]
AHL.AHL_AUTOVISIT_HIERARCHY does not reference any database object
AHL.AHL_AUTOVISIT_HIERARCHY is referenced by following:
AHL
VIEW - AHL_AUTOVISIT_HIERARCHY#
[top of page]
Table: AHL_AUTOVST_SNPSHT_HDR
[top of page]
AHL.AHL_AUTOVST_SNPSHT_HDR does not reference any database object
AHL.AHL_AUTOVST_SNPSHT_HDR is referenced by following:
AHL
VIEW - AHL_AUTOVST_SNPSHT_HDR#
[top of page]
Table: AHL_BUE_WORKER_DATA
Description: Table contains data that needs to be processed by BUE worker programs. Data is populated into this table by BUE concurrent program. This table is for internal use only.
[top of page]
AHL.AHL_BUE_WORKER_DATA does not reference any database object
AHL.AHL_BUE_WORKER_DATA is referenced by following:
AHL
VIEW - AHL_BUE_WORKER_DATA#
[top of page]
Table: AHL_BUILD_GOALS
[top of page]
AHL.AHL_BUILD_GOALS does not reference any database object
AHL.AHL_BUILD_GOALS is referenced by following:
AHL
VIEW - AHL_BUILD_GOALS#
[top of page]
Table: AHL_CONFIG_COMPONENTS
[top of page]
AHL.AHL_CONFIG_COMPONENTS does not reference any database object
AHL.AHL_CONFIG_COMPONENTS is not referenced by any database object
[top of page]
Table: AHL_CONFIG_COMPONENTS1
[top of page]
AHL.AHL_CONFIG_COMPONENTS1 does not reference any database object
AHL.AHL_CONFIG_COMPONENTS1 is referenced by following:
APPS
SYNONYM - AHL_CONFIG_COMPONENTS
SYNONYM - AHL_CONFIG_COMPONENTS1
[top of page]
Table: AHL_CTR_UPDATE_RULES
Description: This table will store rules to update counters for a position with respect to its parent position.
Primary Key: AHL_CTR_UPDATE_RULES_PK
CTR_UPDATE_RULE_ID
Primary Key: AHL_CTR_UPDATE_RULES_UK1
RELATIONSHIP_ID
UOM_CODE
RULE_CODE
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_CTR_UPDATE_RULES.RELATIONSHIP_ID
AHL_MC_RELATIONSHIPS
[top of page]
AHL.AHL_CTR_UPDATE_RULES does not reference any database object
AHL.AHL_CTR_UPDATE_RULES is referenced by following:
AHL
VIEW - AHL_CTR_UPDATE_RULES#
[top of page]
Table: AHL_DEPARTMENT_SHIFTS
Description: This table stores information about department shifts
Primary Key: AHL_DEPARTMENT_SHIFTS_PK
AHL_DEPARTMENT_SHIFTS_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_DEPARTMENT_SHIFTS.DEPARTMENT_ID
BOM_DEPARTMENTS
[top of page]
AHL.AHL_DEPARTMENT_SHIFTS does not reference any database object
AHL.AHL_DEPARTMENT_SHIFTS is referenced by following:
AHL
VIEW - AHL_DEPARTMENT_SHIFTS#
[top of page]
Table: AHL_DEPT_RESOURCE_CAPACITY
[top of page]
AHL.AHL_DEPT_RESOURCE_CAPACITY does not reference any database object
AHL.AHL_DEPT_RESOURCE_CAPACITY is referenced by following:
AHL
VIEW - AHL_DEPT_RESOURCE_CAPACITY#
[top of page]
Table: AHL_DOCUMENTS_B
Description: This table stores information about documents.
Primary Key: AHL_DOCUMENTS_B_PK
DOCUMENT_ID
Primary Key: AHL_DOCUMENTS_B_UK1
DOCUMENT_NO
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_DOCUMENTS_B.SOURCE_PARTY_ID
HZ_PARTIES
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AHL_DOCUMENTS_TL.DOCUMENT_ID
AHL_DOCUMENTS_B
AHL_DOC_REVISIONS_B.DOCUMENT_ID
AHL_DOCUMENTS_B
AHL_DOC_TITLE_ASSOS_B.DOCUMENT_ID
AHL_DOCUMENTS_B
AHL_RECIPIENT_DOCUMENTS.DOCUMENT_ID
AHL_DOCUMENTS_B
AHL_SUBSCRIPTIONS_B.DOCUMENT_ID
AHL_DOCUMENTS_B
AHL_SUPPLIER_DOCUMENTS.DOCUMENT_ID
AHL_DOCUMENTS_B
[top of page]
AHL.AHL_DOCUMENTS_B does not reference any database object
AHL.AHL_DOCUMENTS_B is referenced by following:
AHL
VIEW - AHL_DOCUMENTS_B#
[top of page]
Table: AHL_DOCUMENTS_TL
Description: This table stores the translated column information for document.
Primary Key: AHL_DOCUMENTS_TL_PK
DOCUMENT_ID
LANGUAGE
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_DOCUMENTS_TL.DOCUMENT_ID
AHL_DOCUMENTS_B
[top of page]
AHL.AHL_DOCUMENTS_TL does not reference any database object
AHL.AHL_DOCUMENTS_TL is referenced by following:
AHL
VIEW - AHL_DOCUMENTS_TL#
[top of page]
Table: AHL_DOCUMENT_SUB_TYPES
Description: This table stores association information between document types and document sub types.
Primary Key: AHL_DOCUMENT_SUB_TYPES_PK
DOCUMENT_SUB_TYPE_ID
Primary Key: AHL_DOCUMENT_SUB_TYPES_UK1
DOC_TYPE_CODE
DOC_SUB_TYPE_CODE
[top of page]
AHL.AHL_DOCUMENT_SUB_TYPES does not reference any database object
AHL.AHL_DOCUMENT_SUB_TYPES is referenced by following:
AHL
VIEW - AHL_DOCUMENT_SUB_TYPES#
[top of page]
Table: AHL_DOC_FILE_ASSOC_B
Description: This table stores files association with document. As a part of 11.5.10 Enhancements
Primary Key: AHL_DOC_FILE_ASSOC_B_PK1
ASSOCIATION_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_DOC_FILE_ASSOC_B.REVISION_ID
AHL_DOC_REVISIONS_B
AHL_DOC_FILE_ASSOC_B.FILE_ID
FND_LOBS
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AHL_DOC_FILE_ASSOC_TL.ASSOCIATION_ID
AHL_DOC_FILE_ASSOC_B
[top of page]
AHL.AHL_DOC_FILE_ASSOC_B does not reference any database object
AHL.AHL_DOC_FILE_ASSOC_B is referenced by following:
AHL
VIEW - AHL_DOC_FILE_ASSOC_B#
[top of page]
Table: AHL_DOC_FILE_ASSOC_TL
Description: This table stores the translated values for AHL_DOC_FILE_ASSOC_B
Primary Key: AHL_DOC_FILE_ASSOC_TL_PK
ASSOCIATION_ID
LANGUAGE
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_DOC_FILE_ASSOC_TL.ASSOCIATION_ID
AHL_DOC_FILE_ASSOC_B
[top of page]
AHL.AHL_DOC_FILE_ASSOC_TL does not reference any database object
AHL.AHL_DOC_FILE_ASSOC_TL is referenced by following:
AHL
VIEW - AHL_DOC_FILE_ASSOC_TL#
[top of page]
Table: AHL_DOC_REVISIONS_B
Description: This table stores revision information of a document.
Primary Key: AHL_DOC_REVISIONS_B_PK
DOC_REVISION_ID
Primary Key: AHL_DOC_REVISIONS_B_UK1
DOCUMENT_ID
REVISION_NO
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_DOC_REVISIONS_B.DOCUMENT_ID
AHL_DOCUMENTS_B
AHL_DOC_REVISIONS_B.APPROVED_BY_PARTY_ID
HZ_PARTIES
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AHL_DOC_FILE_ASSOC_B.REVISION_ID
AHL_DOC_REVISIONS_B
AHL_DOC_REVISIONS_TL.DOC_REVISION_ID
AHL_DOC_REVISIONS_B
AHL_DOC_REVISION_COPIES.DOC_REVISION_ID
AHL_DOC_REVISIONS_B
AHL_DOC_TITLE_ASSOS_B.DOC_REVISION_ID
AHL_DOC_REVISIONS_B
[top of page]
AHL.AHL_DOC_REVISIONS_B does not reference any database object
AHL.AHL_DOC_REVISIONS_B is referenced by following:
AHL
VIEW - AHL_DOC_REVISIONS_B#
[top of page]
Table: AHL_DOC_REVISIONS_TL
Description: This table stores the translated column information of a document revision.
Primary Key: AHL_DOC_REVISIONS_TL_PK
DOC_REVISION_ID
LANGUAGE
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_DOC_REVISIONS_TL.DOC_REVISION_ID
AHL_DOC_REVISIONS_B
[top of page]
AHL.AHL_DOC_REVISIONS_TL does not reference any database object
AHL.AHL_DOC_REVISIONS_TL is referenced by following:
AHL
VIEW - AHL_DOC_REVISIONS_TL#
[top of page]
Table: AHL_DOC_REVISION_COPIES
Description: Table is Obsolete.This table stores persons who received copies of document revision.
Primary Key: AHL_DOC_REVISION_COPIES_PK
DOC_REVISION_COPY_ID
Primary Key: AHL_DOC_REVISION_COPIES_UK1
DOC_REVISION_ID
RECEIVED_BY_PARTY_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_DOC_REVISION_COPIES.DOC_REVISION_ID
AHL_DOC_REVISIONS_B
AHL_DOC_REVISION_COPIES.RECEIVED_BY_PARTY_ID
HZ_PARTIES
[top of page]
AHL.AHL_DOC_REVISION_COPIES does not reference any database object
AHL.AHL_DOC_REVISION_COPIES is referenced by following:
AHL
VIEW - AHL_DOC_REVISION_COPIES#
[top of page]
Table: AHL_DOC_TITLE_ASSOS_B
Description: This table stores association between document or document revision and ASO object (ASO object could be a route, master configuration, unit configuration, etc.).
Primary Key: AHL_DOC_TITLE_ASSOS_B_PK
DOC_TITLE_ASSO_ID
Primary Key: AHL_DOC_TITLE_ASSOS_B_UK1
ASO_OBJECT_ID
ASO_OBJECT_TYPE_CODE
DOCUMENT_ID
DOC_REVISION_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_DOC_TITLE_ASSOS_B.DOC_REVISION_ID
AHL_DOC_REVISIONS_B
AHL_DOC_TITLE_ASSOS_B.ASO_OBJECT_ID
AHL_ROUTES_B
AHL_DOC_TITLE_ASSOS_B.ASO_OBJECT_ID
AHL_OPERATIONS_B
AHL_DOC_TITLE_ASSOS_B.ASO_OBJECT_ID
AHL_MC_RELATIONSHIPS
AHL_DOC_TITLE_ASSOS_B.DOCUMENT_ID
AHL_DOCUMENTS_B
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AHL_DOC_TITLE_ASSOS_TL.DOC_TITLE_ASSO_ID
AHL_DOC_TITLE_ASSOS_B
[top of page]
AHL.AHL_DOC_TITLE_ASSOS_B does not reference any database object
AHL.AHL_DOC_TITLE_ASSOS_B is referenced by following:
AHL
VIEW - AHL_DOC_TITLE_ASSOS_B#
[top of page]
Table: AHL_DOC_TITLE_ASSOS_TL
Description: This table stores the translated columns information for the association between document or document revision and ASO object.
Primary Key: AHL_DOC_TITLE_ASSOS_TL_PK
DOC_TITLE_ASSO_ID
LANGUAGE
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_DOC_TITLE_ASSOS_TL.DOC_TITLE_ASSO_ID
AHL_DOC_TITLE_ASSOS_B
[top of page]
AHL.AHL_DOC_TITLE_ASSOS_TL does not reference any database object
AHL.AHL_DOC_TITLE_ASSOS_TL is referenced by following:
AHL
VIEW - AHL_DOC_TITLE_ASSOS_TL#
[top of page]
Table: AHL_ENIGMA_JCG_DETAILS
[top of page]
AHL.AHL_ENIGMA_JCG_DETAILS does not reference any database object
AHL.AHL_ENIGMA_JCG_DETAILS is referenced by following:
AHL
VIEW - AHL_ENIGMA_JCG_DETAILS#
[top of page]
Table: AHL_ENIGMA_OP_INTERFACE
[top of page]
AHL.AHL_ENIGMA_OP_INTERFACE does not reference any database object
AHL.AHL_ENIGMA_OP_INTERFACE is referenced by following:
AHL
VIEW - AHL_ENIGMA_OP_INTERFACE#
[top of page]
Table: AHL_ENIGMA_PROCESS_LOG
Primary Key: AHL_ENIGMA_PROCESS_LOG_PK
LOG_ID
[top of page]
AHL.AHL_ENIGMA_PROCESS_LOG does not reference any database object
AHL.AHL_ENIGMA_PROCESS_LOG is referenced by following:
AHL
VIEW - AHL_ENIGMA_PROCESS_LOG#
[top of page]
Table: AHL_ENIGMA_RT_INTERFACE
[top of page]
AHL.AHL_ENIGMA_RT_INTERFACE does not reference any database object
AHL.AHL_ENIGMA_RT_INTERFACE is referenced by following:
AHL
VIEW - AHL_ENIGMA_RT_INTERFACE#
[top of page]
Table: AHL_EVENT_ASSOCIATIONS
Description: This table is an intersection table to store the association between events and positions.
Primary Key: AHL_EVENT_ASSOCIATIONS_PK
EVENT_ASSOCIATION_ID
Primary Key: AHL_EVENT_ASSOCIATIONS_UK1
RELATIONSHIP_ID
EVENT_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_EVENT_ASSOCIATIONS.RELATIONSHIP_ID
AHL_RELATIONSHIPS_B
AHL_EVENT_ASSOCIATIONS.EVENT_ID
OKC_ACTIONS_B
[top of page]
AHL.AHL_EVENT_ASSOCIATIONS does not reference any database object
AHL.AHL_EVENT_ASSOCIATIONS is referenced by following:
AHL
VIEW - AHL_EVENT_ASSOCIATIONS#
[top of page]
Table: AHL_FLEET_DOWNTIMES
[top of page]
AHL.AHL_FLEET_DOWNTIMES does not reference any database object
AHL.AHL_FLEET_DOWNTIMES is referenced by following:
AHL
VIEW - AHL_FLEET_DOWNTIMES#
[top of page]
Table: AHL_FLEET_HEADERS_B
[top of page]
AHL.AHL_FLEET_HEADERS_B does not reference any database object
AHL.AHL_FLEET_HEADERS_B is referenced by following:
AHL
VIEW - AHL_FLEET_HEADERS_B#
[top of page]
Table: AHL_FLEET_HEADERS_TL
[top of page]
AHL.AHL_FLEET_HEADERS_TL does not reference any database object
AHL.AHL_FLEET_HEADERS_TL is referenced by following:
AHL
VIEW - AHL_FLEET_HEADERS_TL#
[top of page]
Table: AHL_FLEET_RECONFIG_MRS
[top of page]
AHL.AHL_FLEET_RECONFIG_MRS does not reference any database object
AHL.AHL_FLEET_RECONFIG_MRS is referenced by following:
AHL
VIEW - AHL_FLEET_RECONFIG_MRS#
[top of page]
Table: AHL_FLEET_UNIT_ASSOCS
[top of page]
AHL.AHL_FLEET_UNIT_ASSOCS does not reference any database object
AHL.AHL_FLEET_UNIT_ASSOCS is referenced by following:
AHL
VIEW - AHL_FLEET_UNIT_ASSOCS#
[top of page]
Table: AHL_FLEET_UTILIZATION
[top of page]
AHL.AHL_FLEET_UTILIZATION does not reference any database object
AHL.AHL_FLEET_UTILIZATION is referenced by following:
AHL
VIEW - AHL_FLEET_UTILIZATION#
[top of page]
Table: AHL_FLEET_UTLZN_FORECAST
[top of page]
AHL.AHL_FLEET_UTLZN_FORECAST does not reference any database object
AHL.AHL_FLEET_UTLZN_FORECAST is referenced by following:
AHL
VIEW - AHL_FLEET_UTLZN_FORECAST#
[top of page]
Table: AHL_INV_SERVICE_ITEM_RELS
Description: This table stores the relationships between physical inventory items and service items.
Primary Key: INV_SERVICE_ITEM_REL_PK
INV_SERVICE_ITEM_REL_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_INV_SERVICE_ITEM_RELS.INV_ITEM_ID
INV_ORG_ID
MTL_SYSTEM_ITEMS_B
AHL_INV_SERVICE_ITEM_RELS.SERVICE_ITEM_ID
INV_ORG_ID
MTL_SYSTEM_ITEMS_B
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AHL_ITEM_VENDOR_RELS.INV_SERVICE_ITEM_REL_ID
AHL_INV_SERVICE_ITEM_RELS
[top of page]
AHL.AHL_INV_SERVICE_ITEM_RELS does not reference any database object
AHL.AHL_INV_SERVICE_ITEM_RELS is referenced by following:
AHL
VIEW - AHL_INV_SERVICE_ITEM_RELS#
[top of page]
Table: AHL_ITEM_ASSOCIATIONS_B
Description: This table is an intersection table to store the association between item group and the inventory item.
Primary Key: AHL_ITEM_ASSOCIATIONS_B_PK
ITEM_ASSOCIATION_ID
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AHL_ITEM_ASSOCIATIONS_B_H.ITEM_ASSOCIATION_ID
AHL_ITEM_ASSOCIATIONS_B
AHL_ITEM_ASSOCIATIONS_TL.ITEM_ASSOCIATION_ID
AHL_ITEM_ASSOCIATIONS_B
[top of page]
AHL.AHL_ITEM_ASSOCIATIONS_B does not reference any database object
AHL.AHL_ITEM_ASSOCIATIONS_B is referenced by following:
AHL
VIEW - AHL_ITEM_ASSOCIATIONS_B#
[top of page]
Table: AHL_ITEM_ASSOCIATIONS_B_H
Description: This table is Histrory of the Item Group Assoications
Primary Key: AHL_ITEM_ASSOCIATIONS_B_H_PK
ITEM_ASSOCIATION_H_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_ITEM_ASSOCIATIONS_B_H.ITEM_ASSOCIATION_ID
AHL_ITEM_ASSOCIATIONS_B
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AHL_ITEM_ASSOCIATIONS_TL_H.ITEM_ASSOCIATION_H_ID
AHL_ITEM_ASSOCIATIONS_B_H
[top of page]
AHL.AHL_ITEM_ASSOCIATIONS_B_H does not reference any database object
AHL.AHL_ITEM_ASSOCIATIONS_B_H is referenced by following:
AHL
VIEW - AHL_ITEM_ASSOCIATIONS_B_H#
[top of page]
Table: AHL_ITEM_ASSOCIATIONS_TL
Description: This table is an intersection table to store the association between item group and the inventory item.
Primary Key: AHL_ITEM_ASSOCIATIONS_TL_PK
ITEM_ASSOCIATION_ID
LANGUAGE
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_ITEM_ASSOCIATIONS_TL.ITEM_ASSOCIATION_ID
AHL_ITEM_ASSOCIATIONS_B
[top of page]
AHL.AHL_ITEM_ASSOCIATIONS_TL does not reference any database object
AHL.AHL_ITEM_ASSOCIATIONS_TL is referenced by following:
AHL
VIEW - AHL_ITEM_ASSOCIATIONS_TL#
[top of page]
Table: AHL_ITEM_ASSOCIATIONS_TL_H
Description: History table for the Association Table
Primary Key: AHL_ITEM_ASSOCIATIONS_TL_H_PK
ITEM_ASSOCIATION_H_ID
LANGUAGE
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_ITEM_ASSOCIATIONS_TL_H.ITEM_ASSOCIATION_H_ID
AHL_ITEM_ASSOCIATIONS_B_H
[top of page]
AHL.AHL_ITEM_ASSOCIATIONS_TL_H does not reference any database object
AHL.AHL_ITEM_ASSOCIATIONS_TL_H is referenced by following:
AHL
VIEW - AHL_ITEM_ASSOCIATIONS_TL_H#
[top of page]
Table: AHL_ITEM_COMPOSITIONS
Description: This table stores information about item compositions header .
Primary Key: AHL_ITEM_COMPOSITIONS_PK
ITEM_COMPOSITION_ID
Primary Key: AHL_ITEM_COMPOSITIONS_UK1
INVENTORY_ITEM_ID
INVENTORY_MASTER_ORG_ID
APPROVAL_STATUS_CODE
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AHL_ITEM_COMP_DETAILS.ITEM_COMPOSITION_ID
AHL_ITEM_COMPOSITIONS
[top of page]
AHL.AHL_ITEM_COMPOSITIONS does not reference any database object
AHL.AHL_ITEM_COMPOSITIONS is referenced by following:
AHL
VIEW - AHL_ITEM_COMPOSITIONS#
[top of page]
Table: AHL_ITEM_COMP_DETAILS
Description: This table stores the details of Non-Tracked Items/ Item Groups associated with a Item Composition in the header table.
Primary Key: AHL_ITEM_COMP_DETAILS_PK
ITEM_COMP_DETAIL_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_ITEM_COMP_DETAILS.ITEM_COMPOSITION_ID
AHL_ITEM_COMPOSITIONS
AHL_ITEM_COMP_DETAILS.ITEM_GROUP_ID
AHL_ITEM_GROUPS_B
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AHL_RT_OPER_MATERIALS.ITEM_COMP_DETAIL_ID
AHL_ITEM_COMP_DETAILS
[top of page]
AHL.AHL_ITEM_COMP_DETAILS does not reference any database object
AHL.AHL_ITEM_COMP_DETAILS is referenced by following:
AHL
VIEW - AHL_ITEM_COMP_DETAILS#
[top of page]
Table: AHL_ITEM_GROUPS_B
Description: This table stores information about item groups. Items are grouped so that each group could be used in positions multiple times.
Primary Key: AHL_ITEM_GROUPS_B_PK
ITEM_GROUP_ID
Primary Key: AHL_ITEM_GROUPS_B_UK1
NAME
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AHL_ITEM_COMP_DETAILS.ITEM_GROUP_ID
AHL_ITEM_GROUPS_B
AHL_ITEM_GROUPS_B_H.ITEM_GROUP_ID
AHL_ITEM_GROUPS_B
AHL_ITEM_GROUPS_TL.ITEM_GROUP_ID
AHL_ITEM_GROUPS_B
AHL_MC_RELATIONSHIPS.ITEM_GROUP_ID
AHL_ITEM_GROUPS_B
AHL_PRD_DISPOSITIONS_B.ITEM_GROUP_ID
AHL_ITEM_GROUPS_B
AHL_PRD_DISPOSITIONS_B_H.ITEM_GROUP_ID
AHL_ITEM_GROUPS_B
AHL_RELATIONSHIPS_B.ITEM_GROUP_ID
AHL_ITEM_GROUPS_B
AHL_RT_OPER_MATERIALS.ITEM_GROUP_ID
AHL_ITEM_GROUPS_B
[top of page]
AHL.AHL_ITEM_GROUPS_B does not reference any database object
AHL.AHL_ITEM_GROUPS_B is referenced by following:
AHL
VIEW - AHL_ITEM_GROUPS_B#
[top of page]
Table: AHL_ITEM_GROUPS_B_H
Description: This table stores History about item groups.
Primary Key: AHL_ITEM_GROUPS_B_H_PK
ITEM_GROUP_H_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_ITEM_GROUPS_B_H.ITEM_GROUP_ID
AHL_ITEM_GROUPS_B
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AHL_ITEM_GROUPS_TL_H.ITEM_GROUP_H_ID
AHL_ITEM_GROUPS_B_H
[top of page]
AHL.AHL_ITEM_GROUPS_B_H does not reference any database object
AHL.AHL_ITEM_GROUPS_B_H is referenced by following:
AHL
VIEW - AHL_ITEM_GROUPS_B_H#
[top of page]
Table: AHL_ITEM_GROUPS_TL
Description: This table stores translated information about item groups.
Primary Key: AHL_ITEM_GROUPS_TL_PK
ITEM_GROUP_ID
LANGUAGE
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_ITEM_GROUPS_TL.ITEM_GROUP_ID
AHL_ITEM_GROUPS_B
[top of page]
AHL.AHL_ITEM_GROUPS_TL does not reference any database object
AHL.AHL_ITEM_GROUPS_TL is referenced by following:
AHL
VIEW - AHL_ITEM_GROUPS_TL#
[top of page]
Table: AHL_ITEM_GROUPS_TL_H
Description: This table stores translated information about item group History.
Primary Key: AHL_ITEM_GROUPS_TL_H_PK
ITEM_GROUP_H_ID
LANGUAGE
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_ITEM_GROUPS_TL_H.ITEM_GROUP_H_ID
AHL_ITEM_GROUPS_B_H
[top of page]
AHL.AHL_ITEM_GROUPS_TL_H does not reference any database object
AHL.AHL_ITEM_GROUPS_TL_H is referenced by following:
AHL
VIEW - AHL_ITEM_GROUPS_TL_H#
[top of page]
Table: AHL_ITEM_VENDOR_RELS
Description: This table stores the relationships between the relationships of physical inventory items and service items and certified vendors.
Primary Key: AHL_ITEM_VENDOR_RELS_PK
ITEM_VENDOR_REL_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_ITEM_VENDOR_RELS.INV_SERVICE_ITEM_REL_ID
AHL_INV_SERVICE_ITEM_RELS
AHL_ITEM_VENDOR_RELS.VENDOR_CERTIFICATION_ID
AHL_VENDOR_CERTIFICATIONS
[top of page]
AHL.AHL_ITEM_VENDOR_RELS does not reference any database object
AHL.AHL_ITEM_VENDOR_RELS is referenced by following:
AHL
VIEW - AHL_ITEM_VENDOR_RELS#
[top of page]
Table: AHL_MC_CONFIG_RELATIONS
Description: This table maps sub configuration with Parent Master Configurations
Primary Key: AHL_MC_CONFIG_RELATIONS_PK
MC_CONFIG_RELATION_ID
Primary Key: AHL_MC_CONFIG_RELATIONS_UK1
RELATIONSHIP_ID
MC_HEADER_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_MC_CONFIG_RELATIONS.RELATIONSHIP_ID
AHL_MC_RELATIONSHIPS
AHL_MC_CONFIG_RELATIONS.MC_HEADER_ID
AHL_MC_HEADERS_B
[top of page]
AHL.AHL_MC_CONFIG_RELATIONS does not reference any database object
AHL.AHL_MC_CONFIG_RELATIONS is referenced by following:
AHL
VIEW - AHL_MC_CONFIG_RELATIONS#
[top of page]
Table: AHL_MC_HEADERS_B
Description: Stores Master Configuration Header details
Primary Key: AHL_MC_HEADERS_B_PK
MC_HEADER_ID
Primary Key: AHL_MC_HEADERS_B_UK1
MC_ID
VERSION_NUMBER
Primary Key: AHL_MC_HEADERS_B_UK2
NAME
REVISION
Primary Key: AHL_MC_HEADERS_B_UK3
VERSION_NUMBER
NAME
Primary Key: AHL_MC_HEADERS_B_UK4
MC_ID
REVISION
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AHL_MC_CONFIG_RELATIONS.MC_HEADER_ID
AHL_MC_HEADERS_B
AHL_MC_HEADERS_TL.MC_HEADER_ID
AHL_MC_HEADERS_B
AHL_MC_RELATIONSHIPS.MC_HEADER_ID
AHL_MC_HEADERS_B
AHL_MC_RULES_B.MC_HEADER_ID
AHL_MC_HEADERS_B
AHL_ROUTE_EFFECTIVITIES.MC_HEADER_ID
AHL_MC_HEADERS_B
AHL_UC_HEADERS_H.MASTER_CONFIG_ID
AHL_MC_HEADERS_B
AHL_UNIT_CONFIG_HEADERS.MASTER_CONFIG_ID
AHL_MC_HEADERS_B
[top of page]
AHL.AHL_MC_HEADERS_B does not reference any database object
AHL.AHL_MC_HEADERS_B is referenced by following:
AHL
VIEW - AHL_MC_HEADERS_B#
[top of page]
Table: AHL_MC_HEADERS_TL
Description: This table stores translatable Master Configuration header information
Primary Key: AHL_MC_HEADERS_TL_PK
MC_HEADER_ID
LANGUAGE
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_MC_HEADERS_TL.MC_HEADER_ID
AHL_MC_HEADERS_B
[top of page]
AHL.AHL_MC_HEADERS_TL does not reference any database object
AHL.AHL_MC_HEADERS_TL is referenced by following:
AHL
VIEW - AHL_MC_HEADERS_TL#
[top of page]
Table: AHL_MC_PATH_POSITIONS
Description: Stores multi-level MC Positions
Primary Key: AHL_MC_PATH_POSITIONS_PK
PATH_POSITION_ID
Primary Key: AHL_MC_PATH_POSITIONS_UK1
ENCODED_PATH_POSITION
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AHL_MC_PATH_POSITION_NODES.PATH_POSITION_ID
AHL_MC_PATH_POSITIONS
AHL_MC_RULE_STATEMENTS.SUBJECT_ID
AHL_MC_PATH_POSITIONS
AHL_MC_RULE_STATEMENTS.OBJECT_ID
AHL_MC_PATH_POSITIONS
AHL_MR_EFFECTIVITIES.RELATIONSHIP_ID
AHL_MC_PATH_POSITIONS
AHL_PRD_DISPOSITIONS_B.PATH_POSITION_ID
AHL_MC_PATH_POSITIONS
AHL_PRD_DISPOSITIONS_B_H.PATH_POSITION_ID
AHL_MC_PATH_POSITIONS
AHL_RT_OPER_MATERIALS.POSITION_PATH_ID
AHL_MC_PATH_POSITIONS
AHL_UNIT_EFFECTIVITIES_B.POSITION_PATH_ID
AHL_MC_PATH_POSITIONS
[top of page]
AHL.AHL_MC_PATH_POSITIONS does not reference any database object
AHL.AHL_MC_PATH_POSITIONS is referenced by following:
AHL
VIEW - AHL_MC_PATH_POSITIONS#
[top of page]
Table: AHL_MC_PATH_POSITION_NODES
Description: Stores Path Positions nodes
Primary Key: AHL_MC_PATH_POSITION_NODES_PK
PATH_POSITION_NODE_ID
Primary Key: AHL_MC_PATH_POSITION_NODES_UK1
PATH_POSITION_ID
SEQUENCE
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_MC_PATH_POSITION_NODES.PATH_POSITION_ID
AHL_MC_PATH_POSITIONS
[top of page]
AHL.AHL_MC_PATH_POSITION_NODES does not reference any database object
AHL.AHL_MC_PATH_POSITION_NODES is referenced by following:
AHL
VIEW - AHL_MC_PATH_POSITION_NODES#
[top of page]
Table: AHL_MC_RELATIONSHIPS
Description: This table stores MC Node information .It is result of denormalization of AHL_RELATIONSHIP_B and TL.
Primary Key: AHL_MC_RELATIONSHIPS_PK
RELATIONSHIP_ID
Primary Key: AHL_MC_RELATIONSHIPS_UK1
MC_HEADER_ID
POSITION_KEY
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_MC_RELATIONSHIPS.MC_HEADER_ID
AHL_MC_HEADERS_B
AHL_MC_RELATIONSHIPS.ITEM_GROUP_ID
AHL_ITEM_GROUPS_B
AHL_MC_RELATIONSHIPS.PARENT_RELATIONSHIP_ID
AHL_MC_RELATIONSHIPS
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AHL_CTR_UPDATE_RULES.RELATIONSHIP_ID
AHL_MC_RELATIONSHIPS
AHL_DOC_TITLE_ASSOS_B.ASO_OBJECT_ID
AHL_MC_RELATIONSHIPS
AHL_MC_CONFIG_RELATIONS.RELATIONSHIP_ID
AHL_MC_RELATIONSHIPS
AHL_MC_RELATIONSHIPS.PARENT_RELATIONSHIP_ID
AHL_MC_RELATIONSHIPS
[top of page]
AHL.AHL_MC_RELATIONSHIPS does not reference any database object
AHL.AHL_MC_RELATIONSHIPS is referenced by following:
AHL
VIEW - AHL_MC_RELATIONSHIPS#
[top of page]
Table: AHL_MC_RULES_B
Description: Stores MC Rules
Primary Key: AHL_MC_RULES_B_PK
RULE_ID
Primary Key: AHL_MC_RULES_B_UK1
MC_HEADER_ID
RULE_NAME
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_MC_RULES_B.MC_HEADER_ID
AHL_MC_HEADERS_B
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AHL_MC_RULES_TL.RULE_ID
AHL_MC_RULES_B
AHL_MC_RULE_STATEMENTS.RULE_ID
AHL_MC_RULES_B
[top of page]
AHL.AHL_MC_RULES_B does not reference any database object
AHL.AHL_MC_RULES_B is referenced by following:
AHL
VIEW - AHL_MC_RULES_B#
[top of page]
Table: AHL_MC_RULES_TL
Description: Translation table for MC Rules
Primary Key: AHL_MC_RULES_TL_PK
RULE_ID
LANGUAGE
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_MC_RULES_TL.RULE_ID
AHL_MC_RULES_B
[top of page]
AHL.AHL_MC_RULES_TL does not reference any database object
AHL.AHL_MC_RULES_TL is referenced by following:
AHL
VIEW - AHL_MC_RULES_TL#
[top of page]
Table: AHL_MC_RULE_STATEMENTS
Description: Stores Rule Statements
Primary Key: AHL_MC_RULE_STATEMENTS_PK
RULE_STATEMENT_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_MC_RULE_STATEMENTS.RULE_ID
AHL_MC_RULES_B
AHL_MC_RULE_STATEMENTS.SUBJECT_ID
AHL_MC_PATH_POSITIONS
AHL_MC_RULE_STATEMENTS.SUBJECT_ID
AHL_MC_RULE_STATEMENTS
AHL_MC_RULE_STATEMENTS.OBJECT_ID
AHL_MC_PATH_POSITIONS
AHL_MC_RULE_STATEMENTS.OBJECT_ID
AHL_MC_RULE_STATEMENTS
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AHL_MC_RULE_STATEMENTS.SUBJECT_ID
AHL_MC_RULE_STATEMENTS
AHL_MC_RULE_STATEMENTS.OBJECT_ID
AHL_MC_RULE_STATEMENTS
[top of page]
AHL.AHL_MC_RULE_STATEMENTS does not reference any database object
AHL.AHL_MC_RULE_STATEMENTS is referenced by following:
AHL
VIEW - AHL_MC_RULE_STATEMENTS#
[top of page]
Table: AHL_MEL_CDL_ATA_SEQUENCES
Description: This table stores information about ATA codes (System Sequnces) associated to the MEL/CDL.
Primary Key: AHL_MEL_CDL_ATA_SEQUENCES_PK
MEL_CDL_ATA_SEQUENCE_ID
Primary Key: AHL_MEL_CDL_ATA_SEQUENCES_UK1
MEL_CDL_HEADER_ID
ATA_CODE
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_MEL_CDL_ATA_SEQUENCES.MEL_CDL_HEADER_ID
AHL_MEL_CDL_HEADERS
AHL_MEL_CDL_ATA_SEQUENCES.REPAIR_CATEGORY_ID
AHL_REPAIR_CATEGORIES
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AHL_MEL_CDL_MO_PROCEDURES.ATA_SEQUENCE_ID
AHL_MEL_CDL_ATA_SEQUENCES
AHL_MEL_CDL_RELATIONSHIPS.ATA_SEQUENCE_ID
AHL_MEL_CDL_ATA_SEQUENCES
AHL_MEL_CDL_RELATIONSHIPS.RELATED_ATA_SEQUENCE_ID
AHL_MEL_CDL_ATA_SEQUENCES
AHL_UNIT_DEFERRALS_B.ATA_SEQUENCE_ID
AHL_MEL_CDL_ATA_SEQUENCES
[top of page]
AHL.AHL_MEL_CDL_ATA_SEQUENCES does not reference any database object
AHL.AHL_MEL_CDL_ATA_SEQUENCES is referenced by following:
AHL
VIEW - AHL_MEL_CDL_ATA_SEQUENCES#
[top of page]
Table: AHL_MEL_CDL_HEADERS
Description: This table stores MEL / CDL header information associated with Product Classification node.
Primary Key: AHL_MEL_CDL_HEADERS_PK
MEL_CDL_HEADER_ID
Primary Key: AHL_MEL_CDL_HEADERS_UK1
PC_NODE_ID
MEL_CDL_TYPE_CODE
VERSION_NUMBER
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_MEL_CDL_HEADERS.PC_NODE_ID
AHL_PC_NODES_B
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AHL_MEL_CDL_ATA_SEQUENCES.MEL_CDL_HEADER_ID
AHL_MEL_CDL_HEADERS
[top of page]
AHL.AHL_MEL_CDL_HEADERS does not reference any database object
AHL.AHL_MEL_CDL_HEADERS is referenced by following:
AHL
VIEW - AHL_MEL_CDL_HEADERS#
[top of page]
Table: AHL_MEL_CDL_MO_PROCEDURES
Description: This table stores association of M&O procedures (Maintenance Requirements of program_type MO_PROC) with ATA sequences.
Primary Key: AHL_MEL_CDL_MO_PROCEDURES_PK
MEL_CDL_MO_PROCEDURE_ID
Primary Key: AHL_MEL_CDL_MO_PROCEDURES_UK1
MR_HEADER_ID
ATA_SEQUENCE_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_MEL_CDL_MO_PROCEDURES.ATA_SEQUENCE_ID
AHL_MEL_CDL_ATA_SEQUENCES
AHL_MEL_CDL_MO_PROCEDURES.MR_HEADER_ID
AHL_MR_HEADERS_B
[top of page]
AHL.AHL_MEL_CDL_MO_PROCEDURES does not reference any database object
AHL.AHL_MEL_CDL_MO_PROCEDURES is referenced by following:
AHL
VIEW - AHL_MEL_CDL_MO_PROCEDURES#
[top of page]
Table: AHL_MEL_CDL_RELATIONSHIPS
Description: This table stores relationships between a pair of ATA sequences across the same MEL/CDL
Primary Key: AHL_MEL_CDL_RELATIONSHIPS_PK
MEL_CDL_RELATIONSHIP_ID
Primary Key: AHL_MEL_CDL_RELATIONSHIPS_UK1
ATA_SEQUENCE_ID
RELATED_ATA_SEQUENCE_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_MEL_CDL_RELATIONSHIPS.ATA_SEQUENCE_ID
AHL_MEL_CDL_ATA_SEQUENCES
AHL_MEL_CDL_RELATIONSHIPS.RELATED_ATA_SEQUENCE_ID
AHL_MEL_CDL_ATA_SEQUENCES
[top of page]
AHL.AHL_MEL_CDL_RELATIONSHIPS does not reference any database object
AHL.AHL_MEL_CDL_RELATIONSHIPS is referenced by following:
AHL
VIEW - AHL_MEL_CDL_RELATIONSHIPS#
[top of page]
Table: AHL_MM_TXN_INTERFACE
[top of page]
AHL.AHL_MM_TXN_INTERFACE does not reference any database object
AHL.AHL_MM_TXN_INTERFACE is referenced by following:
AHL
VIEW - AHL_MM_TXN_INTERFACE#
[top of page]
Table: AHL_MR_ACTIONS_B
Description: This table stores the actions associated with each maintenance requirement.
Primary Key: AHL_MR_ACTIONS_B_PK
MR_ACTION_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_MR_ACTIONS_B.MR_HEADER_ID
AHL_MR_HEADERS_B
AHL_MR_ACTIONS_B.PLAN_ID
QA_PLANS
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AHL_MR_ACTIONS_TL.MR_ACTION_ID
AHL_MR_ACTIONS_B
[top of page]
AHL.AHL_MR_ACTIONS_B does not reference any database object
AHL.AHL_MR_ACTIONS_B is referenced by following:
AHL
VIEW - AHL_MR_ACTIONS_B#
[top of page]
Table: AHL_MR_ACTIONS_TL
Description: Translation table for maintenance requirement and action association.
Primary Key: AHL_MR_ACTIONS_TL_PK
LANGUAGE
MR_ACTION_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_MR_ACTIONS_TL.MR_ACTION_ID
AHL_MR_ACTIONS_B
[top of page]
AHL.AHL_MR_ACTIONS_TL does not reference any database object
AHL.AHL_MR_ACTIONS_TL is referenced by following:
AHL
VIEW - AHL_MR_ACTIONS_TL#
[top of page]
Table: AHL_MR_EFFECTIVITIES
Description: This table stores the effectivity of maintenance requirement.
Primary Key: AHL_MR_EFFECTIVITIES_PK
MR_EFFECTIVITY_ID
Primary Key: AHL_MR_EFFECTIVITIES_UK1
NAME
MR_HEADER_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_MR_EFFECTIVITIES.MR_HEADER_ID
AHL_MR_HEADERS_B
AHL_MR_EFFECTIVITIES.RELATIONSHIP_ID
AHL_MC_PATH_POSITIONS
AHL_MR_EFFECTIVITIES.INVENTORY_ITEM_ID
INVENTORY_ORG_ID
MTL_SYSTEM_ITEMS_B
AHL_MR_EFFECTIVITIES.PC_NODE_ID
AHL_PC_NODES_B
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AHL_MR_EFFECTIVITY_DTLS.MR_EFFECTIVITY_ID
AHL_MR_EFFECTIVITIES
AHL_MR_EFFECTIVITY_EXT_DTLS.MR_EFFECTIVITY_ID
AHL_MR_EFFECTIVITIES
AHL_MR_INTERVALS.MR_EFFECTIVITY_ID
AHL_MR_EFFECTIVITIES
AHL_UNIT_EFFECTIVITIES_B.MR_EFFECTIVITY_ID
AHL_MR_EFFECTIVITIES
[top of page]
AHL.AHL_MR_EFFECTIVITIES does not reference any database object
AHL.AHL_MR_EFFECTIVITIES is referenced by following:
AHL
VIEW - AHL_MR_EFFECTIVITIES#
[top of page]
Table: AHL_MR_EFFECTIVITY_DTLS
Description: This table stores the item instance level details of the maintenance requirement.
Primary Key: AHL_MR_EFFECTIVITY_DTLS_PK
MR_EFFECTIVITY_DETAIL_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_MR_EFFECTIVITY_DTLS.MR_EFFECTIVITY_ID
AHL_MR_EFFECTIVITIES
AHL_MR_EFFECTIVITY_DTLS.MANUFACTURER_ID
MTL_MANUFACTURERS
AHL_MR_EFFECTIVITY_DTLS.COUNTRY_CODE
FND_TERRITORIES
[top of page]
AHL.AHL_MR_EFFECTIVITY_DTLS does not reference any database object
AHL.AHL_MR_EFFECTIVITY_DTLS is referenced by following:
AHL
VIEW - AHL_MR_EFFECTIVITY_DTLS#
[top of page]
Table: AHL_MR_EFFECTIVITY_EXT_DTLS
Description: Table to store extended effectivity details
Primary Key: AHL_MR_EFFECTIVITY_EXT_DTLS_PK
MR_EFFECTIVITY_EXT_DTL_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_MR_EFFECTIVITY_EXT_DTLS.MR_EFFECTIVITY_ID
AHL_MR_EFFECTIVITIES
[top of page]
AHL.AHL_MR_EFFECTIVITY_EXT_DTLS does not reference any database object
AHL.AHL_MR_EFFECTIVITY_EXT_DTLS is referenced by following:
AHL
VIEW - AHL_MR_EFFECTIVITY_EXT_DTLS#
[top of page]
Table: AHL_MR_HEADERS_B
Description: This table stores the maintenance requirement header information.
Primary Key: AHL_MR_HEADERS_B_PK
MR_HEADER_ID
Primary Key: AHL_MR_HEADERS_B_UK1
TITLE
VERSION_NUMBER
APPLICATION_USG_CODE
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_MR_HEADERS_B.PRECEDING_MR_HEADER_ID
AHL_MR_HEADERS_B
AHL_MR_HEADERS_B.WARRANTY_TEMPLATE_ID
%
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AHL_MEL_CDL_MO_PROCEDURES.MR_HEADER_ID
AHL_MR_HEADERS_B
AHL_MR_ACTIONS_B.MR_HEADER_ID
AHL_MR_HEADERS_B
AHL_MR_EFFECTIVITIES.MR_HEADER_ID
AHL_MR_HEADERS_B
AHL_MR_HEADERS_B.PRECEDING_MR_HEADER_ID
AHL_MR_HEADERS_B
AHL_MR_HEADERS_TL.MR_HEADER_ID
AHL_MR_HEADERS_B
AHL_MR_RELATIONSHIPS.MR_HEADER_ID
AHL_MR_HEADERS_B
AHL_MR_RELATIONSHIPS.RELATED_MR_HEADER_ID
AHL_MR_HEADERS_B
AHL_MR_ROUTES.MR_HEADER_ID
AHL_MR_HEADERS_B
AHL_SNAPSHOTS.MR_ID
AHL_MR_HEADERS_B
AHL_UNIT_EFFECTIVITIES_B.MR_HEADER_ID
AHL_MR_HEADERS_B
AHL_UNIT_EFFECTIVITIES_B.PROGRAM_MR_HEADER_ID
AHL_MR_HEADERS_B
AHL_UNIT_EFFECTIVITIES_B.PROGRAM_MR_HEADER_ID
AHL_MR_HEADERS_B
AHL_VISIT_TASKS_B.MR_ID
AHL_MR_HEADERS_B
[top of page]
AHL.AHL_MR_HEADERS_B does not reference any database object
AHL.AHL_MR_HEADERS_B is referenced by following:
AHL
VIEW - AHL_MR_HEADERS_B#
[top of page]
Table: AHL_MR_HEADERS_TL
Description: Translation table for maintenance requirement header.
Primary Key: AHL_MR_HEADERS_TL_PK
MR_HEADER_ID
LANGUAGE
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_MR_HEADERS_TL.MR_HEADER_ID
AHL_MR_HEADERS_B
[top of page]
AHL.AHL_MR_HEADERS_TL does not reference any database object
AHL.AHL_MR_HEADERS_TL is referenced by following:
AHL
VIEW - AHL_MR_HEADERS_TL#
[top of page]
Table: AHL_MR_INTERVALS
Description: This table stores the details of the frequency at whcih the maintenance requirement would be performed.
Primary Key: AHL_MR_INTERVALS_PK
MR_INTERVAL_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_MR_INTERVALS.MR_EFFECTIVITY_ID
AHL_MR_EFFECTIVITIES
AHL_MR_INTERVALS.COUNTER_ID
CS_COUNTERS
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AHL_UNIT_EFFECTIVITIES_B.MR_INTERVAL_ID
AHL_MR_INTERVALS
[top of page]
AHL.AHL_MR_INTERVALS does not reference any database object
AHL.AHL_MR_INTERVALS is referenced by following:
AHL
VIEW - AHL_MR_INTERVALS#
[top of page]
Table: AHL_MR_ORGANIZATIONS
[top of page]
AHL.AHL_MR_ORGANIZATIONS does not reference any database object
AHL.AHL_MR_ORGANIZATIONS is referenced by following:
AHL
VIEW - AHL_MR_ORGANIZATIONS#
[top of page]
Table: AHL_MR_RELATIONSHIPS
Description: This table stores the parent/child relationships of maintenance requirements.
Primary Key: AHL_MR_RELATIONSHIPS_PK
MR_RELATIONSHIP_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_MR_RELATIONSHIPS.MR_HEADER_ID
AHL_MR_HEADERS_B
AHL_MR_RELATIONSHIPS.RELATED_MR_HEADER_ID
AHL_MR_HEADERS_B
[top of page]
AHL.AHL_MR_RELATIONSHIPS does not reference any database object
AHL.AHL_MR_RELATIONSHIPS is referenced by following:
AHL
VIEW - AHL_MR_RELATIONSHIPS#
[top of page]
Table: AHL_MR_ROUTES
Description: This table stores the associations of maintenance requirements to routes.
Primary Key: AHL_MR_ROUTES_PK
MR_ROUTE_ID
Primary Key: AHL_MR_ROUTES_UK1
ROUTE_ID
MR_HEADER_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_MR_ROUTES.MR_HEADER_ID
AHL_MR_HEADERS_B
AHL_MR_ROUTES.ROUTE_ID
AHL_ROUTES_B
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AHL_MR_ROUTE_SEQUENCES.MR_ROUTE_ID
AHL_MR_ROUTES
AHL_MR_ROUTE_SEQUENCES.RELATED_MR_ROUTE_ID
AHL_MR_ROUTES
AHL_VISIT_TASKS_B.MR_ROUTE_ID
AHL_MR_ROUTES
[top of page]
AHL.AHL_MR_ROUTES does not reference any database object
AHL.AHL_MR_ROUTES is referenced by following:
AHL
VIEW - AHL_MR_ROUTES#
[top of page]
Table: AHL_MR_ROUTE_SEQUENCES
Description: This table stores the sequencing of routes attached to a maintenance requirement.
Primary Key: AHL_MR_ROUTE_SEQUENCES_PK
MR_ROUTE_SEQUENCE_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_MR_ROUTE_SEQUENCES.MR_ROUTE_ID
AHL_MR_ROUTES
AHL_MR_ROUTE_SEQUENCES.RELATED_MR_ROUTE_ID
AHL_MR_ROUTES
[top of page]
AHL.AHL_MR_ROUTE_SEQUENCES does not reference any database object
AHL.AHL_MR_ROUTE_SEQUENCES is referenced by following:
AHL
VIEW - AHL_MR_ROUTE_SEQUENCES#
[top of page]
Table: AHL_MR_VISIT_TYPES
Description: Ahl mr visit types Table
[top of page]
AHL.AHL_MR_VISIT_TYPES does not reference any database object
AHL.AHL_MR_VISIT_TYPES is referenced by following:
AHL
VIEW - AHL_MR_VISIT_TYPES#
[top of page]
Table: AHL_NR_PROFILE_DETAILS
[top of page]
AHL.AHL_NR_PROFILE_DETAILS does not reference any database object
AHL.AHL_NR_PROFILE_DETAILS is referenced by following:
AHL
VIEW - AHL_NR_PROFILE_DETAILS#
[top of page]
Table: AHL_NR_PROFILE_HEADERS
[top of page]
AHL.AHL_NR_PROFILE_HEADERS does not reference any database object
AHL.AHL_NR_PROFILE_HEADERS is referenced by following:
AHL
VIEW - AHL_NR_PROFILE_HEADERS#
[top of page]
Table: AHL_OPERATIONS_B
Description: This Table stores the Standard and Non Standard Operations.
Primary Key: AHL_OPERATIONS_B_PK
OPERATION_ID
Primary Key: AHL_OPERATIONS_B_UK1
SEGMENT1
SEGMENT2
SEGMENT3
SEGMENT4
SEGMENT5
SEGMENT6
SEGMENT7
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_OPERATIONS_B.QA_PLAN_ID
QA_PLANS
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AHL_DOC_TITLE_ASSOS_B.ASO_OBJECT_ID
AHL_OPERATIONS_B
AHL_OPERATIONS_H_B.OPERATION_ID
AHL_OPERATIONS_B
AHL_OPERATIONS_TL.OPERATION_ID
AHL_OPERATIONS_B
AHL_OPERATION_PHASES.OPERATION_ID
AHL_OPERATIONS_B
AHL_OPERATION_PHASES_H.OPERATION_ID
AHL_OPERATIONS_B
AHL_ROUTE_OPERATIONS.OPERATION_ID
AHL_OPERATIONS_B
AHL_ROUTE_OPERATIONS_H.OPERATION_ID
AHL_OPERATIONS_B
AHL_RT_OPER_ACCESS_PANELS.OBJECT_ID
AHL_OPERATIONS_B
AHL_RT_OPER_LABOR.OBJECT_ID
AHL_OPERATIONS_B
AHL_RT_OPER_LABOR_H.OBJECT_ID
AHL_OPERATIONS_B
AHL_RT_OPER_MATERIALS.OBJECT_ID
AHL_OPERATIONS_B
AHL_RT_OPER_MATERIALS_H.OBJECT_ID
AHL_OPERATIONS_B
AHL_RT_OPER_RESOURCES.OBJECT_ID
AHL_OPERATIONS_B
AHL_WORKORDER_OPERATIONS.OPERATION_ID
AHL_OPERATIONS_B
[top of page]
AHL.AHL_OPERATIONS_B does not reference any database object
AHL.AHL_OPERATIONS_B is referenced by following:
AHL
VIEW - AHL_OPERATIONS_B#
[top of page]
Table: AHL_OPERATIONS_H_B
Description: History table for AHL_OPERATIONS_B.
Primary Key: AHL_OPERATIONS_H_B_PK
OPERATIONS_H_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_OPERATIONS_H_B.OPERATION_ID
AHL_OPERATIONS_B
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AHL_OPERATIONS_H_TL.OPERATIONS_H_ID
AHL_OPERATIONS_H_B
[top of page]
AHL.AHL_OPERATIONS_H_B does not reference any database object
AHL.AHL_OPERATIONS_H_B is referenced by following:
AHL
VIEW - AHL_OPERATIONS_H_B#
[top of page]
Table: AHL_OPERATIONS_H_TL
Description: This table stores the translated Operation history attributes.
Primary Key: AHL_OPERATIONS_H_TL_PK
OPERATIONS_H_ID
LANGUAGE
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_OPERATIONS_H_TL.OPERATIONS_H_ID
AHL_OPERATIONS_H_B
[top of page]
AHL.AHL_OPERATIONS_H_TL does not reference any database object
AHL.AHL_OPERATIONS_H_TL is referenced by following:
AHL
VIEW - AHL_OPERATIONS_H_TL#
[top of page]
Table: AHL_OPERATIONS_TL
Description: This table stores the translated Operation attributes.
Primary Key: AHL_OPERATIONS_TL_PK
OPERATION_ID
LANGUAGE
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_OPERATIONS_TL.OPERATION_ID
AHL_OPERATIONS_B
[top of page]
AHL.AHL_OPERATIONS_TL does not reference any database object
AHL.AHL_OPERATIONS_TL is referenced by following:
AHL
VIEW - AHL_OPERATIONS_TL#
[top of page]
Table: AHL_OPERATION_PHASES
Description: This table stores the significant phases in an Operation.
Primary Key: AHL_OPERATION_PHASES_PK
OPERATION_PHASE_ID
Primary Key: AHL_OPERATION_PHASES_UK1
OPERATION_ID
PHASE_CODE
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_OPERATION_PHASES.OPERATION_ID
AHL_OPERATIONS_B
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AHL_OPERATION_PHASES_H.OPERATION_PHASE_ID
AHL_OPERATION_PHASES
[top of page]
AHL.AHL_OPERATION_PHASES does not reference any database object
AHL.AHL_OPERATION_PHASES is referenced by following:
AHL
VIEW - AHL_OPERATION_PHASES#
[top of page]
Table: AHL_OPERATION_PHASES_H
Description: History table for AHL_OPERATION_PHASES.
Primary Key: AHL_OPERATION_PHASES_H_PK
OPERATION_PHASES_H_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_OPERATION_PHASES_H.OPERATION_PHASE_ID
AHL_OPERATION_PHASES
AHL_OPERATION_PHASES_H.OPERATION_ID
AHL_OPERATIONS_B
[top of page]
AHL.AHL_OPERATION_PHASES_H does not reference any database object
AHL.AHL_OPERATION_PHASES_H is referenced by following:
AHL
VIEW - AHL_OPERATION_PHASES_H#
[top of page]
Table: AHL_OPERATION_RESOURCES
Description: This table stores information about job operation resources
Primary Key: AHL_OPERATION_RESOURCES_PK
OPERATION_RESOURCE_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_OPERATION_RESOURCES.WORKORDER_OPERATION_ID
AHL_WORKORDER_OPERATIONS
AHL_OPERATION_RESOURCES.RESOURCE_ID
BOM_RESOURCES
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AHL_WORK_ASSIGNMENTS.OPERATION_RESOURCE_ID
AHL_OPERATION_RESOURCES
AHL_WORK_LOGIN_TIMES.OPERATION_RESOURCE_ID
AHL_OPERATION_RESOURCES
AHL_WO_OPERATIONS_TXNS.OPERATION_RESOURCE_ID
AHL_OPERATION_RESOURCES
[top of page]
AHL.AHL_OPERATION_RESOURCES does not reference any database object
AHL.AHL_OPERATION_RESOURCES is referenced by following:
AHL
VIEW - AHL_OPERATION_RESOURCES#
[top of page]
Table: AHL_OPER_VST_AUTOCREATE
[top of page]
AHL.AHL_OPER_VST_AUTOCREATE does not reference any database object
AHL.AHL_OPER_VST_AUTOCREATE is referenced by following:
AHL
VIEW - AHL_OPER_VST_AUTOCREATE#
[top of page]
Table: AHL_OSP_ORDERS_B
Description: This table stores the osp order header information.
Primary Key: AHLOSP_ORDERS_B_PK
OSP_ORDER_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_OSP_ORDERS_B.VENDOR_ID
PO_VENDORS
AHL_OSP_ORDERS_B.CUSTOMER_ID
HZ_PARTIES
AHL_OSP_ORDERS_B.PO_HEADER_ID
PO_HEADERS_ALL
AHL_OSP_ORDERS_B.OE_HEADER_ID
OE_ORDER_HEADERS_ALL
AHL_OSP_ORDERS_B.CONTRACT_ID
OKC_K_HEADERS_B
AHL_OSP_ORDERS_B.PO_AGENT_ID
PO_AGENTS
AHL_OSP_ORDERS_B.PO_REQ_HEADER_ID
PO_REQUISITION_HEADERS_ALL
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AHL_OSP_ORDERS_TL.OSP_ORDER_ID
AHL_OSP_ORDERS_B
AHL_OSP_ORDER_LINES.OSP_ORDER_ID
AHL_OSP_ORDERS_B
[top of page]
AHL.AHL_OSP_ORDERS_B does not reference any database object
AHL.AHL_OSP_ORDERS_B is referenced by following:
AHL
VIEW - AHL_OSP_ORDERS_B#
[top of page]
Table: AHL_OSP_ORDERS_TL
Description: Translatable Table for AHL_OSP_ORDERS_B
Primary Key: AHL_OSP_ORDERS_TL_PK
OSP_ORDER_ID
LANGUAGE
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_OSP_ORDERS_TL.OSP_ORDER_ID
AHL_OSP_ORDERS_B
[top of page]
AHL.AHL_OSP_ORDERS_TL does not reference any database object
AHL.AHL_OSP_ORDERS_TL is referenced by following:
AHL
VIEW - AHL_OSP_ORDERS_TL#
[top of page]
Table: AHL_OSP_ORDER_LINES
Description: Table to store order lines
Primary Key: AHL_OSP_ORDER_LINES_PK
OSP_ORDER_LINE_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_OSP_ORDER_LINES.OSP_ORDER_ID
AHL_OSP_ORDERS_B
AHL_OSP_ORDER_LINES.PO_LINE_ID
PO_LINES_ALL
AHL_OSP_ORDER_LINES.PO_LINE_TYPE_ID
PO_LINE_TYPES_B
AHL_OSP_ORDER_LINES.OE_SHIP_LINE_ID
OE_ORDER_LINES_ALL
AHL_OSP_ORDER_LINES.OE_RETURN_LINE_ID
OE_ORDER_LINES_ALL
AHL_OSP_ORDER_LINES.WORKORDER_ID
AHL_WORKORDERS
AHL_OSP_ORDER_LINES.PO_REQ_LINE_ID
PO_REQUISITION_LINES_ALL
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AHL_WARRANTY_ENTITLEMENTS.OSP_ORDER_LINE_ID
AHL_OSP_ORDER_LINES
[top of page]
AHL.AHL_OSP_ORDER_LINES does not reference any database object
AHL.AHL_OSP_ORDER_LINES is referenced by following:
AHL
VIEW - AHL_OSP_ORDER_LINES#
[top of page]
Table: AHL_OSP_ORDER_LOGS
Description: This table stores the log for OSP order transactions
Primary Key: AHLOSP_ORDER_LOG_ID_PK
OSP_ORDER_LOG_ID
[top of page]
AHL.AHL_OSP_ORDER_LOGS does not reference any database object
AHL.AHL_OSP_ORDER_LOGS is referenced by following:
AHL
VIEW - AHL_OSP_ORDER_LOGS#
[top of page]
Table: AHL_PART_CHANGES
Description: Table to store part change transaction details.
Primary Key: AHL_PART_CHANGES_PK
PART_CHANGE_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_PART_CHANGES.UNIT_CONFIG_HEADER_ID
AHL_UNIT_CONFIG_HEADERS
AHL_PART_CHANGES.REMOVED_INSTANCE_ID
CSI_ITEM_INSTANCES
AHL_PART_CHANGES.INSTALLED_INSTANCE_ID
CSI_ITEM_INSTANCES
AHL_PART_CHANGES.MC_RELATIONSHIP_ID
AHL_RELATIONSHIPS_B
AHL_PART_CHANGES.WORKORDER_OPERATION_ID
AHL_WORKORDER_OPERATIONS
AHL_PART_CHANGES.NON_ROUTINE_WORKORDER_ID
AHL_WORKORDERS
AHL_PART_CHANGES.WORKORDER_MTL_TXN_ID
AHL_WORKORDER_MTL_TXNS
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AHL_PRD_DISPOSITIONS_B.PART_CHANGE_ID
AHL_PART_CHANGES
AHL_PRD_DISPOSITIONS_B_H.PART_CHANGE_ID
AHL_PART_CHANGES
[top of page]
AHL.AHL_PART_CHANGES does not reference any database object
AHL.AHL_PART_CHANGES is referenced by following:
AHL
VIEW - AHL_PART_CHANGES#
[top of page]
Table: AHL_PC_ASSOCIATIONS
Description: This table stores information about Product Classification Node Association with Unit or Part.
Primary Key: AHL_PC_ASSOCIATIONS_PK
PC_ASSOCIATION_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_PC_ASSOCIATIONS.PC_NODE_ID
AHL_PC_NODES_B
AHL_PC_ASSOCIATIONS.UNIT_ITEM_ID
AHL_UNIT_CONFIG_HEADERS
[top of page]
AHL.AHL_PC_ASSOCIATIONS does not reference any database object
AHL.AHL_PC_ASSOCIATIONS is referenced by following:
AHL
VIEW - AHL_PC_ASSOCIATIONS#
[top of page]
Table: AHL_PC_HEADERS_B
Description: This table stores information about Product Classification header.
Primary Key: AHL_PC_HEADER_B_UK1
NAME
STATUS
Primary Key: PC_HEADER_HEADERS_B_PK1
PC_HEADER_ID
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AHL_PC_NODES_B.PC_HEADER_ID
AHL_PC_HEADERS_B
[top of page]
AHL.AHL_PC_HEADERS_B does not reference any database object
AHL.AHL_PC_HEADERS_B is referenced by following:
AHL
VIEW - AHL_PC_HEADERS_B#
[top of page]
Table: AHL_PC_HEADERS_TL
Description: Translation table for AHL_PC_HEADERS_B.
[top of page]
AHL.AHL_PC_HEADERS_TL does not reference any database object
AHL.AHL_PC_HEADERS_TL is referenced by following:
AHL
VIEW - AHL_PC_HEADERS_TL#
[top of page]
Table: AHL_PC_NODES_B
Description: Product Classification Node Table
Primary Key: AHL_PC_NODES_B_PK
PC_NODE_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_PC_NODES_B.PC_HEADER_ID
AHL_PC_HEADERS_B
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AHL_MEL_CDL_HEADERS.PC_NODE_ID
AHL_PC_NODES_B
AHL_MR_EFFECTIVITIES.PC_NODE_ID
AHL_PC_NODES_B
AHL_PC_ASSOCIATIONS.PC_NODE_ID
AHL_PC_NODES_B
AHL_PC_NODES_TL.PC_NODE_ID
AHL_PC_NODES_B
AHL_UF_HEADERS.PC_NODE_ID
AHL_PC_NODES_B
[top of page]
AHL.AHL_PC_NODES_B does not reference any database object
AHL.AHL_PC_NODES_B is referenced by following:
AHL
VIEW - AHL_PC_NODES_B#
[top of page]
Table: AHL_PC_NODES_TL
Description: Translation table for AHL_PC_NODES_B.
Primary Key: AHL_PC_NODES_TL_PK
PC_NODE_ID
LANGUAGE
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_PC_NODES_TL.PC_NODE_ID
AHL_PC_NODES_B
[top of page]
AHL.AHL_PC_NODES_TL does not reference any database object
AHL.AHL_PC_NODES_TL is referenced by following:
AHL
VIEW - AHL_PC_NODES_TL#
[top of page]
Table: AHL_PLANNING_FACTORS
[top of page]
AHL.AHL_PLANNING_FACTORS does not reference any database object
AHL.AHL_PLANNING_FACTORS is referenced by following:
AHL
VIEW - AHL_PLANNING_FACTORS#
[top of page]
Table: AHL_PRD_DISPOSITIONS_B
Description: Store information about workorders's disposiiton
Primary Key: AHL_PRD_DISPOSITIONS_B_PK
DISPOSITION_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_PRD_DISPOSITIONS_B.WORKORDER_ID
AHL_WORKORDERS
AHL_PRD_DISPOSITIONS_B.WO_OPERATION_ID
AHL_WORKORDER_OPERATIONS
AHL_PRD_DISPOSITIONS_B.PART_CHANGE_ID
AHL_PART_CHANGES
AHL_PRD_DISPOSITIONS_B.PATH_POSITION_ID
AHL_MC_PATH_POSITIONS
AHL_PRD_DISPOSITIONS_B.INVENTORY_ITEM_ID
ORGANIZATION_ID
MTL_SYSTEM_ITEMS_B
AHL_PRD_DISPOSITIONS_B.ITEM_GROUP_ID
AHL_ITEM_GROUPS_B
AHL_PRD_DISPOSITIONS_B.INSTANCE_ID
CSI_ITEM_INSTANCES
AHL_PRD_DISPOSITIONS_B.PRIMARY_SERVICE_REQUEST_ID
CS_INCIDENTS_ALL_B
AHL_PRD_DISPOSITIONS_B.NON_ROUTINE_WORKORDER_ID
AHL_WORKORDERS
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AHL_PRD_DISPOSITIONS_TL.DISPOSITION_ID
AHL_PRD_DISPOSITIONS_B
AHL_PRD_DISPOSITIONS_TL_H.DISPOSITION_ID
AHL_PRD_DISPOSITIONS_B
AHL_PRD_DISP_MTL_TXNS.DISPOSITION_ID
AHL_PRD_DISPOSITIONS_B
[top of page]
AHL.AHL_PRD_DISPOSITIONS_B does not reference any database object
AHL.AHL_PRD_DISPOSITIONS_B is referenced by following:
AHL
VIEW - AHL_PRD_DISPOSITIONS_B#
[top of page]
Table: AHL_PRD_DISPOSITIONS_B_H
Description: Store disposition history
Primary Key: AHL_PRD_DISPOSITIONS_B_H_PK
DISPOSITION_H_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_PRD_DISPOSITIONS_B_H.WORKORDER_ID
AHL_WORKORDERS
AHL_PRD_DISPOSITIONS_B_H.WO_OPERATION_ID
AHL_WORKORDER_OPERATIONS
AHL_PRD_DISPOSITIONS_B_H.PART_CHANGE_ID
AHL_PART_CHANGES
AHL_PRD_DISPOSITIONS_B_H.PATH_POSITION_ID
AHL_MC_PATH_POSITIONS
AHL_PRD_DISPOSITIONS_B_H.INVENTORY_ITEM_ID
ORGANIZATION_ID
MTL_SYSTEM_ITEMS_B
AHL_PRD_DISPOSITIONS_B_H.ITEM_GROUP_ID
AHL_ITEM_GROUPS_B
AHL_PRD_DISPOSITIONS_B_H.INSTANCE_ID
CSI_ITEM_INSTANCES
AHL_PRD_DISPOSITIONS_B_H.PRIMARY_SERVICE_REQUEST_ID
CS_INCIDENTS_ALL_B
AHL_PRD_DISPOSITIONS_B_H.NON_ROUTINE_WORKORDER_ID
AHL_WORKORDERS
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AHL_PRD_DISPOSITIONS_TL_H.DISPOSITION_H_ID
AHL_PRD_DISPOSITIONS_B_H
[top of page]
AHL.AHL_PRD_DISPOSITIONS_B_H does not reference any database object
AHL.AHL_PRD_DISPOSITIONS_B_H is referenced by following:
AHL
VIEW - AHL_PRD_DISPOSITIONS_B_H#
[top of page]
Table: AHL_PRD_DISPOSITIONS_TL
Description: Stores disposition translatable columns
Primary Key: AHL_PRD_DISPOSITIONS_TL_PK
DISPOSITION_ID
LANGUAGE
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_PRD_DISPOSITIONS_TL.DISPOSITION_ID
AHL_PRD_DISPOSITIONS_B
[top of page]
AHL.AHL_PRD_DISPOSITIONS_TL does not reference any database object
AHL.AHL_PRD_DISPOSITIONS_TL is referenced by following:
AHL
VIEW - AHL_PRD_DISPOSITIONS_TL#
[top of page]
Table: AHL_PRD_DISPOSITIONS_TL_H
Description: Stores disposition history's translatable columns
Primary Key: AHL_PRD_DISPOSITIONS_TL_H_PK
DISPOSITION_H_ID
LANGUAGE
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_PRD_DISPOSITIONS_TL_H.DISPOSITION_H_ID
AHL_PRD_DISPOSITIONS_B_H
AHL_PRD_DISPOSITIONS_TL_H.DISPOSITION_ID
AHL_PRD_DISPOSITIONS_B
[top of page]
AHL.AHL_PRD_DISPOSITIONS_TL_H does not reference any database object
AHL.AHL_PRD_DISPOSITIONS_TL_H is referenced by following:
AHL
VIEW - AHL_PRD_DISPOSITIONS_TL_H#
[top of page]
Table: AHL_PRD_DISP_MTL_TXNS
Description: This table stores the relationship between dispositions and material transactions.
Primary Key: AHL_PRD_DISP_MTL_TXNS_PK
DISP_MTL_TXN_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_PRD_DISP_MTL_TXNS.DISPOSITION_ID
AHL_PRD_DISPOSITIONS_B
AHL_PRD_DISP_MTL_TXNS.WORKORDER_MTL_TXN_ID
AHL_WORKORDER_MTL_TXNS
[top of page]
AHL.AHL_PRD_DISP_MTL_TXNS does not reference any database object
AHL.AHL_PRD_DISP_MTL_TXNS is referenced by following:
AHL
VIEW - AHL_PRD_DISP_MTL_TXNS#
[top of page]
Table: AHL_PRD_MB_UC_DETAILS
[top of page]
AHL.AHL_PRD_MB_UC_DETAILS does not reference any database object
AHL.AHL_PRD_MB_UC_DETAILS is referenced by following:
APPS
SYNONYM - AHL_PRD_MB_UC_DETAILS
[top of page]
Table: AHL_PRODTYPE_ZONES
Description: This table stores the association between product type, zone and sub zone.
Primary Key: AHL_PRODTYPE_ZONES_PK
PRODTYPE_ZONE_ID
Primary Key: AHL_PRODTYPE_ZONES_UK1
PRODUCT_TYPE_CODE
ZONE_CODE
SUB_ZONE_CODE
[top of page]
AHL.AHL_PRODTYPE_ZONES does not reference any database object
AHL.AHL_PRODTYPE_ZONES is referenced by following:
AHL
VIEW - AHL_PRODTYPE_ZONES#
[top of page]
Table: AHL_PROG_TYPE_SUBTYPES
Description: This table stores the association between program type sand subtypes.
Primary Key: AHL_PROG_TYPE_SUBTYPES_PK
PROG_TYPE_SUBTYPE_ID
[top of page]
AHL.AHL_PROG_TYPE_SUBTYPES does not reference any database object
AHL.AHL_PROG_TYPE_SUBTYPES is referenced by following:
AHL
VIEW - AHL_PROG_TYPE_SUBTYPES#
[top of page]
Table: AHL_RA_CTR_ASSOCIATIONS
Description: This Table stores information about counter association.
Primary Key: RACA_PK
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_RA_CTR_ASSOCIATIONS.SINCE_NEW_COUNTER_ID
CSI_COUNTER_TEMPLATE_B
AHL_RA_CTR_ASSOCIATIONS.SINCE_OVERHAUL_COUNTER_ID
CSI_COUNTER_TEMPLATE_B
[top of page]
AHL.AHL_RA_CTR_ASSOCIATIONS does not reference any database object
AHL.AHL_RA_CTR_ASSOCIATIONS is referenced by following:
AHL
VIEW - AHL_RA_CTR_ASSOCIATIONS#
[top of page]
Table: AHL_RA_DEFINITION_DTLS
Description: This Setup Table stores Reliability definition details.
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_RA_DEFINITION_DTLS.COUNTER_ID
CSI_COUNTER_TEMPLATE_B
[top of page]
AHL.AHL_RA_DEFINITION_DTLS does not reference any database object
AHL.AHL_RA_DEFINITION_DTLS is referenced by following:
AHL
VIEW - AHL_RA_DEFINITION_DTLS#
[top of page]
Table: AHL_RA_DEFINITION_HDR
Description: This Setup Table stores Reliability definition Header info.
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_RA_DEFINITION_HDR.INVENTORY_ITEM_ID
INVENTORY_ORG_ID
MTL_SYSTEM_ITEMS_B
[top of page]
AHL.AHL_RA_DEFINITION_HDR does not reference any database object
AHL.AHL_RA_DEFINITION_HDR is referenced by following:
AHL
VIEW - AHL_RA_DEFINITION_HDR#
[top of page]
Table: AHL_RA_FCT_ASSOCIATIONS
Description: This Table stores Reliability Forecast association (Forecast designator of MRP/IO) for setup (MTBF) data and Historical data.
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_RA_FCT_ASSOCIATIONS.FORECAST_DESIGNATOR
ORGANIZATION_ID
MRP_FORECAST_DESIGNATORS
[top of page]
AHL.AHL_RA_FCT_ASSOCIATIONS does not reference any database object
AHL.AHL_RA_FCT_ASSOCIATIONS is referenced by following:
AHL
VIEW - AHL_RA_FCT_ASSOCIATIONS#
[top of page]
Table: AHL_RA_SETUPS
Description: This Table stores Reliability Setup info.
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_RA_SETUPS.STATUS_ID
MTL_MATERIAL_STATUSES_B
[top of page]
AHL.AHL_RA_SETUPS does not reference any database object
AHL.AHL_RA_SETUPS is referenced by following:
AHL
VIEW - AHL_RA_SETUPS#
[top of page]
Table: AHL_RECIPIENT_DOCUMENTS
Description: This table stores information about recipients who received the document.
Primary Key: AHL_RECIPIENT_DOCUMENTS_PK
RECIPIENT_DOCUMENT_ID
Primary Key: AHL_RECIPIENT_DOCUMENTS_UK1
RECIPIENT_PARTY_ID
DOCUMENT_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_RECIPIENT_DOCUMENTS.RECIPIENT_PARTY_ID
HZ_PARTIES
AHL_RECIPIENT_DOCUMENTS.DOCUMENT_ID
AHL_DOCUMENTS_B
[top of page]
AHL.AHL_RECIPIENT_DOCUMENTS does not reference any database object
AHL.AHL_RECIPIENT_DOCUMENTS is referenced by following:
AHL
VIEW - AHL_RECIPIENT_DOCUMENTS#
[top of page]
Table: AHL_RELATIONSHIPS_B
Description: This table is obsoleted tabled from 11.5.10 .. This table stores the position hierarchy of the master configuration.
Primary Key: AHL_RELATIONSHIPS_B_PK
RELATIONSHIP_ID
Primary Key: AHL_RELATIONSHIPS_B_UK1
NAME
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_RELATIONSHIPS_B.PARENT_RELATIONSHIP_ID
AHL_RELATIONSHIPS_B
AHL_RELATIONSHIPS_B.ITEM_GROUP_ID
AHL_ITEM_GROUPS_B
AHL_RELATIONSHIPS_B.COUNTER_GROUP_ID
CS_COUNTER_GROUPS
AHL_RELATIONSHIPS_B.PARENT_RELATIONSHIP_ID
AHL_RELATIONSHIPS_B
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AHL_EVENT_ASSOCIATIONS.RELATIONSHIP_ID
AHL_RELATIONSHIPS_B
AHL_PART_CHANGES.MC_RELATIONSHIP_ID
AHL_RELATIONSHIPS_B
AHL_RELATIONSHIPS_B.PARENT_RELATIONSHIP_ID
AHL_RELATIONSHIPS_B
AHL_RELATIONSHIPS_TL.RELATIONSHIP_ID
AHL_RELATIONSHIPS_B
AHL_RELATIONSHIPS_B.PARENT_RELATIONSHIP_ID
AHL_RELATIONSHIPS_B
[top of page]
AHL.AHL_RELATIONSHIPS_B does not reference any database object
AHL.AHL_RELATIONSHIPS_B is referenced by following:
AHL
VIEW - AHL_RELATIONSHIPS_B#
[top of page]
Table: AHL_RELATIONSHIPS_TL
Description: This table is obsoleted tabled from 11.5.10 .. This table stores the translated position hierarchy information of the master configuration.
Primary Key: AHL_RELATIONSHIPS_TL_PK
RELATIONSHIP_ID
LANGUAGE
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_RELATIONSHIPS_TL.RELATIONSHIP_ID
AHL_RELATIONSHIPS_B
[top of page]
AHL.AHL_RELATIONSHIPS_TL does not reference any database object
AHL.AHL_RELATIONSHIPS_TL is referenced by following:
AHL
VIEW - AHL_RELATIONSHIPS_TL#
[top of page]
Table: AHL_REPAIR_CATEGORIES
Description: This table stores repair categories from CS_INCIDENT_URGENCIES_B with their repair time limits (in hours).
Primary Key: AHL_REPAIR_CATEGORIES_PK
REPAIR_CATEGORY_ID
Primary Key: AHL_REPAIR_CATEGORIES_UK1
SR_URGENCY_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_REPAIR_CATEGORIES.SR_URGENCY_ID
CS_INCIDENT_URGENCIES_B
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AHL_MEL_CDL_ATA_SEQUENCES.REPAIR_CATEGORY_ID
AHL_REPAIR_CATEGORIES
[top of page]
AHL.AHL_REPAIR_CATEGORIES does not reference any database object
AHL.AHL_REPAIR_CATEGORIES is referenced by following:
AHL
VIEW - AHL_REPAIR_CATEGORIES#
[top of page]
Table: AHL_REQ_SUPPLY_SCHEDULE
[top of page]
AHL.AHL_REQ_SUPPLY_SCHEDULE does not reference any database object
AHL.AHL_REQ_SUPPLY_SCHEDULE is referenced by following:
AHL
VIEW - AHL_REQ_SUPPLY_SCHEDULE#
[top of page]
Table: AHL_RESOURCES
Description: This table stores the ASO resource, which can be related to HR's skill type, skill lvevl and certifiaction.
Primary Key: AHL_RESOURCES_PK
RESOURCE_ID
Primary Key: AHL_RESOURCES_UK1
NAME
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AHL_ALTERNATE_RESOURCES.ASO_RESOURCE_ID
AHL_RESOURCES
AHL_RESOURCE_MAPPINGS.ASO_RESOURCE_ID
AHL_RESOURCES
AHL_RESOURCE_SKILLS.AHL_RESOURCE_ID
AHL_RESOURCES
AHL_RT_OPER_RESOURCES.ASO_RESOURCE_ID
AHL_RESOURCES
[top of page]
AHL.AHL_RESOURCES does not reference any database object
AHL.AHL_RESOURCES is referenced by following:
AHL
VIEW - AHL_RESOURCES#
[top of page]
Table: AHL_RESOURCE_MAPPINGS
Description: This table stores the mapping between ASO resource and BOM resource.
Primary Key: AHL_RESOURCE_MAPPINGS_PK
RESOURCE_MAPPING_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_RESOURCE_MAPPINGS.ASO_RESOURCE_ID
AHL_RESOURCES
AHL_RESOURCE_MAPPINGS.BOM_RESOURCE_ID
BOM_RESOURCES
[top of page]
AHL.AHL_RESOURCE_MAPPINGS does not reference any database object
AHL.AHL_RESOURCE_MAPPINGS is referenced by following:
AHL
VIEW - AHL_RESOURCE_MAPPINGS#
[top of page]
Table: AHL_RESOURCE_SKILLS
Description: This table stores the relationship between the ASO resource and HR's skill type, skill lvevl and certifiaction. It should be obsolete for next release.
Primary Key: AHL_RESOURCE_SKILLS_PK
RESOURCE_SKILL_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_RESOURCE_SKILLS.AHL_RESOURCE_ID
AHL_RESOURCES
AHL_RESOURCE_SKILLS.COMPETENCE_ID
PER_COMPETENCES
AHL_RESOURCE_SKILLS.RATING_LEVEL_ID
PER_RATING_LEVELS
AHL_RESOURCE_SKILLS.QUALIFICATION_TYPE_ID
PER_QUALIFICATION_TYPES
[top of page]
AHL.AHL_RESOURCE_SKILLS does not reference any database object
AHL.AHL_RESOURCE_SKILLS is referenced by following:
AHL
VIEW - AHL_RESOURCE_SKILLS#
[top of page]
Table: AHL_ROUTES_B
Description: This table stores the Route attributes.
Primary Key: AHL_ROUTES_B_PK
ROUTE_ID
Primary Key: AHL_ROUTES_B_UK1
ROUTE_NO
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_ROUTES_B.OPERATOR_PARTY_ID
HZ_PARTIES
AHL_ROUTES_B.QA_PLAN_ID
QA_PLANS
AHL_ROUTES_B.SERVICE_ITEM_ID
SERVICE_ITEM_ORG_ID
MTL_SYSTEM_ITEMS_B
AHL_ROUTES_B.TASK_TEMPLATE_GROUP_ID
JTF_TASK_TEMP_GROUPS_B
AHL_ROUTES_B.ACCOUNTING_CLASS_CODE
ACCOUNTING_CLASS_ORG_ID
WIP_ACCOUNTING_CLASSES
AHL_ROUTES_B.WARRANTY_TEMPLATE_ID
%
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AHL_DOC_TITLE_ASSOS_B.ASO_OBJECT_ID
AHL_ROUTES_B
AHL_MR_ROUTES.ROUTE_ID
AHL_ROUTES_B
AHL_ROUTES_H_B.ROUTE_ID
AHL_ROUTES_B
AHL_ROUTES_TL.ROUTE_ID
AHL_ROUTES_B
AHL_ROUTE_EFFECTIVITIES.ROUTE_ID
AHL_ROUTES_B
AHL_ROUTE_OPERATIONS.ROUTE_ID
AHL_ROUTES_B
AHL_ROUTE_OPERATIONS_H.ROUTE_ID
AHL_ROUTES_B
AHL_RT_OPER_ACCESS_PANELS.OBJECT_ID
AHL_ROUTES_B
AHL_RT_OPER_LABOR.OBJECT_ID
AHL_ROUTES_B
AHL_RT_OPER_LABOR_H.OBJECT_ID
AHL_ROUTES_B
AHL_RT_OPER_MATERIALS.OBJECT_ID
AHL_ROUTES_B
AHL_RT_OPER_MATERIALS_H.OBJECT_ID
AHL_ROUTES_B
AHL_RT_OPER_RESOURCES.OBJECT_ID
AHL_ROUTES_B
AHL_WORKORDERS.ROUTE_ID
AHL_ROUTES_B
[top of page]
AHL.AHL_ROUTES_B does not reference any database object
AHL.AHL_ROUTES_B is referenced by following:
AHL
VIEW - AHL_ROUTES_B#
[top of page]
Table: AHL_ROUTES_H_B
Description: History table for AHL_ROUTES_B.
Primary Key: AHL_ROUTES_H_B_PK
ROUTES_H_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_ROUTES_H_B.ROUTE_ID
AHL_ROUTES_B
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AHL_ROUTES_H_TL.ROUTES_H_ID
AHL_ROUTES_H_B
[top of page]
AHL.AHL_ROUTES_H_B does not reference any database object
AHL.AHL_ROUTES_H_B is referenced by following:
AHL
VIEW - AHL_ROUTES_H_B#
[top of page]
Table: AHL_ROUTES_H_TL
Description: This table stores the translated Route history attributes.
Primary Key: AHL_ROUTES_H_TL_PK
ROUTES_H_ID
LANGUAGE
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_ROUTES_H_TL.ROUTES_H_ID
AHL_ROUTES_H_B
[top of page]
AHL.AHL_ROUTES_H_TL does not reference any database object
AHL.AHL_ROUTES_H_TL is referenced by following:
AHL
VIEW - AHL_ROUTES_H_TL#
[top of page]
Table: AHL_ROUTES_TL
Description: This table stores the translated Route attributes.
Primary Key: AHL_ROUTES_TL_PK
ROUTE_ID
LANGUAGE
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_ROUTES_TL.ROUTE_ID
AHL_ROUTES_B
[top of page]
AHL.AHL_ROUTES_TL does not reference any database object
AHL.AHL_ROUTES_TL is referenced by following:
AHL
VIEW - AHL_ROUTES_TL#
[top of page]
Table: AHL_ROUTE_EFFECTIVITIES
Description: This table stores the Route Effectivity Attributes.
Primary Key: AHL_ROUTE_EFFECTIVITIES_PK
ROUTE_EFFECTIVITY_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_ROUTE_EFFECTIVITIES.ROUTE_ID
AHL_ROUTES_B
AHL_ROUTE_EFFECTIVITIES.INVENTORY_ITEM_ID
INVENTORY_MASTER_ORG_ID
MTL_SYSTEM_ITEMS_B
AHL_ROUTE_EFFECTIVITIES.MC_HEADER_ID
AHL_MC_HEADERS_B
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AHL_RT_OPER_MATERIALS.OBJECT_ID
AHL_ROUTE_EFFECTIVITIES
[top of page]
AHL.AHL_ROUTE_EFFECTIVITIES does not reference any database object
AHL.AHL_ROUTE_EFFECTIVITIES is referenced by following:
AHL
VIEW - AHL_ROUTE_EFFECTIVITIES#
[top of page]
Table: AHL_ROUTE_OPERATIONS
Description: This table stores the association between Routes and Operations.
Primary Key: AHL_ROUTE_OPERATIONS_PK
ROUTE_OPERATION_ID
Primary Key: AHL_ROUTE_OPERATIONS_UK1
ROUTE_ID
OPERATION_ID
STEP
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_ROUTE_OPERATIONS.ROUTE_ID
AHL_ROUTES_B
AHL_ROUTE_OPERATIONS.OPERATION_ID
AHL_OPERATIONS_B
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AHL_ROUTE_OPERATIONS_H.ROUTE_OPERATION_ID
AHL_ROUTE_OPERATIONS
[top of page]
AHL.AHL_ROUTE_OPERATIONS does not reference any database object
AHL.AHL_ROUTE_OPERATIONS is referenced by following:
AHL
VIEW - AHL_ROUTE_OPERATIONS#
[top of page]
Table: AHL_ROUTE_OPERATIONS_H
Description: History table for AHL_ROUTE_OPERATIONS.
Primary Key: AHL_ROUTE_OPERATIONS_H_PK
ROUTE_OPERATIONS_H_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_ROUTE_OPERATIONS_H.ROUTE_OPERATION_ID
AHL_ROUTE_OPERATIONS
AHL_ROUTE_OPERATIONS_H.ROUTE_ID
AHL_ROUTES_B
AHL_ROUTE_OPERATIONS_H.OPERATION_ID
AHL_OPERATIONS_B
[top of page]
AHL.AHL_ROUTE_OPERATIONS_H does not reference any database object
AHL.AHL_ROUTE_OPERATIONS_H is referenced by following:
AHL
VIEW - AHL_ROUTE_OPERATIONS_H#
[top of page]
Table: AHL_RT_OPER_ACCESS_PANELS
Description: This table stores the access panels associated with a Route or an Operation.
Primary Key: AHL_RT_OPER_ACCESS_PANELS_PK
RT_OPER_PANEL_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_RT_OPER_ACCESS_PANELS.OBJECT_ID
AHL_ROUTES_B
AHL_RT_OPER_ACCESS_PANELS.OBJECT_ID
AHL_OPERATIONS_B
[top of page]
AHL.AHL_RT_OPER_ACCESS_PANELS does not reference any database object
AHL.AHL_RT_OPER_ACCESS_PANELS is referenced by following:
AHL
VIEW - AHL_RT_OPER_ACCESS_PANELS#
[top of page]
Table: AHL_RT_OPER_DEPENDENCIES
[top of page]
AHL.AHL_RT_OPER_DEPENDENCIES does not reference any database object
AHL.AHL_RT_OPER_DEPENDENCIES is referenced by following:
AHL
VIEW - AHL_RT_OPER_DEPENDENCIES#
[top of page]
Table: AHL_RT_OPER_INTERFACE
[top of page]
AHL.AHL_RT_OPER_INTERFACE does not reference any database object
AHL.AHL_RT_OPER_INTERFACE is referenced by following:
AHL
VIEW - AHL_RT_OPER_INTERFACE#
[top of page]
Table: AHL_RT_OPER_LABOR
Description: This table stores the labor requirements for a Route or an Operation.
Primary Key: AHL_RT_OPER_LABOR_PK
RT_OPER_LABOR_ID
Primary Key: AHL_RT_OPER_LABOR_UK1
OBJECT_ID
SKILL_COMPETENCE_ID
SKILL_RATING_LEVEL_ID
ASSOCIATION_TYPE_CODE
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_RT_OPER_LABOR.OBJECT_ID
AHL_ROUTES_B
AHL_RT_OPER_LABOR.OBJECT_ID
AHL_OPERATIONS_B
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AHL_RT_OPER_LABOR_H.RT_OPER_LABOR_ID
AHL_RT_OPER_LABOR
[top of page]
AHL.AHL_RT_OPER_LABOR does not reference any database object
AHL.AHL_RT_OPER_LABOR is referenced by following:
AHL
VIEW - AHL_RT_OPER_LABOR#
[top of page]
Table: AHL_RT_OPER_LABOR_H
Description: History table for AHL_RT_OPER_LABOR.
Primary Key: AHL_RT_OPER_LABOR_H_PK
RT_OPER_LABOR_H_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_RT_OPER_LABOR_H.RT_OPER_LABOR_ID
AHL_RT_OPER_LABOR
AHL_RT_OPER_LABOR_H.OBJECT_ID
AHL_ROUTES_B
AHL_RT_OPER_LABOR_H.OBJECT_ID
AHL_OPERATIONS_B
[top of page]
AHL.AHL_RT_OPER_LABOR_H does not reference any database object
AHL.AHL_RT_OPER_LABOR_H is referenced by following:
AHL
VIEW - AHL_RT_OPER_LABOR_H#
[top of page]
Table: AHL_RT_OPER_MATERIALS
Description: This table stores the material and tool requirements for a Route or an Operation.
Primary Key: AHL_RT_OPER_MATERIALS_PK
RT_OPER_MATERIAL_ID
Primary Key: AHL_RT_OPER_MATERIALS_UK1
OBJECT_ID
INVENTORY_ITEM_ID
INVENTORY_ORG_ID
POSITION_PATH_ID
ASSOCIATION_TYPE_CODE
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_RT_OPER_MATERIALS.INVENTORY_ITEM_ID
INVENTORY_ORG_ID
MTL_SYSTEM_ITEMS_B
AHL_RT_OPER_MATERIALS.OBJECT_ID
AHL_ROUTES_B
AHL_RT_OPER_MATERIALS.OBJECT_ID
AHL_OPERATIONS_B
AHL_RT_OPER_MATERIALS.ITEM_GROUP_ID
AHL_ITEM_GROUPS_B
AHL_RT_OPER_MATERIALS.POSITION_PATH_ID
AHL_MC_PATH_POSITIONS
AHL_RT_OPER_MATERIALS.ITEM_COMP_DETAIL_ID
AHL_ITEM_COMP_DETAILS
AHL_RT_OPER_MATERIALS.OBJECT_ID
AHL_ROUTE_EFFECTIVITIES
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AHL_RT_OPER_MATERIALS_H.RT_OPER_MATERIAL_ID
AHL_RT_OPER_MATERIALS
[top of page]
AHL.AHL_RT_OPER_MATERIALS does not reference any database object
AHL.AHL_RT_OPER_MATERIALS is referenced by following:
AHL
VIEW - AHL_RT_OPER_MATERIALS#
[top of page]
Table: AHL_RT_OPER_MATERIALS_H
Description: History table for AHL_RT_OPER_MATERIALS.
Primary Key: AHL_RT_OPER_MATERIALS_H_PK
RT_OPER_MATERIALS_H_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_RT_OPER_MATERIALS_H.RT_OPER_MATERIAL_ID
AHL_RT_OPER_MATERIALS
AHL_RT_OPER_MATERIALS_H.INVENTORY_ITEM_ID
INVENTORY_ORG_ID
MTL_SYSTEM_ITEMS_B
AHL_RT_OPER_MATERIALS_H.OBJECT_ID
AHL_ROUTES_B
AHL_RT_OPER_MATERIALS_H.OBJECT_ID
AHL_OPERATIONS_B
[top of page]
AHL.AHL_RT_OPER_MATERIALS_H does not reference any database object
AHL.AHL_RT_OPER_MATERIALS_H is referenced by following:
AHL
VIEW - AHL_RT_OPER_MATERIALS_H#
[top of page]
Table: AHL_RT_OPER_RESOURCES
Description: This table stores the resource requirements for a Route or an Operation.
Primary Key: AHL_RT_OPER_RESOURCES_PK
RT_OPER_RESOURCE_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_RT_OPER_RESOURCES.ASO_RESOURCE_ID
AHL_RESOURCES
AHL_RT_OPER_RESOURCES.OBJECT_ID
AHL_ROUTES_B
AHL_RT_OPER_RESOURCES.OBJECT_ID
AHL_OPERATIONS_B
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AHL_ALTERNATE_RESOURCES.RT_OPER_RESOURCE_ID
AHL_RT_OPER_RESOURCES
[top of page]
AHL.AHL_RT_OPER_RESOURCES does not reference any database object
AHL.AHL_RT_OPER_RESOURCES is referenced by following:
AHL
VIEW - AHL_RT_OPER_RESOURCES#
[top of page]
Table: AHL_SB_POSITION_RULES
[top of page]
AHL.AHL_SB_POSITION_RULES does not reference any database object
AHL.AHL_SB_POSITION_RULES is referenced by following:
AHL
VIEW - AHL_SB_POSITION_RULES#
[top of page]
Table: AHL_SB_RULE_ITEMS
[top of page]
AHL.AHL_SB_RULE_ITEMS does not reference any database object
AHL.AHL_SB_RULE_ITEMS is referenced by following:
AHL
VIEW - AHL_SB_RULE_ITEMS#
[top of page]
Table: AHL_SCHEDULE_MATERIALS
Description: This table stores information about materials scheduled in MRP
Primary Key: AHL_SCHEDULED_MATERIALS_PK
SCHEDULED_MATERIAL_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_SCHEDULE_MATERIALS.VISIT_TASK_ID
AHL_VISIT_TASKS_B
AHL_SCHEDULE_MATERIALS.WORKORDER_OPERATION_ID
AHL_WORKORDER_OPERATIONS
AHL_SCHEDULE_MATERIALS.UNIT_EFFECTIVITY_ID
AHL_UNIT_EFFECTIVITIES_B
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AHL_WO_OPERATIONS_TXNS.SCHEDULE_MATERIAL_ID
AHL_SCHEDULE_MATERIALS
[top of page]
AHL.AHL_SCHEDULE_MATERIALS does not reference any database object
AHL.AHL_SCHEDULE_MATERIALS is referenced by following:
AHL
VIEW - AHL_SCHEDULE_MATERIALS#
[top of page]
Table: AHL_SIMULATION_PLANS_B
Description: This table stores information about simulation plans
Primary Key: AHL_SIMULATION_PLANS_B_PK
SIMULATION_PLAN_ID
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AHL_SIMULATION_PLANS_TL.SIMULATION_PLAN_ID
AHL_SIMULATION_PLANS_B
AHL_VISITS_B.SIMULATION_PLAN_ID
AHL_SIMULATION_PLANS_B
[top of page]
AHL.AHL_SIMULATION_PLANS_B does not reference any database object
AHL.AHL_SIMULATION_PLANS_B is referenced by following:
AHL
VIEW - AHL_SIMULATION_PLANS_B#
[top of page]
Table: AHL_SIMULATION_PLANS_TL
Description: This table stores information about translated columns for simulation plans
Primary Key: AHL_SIMULATION_PLANS_TL_PK
SIMULATION_PLAN_ID
LANGUAGE
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_SIMULATION_PLANS_TL.SIMULATION_PLAN_ID
AHL_SIMULATION_PLANS_B
[top of page]
AHL.AHL_SIMULATION_PLANS_TL does not reference any database object
AHL.AHL_SIMULATION_PLANS_TL is referenced by following:
AHL
VIEW - AHL_SIMULATION_PLANS_TL#
[top of page]
Table: AHL_SNAPSHOTS
Description: This table stores information about SnapShots.
Primary Key: AHL_SNAPSHOTS_PK
SNAPSHOT_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_SNAPSHOTS.VISIT_ID
AHL_VISITS_B
AHL_SNAPSHOTS.VISIT_TASK_ID
AHL_VISIT_TASKS_B
AHL_SNAPSHOTS.MR_ID
AHL_MR_HEADERS_B
[top of page]
AHL.AHL_SNAPSHOTS does not reference any database object
AHL.AHL_SNAPSHOTS is referenced by following:
AHL
VIEW - AHL_SNAPSHOTS#
[top of page]
Table: AHL_SPACES_B
Description: This table stores information about spaces
Primary Key: AHL_SPACES_B_PK
SPACE_ID
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AHL_SPACES_TL.SPACE_ID
AHL_SPACES_B
AHL_SPACE_ASSIGNMENTS.SPACE_ID
AHL_SPACES_B
AHL_SPACE_CAPABILITIES.SPACE_ID
AHL_SPACES_B
AHL_SPACE_UNAVAILABLE_B.SPACE_ID
AHL_SPACES_B
[top of page]
AHL.AHL_SPACES_B does not reference any database object
AHL.AHL_SPACES_B is referenced by following:
AHL
VIEW - AHL_SPACES_B#
[top of page]
Table: AHL_SPACES_TL
Description: This table stores information about translated columns for spaces
Primary Key: AHL_SPACES_TL_PK
SPACE_ID
LANGUAGE
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_SPACES_TL.SPACE_ID
AHL_SPACES_B
[top of page]
AHL.AHL_SPACES_TL does not reference any database object
AHL.AHL_SPACES_TL is referenced by following:
AHL
VIEW - AHL_SPACES_TL#
[top of page]
Table: AHL_SPACE_ASSIGNMENTS
Description: This table stores information about space assignments
Primary Key: AHL_SPACE_ASSIGNMENTS_PK
SPACE_ASSIGNMENT_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_SPACE_ASSIGNMENTS.VISIT_ID
AHL_VISITS_B
AHL_SPACE_ASSIGNMENTS.SPACE_ID
AHL_SPACES_B
[top of page]
AHL.AHL_SPACE_ASSIGNMENTS does not reference any database object
AHL.AHL_SPACE_ASSIGNMENTS is referenced by following:
AHL
VIEW - AHL_SPACE_ASSIGNMENTS#
[top of page]
Table: AHL_SPACE_CAPABILITIES
Description: This table stores information about space capabilities
Primary Key: AHL_SPACE_CAPABILITIES_PK
SPACE_CAPABILITY_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_SPACE_CAPABILITIES.SPACE_ID
AHL_SPACES_B
[top of page]
AHL.AHL_SPACE_CAPABILITIES does not reference any database object
AHL.AHL_SPACE_CAPABILITIES is referenced by following:
AHL
VIEW - AHL_SPACE_CAPABILITIES#
[top of page]
Table: AHL_SPACE_UNAVAILABLE_B
Description: This table stores information about space restrictions
Primary Key: AHL_SPACE_UNAVAILABLE_B_PK
SPACE_UNAVAILABILITY_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_SPACE_UNAVAILABLE_B.SPACE_ID
AHL_SPACES_B
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AHL_SPACE_UNAVAILABLE_TL.SPACE_UNAVAILABILITY_ID
AHL_SPACE_UNAVAILABLE_B
[top of page]
AHL.AHL_SPACE_UNAVAILABLE_B does not reference any database object
AHL.AHL_SPACE_UNAVAILABLE_B is referenced by following:
AHL
VIEW - AHL_SPACE_UNAVAILABLE_B#
[top of page]
Table: AHL_SPACE_UNAVAILABLE_TL
Description: This table stores information about space restrictions(Translation Table)
Primary Key: AHL_SPACE_UNAVAILABLE_TL_PK
SPACE_UNAVAILABILITY_ID
LANGUAGE
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_SPACE_UNAVAILABLE_TL.SPACE_UNAVAILABILITY_ID
AHL_SPACE_UNAVAILABLE_B
[top of page]
AHL.AHL_SPACE_UNAVAILABLE_TL does not reference any database object
AHL.AHL_SPACE_UNAVAILABLE_TL is referenced by following:
AHL
VIEW - AHL_SPACE_UNAVAILABLE_TL#
[top of page]
Table: AHL_STAGE_LINKS
[top of page]
AHL.AHL_STAGE_LINKS does not reference any database object
AHL.AHL_STAGE_LINKS is referenced by following:
AHL
VIEW - AHL_STAGE_LINKS#
[top of page]
Table: AHL_STATUS_ORDER_RULES
Description: This table stores status order rules for any aso object
Primary Key: AHL_STATUS_ORDER_RULES_PK
STATUS_ORDER_RULE_ID
[top of page]
AHL.AHL_STATUS_ORDER_RULES does not reference any database object
AHL.AHL_STATUS_ORDER_RULES is referenced by following:
AHL
VIEW - AHL_STATUS_ORDER_RULES#
[top of page]
Table: AHL_SUBSCRIPTIONS_B
Description: This table stores information about subscriptions for documents.
Primary Key: AHL_SUBSCRIPTIONS_B_PK
SUBSCRIPTION_ID
Primary Key: AHL_SUBSCRIPTIONS_B_UK1
DOCUMENT_ID
REQUESTED_BY_PARTY_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_SUBSCRIPTIONS_B.DOCUMENT_ID
AHL_DOCUMENTS_B
AHL_SUBSCRIPTIONS_B.REQUESTED_BY_PARTY_ID
HZ_PARTIES
AHL_SUBSCRIPTIONS_B.SUBSCRIBED_FRM_PARTY_ID
HZ_PARTIES
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AHL_SUBSCRIPTIONS_TL.SUBSCRIPTION_ID
AHL_SUBSCRIPTIONS_B
[top of page]
AHL.AHL_SUBSCRIPTIONS_B does not reference any database object
AHL.AHL_SUBSCRIPTIONS_B is referenced by following:
AHL
VIEW - AHL_SUBSCRIPTIONS_B#
[top of page]
Table: AHL_SUBSCRIPTIONS_TL
Description: This table stores the translated columns of subscription information for a document.
Primary Key: AHL_SUBSCRIPTIONS_TL_PK
SUBSCRIPTION_ID
LANGUAGE
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_SUBSCRIPTIONS_TL.SUBSCRIPTION_ID
AHL_SUBSCRIPTIONS_B
[top of page]
AHL.AHL_SUBSCRIPTIONS_TL does not reference any database object
AHL.AHL_SUBSCRIPTIONS_TL is referenced by following:
AHL
VIEW - AHL_SUBSCRIPTIONS_TL#
[top of page]
Table: AHL_SUPPLIER_DOCUMENTS
Description: This table stores supplier information for documents.
Primary Key: AHL_SUPPLIER_DOCUMENTS_PK
SUPPLIER_DOCUMENT_ID
Primary Key: AHL_SUPPLIER_DOCUMENTS_UK1
SUPPLIER_ID
DOCUMENT_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_SUPPLIER_DOCUMENTS.SUPPLIER_ID
HZ_PARTIES
AHL_SUPPLIER_DOCUMENTS.SUPPLIER_ID
PO_VENDORS
AHL_SUPPLIER_DOCUMENTS.DOCUMENT_ID
AHL_DOCUMENTS_B
[top of page]
AHL.AHL_SUPPLIER_DOCUMENTS does not reference any database object
AHL.AHL_SUPPLIER_DOCUMENTS is referenced by following:
AHL
VIEW - AHL_SUPPLIER_DOCUMENTS#
[top of page]
Table: AHL_TASK_LINKS
Description: This table stores information about task links between different ahl tasks
Primary Key: AHL_TASK_LINKS_PK
TASK_LINK_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_TASK_LINKS.VISIT_TASK_ID
AHL_VISIT_TASKS_B
AHL_TASK_LINKS.PARENT_TASK_ID
AHL_VISIT_TASKS_B
[top of page]
AHL.AHL_TASK_LINKS does not reference any database object
AHL.AHL_TASK_LINKS is referenced by following:
AHL
VIEW - AHL_TASK_LINKS#
[top of page]
Table: AHL_TEMP_UNIT_EFFECTIVITIES1
[top of page]
AHL.AHL_TEMP_UNIT_EFFECTIVITIES1 does not reference any database object
AHL.AHL_TEMP_UNIT_EFFECTIVITIES1 is referenced by following:
APPS
SYNONYM - AHL_TEMP_UNIT_EFFECTIVITIES
SYNONYM - AHL_TEMP_UNIT_EFFECTIVITIES1
[top of page]
Table: AHL_UC_DETAILS_FOR_HGRID
[top of page]
APPS.AHL_UC_DETAILS_FOR_HGRID does not reference any database object
APPS.AHL_UC_DETAILS_FOR_HGRID is referenced by following:
APPS
PACKAGE BODY - AHL_PRD_BLK_PARTS_CHANGE_PVT
[top of page]
Table: AHL_UC_HEADERS_H
Description: History table of ahl_unit_config_headers. To keep the changes of each unit configuration.
Primary Key: AHL_UC_HEADERS_H_PK
UNIT_CONFIG_HEADER_ID
VERSION_NO
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_UC_HEADERS_H.UNIT_CONFIG_HEADER_ID
AHL_UNIT_CONFIG_HEADERS
AHL_UC_HEADERS_H.MASTER_CONFIG_ID
AHL_MC_HEADERS_B
AHL_UC_HEADERS_H.CSI_ITEM_INSTANCE_ID
CSI_ITEM_INSTANCES
AHL_UC_HEADERS_H.PARENT_UC_HEADER_ID
AHL_UNIT_CONFIG_HEADERS
[top of page]
AHL.AHL_UC_HEADERS_H does not reference any database object
AHL.AHL_UC_HEADERS_H is referenced by following:
AHL
VIEW - AHL_UC_HEADERS_H#
[top of page]
Table: AHL_UE_RELATIONSHIPS
Description: This table stores information about the relationships between unit effectivities.
Primary Key: AHL_UE_RELATIONSHIPS_PK
UE_RELATIONSHIP_ID
Primary Key: AHL_UE_RELATIONSHIPS_UK1
RELATIONSHIP_CODE
RELATED_UE_ID
UE_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_UE_RELATIONSHIPS.UE_ID
AHL_UNIT_EFFECTIVITIES_B
AHL_UE_RELATIONSHIPS.RELATED_UE_ID
AHL_UNIT_EFFECTIVITIES_B
[top of page]
AHL.AHL_UE_RELATIONSHIPS does not reference any database object
AHL.AHL_UE_RELATIONSHIPS is referenced by following:
AHL
VIEW - AHL_UE_RELATIONSHIPS#
[top of page]
Table: AHL_UE_SIMULATIONS
[top of page]
AHL.AHL_UE_SIMULATIONS does not reference any database object
AHL.AHL_UE_SIMULATIONS is referenced by following:
AHL
VIEW - AHL_UE_SIMULATIONS#
[top of page]
Table: AHL_UF_DETAILS
Description: This table stores information about unit forcast details
Primary Key: AHL_UF_DETAILS_UK1
UF_HEADER_ID
UOM_CODE
START_DATE
Primary Key: UF_DETAIL_ID
UF_DETAIL_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_UF_DETAILS.UF_HEADER_ID
AHL_UF_HEADERS
[top of page]
AHL.AHL_UF_DETAILS does not reference any database object
AHL.AHL_UF_DETAILS is referenced by following:
AHL
VIEW - AHL_UF_DETAILS#
[top of page]
Table: AHL_UF_HEADERS
Description: This table stores information about utilization forecast header.
Primary Key: UF_HEADER_ID
UF_HEADER_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_UF_HEADERS.UNIT_CONFIG_HEADER_ID
AHL_UNIT_CONFIG_HEADERS
AHL_UF_HEADERS.INVENTORY_ITEM_ID
INVENTORY_ORG_ID
MTL_SYSTEM_ITEMS_B
AHL_UF_HEADERS.CSI_ITEM_INSTANCE_ID
CSI_ITEM_INSTANCES
AHL_UF_HEADERS.PC_NODE_ID
AHL_PC_NODES_B
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AHL_UF_DETAILS.UF_HEADER_ID
AHL_UF_HEADERS
[top of page]
AHL.AHL_UF_HEADERS does not reference any database object
AHL.AHL_UF_HEADERS is referenced by following:
AHL
VIEW - AHL_UF_HEADERS#
[top of page]
Table: AHL_UMP_MAINT_REQMNTS
[top of page]
AHL.AHL_UMP_MAINT_REQMNTS does not reference any database object
AHL.AHL_UMP_MAINT_REQMNTS is referenced by following:
AHL
VIEW - AHL_UMP_MAINT_REQMNTS#
[top of page]
Table: AHL_UMP_MATERIAL_REQMNTS
[top of page]
AHL.AHL_UMP_MATERIAL_REQMNTS does not reference any database object
AHL.AHL_UMP_MATERIAL_REQMNTS is referenced by following:
AHL
VIEW - AHL_UMP_MATERIAL_REQMNTS#
[top of page]
Table: AHL_UMP_RESOURCE_REQMNTS
[top of page]
AHL.AHL_UMP_RESOURCE_REQMNTS does not reference any database object
AHL.AHL_UMP_RESOURCE_REQMNTS is referenced by following:
AHL
VIEW - AHL_UMP_RESOURCE_REQMNTS#
[top of page]
Table: AHL_UNIT_ACCOMPLISHMNTS
Description: This table will contain all instances counter values at the time of accomplishment.
Primary Key: AHL_UNIT_ACCOMPLISHMNTS_PK
UNIT_ACCOMPLISHMNT_ID
Primary Key: AHL_UNIT_ACCOMPLISHMNTS_UK1
UNIT_EFFECTIVITY_ID
COUNTER_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_UNIT_ACCOMPLISHMNTS.UNIT_EFFECTIVITY_ID
AHL_UNIT_EFFECTIVITIES_B
[top of page]
AHL.AHL_UNIT_ACCOMPLISHMNTS does not reference any database object
AHL.AHL_UNIT_ACCOMPLISHMNTS is referenced by following:
AHL
VIEW - AHL_UNIT_ACCOMPLISHMNTS#
[top of page]
Table: AHL_UNIT_CONFIG_HEADERS
Description: Unit Configuration represents a complex equipment. A unit configuration is constructed from a master configuration template. This table stores information about the unit configuration name and the master configuration it was constructed fro
Primary Key: AHL_UNIT_CONFIG_HEADERS_PK
UNIT_CONFIG_HEADER_ID
Primary Key: AHL_UNIT_CONFIG_HEADERS_UK1
NAME
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_UNIT_CONFIG_HEADERS.MASTER_CONFIG_ID
AHL_MC_HEADERS_B
AHL_UNIT_CONFIG_HEADERS.CSI_ITEM_INSTANCE_ID
CSI_ITEM_INSTANCES
AHL_UNIT_CONFIG_HEADERS.PARENT_UC_HEADER_ID
AHL_UNIT_CONFIG_HEADERS
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AHL_PART_CHANGES.UNIT_CONFIG_HEADER_ID
AHL_UNIT_CONFIG_HEADERS
AHL_PC_ASSOCIATIONS.UNIT_ITEM_ID
AHL_UNIT_CONFIG_HEADERS
AHL_UC_HEADERS_H.UNIT_CONFIG_HEADER_ID
AHL_UNIT_CONFIG_HEADERS
AHL_UC_HEADERS_H.PARENT_UC_HEADER_ID
AHL_UNIT_CONFIG_HEADERS
AHL_UF_HEADERS.UNIT_CONFIG_HEADER_ID
AHL_UNIT_CONFIG_HEADERS
AHL_UNIT_CONFIG_HEADERS.PARENT_UC_HEADER_ID
AHL_UNIT_CONFIG_HEADERS
AHL_UNIT_EFFECTIVITIES_B.UNIT_CONFIG_HEADER_ID
AHL_UNIT_CONFIG_HEADERS
AHL_UNIT_SCHEDULES.UNIT_CONFIG_HEADER_ID
AHL_UNIT_CONFIG_HEADERS
[top of page]
AHL.AHL_UNIT_CONFIG_HEADERS does not reference any database object
AHL.AHL_UNIT_CONFIG_HEADERS is referenced by following:
AHL
VIEW - AHL_UNIT_CONFIG_HEADERS#
[top of page]
Table: AHL_UNIT_DEFERRALS_B
Description: This table holds the deferral and MR initialization information for a unit effectivity.
Primary Key: AHL_UNIT_DEFERRALS_B_PK
UNIT_DEFERRAL_ID
Primary Key: AHL_UNIT_DEFERRALS_B_UK
UNIT_EFFECTIVITY_ID
UNIT_DEFERRAL_TYPE
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_UNIT_DEFERRALS_B.UNIT_EFFECTIVITY_ID
AHL_UNIT_EFFECTIVITIES_B
AHL_UNIT_DEFERRALS_B.ATA_SEQUENCE_ID
AHL_MEL_CDL_ATA_SEQUENCES
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AHL_UNIT_DEFERRALS_TL.UNIT_DEFERRAL_ID
AHL_UNIT_DEFERRALS_B
AHL_UNIT_THRESHOLDS.UNIT_DEFERRAL_ID
AHL_UNIT_DEFERRALS_B
[top of page]
AHL.AHL_UNIT_DEFERRALS_B does not reference any database object
AHL.AHL_UNIT_DEFERRALS_B is referenced by following:
AHL
VIEW - AHL_UNIT_DEFERRALS_B#
[top of page]
Table: AHL_UNIT_DEFERRALS_TL
Description: Translation table for AHL_UNIT_DEFFRALS_B
Primary Key: AHL_UNIT_DEFERRALS_TL_PK
UNIT_DEFERRAL_ID
LANGUAGE
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_UNIT_DEFERRALS_TL.UNIT_DEFERRAL_ID
AHL_UNIT_DEFERRALS_B
[top of page]
AHL.AHL_UNIT_DEFERRALS_TL does not reference any database object
AHL.AHL_UNIT_DEFERRALS_TL is referenced by following:
AHL
VIEW - AHL_UNIT_DEFERRALS_TL#
[top of page]
Table: AHL_UNIT_EFFECTIVITIES_B
Description: This table stores the applicable maintenance requirements for all units and their components.
Primary Key: AHL_UNIT_EFFECTIVITIES_B_UK1
LOG_SERIES_NUMBER
Primary Key: UNIT_EFFECTIVITY_ID
UNIT_EFFECTIVITY_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_UNIT_EFFECTIVITIES_B.CSI_ITEM_INSTANCE_ID
CSI_ITEM_INSTANCES
AHL_UNIT_EFFECTIVITIES_B.DEFER_FROM_UE_ID
AHL_UNIT_EFFECTIVITIES_B
AHL_UNIT_EFFECTIVITIES_B.ORIG_DEFERRAL_UE_ID
AHL_UNIT_EFFECTIVITIES_B
AHL_UNIT_EFFECTIVITIES_B.PRECEDING_UE_ID
AHL_UNIT_EFFECTIVITIES_B
AHL_UNIT_EFFECTIVITIES_B.POSITION_PATH_ID
AHL_MC_PATH_POSITIONS
AHL_UNIT_EFFECTIVITIES_B.CLEAR_STATION_ORG_ID
HR_ALL_ORGANIZATION_UNITS
AHL_UNIT_EFFECTIVITIES_B.CLEAR_STATION_DEPT_ID
BOM_DEPARTMENTS
AHL_UNIT_EFFECTIVITIES_B.UNIT_CONFIG_HEADER_ID
AHL_UNIT_CONFIG_HEADERS
AHL_UNIT_EFFECTIVITIES_B.MR_HEADER_ID
AHL_MR_HEADERS_B
AHL_UNIT_EFFECTIVITIES_B.MR_INTERVAL_ID
AHL_MR_INTERVALS
AHL_UNIT_EFFECTIVITIES_B.PROGRAM_MR_HEADER_ID
AHL_MR_HEADERS_B
AHL_UNIT_EFFECTIVITIES_B.SERVICE_LINE_ID
OKC_K_LINES_B
AHL_UNIT_EFFECTIVITIES_B.MR_EFFECTIVITY_ID
AHL_MR_EFFECTIVITIES
AHL_UNIT_EFFECTIVITIES_B.CS_INCIDENT_ID
CS_INCIDENTS_ALL_B
AHL_UNIT_EFFECTIVITIES_B.PROGRAM_MR_HEADER_ID
AHL_MR_HEADERS_B
AHL_UNIT_EFFECTIVITIES_B.COUNTER_ID
CS_COUNTERS
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AHL_SCHEDULE_MATERIALS.UNIT_EFFECTIVITY_ID
AHL_UNIT_EFFECTIVITIES_B
AHL_UE_RELATIONSHIPS.UE_ID
AHL_UNIT_EFFECTIVITIES_B
AHL_UE_RELATIONSHIPS.RELATED_UE_ID
AHL_UNIT_EFFECTIVITIES_B
AHL_UNIT_ACCOMPLISHMNTS.UNIT_EFFECTIVITY_ID
AHL_UNIT_EFFECTIVITIES_B
AHL_UNIT_DEFERRALS_B.UNIT_EFFECTIVITY_ID
AHL_UNIT_EFFECTIVITIES_B
AHL_UNIT_EFFECTIVITIES_B.DEFER_FROM_UE_ID
AHL_UNIT_EFFECTIVITIES_B
AHL_UNIT_EFFECTIVITIES_B.ORIG_DEFERRAL_UE_ID
AHL_UNIT_EFFECTIVITIES_B
AHL_UNIT_EFFECTIVITIES_B.PRECEDING_UE_ID
AHL_UNIT_EFFECTIVITIES_B
AHL_UNIT_EFFECTIVITIES_TL.UNIT_EFFECTIVITY_ID
AHL_UNIT_EFFECTIVITIES_B
AHL_VISIT_TASKS_B.UNIT_EFFECTIVITY_ID
AHL_UNIT_EFFECTIVITIES_B
[top of page]
AHL.AHL_UNIT_EFFECTIVITIES_B does not reference any database object
AHL.AHL_UNIT_EFFECTIVITIES_B is referenced by following:
AHL
VIEW - AHL_UNIT_EFFECTIVITIES_B#
[top of page]
Table: AHL_UNIT_EFFECTIVITIES_TL
Description: Translate table that for unit effectivities
Primary Key: AHL_UNIT_EFFECTIVITIES_TL_PK
UNIT_EFFECTIVITY_ID
LANGUAGE
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_UNIT_EFFECTIVITIES_TL.UNIT_EFFECTIVITY_ID
AHL_UNIT_EFFECTIVITIES_B
[top of page]
AHL.AHL_UNIT_EFFECTIVITIES_TL does not reference any database object
AHL.AHL_UNIT_EFFECTIVITIES_TL is referenced by following:
AHL
VIEW - AHL_UNIT_EFFECTIVITIES_TL#
[top of page]
Table: AHL_UNIT_SCHEDULES
Description: Event describing usage of a configured unit for a specific time period, such as an airplane flight.
Primary Key: AHL_UNIT_SCHEDULES_PK
UNIT_SCHEDULE_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_UNIT_SCHEDULES.UNIT_CONFIG_HEADER_ID
AHL_UNIT_CONFIG_HEADERS
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AHL_VISITS_B.UNIT_SCHEDULE_ID
AHL_UNIT_SCHEDULES
[top of page]
AHL.AHL_UNIT_SCHEDULES does not reference any database object
AHL.AHL_UNIT_SCHEDULES is referenced by following:
AHL
VIEW - AHL_UNIT_SCHEDULES#
[top of page]
Table: AHL_UNIT_THRESHOLDS
Description: This will store the item instance's threshold values, i.e Due at counter values, provided by Production or in cases where previous accomplishment data not available on the component and initial setup values are defined through Initializati
Primary Key: AHL_UNIT_THRESHOLDS_PK
UNIT_THRESHOLD_ID
Primary Key: AHL_UNIT_THRESHOLDS_UK1
UNIT_EFFECTIVITY_ID
COUNTER_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_UNIT_THRESHOLDS.UNIT_DEFERRAL_ID
AHL_UNIT_DEFERRALS_B
AHL_UNIT_THRESHOLDS.COUNTER_ID
CS_COUNTERS
[top of page]
AHL.AHL_UNIT_THRESHOLDS does not reference any database object
AHL.AHL_UNIT_THRESHOLDS is referenced by following:
AHL
VIEW - AHL_UNIT_THRESHOLDS#
[top of page]
Table: AHL_USER_STATUSES_B
Description: This table stores user status information
Primary Key: AHL_USER_STATUSES_B_PK
USER_STATUS_ID
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AHL_USER_STATUSES_TL.USER_STATUS_ID
AHL_USER_STATUSES_B
[top of page]
AHL.AHL_USER_STATUSES_B does not reference any database object
AHL.AHL_USER_STATUSES_B is referenced by following:
AHL
VIEW - AHL_USER_STATUSES_B#
[top of page]
Table: AHL_USER_STATUSES_TL
Description: This table stores translated information for user statuses
Primary Key: AHL_USER_STATUSES_TL_PK
USER_STATUS_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_USER_STATUSES_TL.USER_STATUS_ID
AHL_USER_STATUSES_B
[top of page]
AHL.AHL_USER_STATUSES_TL does not reference any database object
AHL.AHL_USER_STATUSES_TL is referenced by following:
AHL
VIEW - AHL_USER_STATUSES_TL#
[top of page]
Table: AHL_VENDOR_CERTIFICATIONS
Description: This table stores the vendors that can perform services during outside processing.
Primary Key: VENDOR_CERTIFICATION_ID
VENDOR_CERTIFICATION_ID
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AHL_ITEM_VENDOR_RELS.VENDOR_CERTIFICATION_ID
AHL_VENDOR_CERTIFICATIONS
[top of page]
AHL.AHL_VENDOR_CERTIFICATIONS does not reference any database object
AHL.AHL_VENDOR_CERTIFICATIONS is referenced by following:
AHL
VIEW - AHL_VENDOR_CERTIFICATIONS#
[top of page]
Table: AHL_VENDOR_CUSTOMER_RELS
Description: This table stores the association between vendor, vendor location and customer, customer location for use during outside processing.
Primary Key: VENDOR_CUSTOMER_REL_ID
VENDOR_CUSTOMER_REL_ID
[top of page]
AHL.AHL_VENDOR_CUSTOMER_RELS does not reference any database object
AHL.AHL_VENDOR_CUSTOMER_RELS is referenced by following:
AHL
VIEW - AHL_VENDOR_CUSTOMER_RELS#
[top of page]
Table: AHL_VISITS_B
Description: This table stores information about visits
Primary Key: AHL_VISITS_B_PK
VISIT_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_VISITS_B.SIMULATION_PLAN_ID
AHL_SIMULATION_PLANS_B
AHL_VISITS_B.PROJECT_ID
PA_PROJECTS_ALL
AHL_VISITS_B.SERVICE_REQUEST_ID
CS_INCIDENTS_ALL_B
AHL_VISITS_B.ITEM_INSTANCE_ID
CSI_ITEM_INSTANCES
AHL_VISITS_B.DEPARTMENT_ID
BOM_DEPARTMENTS
AHL_VISITS_B.INVENTORY_ITEM_ID
ITEM_ORGANIZATION_ID
MTL_SYSTEM_ITEMS_B
AHL_VISITS_B.UNIT_SCHEDULE_ID
AHL_UNIT_SCHEDULES
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AHL_SNAPSHOTS.VISIT_ID
AHL_VISITS_B
AHL_SPACE_ASSIGNMENTS.VISIT_ID
AHL_VISITS_B
AHL_VISITS_TL.VISIT_ID
AHL_VISITS_B
AHL_VISIT_TASKS_B.VISIT_ID
AHL_VISITS_B
AHL_VWP_STAGES_B.VISIT_ID
AHL_VISITS_B
AHL_WORKORDERS.VISIT_ID
AHL_VISITS_B
[top of page]
AHL.AHL_VISITS_B does not reference any database object
AHL.AHL_VISITS_B is referenced by following:
AHL
VIEW - AHL_VISITS_B#
[top of page]
Table: AHL_VISITS_TL
Description: This table stores information about translated columns for a visit
Primary Key: AHL_VISITS_PK
VISIT_ID
LANGUAGE
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_VISITS_TL.VISIT_ID
AHL_VISITS_B
[top of page]
AHL.AHL_VISITS_TL does not reference any database object
AHL.AHL_VISITS_TL is referenced by following:
AHL
VIEW - AHL_VISITS_TL#
[top of page]
Table: AHL_VISIT_INST_ROUTINGS
[top of page]
AHL.AHL_VISIT_INST_ROUTINGS does not reference any database object
AHL.AHL_VISIT_INST_ROUTINGS is referenced by following:
AHL
VIEW - AHL_VISIT_INST_ROUTINGS#
[top of page]
Table: AHL_VISIT_IR_UC_DETAILS
[top of page]
AHL.AHL_VISIT_IR_UC_DETAILS does not reference any database object
AHL.AHL_VISIT_IR_UC_DETAILS is referenced by following:
APPS
SYNONYM - AHL_VISIT_IR_UC_DETAILS
[top of page]
Table: AHL_VISIT_STAGE_TYP_ASOC
[top of page]
AHL.AHL_VISIT_STAGE_TYP_ASOC does not reference any database object
AHL.AHL_VISIT_STAGE_TYP_ASOC is referenced by following:
AHL
VIEW - AHL_VISIT_STAGE_TYP_ASOC#
[top of page]
Table: AHL_VISIT_TASKS_B
Description: This table stores information about visit tasks
Primary Key: AHL_VISIT_TASKS_B_PK
VISIT_TASK_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_VISIT_TASKS_B.VISIT_ID
AHL_VISITS_B
AHL_VISIT_TASKS_B.ORIGINATING_TASK_ID
AHL_VISIT_TASKS_B
AHL_VISIT_TASKS_B.STAGE_ID
AHL_VWP_STAGES_B
AHL_VISIT_TASKS_B.MR_ID
AHL_MR_HEADERS_B
AHL_VISIT_TASKS_B.MR_ROUTE_ID
AHL_MR_ROUTES
AHL_VISIT_TASKS_B.UNIT_EFFECTIVITY_ID
AHL_UNIT_EFFECTIVITIES_B
AHL_VISIT_TASKS_B.INSTANCE_ID
CSI_ITEM_INSTANCES
AHL_VISIT_TASKS_B.SERVICE_REQUEST_ID
CS_INCIDENTS_ALL_B
AHL_VISIT_TASKS_B.DEPARTMENT_ID
BOM_DEPARTMENTS
AHL_VISIT_TASKS_B.INVENTORY_ITEM_ID
ITEM_ORGANIZATION_ID
MTL_SYSTEM_ITEMS_B
AHL_VISIT_TASKS_B.PROJECT_TASK_ID
PA_TASKS
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AHL_SCHEDULE_MATERIALS.VISIT_TASK_ID
AHL_VISIT_TASKS_B
AHL_SNAPSHOTS.VISIT_TASK_ID
AHL_VISIT_TASKS_B
AHL_TASK_LINKS.VISIT_TASK_ID
AHL_VISIT_TASKS_B
AHL_TASK_LINKS.PARENT_TASK_ID
AHL_VISIT_TASKS_B
AHL_VISIT_TASKS_B.ORIGINATING_TASK_ID
AHL_VISIT_TASKS_B
AHL_VISIT_TASKS_TL.VISIT_TASK_ID
AHL_VISIT_TASKS_B
AHL_WARRANTY_ENTITLEMENTS.VISIT_TASK_ID
AHL_VISIT_TASKS_B
AHL_WORKORDERS.VISIT_TASK_ID
AHL_VISIT_TASKS_B
[top of page]
AHL.AHL_VISIT_TASKS_B does not reference any database object
AHL.AHL_VISIT_TASKS_B is referenced by following:
AHL
VIEW - AHL_VISIT_TASKS_B#
[top of page]
Table: AHL_VISIT_TASKS_TL
Description: This table stores information about translated columns for visit tasks
Primary Key: AHL_VISIT_TASKS_TL_PK
VISIT_TASK_ID
LANGUAGE
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_VISIT_TASKS_TL.VISIT_TASK_ID
AHL_VISIT_TASKS_B
[top of page]
AHL.AHL_VISIT_TASKS_TL does not reference any database object
AHL.AHL_VISIT_TASKS_TL is referenced by following:
AHL
VIEW - AHL_VISIT_TASKS_TL#
[top of page]
Table: AHL_VISIT_TYPES_B
[top of page]
AHL.AHL_VISIT_TYPES_B does not reference any database object
AHL.AHL_VISIT_TYPES_B is referenced by following:
AHL
VIEW - AHL_VISIT_TYPES_B#
[top of page]
Table: AHL_VISIT_TYPES_TL
[top of page]
AHL.AHL_VISIT_TYPES_TL does not reference any database object
AHL.AHL_VISIT_TYPES_TL is referenced by following:
AHL
VIEW - AHL_VISIT_TYPES_TL#
[top of page]
Table: AHL_VISIT_TYPE_STAGES_B
[top of page]
AHL.AHL_VISIT_TYPE_STAGES_B does not reference any database object
AHL.AHL_VISIT_TYPE_STAGES_B is referenced by following:
AHL
VIEW - AHL_VISIT_TYPE_STAGES_B#
[top of page]
Table: AHL_VISIT_TYPE_STAGES_TL
[top of page]
AHL.AHL_VISIT_TYPE_STAGES_TL does not reference any database object
AHL.AHL_VISIT_TYPE_STAGES_TL is referenced by following:
AHL
VIEW - AHL_VISIT_TYPE_STAGES_TL#
[top of page]
Table: AHL_VST_TYP_STAGE_LINKS
[top of page]
AHL.AHL_VST_TYP_STAGE_LINKS does not reference any database object
AHL.AHL_VST_TYP_STAGE_LINKS is referenced by following:
AHL
VIEW - AHL_VST_TYP_STAGE_LINKS#
[top of page]
Table: AHL_VST_TYP_STG_TYP_ASOC
[top of page]
AHL.AHL_VST_TYP_STG_TYP_ASOC does not reference any database object
AHL.AHL_VST_TYP_STG_TYP_ASOC is referenced by following:
AHL
VIEW - AHL_VST_TYP_STG_TYP_ASOC#
[top of page]
Table: AHL_VWP_STAGES_B
Description: This table stores information about stages
Primary Key: AHL_VWP_STAGES_B_PK
STAGE_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_VWP_STAGES_B.VISIT_ID
AHL_VISITS_B
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AHL_VISIT_TASKS_B.STAGE_ID
AHL_VWP_STAGES_B
AHL_VWP_STAGES_TL.STAGE_ID
AHL_VWP_STAGES_B
[top of page]
AHL.AHL_VWP_STAGES_B does not reference any database object
AHL.AHL_VWP_STAGES_B is referenced by following:
AHL
VIEW - AHL_VWP_STAGES_B#
[top of page]
Table: AHL_VWP_STAGES_TL
Description: This table stores information about translated columns for stages
Primary Key: AHL_VISIT_STAGES_TL_PK
STAGE_ID
LANGUAGE
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_VWP_STAGES_TL.STAGE_ID
AHL_VWP_STAGES_B
[top of page]
AHL.AHL_VWP_STAGES_TL does not reference any database object
AHL.AHL_VWP_STAGES_TL is referenced by following:
AHL
VIEW - AHL_VWP_STAGES_TL#
[top of page]
Table: AHL_WARRANTY_CLAIMS_B
Description: This table stores information of a Supplier Warranty Claim
Primary Key: AHL_WARRANTY_CLAIMS_B_PK
WARRANTY_CLAIM_ID
[top of page]
AHL.AHL_WARRANTY_CLAIMS_B does not reference any database object
AHL.AHL_WARRANTY_CLAIMS_B is referenced by following:
AHL
VIEW - AHL_WARRANTY_CLAIMS_B#
[top of page]
Table: AHL_WARRANTY_CLAIMS_TL
Description: This table stores the translated column information of a document revision.
Primary Key: AHL_WARRANTY_CLAIMS_TL_PK
LANGUAGE
WARRANTY_CLAIM_ID
[top of page]
AHL.AHL_WARRANTY_CLAIMS_TL does not reference any database object
AHL.AHL_WARRANTY_CLAIMS_TL is referenced by following:
AHL
VIEW - AHL_WARRANTY_CLAIMS_TL#
[top of page]
Table: AHL_WARRANTY_CONTRACTS_B
Description: Table to store Contract records
Primary Key: AHL_WARRANTY_CONTRACTS_B_PK1
WARRANTY_CONTRACT_ID
Primary Key: AHL_WARRANTY_CONTRACTS_B_UK1
CONTRACT_NUMBER
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_WARRANTY_CONTRACTS_B.ITEM_INSTANCE_ID
CSI_ITEM_INSTANCES
AHL_WARRANTY_CONTRACTS_B.WARRANTY_TEMPLATE_ID
AHL_WARRANTY_TEMPLATES_B
[top of page]
AHL.AHL_WARRANTY_CONTRACTS_B does not reference any database object
AHL.AHL_WARRANTY_CONTRACTS_B is referenced by following:
AHL
VIEW - AHL_WARRANTY_CONTRACTS_B#
[top of page]
Table: AHL_WARRANTY_CONTRACTS_TL
Primary Key: AHL_WARRANTY_CONTRACTS_TL_PK1
WARRANTY_CONTRACT_ID
LANGUAGE
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_WARRANTY_CONTRACTS_TL.WARRANTY_CONTRACT_ID
%
[top of page]
AHL.AHL_WARRANTY_CONTRACTS_TL does not reference any database object
AHL.AHL_WARRANTY_CONTRACTS_TL is referenced by following:
AHL
VIEW - AHL_WARRANTY_CONTRACTS_TL#
[top of page]
Table: AHL_WARRANTY_CONT_CTR_B
Primary Key: AHL_WARRANTY_CONT_CTR_B_PK1
WARRANTY_CNTRT_COUNTER_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_WARRANTY_CONT_CTR_B.COUNTER_ID
CSI_COUNTERS_B
AHL_WARRANTY_CONT_CTR_B.WARRANTY_CONTRACT_ID
%
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AHL_WARRANTY_CONT_CTR_TL.WARRANTY_CNTRT_COUNTER_ID
AHL_WARRANTY_CONT_CTR_B
[top of page]
AHL.AHL_WARRANTY_CONT_CTR_B does not reference any database object
AHL.AHL_WARRANTY_CONT_CTR_B is referenced by following:
AHL
VIEW - AHL_WARRANTY_CONT_CTR_B#
[top of page]
Table: AHL_WARRANTY_CONT_CTR_TL
Primary Key: AHL_WARRANTY_CONT_CTR_TL_PK1
WARRANTY_CNTRT_COUNTER_ID
LANGUAGE
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_WARRANTY_CONT_CTR_TL.WARRANTY_CNTRT_COUNTER_ID
AHL_WARRANTY_CONT_CTR_B
[top of page]
AHL.AHL_WARRANTY_CONT_CTR_TL does not reference any database object
AHL.AHL_WARRANTY_CONT_CTR_TL is referenced by following:
AHL
VIEW - AHL_WARRANTY_CONT_CTR_TL#
[top of page]
Table: AHL_WARRANTY_ENTITLEMENTS
Primary Key: AHL_WARRANTY_ENTITLEMENTS_PK1
WARRANTY_ENTITLEMENT_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_WARRANTY_ENTITLEMENTS.WARRANTY_CONTRACT_ID
%
AHL_WARRANTY_ENTITLEMENTS.OLD_WARRANTY_CONTRACT_ID
%
AHL_WARRANTY_ENTITLEMENTS.WARRANTY_CLAIM_ID
%
AHL_WARRANTY_ENTITLEMENTS.WORKORDER_ID
AHL_WORKORDERS
AHL_WARRANTY_ENTITLEMENTS.VISIT_TASK_ID
AHL_VISIT_TASKS_B
AHL_WARRANTY_ENTITLEMENTS.OSP_ORDER_LINE_ID
AHL_OSP_ORDER_LINES
[top of page]
AHL.AHL_WARRANTY_ENTITLEMENTS does not reference any database object
AHL.AHL_WARRANTY_ENTITLEMENTS is referenced by following:
AHL
VIEW - AHL_WARRANTY_ENTITLEMENTS#
[top of page]
Table: AHL_WARRANTY_TEMPLATES_B
Description: Table contains Warranty Template definitions
Primary Key: AHL_WARRANTY_TEMPLATES_PK1
WARRANTY_TEMPLATE_ID
Primary Key: AHL_WARRANTY_TEMPLATES_UK1
NAME
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AHL_WARRANTY_CONTRACTS_B.WARRANTY_TEMPLATE_ID
AHL_WARRANTY_TEMPLATES_B
AHL_WARRANTY_TEMPLATES_TL.WARRANTY_TEMPLATE_ID
AHL_WARRANTY_TEMPLATES_B
AHL_WARRANTY_TMPL_CTR_B.WARRANTY_TEMPLATE_ID
AHL_WARRANTY_TEMPLATES_B
AHL_WARRANTY_TMPL_ITEMS.WARRANTY_TEMPLATE_ID
AHL_WARRANTY_TEMPLATES_B
[top of page]
AHL.AHL_WARRANTY_TEMPLATES_B does not reference any database object
AHL.AHL_WARRANTY_TEMPLATES_B is referenced by following:
AHL
VIEW - AHL_WARRANTY_TEMPLATES_B#
[top of page]
Table: AHL_WARRANTY_TEMPLATES_TL
Description: Table to hold warranty template translated attibutes
Primary Key: AHL_WARRANTY_TEMPLATE_TL_PK1
WARRANTY_TEMPLATE_ID
LANGUAGE
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_WARRANTY_TEMPLATES_TL.WARRANTY_TEMPLATE_ID
AHL_WARRANTY_TEMPLATES_B
[top of page]
AHL.AHL_WARRANTY_TEMPLATES_TL does not reference any database object
AHL.AHL_WARRANTY_TEMPLATES_TL is referenced by following:
AHL
VIEW - AHL_WARRANTY_TEMPLATES_TL#
[top of page]
Table: AHL_WARRANTY_TMPL_CTR_B
Description: Table holds warranty template counter definitions
Primary Key: AHL_WARRANTY_TMPL_CTR_B_PK1
WARRANTY_TMPL_COUNTER_ID
Primary Key: AHL_WARRANTY_TMPL_CTR_B_UK1
WARRANTY_TEMPLATE_ID
COUNTER_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_WARRANTY_TMPL_CTR_B.WARRANTY_TEMPLATE_ID
AHL_WARRANTY_TEMPLATES_B
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AHL_WARRANTY_TMPL_CTR_TL.WARRANTY_TMPL_COUNTER_ID
AHL_WARRANTY_TMPL_CTR_B
[top of page]
AHL.AHL_WARRANTY_TMPL_CTR_B does not reference any database object
AHL.AHL_WARRANTY_TMPL_CTR_B is referenced by following:
AHL
VIEW - AHL_WARRANTY_TMPL_CTR_B#
[top of page]
Table: AHL_WARRANTY_TMPL_CTR_TL
Description: Table to store translated information for the warranty template counter.
Primary Key: AHL_WARRANTY_TMPL_CTR_TL_PK1
WARRANTY_TMPL_COUNTER_ID
LANGUAGE
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_WARRANTY_TMPL_CTR_TL.WARRANTY_TMPL_COUNTER_ID
AHL_WARRANTY_TMPL_CTR_B
[top of page]
AHL.AHL_WARRANTY_TMPL_CTR_TL does not reference any database object
AHL.AHL_WARRANTY_TMPL_CTR_TL is referenced by following:
AHL
VIEW - AHL_WARRANTY_TMPL_CTR_TL#
[top of page]
Table: AHL_WARRANTY_TMPL_ITEMS
Description: Table to store items association to warranty template.
Primary Key: AHL_WARRANTY_TMPL_ITEMS_PK1
WARRANTY_TMPL_ITEM_ID
Primary Key: AHL_WARRANTY_TMPL_ITEMS_UK1
WARRANTY_TEMPLATE_ID
INVENTORY_ITEM_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_WARRANTY_TMPL_ITEMS.WARRANTY_TEMPLATE_ID
AHL_WARRANTY_TEMPLATES_B
[top of page]
AHL.AHL_WARRANTY_TMPL_ITEMS does not reference any database object
AHL.AHL_WARRANTY_TMPL_ITEMS is referenced by following:
AHL
VIEW - AHL_WARRANTY_TMPL_ITEMS#
[top of page]
Table: AHL_WBS_RULES
[top of page]
AHL.AHL_WBS_RULES does not reference any database object
AHL.AHL_WBS_RULES is referenced by following:
AHL
VIEW - AHL_WBS_RULES#
[top of page]
Table: AHL_WF_MAPPING
Description: This table stores information about workflow process mapping for differnet AHL objects
Primary Key: AHL_WF_MAPPING_PK
WF_MAPPING_ID
[top of page]
AHL.AHL_WF_MAPPING does not reference any database object
AHL.AHL_WF_MAPPING is referenced by following:
AHL
VIEW - AHL_WF_MAPPING#
[top of page]
Table: AHL_WORKORDERS
Description: Ahl Production Workorder Information stored in this table
Primary Key: AHL_WORKORDERS_PK
WORKORDER_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_WORKORDERS.ROUTE_ID
AHL_ROUTES_B
AHL_WORKORDERS.VISIT_TASK_ID
AHL_VISIT_TASKS_B
AHL_WORKORDERS.WIP_ENTITY_ID
WIP_ENTITIES
AHL_WORKORDERS.PLAN_ID
QA_PLANS
AHL_WORKORDERS.VISIT_ID
AHL_VISITS_B
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AHL_OSP_ORDER_LINES.WORKORDER_ID
AHL_WORKORDERS
AHL_PART_CHANGES.NON_ROUTINE_WORKORDER_ID
AHL_WORKORDERS
AHL_PRD_DISPOSITIONS_B.WORKORDER_ID
AHL_WORKORDERS
AHL_PRD_DISPOSITIONS_B.NON_ROUTINE_WORKORDER_ID
AHL_WORKORDERS
AHL_PRD_DISPOSITIONS_B_H.WORKORDER_ID
AHL_WORKORDERS
AHL_PRD_DISPOSITIONS_B_H.NON_ROUTINE_WORKORDER_ID
AHL_WORKORDERS
AHL_WARRANTY_ENTITLEMENTS.WORKORDER_ID
AHL_WORKORDERS
AHL_WORKORDER_MTL_TXNS.NON_ROUTINE_WORKORDER_ID
AHL_WORKORDERS
AHL_WORKORDER_OPERATIONS.WORKORDER_ID
AHL_WORKORDERS
AHL_WORKORDER_TXNS.WORKORDER_ID
AHL_WORKORDERS
[top of page]
AHL.AHL_WORKORDERS does not reference any database object
AHL.AHL_WORKORDERS is referenced by following:
AHL
VIEW - AHL_WORKORDERS#
[top of page]
Table: AHL_WORKORDER_MTL_TXNS
Description: This table stores the material transactions that were issued against a job.
Primary Key: AHL_WORKORDER_MTL_TXNS_PK
WORKORDER_MTL_TXN_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_WORKORDER_MTL_TXNS.WORKORDER_OPERATION_ID
AHL_WORKORDER_OPERATIONS
AHL_WORKORDER_MTL_TXNS.LOCATOR_ID
ORGANIZATION_ID
MTL_ITEM_LOCATIONS
AHL_WORKORDER_MTL_TXNS.NON_ROUTINE_WORKORDER_ID
AHL_WORKORDERS
AHL_WORKORDER_MTL_TXNS.MATERIAL_TRANSACTION_ID
MTL_MATERIAL_TRANSACTIONS
AHL_WORKORDER_MTL_TXNS.INVENTORY_ITEM_ID
ORGANIZATION_ID
MTL_SYSTEM_ITEMS_B
AHL_WORKORDER_MTL_TXNS.SUBINVENTORY_CODE
ORGANIZATION_ID
MTL_SECONDARY_INVENTORIES
AHL_WORKORDER_MTL_TXNS.TRANSACTION_TYPE_ID
MTL_TRANSACTION_TYPES
AHL_WORKORDER_MTL_TXNS.INVENTORY_ITEM_ID
ORGANIZATION_ID
LOT_NUMBER
MTL_LOT_NUMBERS
AHL_WORKORDER_MTL_TXNS.SERIAL_NUMBER
INVENTORY_ITEM_ID
ORGANIZATION_ID
MTL_SERIAL_NUMBERS
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AHL_PART_CHANGES.WORKORDER_MTL_TXN_ID
AHL_WORKORDER_MTL_TXNS
AHL_PRD_DISP_MTL_TXNS.WORKORDER_MTL_TXN_ID
AHL_WORKORDER_MTL_TXNS
[top of page]
AHL.AHL_WORKORDER_MTL_TXNS does not reference any database object
AHL.AHL_WORKORDER_MTL_TXNS is referenced by following:
AHL
VIEW - AHL_WORKORDER_MTL_TXNS#
[top of page]
Table: AHL_WORKORDER_OPERATIONS
Description: Stores AHL Workorder Operation Information
Primary Key: AHL_WORKORDER_OPERATIONS_PK1
WORKORDER_OPERATION_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_WORKORDER_OPERATIONS.WORKORDER_ID
AHL_WORKORDERS
AHL_WORKORDER_OPERATIONS.OPERATION_ID
AHL_OPERATIONS_B
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AHL_OPERATION_RESOURCES.WORKORDER_OPERATION_ID
AHL_WORKORDER_OPERATIONS
AHL_PART_CHANGES.WORKORDER_OPERATION_ID
AHL_WORKORDER_OPERATIONS
AHL_PRD_DISPOSITIONS_B.WO_OPERATION_ID
AHL_WORKORDER_OPERATIONS
AHL_PRD_DISPOSITIONS_B_H.WO_OPERATION_ID
AHL_WORKORDER_OPERATIONS
AHL_SCHEDULE_MATERIALS.WORKORDER_OPERATION_ID
AHL_WORKORDER_OPERATIONS
AHL_WORKORDER_MTL_TXNS.WORKORDER_OPERATION_ID
AHL_WORKORDER_OPERATIONS
AHL_WO_OPERATIONS_TXNS.WORKORDER_OPERATION_ID
AHL_WORKORDER_OPERATIONS
[top of page]
AHL.AHL_WORKORDER_OPERATIONS does not reference any database object
AHL.AHL_WORKORDER_OPERATIONS is referenced by following:
AHL
VIEW - AHL_WORKORDER_OPERATIONS#
[top of page]
Table: AHL_WORKORDER_TXNS
Description: Ahl Production Workorder Transaction Information stored in this table
Primary Key: AHL_WORKORDER_TXNS_PK
WORKORDER_TXN_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_WORKORDER_TXNS.WORKORDER_ID
AHL_WORKORDERS
[top of page]
AHL.AHL_WORKORDER_TXNS does not reference any database object
AHL.AHL_WORKORDER_TXNS is referenced by following:
AHL
VIEW - AHL_WORKORDER_TXNS#
[top of page]
Table: AHL_WORK_ASSIGNMENTS
Description: This table stores the workorder assigments
Primary Key: AHL_WORK_ASSIGNMENTS_PK
ASSIGNMENT_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_WORK_ASSIGNMENTS.OPERATION_RESOURCE_ID
AHL_OPERATION_RESOURCES
[top of page]
AHL.AHL_WORK_ASSIGNMENTS does not reference any database object
AHL.AHL_WORK_ASSIGNMENTS is referenced by following:
AHL
VIEW - AHL_WORK_ASSIGNMENTS#
[top of page]
Table: AHL_WORK_LOGIN_TIMES
Description: This table stores employee login/logout times into a operation-resource.
Primary Key: AHL_WORK_LOGIN_TIMES_PK
WORK_LOGIN_TIME_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_WORK_LOGIN_TIMES.OPERATION_RESOURCE_ID
AHL_OPERATION_RESOURCES
[top of page]
AHL.AHL_WORK_LOGIN_TIMES does not reference any database object
AHL.AHL_WORK_LOGIN_TIMES is referenced by following:
AHL
VIEW - AHL_WORK_LOGIN_TIMES#
[top of page]
Table: AHL_WO_OPERATIONS_RELN
[top of page]
AHL.AHL_WO_OPERATIONS_RELN does not reference any database object
AHL.AHL_WO_OPERATIONS_RELN is referenced by following:
AHL
VIEW - AHL_WO_OPERATIONS_RELN#
[top of page]
Table: AHL_WO_OPERATIONS_TXNS
Description: Ahl Production Workorder Operations Information stored in this table
Primary Key: AHL_WO_OPERATIONS_TXNS_PK1
WO_OPERATION_TXN_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AHL_WO_OPERATIONS_TXNS.OPERATION_RESOURCE_ID
AHL_OPERATION_RESOURCES
AHL_WO_OPERATIONS_TXNS.SCHEDULE_MATERIAL_ID
AHL_SCHEDULE_MATERIALS
AHL_WO_OPERATIONS_TXNS.BOM_RESOURCE_ID
BOM_RESOURCES
AHL_WO_OPERATIONS_TXNS.WORKORDER_OPERATION_ID
AHL_WORKORDER_OPERATIONS
[top of page]
AHL.AHL_WO_OPERATIONS_TXNS does not reference any database object
AHL.AHL_WO_OPERATIONS_TXNS is referenced by following:
AHL
VIEW - AHL_WO_OPERATIONS_TXNS#
[top of page]
View: AHL_ALL_WORKORDERS_V
[top of page]
APPS.AHL_ALL_WORKORDERS_V references the following:
APPS
PACKAGE - AHL_COMPLETIONS_PVT
SYNONYM - AHL_MR_HEADERS_B
VIEW - AHL_MR_ROUTES_APP_V
SYNONYM - AHL_OSP_ORDERS_B
SYNONYM - AHL_OSP_ORDER_LINES
VIEW - AHL_ROUTES_VL
SYNONYM - AHL_UNIT_EFFECTIVITIES_B
PACKAGE - AHL_UTILITY_PVT
VIEW - AHL_VISITS_VL
SYNONYM - AHL_VISIT_TASKS_B
VIEW - AHL_VISIT_TASKS_VL
SYNONYM - AHL_WORKORDERS
SYNONYM - BOM_DEPARTMENTS
SYNONYM - CSI_ITEM_INSTANCES
PACKAGE - FND_GLOBAL
PACKAGE - FND_PROFILE
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
SYNONYM - PA_TASKS
SYNONYM - QA_PLAN_COLLECTION_TRIGGERS
SYNONYM - QA_PLAN_TRANSACTIONS
SYNONYM - QA_RESULTS
SYNONYM - WIP_DISCRETE_JOBS
- ORG_ORGANIZATION_DEFINITIONS
- QA_PLANS_VAL_V
- MO_GLOBAL
- PA_PROJECTS_ALL
- MTL_ITEM_LOCATIONS_KFV
- HR_ORGANIZATION_UNITS
- MFG_LOOKUPS
- FND_LOOKUP_VALUES_VL
- MTL_SYSTEM_ITEMS_KFV
- CS_INCIDENTS_ALL_B
APPS.AHL_ALL_WORKORDERS_V is not referenced by any database object
[top of page]
View: AHL_ALTERNATE_RESOURCES_V
[top of page]
APPS.AHL_ALTERNATE_RESOURCES_V references the following:
APPS
SYNONYM - AHL_ALTERNATE_RESOURCES
SYNONYM - AHL_RESOURCES
APPS.AHL_ALTERNATE_RESOURCES_V is not referenced by any database object
[top of page]
View: AHL_APPROVAL_RULES_V
[top of page]
APPS.AHL_APPROVAL_RULES_V references the following:
APPS
VIEW - AHL_APPROVAL_RULES_VL
- FND_LOOKUP_VALUES_VL
APPS.AHL_APPROVAL_RULES_V is not referenced by any database object
[top of page]
View: AHL_APPROVAL_RULES_VL
[top of page]
APPS.AHL_APPROVAL_RULES_VL references the following:
APPS
SYNONYM - AHL_APPROVAL_RULES_B
SYNONYM - AHL_APPROVAL_RULES_TL
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
APPS.AHL_APPROVAL_RULES_VL is referenced by following:
APPS
VIEW - AHL_APPROVAL_RULES_V
[top of page]
View: AHL_APPROVERS_TYPE_V
[top of page]
APPS.AHL_APPROVERS_TYPE_V references the following:
APPS
PACKAGE - FND_GLOBAL
SYNONYM - JTF_RS_RESOURCE_EXTNS
- JTF_RS_ROLE_RELATIONS_VL
APPS.AHL_APPROVERS_TYPE_V is not referenced by any database object
[top of page]
View: AHL_APPROVERS_V
[top of page]
APPS.AHL_APPROVERS_V references the following:
APPS
SYNONYM - AHL_APPROVERS
PACKAGE - FND_GLOBAL
- FND_LOOKUP_VALUES_VL
- JTF_RS_ROLE_RELATIONS_VL
- AHL_JTF_RS_EMP_V
APPS.AHL_APPROVERS_V is not referenced by any database object
[top of page]
View: AHL_CSI_INSTANCE_RELNS_V
[top of page]
APPS.AHL_CSI_INSTANCE_RELNS_V references the following:
APPS
SYNONYM - CSI_II_RELATIONSHIPS
SYNONYM - CSI_ITEM_INSTANCES
APPS.AHL_CSI_INSTANCE_RELNS_V is not referenced by any database object
[top of page]
View: AHL_DEPARTMENT_SHIFTS_V
[top of page]
APPS.AHL_DEPARTMENT_SHIFTS_V references the following:
APPS
SYNONYM - AHL_DEPARTMENT_SHIFTS
SYNONYM - BOM_CALENDARS
SYNONYM - BOM_SHIFT_TIMES
SYNONYM - BOM_WORKDAY_PATTERNS
SYNONYM - HR_ALL_ORGANIZATION_UNITS
PACKAGE - HR_GENERAL
- MTL_ITEM_LOCATIONS_KFV
- BOM_DEPARTMENTS_V
APPS.AHL_DEPARTMENT_SHIFTS_V is referenced by following:
APPS
VIEW - AHL_UE_ORGS_DEPTS_V
[top of page]
View: AHL_DOCUMENTS_V
[top of page]
APPS.AHL_DOCUMENTS_V references the following:
APPS
VIEW - AHL_DOCUMENTS_VL
SYNONYM - HZ_PARTIES
- FND_LOOKUP_VALUES_VL
APPS.AHL_DOCUMENTS_V is not referenced by any database object
[top of page]
View: AHL_DOCUMENTS_VL
[top of page]
APPS.AHL_DOCUMENTS_VL references the following:
APPS
SYNONYM - AHL_DOCUMENTS_B
SYNONYM - AHL_DOCUMENTS_TL
APPS.AHL_DOCUMENTS_VL is referenced by following:
APPS
VIEW - AHL_DOCUMENTS_V
VIEW - AHL_DOCUMENT_ASSOS_V
VIEW - AHL_DOC_TYPE_ASSOS_V
VIEW - AHL_REFERENCE_DOC_V
[top of page]
View: AHL_DOCUMENT_ASSOS_V
[top of page]
APPS.AHL_DOCUMENT_ASSOS_V references the following:
APPS
VIEW - AHL_DOCUMENTS_VL
SYNONYM - AHL_DOC_FILE_ASSOC_B
SYNONYM - AHL_DOC_REVISIONS_B
VIEW - AHL_DOC_TITLE_ASSOS_VL
- FND_LOOKUP_VALUES_VL
APPS.AHL_DOCUMENT_ASSOS_V is not referenced by any database object
[top of page]
View: AHL_DOC_FILE_ASSOC_V
[top of page]
APPS.AHL_DOC_FILE_ASSOC_V references the following:
- AHL_DOC_FILE_ASSOC_VL
- FND_LOOKUP_VALUES_VL
APPS.AHL_DOC_FILE_ASSOC_V is not referenced by any database object
[top of page]
View: AHL_DOC_FILE_ASSOC_VL
[top of page]
APPS.AHL_DOC_FILE_ASSOC_VL references the following:
APPS
SYNONYM - AHL_DOC_FILE_ASSOC_B
SYNONYM - AHL_DOC_FILE_ASSOC_TL
APPS.AHL_DOC_FILE_ASSOC_VL is not referenced by any database object
[top of page]
View: AHL_DOC_REVISIONS_V
[top of page]
APPS.AHL_DOC_REVISIONS_V references the following:
APPS
PACKAGE - AHL_DI_DOC_INDEX_PVT
VIEW - AHL_DOC_REVISIONS_VL
VIEW - AHL_HZ_PER_EMPLOYEES_V
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
- FND_LOOKUP_VALUES_VL
APPS.AHL_DOC_REVISIONS_V is not referenced by any database object
[top of page]
View: AHL_DOC_REVISIONS_VL
[top of page]
APPS.AHL_DOC_REVISIONS_VL references the following:
APPS
SYNONYM - AHL_DOC_REVISIONS_B
SYNONYM - AHL_DOC_REVISIONS_TL
APPS.AHL_DOC_REVISIONS_VL is referenced by following:
APPS
VIEW - AHL_DOC_REVISIONS_V
VIEW - AHL_DOC_REV_DETAILS_V
[top of page]
View: AHL_DOC_TITLE_ASSOS_VL
[top of page]
APPS.AHL_DOC_TITLE_ASSOS_VL references the following:
APPS
SYNONYM - AHL_DOC_TITLE_ASSOS_B
SYNONYM - AHL_DOC_TITLE_ASSOS_TL
APPS.AHL_DOC_TITLE_ASSOS_VL is referenced by following:
APPS
VIEW - AHL_DOCUMENT_ASSOS_V
VIEW - AHL_DOC_TYPE_ASSOS_V
VIEW - AHL_REFERENCE_DOC_V
[top of page]
View: AHL_DOC_TYPE_ASSOS_V
[top of page]
APPS.AHL_DOC_TYPE_ASSOS_V references the following:
APPS
VIEW - AHL_DOCUMENTS_VL
SYNONYM - AHL_DOC_REVISIONS_B
VIEW - AHL_DOC_TITLE_ASSOS_VL
- FND_LOOKUP_VALUES_VL
APPS.AHL_DOC_TYPE_ASSOS_V is not referenced by any database object
[top of page]
View: AHL_DUMMY_V
[top of page]
APPS.AHL_DUMMY_V references the following:
SYS
TABLE - DUAL
APPS.AHL_DUMMY_V is not referenced by any database object
[top of page]
View: AHL_FLEET_HEADERS_VL
[top of page]
APPS.AHL_FLEET_HEADERS_VL references the following:
APPS
SYNONYM - AHL_FLEET_HEADERS_B
SYNONYM - AHL_FLEET_HEADERS_TL
APPS.AHL_FLEET_HEADERS_VL is referenced by following:
APPS
VIEW - AHL_NR_PROFILE_DETAILS_V
VIEW - AHL_PLANNING_FACTORS_V
PACKAGE BODY - AHL_RA_NR_PROFILE_PVT
[top of page]
View: AHL_HZ_PER_EMPLOYEES_V
[top of page]
APPS.AHL_HZ_PER_EMPLOYEES_V references the following:
APPS
PACKAGE - AHL_DI_DOC_INDEX_PVT
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
SYNONYM - HZ_PARTIES
SYNONYM - PER_PERSON_TYPES
- PER_PEOPLE_F
APPS.AHL_HZ_PER_EMPLOYEES_V is referenced by following:
APPS
VIEW - AHL_DOC_REVISIONS_V
[top of page]
View: AHL_HZ_PO_SUPPLIERS_V
[top of page]
APPS.AHL_HZ_PO_SUPPLIERS_V references the following:
APPS
PACKAGE - AHL_DI_DOC_INDEX_PVT
SYNONYM - HZ_PARTIES
VIEW - PO_VENDORS
APPS.AHL_HZ_PO_SUPPLIERS_V is not referenced by any database object
[top of page]
View: AHL_ITEM_ASSOCIATIONS_V
[top of page]
APPS.AHL_ITEM_ASSOCIATIONS_V references the following:
APPS
VIEW - AHL_ITEM_ASSOCIATIONS_VL
VIEW - AHL_MTL_ITEMS_NON_OU_V
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
APPS.AHL_ITEM_ASSOCIATIONS_V is not referenced by any database object
[top of page]
View: AHL_ITEM_ASSOCIATIONS_VL
[top of page]
APPS.AHL_ITEM_ASSOCIATIONS_VL references the following:
APPS
SYNONYM - AHL_ITEM_ASSOCIATIONS_B
SYNONYM - AHL_ITEM_ASSOCIATIONS_TL
APPS.AHL_ITEM_ASSOCIATIONS_VL is referenced by following:
APPS
VIEW - AHL_ITEM_ASSOCIATIONS_V
VIEW - AHL_POSITION_ALTERNATES_V
[top of page]
View: AHL_ITEM_CLASS_UOM_V
[top of page]
APPS.AHL_ITEM_CLASS_UOM_V references the following:
- FND_LOOKUP_VALUES_VL
- MTL_SYSTEM_ITEMS_KFV
- MTL_UNITS_OF_MEASURE_VL
APPS.AHL_ITEM_CLASS_UOM_V is not referenced by any database object
[top of page]
View: AHL_ITEM_COMP_DETAIL_V
[top of page]
APPS.AHL_ITEM_COMP_DETAIL_V references the following:
APPS
SYNONYM - AHL_ITEM_COMP_DETAILS
VIEW - AHL_ITEM_GROUPS_VL
VIEW - AHL_MTL_ITEMS_NON_OU_V
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
- MTL_UNITS_OF_MEASURE_VL
APPS.AHL_ITEM_COMP_DETAIL_V is not referenced by any database object
[top of page]
View: AHL_ITEM_COMP_V
[top of page]
APPS.AHL_ITEM_COMP_V references the following:
APPS
SYNONYM - AHL_ITEM_COMPOSITIONS
VIEW - AHL_MTL_ITEMS_NON_OU_V
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
- FND_LOOKUP_VALUES_VL
APPS.AHL_ITEM_COMP_V is not referenced by any database object
[top of page]
View: AHL_ITEM_GROUPS_V
[top of page]
APPS.AHL_ITEM_GROUPS_V references the following:
APPS
VIEW - AHL_ITEM_GROUPS_VL
- FND_LOOKUP_VALUES_VL
APPS.AHL_ITEM_GROUPS_V is not referenced by any database object
[top of page]
View: AHL_ITEM_GROUPS_VL
[top of page]
APPS.AHL_ITEM_GROUPS_VL references the following:
APPS
SYNONYM - AHL_ITEM_GROUPS_B
SYNONYM - AHL_ITEM_GROUPS_TL
APPS.AHL_ITEM_GROUPS_VL is referenced by following:
APPS
VIEW - AHL_ITEM_COMP_DETAIL_V
VIEW - AHL_ITEM_GROUPS_V
PACKAGE - AHL_RM_ROUTE_UTIL
VIEW - AHL_RT_OPER_MATERIALS_V
[top of page]
View: AHL_JOB_OPER_MATERIALS_V
[top of page]
APPS.AHL_JOB_OPER_MATERIALS_V references the following:
APPS
PACKAGE - AHL_PP_MATERIALS_PVT
SYNONYM - AHL_SCHEDULE_MATERIALS
VIEW - AHL_VISITS_VL
SYNONYM - AHL_WORKORDERS
VIEW - AHL_WORKORDER_OPERATIONS_V
SYNONYM - MTL_RESERVATIONS
SYNONYM - WIP_REQUIREMENT_OPERATIONS
- MTL_SYSTEM_ITEMS_VL
APPS.AHL_JOB_OPER_MATERIALS_V is not referenced by any database object
[top of page]
View: AHL_JTF_RS_EMP_V
[top of page]
APPS.AHL_JTF_RS_EMP_V references the following:
APPS
SYNONYM - JTF_RS_RESOURCE_EXTNS
SYNONYM - JTF_RS_RESOURCE_EXTNS_TL
APPS.AHL_JTF_RS_EMP_V is not referenced by any database object
[top of page]
View: AHL_MASTER_CONFIG_DETAILS_V
[top of page]
APPS.AHL_MASTER_CONFIG_DETAILS_V references the following:
- AHL_MC_HEADERS_V
- AHL_MC_RELATIONSHIPS_V
APPS.AHL_MASTER_CONFIG_DETAILS_V is not referenced by any database object
[top of page]
View: AHL_MC_HEADERS_V
[top of page]
APPS.AHL_MC_HEADERS_V references the following:
APPS
SYNONYM - AHL_MC_HEADERS_B
SYNONYM - AHL_MC_HEADERS_TL
SYNONYM - AHL_MC_RELATIONSHIPS
- FND_LOOKUP_VALUES_VL
APPS.AHL_MC_HEADERS_V is not referenced by any database object
[top of page]
View: AHL_MC_HEADERS_VL
[top of page]
APPS.AHL_MC_HEADERS_VL references the following:
APPS
SYNONYM - AHL_MC_HEADERS_B
SYNONYM - AHL_MC_HEADERS_TL
APPS.AHL_MC_HEADERS_VL is not referenced by any database object
[top of page]
View: AHL_MC_RELATIONSHIPS_V
[top of page]
APPS.AHL_MC_RELATIONSHIPS_V references the following:
APPS
SYNONYM - AHL_ITEM_GROUPS_B
SYNONYM - AHL_ITEM_GROUPS_TL
SYNONYM - AHL_MC_RELATIONSHIPS
- FND_LOOKUP_VALUES_VL
APPS.AHL_MC_RELATIONSHIPS_V is not referenced by any database object
[top of page]
View: AHL_MC_RULES_VL
[top of page]
APPS.AHL_MC_RULES_VL references the following:
APPS
SYNONYM - AHL_MC_RULES_B
SYNONYM - AHL_MC_RULES_TL
APPS.AHL_MC_RULES_VL is not referenced by any database object
[top of page]
View: AHL_MM_WRK_ORDER_RESERVTN_V
[top of page]
APPS.AHL_MM_WRK_ORDER_RESERVTN_V references the following:
APPS
PACKAGE - AHL_CMP_UTIL_PKG
SYNONYM - AHL_UNIT_EFFECTIVITIES_B
SYNONYM - AHL_WORKORDERS
SYNONYM - CSI_ITEM_INSTANCES
PACKAGE - FND_GLOBAL
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
SYNONYM - HZ_PARTIES
SYNONYM - MTL_RESERVATIONS
SYNONYM - WIP_DISCRETE_JOBS
- AHL_VISIT_TASKS_VL
- CS_INCIDENTS_ALL_B
- HR_ORGANIZATION_UNITS
- FND_LOOKUPS
- MTL_SYSTEM_ITEMS_KFV
- AHL_VISITS_VL
APPS.AHL_MM_WRK_ORDER_RESERVTN_V is not referenced by any database object
[top of page]
View: AHL_MR_ACTIONS_V
[top of page]
APPS.AHL_MR_ACTIONS_V references the following:
APPS
VIEW - AHL_MR_ACTIONS_VL
SYNONYM - QA_PLANS
- FND_LOOKUP_VALUES_VL
APPS.AHL_MR_ACTIONS_V is not referenced by any database object
[top of page]
View: AHL_MR_ACTIONS_VL
[top of page]
APPS.AHL_MR_ACTIONS_VL references the following:
APPS
SYNONYM - AHL_MR_ACTIONS_B
SYNONYM - AHL_MR_ACTIONS_TL
APPS.AHL_MR_ACTIONS_VL is referenced by following:
APPS
VIEW - AHL_MR_ACTIONS_V
[top of page]
View: AHL_MR_DETAILS_V
[top of page]
APPS.AHL_MR_DETAILS_V references the following:
APPS
SYNONYM - AHL_DOCUMENTS_B
SYNONYM - AHL_DOCUMENTS_TL
SYNONYM - AHL_DOC_REVISIONS_B
SYNONYM - AHL_DOC_TITLE_ASSOS_B
SYNONYM - AHL_MR_HEADERS_B
SYNONYM - AHL_MR_HEADERS_TL
SYNONYM - AHL_MR_RELATIONSHIPS
SYNONYM - AHL_WARRANTY_TEMPLATES_B
SYNONYM - FND_LOOKUP_VALUES
PACKAGE - FND_PROFILE
APPS.AHL_MR_DETAILS_V is not referenced by any database object
[top of page]
View: AHL_MR_EFFECTIVITIES_APP_V
[top of page]
APPS.AHL_MR_EFFECTIVITIES_APP_V references the following:
APPS
SYNONYM - AHL_FLEET_HEADERS_B
SYNONYM - AHL_MR_EFFECTIVITIES
VIEW - AHL_MR_HEADERS_APP_V
PACKAGE - FND_PROFILE
APPS.AHL_MR_EFFECTIVITIES_APP_V is referenced by following:
APPS
VIEW - AHL_MR_EFFECTIVITIES_V
VIEW - AHL_MR_EFFECTIVITY_DTLS_APP_V
VIEW - AHL_MR_INTERVALS_APP_V
[top of page]
View: AHL_MR_EFFECTIVITIES_V
[top of page]
APPS.AHL_MR_EFFECTIVITIES_V references the following:
APPS
PACKAGE - AHL_MC_PATH_POSITION_PVT
VIEW - AHL_MR_EFFECTIVITIES_APP_V
SYNONYM - AHL_PC_NODES_B
PACKAGE - FND_PROFILE
- FND_LOOKUP_VALUES_VL
- MTL_SYSTEM_ITEMS_KFV
APPS.AHL_MR_EFFECTIVITIES_V is not referenced by any database object
[top of page]
View: AHL_MR_EFFECTIVITY_DTLS_APP_V
[top of page]
APPS.AHL_MR_EFFECTIVITY_DTLS_APP_V references the following:
APPS
VIEW - AHL_MR_EFFECTIVITIES_APP_V
SYNONYM - AHL_MR_EFFECTIVITY_DTLS
VIEW - AHL_MR_HEADERS_APP_V
PACKAGE - FND_PROFILE
APPS.AHL_MR_EFFECTIVITY_DTLS_APP_V is not referenced by any database object
[top of page]
View: AHL_MR_EFFECTIVITY_DTLS_V
[top of page]
APPS.AHL_MR_EFFECTIVITY_DTLS_V references the following:
APPS
SYNONYM - AHL_MR_EFFECTIVITY_DTLS
SYNONYM - MTL_MANUFACTURERS
- FND_TERRITORIES_VL
- FND_LOOKUP_VALUES_VL
APPS.AHL_MR_EFFECTIVITY_DTLS_V is not referenced by any database object
[top of page]
View: AHL_MR_HEADERS_APP_V
[top of page]
APPS.AHL_MR_HEADERS_APP_V references the following:
APPS
VIEW - AHL_MR_HEADERS_VL
PACKAGE - FND_PROFILE
APPS.AHL_MR_HEADERS_APP_V is referenced by following:
APPS
VIEW - AHL_MR_EFFECTIVITIES_APP_V
VIEW - AHL_MR_EFFECTIVITY_DTLS_APP_V
VIEW - AHL_MR_INTERVALS_APP_V
VIEW - AHL_MR_PC_NODES_V
VIEW - AHL_MR_ROUTES_APP_V
VIEW - AHL_MR_ROUTE_SEQUENCES_APP_V
VIEW - AHL_MR_VISIT_TYPES_APP_V
VIEW - AHL_SEARCH_TEMPLATE_TASK_V
VIEW - AHL_SRH_WO_HISTORY_V
[top of page]
View: AHL_MR_HEADERS_V
[top of page]
APPS.AHL_MR_HEADERS_V references the following:
APPS
SYNONYM - AHL_MR_HEADERS_B
SYNONYM - AHL_MR_HEADERS_TL
SYNONYM - AHL_WARRANTY_TEMPLATES_B
SYNONYM - FND_LOOKUP_VALUES
PACKAGE - FND_PROFILE
SYNONYM - QA_CHAR_VALUE_LOOKUPS
- MTL_SYSTEM_ITEMS_KFV
- FND_LOOKUP_VALUES_VL
APPS.AHL_MR_HEADERS_V is referenced by following:
APPS
VIEW - AHL_UE_DEFERRAL_DETAILS_V
[top of page]
View: AHL_MR_HEADERS_VL
[top of page]
APPS.AHL_MR_HEADERS_VL references the following:
APPS
SYNONYM - AHL_MR_HEADERS_B
SYNONYM - AHL_MR_HEADERS_TL
APPS.AHL_MR_HEADERS_VL is referenced by following:
APPS
VIEW - AHL_MR_HEADERS_APP_V
VIEW - AHL_SEARCH_TEMPLATE_TASK_V
VIEW - AHL_SEARCH_VISIT_TASK_V
VIEW - AHL_SR_UE_ASSOCIATIONS_V
VIEW - AHL_VISIT_MR_V
[top of page]
View: AHL_MR_INSTANCES_V
[top of page]
APPS.AHL_MR_INSTANCES_V references the following:
APPS
PACKAGE - AHL_COMPLETIONS_PVT
SYNONYM - AHL_MR_HEADERS_B
PACKAGE - AHL_PRD_PRINT_PVT
VIEW - AHL_UE_DEFERRAL_DETAILS_V
PACKAGE - AHL_UTILITY_PVT
SYNONYM - AHL_VISITS_B
SYNONYM - AHL_VISIT_TASKS_B
SYNONYM - AHL_WORKORDERS
SYNONYM - BOM_DEPARTMENTS
SYNONYM - CSI_ITEM_INSTANCES
PACKAGE - FND_GLOBAL
PACKAGE - FND_PROFILE
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
SYNONYM - WIP_DISCRETE_JOBS
- CS_INCIDENTS_ALL_VL
- MTL_SYSTEM_ITEMS_KFV
- CS_INCIDENT_TYPES_VL
- ORG_ORGANIZATION_DEFINITIONS
- MO_GLOBAL
- FND_LOOKUP_VALUES_VL
APPS.AHL_MR_INSTANCES_V is referenced by following:
APPS
VIEW - AHL_MR_INST_RELATIONSHIPS_V
[top of page]
View: AHL_MR_INST_RELATIONSHIPS_V
[top of page]
APPS.AHL_MR_INST_RELATIONSHIPS_V references the following:
APPS
PACKAGE - AHL_COMPLETIONS_PVT
VIEW - AHL_MR_INSTANCES_V
PACKAGE - AHL_PRD_PRINT_PVT
SYNONYM - AHL_UE_RELATIONSHIPS
PACKAGE - AHL_UTILITY_PVT
PACKAGE - FND_GLOBAL
PACKAGE - FND_PROFILE
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
- MO_GLOBAL
APPS.AHL_MR_INST_RELATIONSHIPS_V is not referenced by any database object
[top of page]
View: AHL_MR_INTERVALS_APP_V
[top of page]
APPS.AHL_MR_INTERVALS_APP_V references the following:
APPS
VIEW - AHL_MR_EFFECTIVITIES_APP_V
VIEW - AHL_MR_HEADERS_APP_V
SYNONYM - AHL_MR_INTERVALS
PACKAGE - FND_PROFILE
APPS.AHL_MR_INTERVALS_APP_V is not referenced by any database object
[top of page]
View: AHL_MR_INTERVALS_V
[top of page]
APPS.AHL_MR_INTERVALS_V references the following:
APPS
SYNONYM - AHL_MR_EFFECTIVITIES
SYNONYM - AHL_MR_HEADERS_B
SYNONYM - AHL_MR_INTERVALS
PACKAGE - FND_GLOBAL
PACKAGE - FND_PROFILE
- MTL_UNITS_OF_MEASURE_VL
- FND_LOOKUPS
- CS_COUNTERS
APPS.AHL_MR_INTERVALS_V is not referenced by any database object
[top of page]
View: AHL_MR_ITEMS_V
[top of page]
APPS.AHL_MR_ITEMS_V references the following:
APPS
SYNONYM - AHL_MR_EFFECTIVITIES
SYNONYM - AHL_MR_HEADERS_B
VIEW - AHL_POSITION_ALTERNATES_V
PACKAGE - FND_PROFILE
- MTL_SYSTEM_ITEMS_KFV
APPS.AHL_MR_ITEMS_V is not referenced by any database object
[top of page]
View: AHL_MR_ITEM_DETAILS_V
[top of page]
APPS.AHL_MR_ITEM_DETAILS_V references the following:
APPS
SYNONYM - AHL_DOCUMENTS_B
SYNONYM - AHL_DOCUMENTS_TL
SYNONYM - AHL_DOC_REVISIONS_B
SYNONYM - AHL_DOC_TITLE_ASSOS_B
SYNONYM - AHL_MR_EFFECTIVITIES
SYNONYM - AHL_MR_HEADERS_B
SYNONYM - AHL_MR_HEADERS_TL
SYNONYM - AHL_MR_RELATIONSHIPS
VIEW - AHL_POSITION_ALTERNATES_V
SYNONYM - AHL_WARRANTY_TEMPLATES_B
SYNONYM - FND_LOOKUP_VALUES
PACKAGE - FND_PROFILE
- MTL_SYSTEM_ITEMS_KFV
APPS.AHL_MR_ITEM_DETAILS_V is not referenced by any database object
[top of page]
View: AHL_MR_PC_NODES_V
[top of page]
APPS.AHL_MR_PC_NODES_V references the following:
APPS
SYNONYM - AHL_MR_EFFECTIVITIES
VIEW - AHL_MR_HEADERS_APP_V
PACKAGE - FND_PROFILE
- FND_LOOKUP_VALUES_VL
APPS.AHL_MR_PC_NODES_V is referenced by following:
APPS
VIEW - AHL_PC_HEADER_DETAILS_V
[top of page]
View: AHL_MR_RELATIONSHIPS_APP_V
[top of page]
APPS.AHL_MR_RELATIONSHIPS_APP_V references the following:
APPS
SYNONYM - AHL_MR_RELATIONSHIPS
PACKAGE - FND_PROFILE
- AHL_MR_HEADERS_APP_V
APPS.AHL_MR_RELATIONSHIPS_APP_V is not referenced by any database object
[top of page]
View: AHL_MR_RELATIONSHIPS_V
[top of page]
APPS.AHL_MR_RELATIONSHIPS_V references the following:
APPS
SYNONYM - AHL_MR_HEADERS_B
SYNONYM - AHL_MR_HEADERS_TL
SYNONYM - AHL_MR_RELATIONSHIPS
SYNONYM - FND_LOOKUP_VALUES
PACKAGE - FND_PROFILE
APPS.AHL_MR_RELATIONSHIPS_V is not referenced by any database object
[top of page]
View: AHL_MR_ROUTES_APP_V
[top of page]
APPS.AHL_MR_ROUTES_APP_V references the following:
APPS
VIEW - AHL_MR_HEADERS_APP_V
SYNONYM - AHL_MR_ROUTES
PACKAGE - FND_PROFILE
APPS.AHL_MR_ROUTES_APP_V is referenced by following:
APPS
VIEW - AHL_ALL_WORKORDERS_V
VIEW - AHL_MR_ROUTES_V
VIEW - AHL_MR_ROUTE_SEQUENCES_APP_V
VIEW - AHL_SRH_WO_HISTORY_V
VIEW - AHL_WORKORDERS_V
[top of page]
View: AHL_MR_ROUTES_V
[top of page]
APPS.AHL_MR_ROUTES_V references the following:
APPS
VIEW - AHL_MR_ROUTES_APP_V
VIEW - AHL_ROUTES_APP_V
PACKAGE - FND_PROFILE
SYNONYM - HZ_PARTIES
- FND_LOOKUP_VALUES_VL
APPS.AHL_MR_ROUTES_V is referenced by following:
APPS
VIEW - AHL_SEARCH_TEMPLATE_TASK_V
VIEW - AHL_SEARCH_VISIT_TASK_V
[top of page]
View: AHL_MR_ROUTE_SEQUENCES_APP_V
[top of page]
APPS.AHL_MR_ROUTE_SEQUENCES_APP_V references the following:
APPS
VIEW - AHL_MR_HEADERS_APP_V
VIEW - AHL_MR_ROUTES_APP_V
SYNONYM - AHL_MR_ROUTE_SEQUENCES
PACKAGE - FND_PROFILE
APPS.AHL_MR_ROUTE_SEQUENCES_APP_V is not referenced by any database object
[top of page]
View: AHL_MTL_ITEMS_NON_OU_V
[top of page]
APPS.AHL_MTL_ITEMS_NON_OU_V references the following:
APPS
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
SYNONYM - MTL_PARAMETERS
- HR_ORGANIZATION_UNITS
- MTL_SYSTEM_ITEMS_KFV
APPS.AHL_MTL_ITEMS_NON_OU_V is referenced by following:
APPS
VIEW - AHL_ITEM_ASSOCIATIONS_V
VIEW - AHL_ITEM_COMP_DETAIL_V
VIEW - AHL_ITEM_COMP_V
[top of page]
View: AHL_MTL_ITEMS_OU_V
[top of page]
APPS.AHL_MTL_ITEMS_OU_V references the following:
APPS
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
SYNONYM - MTL_PARAMETERS
- MO_GLOBAL
- MTL_SYSTEM_ITEMS_KFV
- ORG_ORGANIZATION_DEFINITIONS
- HR_ORGANIZATION_UNITS
APPS.AHL_MTL_ITEMS_OU_V is referenced by following:
APPS
VIEW - AHL_OSP_INV_ITEMS_V
[top of page]
View: AHL_NR_PROFILE_DETAILS_V
[top of page]
APPS.AHL_NR_PROFILE_DETAILS_V references the following:
APPS
VIEW - AHL_FLEET_HEADERS_VL
SYNONYM - AHL_NR_PROFILE_DETAILS
PACKAGE - FND_GLOBAL
SYNONYM - HR_ALL_ORGANIZATION_UNITS
- MTL_UNITS_OF_MEASURE_VL
- MTL_SYSTEM_ITEMS_KFV
- AHL_RESOURCES_V
- FND_LOOKUPS
APPS.AHL_NR_PROFILE_DETAILS_V is not referenced by any database object
[top of page]
View: AHL_OPERATIONS_B_KFV
[top of page]
APPS.AHL_OPERATIONS_B_KFV references the following:
APPS
SYNONYM - AHL_OPERATIONS_B
APPS.AHL_OPERATIONS_B_KFV is referenced by following:
APPS
VIEW - AHL_OPERATIONS_VL
VIEW - AHL_WORKORDER_OPERATIONS_V
[top of page]
View: AHL_OPERATIONS_H_VL
[top of page]
APPS.AHL_OPERATIONS_H_VL references the following:
APPS
SYNONYM - AHL_OPERATIONS_H_B
SYNONYM - AHL_OPERATIONS_H_TL
APPS.AHL_OPERATIONS_H_VL is not referenced by any database object
[top of page]
View: AHL_OPERATIONS_V
[top of page]
APPS.AHL_OPERATIONS_V references the following:
APPS
VIEW - AHL_OPERATIONS_VL
- FND_LOOKUP_VALUES_VL
- QA_CHAR_VALUE_LOOKUPS_V
APPS.AHL_OPERATIONS_V is not referenced by any database object
[top of page]
View: AHL_OPERATIONS_VL
[top of page]
APPS.AHL_OPERATIONS_VL references the following:
APPS
VIEW - AHL_OPERATIONS_B_KFV
SYNONYM - AHL_OPERATIONS_TL
APPS.AHL_OPERATIONS_VL is referenced by following:
APPS
VIEW - AHL_OPERATIONS_V
VIEW - AHL_PP_REQUIREMENT_V
VIEW - AHL_ROUTE_OPERATIONS_V
[top of page]
View: AHL_OPERATION_PHASES_V
[top of page]
APPS.AHL_OPERATION_PHASES_V references the following:
APPS
SYNONYM - AHL_OPERATION_PHASES
- FND_LOOKUP_VALUES_VL
APPS.AHL_OPERATION_PHASES_V is not referenced by any database object
[top of page]
View: AHL_OSP_ORDERS_V
[top of page]
APPS.AHL_OSP_ORDERS_V references the following:
APPS
SYNONYM - AHL_OSP_ORDERS_B
SYNONYM - AHL_OSP_ORDERS_TL
PACKAGE - FND_GLOBAL
SYNONYM - FND_LOOKUP_VALUES
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
SYNONYM - HZ_PARTIES
SYNONYM - OE_ORDER_HEADERS_ALL
SYNONYM - OKC_K_HEADERS_B
PACKAGE - PO_BUYER_WORKLOAD_SV
SYNONYM - PO_HEADERS
SYNONYM - PO_REQUISITION_HEADERS_ALL
VIEW - PO_VENDORS
VIEW - PO_VENDOR_CONTACTS
- PO_AGENTS_NAME_V
- MO_GLOBAL
- PO_VENDOR_SITES_ALL
APPS.AHL_OSP_ORDERS_V is not referenced by any database object
[top of page]
View: AHL_OSP_ORDERS_VL
[top of page]
APPS.AHL_OSP_ORDERS_VL references the following:
APPS
SYNONYM - AHL_OSP_ORDERS_B
SYNONYM - AHL_OSP_ORDERS_TL
APPS.AHL_OSP_ORDERS_VL is referenced by following:
APPS
VIEW - AHL_SRH_MR_HISTORY_ALL_V
[top of page]
View: AHL_OSP_ORDER_LINES_V
[top of page]
APPS.AHL_OSP_ORDER_LINES_V references the following:
APPS
SYNONYM - AHL_OSP_ORDERS_B
SYNONYM - AHL_OSP_ORDER_LINES
SYNONYM - CSI_ITEM_INSTANCES
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
- MO_GLOBAL
- AHL_WORKORDERS_OSP_V
- MTL_SYSTEM_ITEMS_KFV
- FND_LOOKUP_VALUES_VL
- PO_LINE_TYPES
APPS.AHL_OSP_ORDER_LINES_V is not referenced by any database object
[top of page]
View: AHL_OWNER_DETAILS_V
[top of page]
APPS.AHL_OWNER_DETAILS_V references the following:
APPS
SYNONYM - HZ_PARTIES
VIEW - PO_VENDORS
APPS.AHL_OWNER_DETAILS_V is not referenced by any database object
[top of page]
View: AHL_OWNER_LOCATIONS_V
[top of page]
APPS.AHL_OWNER_LOCATIONS_V references the following:
APPS
PACKAGE - FND_GLOBAL
SYNONYM - HZ_LOCATIONS
SYNONYM - HZ_PARTIES
SYNONYM - HZ_PARTY_SITES
VIEW - PO_VENDORS
- MO_GLOBAL
- PO_VENDOR_SITES_ALL
APPS.AHL_OWNER_LOCATIONS_V is not referenced by any database object
[top of page]
View: AHL_PC_ASSOCIATIONS_V
[top of page]
APPS.AHL_PC_ASSOCIATIONS_V references the following:
APPS
SYNONYM - AHL_PC_ASSOCIATIONS
SYNONYM - AHL_PC_HEADERS_B
SYNONYM - AHL_PC_NODES_B
SYNONYM - AHL_UNIT_CONFIG_HEADERS
SYNONYM - CSI_ITEM_INSTANCES
- MTL_SYSTEM_ITEMS_KFV
APPS.AHL_PC_ASSOCIATIONS_V is referenced by following:
APPS
VIEW - AHL_PC_HEADER_DETAILS_V
VIEW - AHL_PC_TREE_V
[top of page]
View: AHL_PC_HEADERS_V
[top of page]
APPS.AHL_PC_HEADERS_V references the following:
APPS
VIEW - AHL_PC_HEADERS_VL
- FND_LOOKUP_VALUES_VL
APPS.AHL_PC_HEADERS_V is referenced by following:
APPS
VIEW - AHL_PC_HEADER_DETAILS_V
[top of page]
View: AHL_PC_HEADERS_VL
[top of page]
APPS.AHL_PC_HEADERS_VL references the following:
APPS
SYNONYM - AHL_PC_HEADERS_B
SYNONYM - AHL_PC_HEADERS_TL
APPS.AHL_PC_HEADERS_VL is referenced by following:
APPS
VIEW - AHL_MEL_CDL_HEADERS_V
VIEW - AHL_PC_HEADERS_V
[top of page]
View: AHL_PC_HEADER_DETAILS_V
[top of page]
APPS.AHL_PC_HEADER_DETAILS_V references the following:
APPS
SYNONYM - AHL_DOCUMENTS_B
SYNONYM - AHL_DOC_REVISIONS_B
SYNONYM - AHL_DOC_TITLE_ASSOS_B
VIEW - AHL_MR_PC_NODES_V
VIEW - AHL_PC_ASSOCIATIONS_V
VIEW - AHL_PC_HEADERS_V
SYNONYM - AHL_PC_NODES_B
PACKAGE - FND_PROFILE
APPS.AHL_PC_HEADER_DETAILS_V is not referenced by any database object
[top of page]
View: AHL_PC_NODES_VL
[top of page]
APPS.AHL_PC_NODES_VL references the following:
APPS
SYNONYM - AHL_PC_NODES_B
SYNONYM - AHL_PC_NODES_TL
APPS.AHL_PC_NODES_VL is referenced by following:
APPS
VIEW - AHL_MEL_CDL_HEADERS_V
VIEW - AHL_PC_TREE_V
[top of page]
View: AHL_PC_TREE_V
[top of page]
APPS.AHL_PC_TREE_V references the following:
APPS
VIEW - AHL_PC_ASSOCIATIONS_V
VIEW - AHL_PC_NODES_VL
APPS.AHL_PC_TREE_V is not referenced by any database object
[top of page]
View: AHL_PLANNING_FACTORS_V
[top of page]
APPS.AHL_PLANNING_FACTORS_V references the following:
APPS
VIEW - AHL_FLEET_HEADERS_VL
SYNONYM - AHL_NR_PROFILE_HEADERS
SYNONYM - AHL_PLANNING_FACTORS
PACKAGE - FND_GLOBAL
SYNONYM - HR_ALL_ORGANIZATION_UNITS
- MTL_UNITS_OF_MEASURE_VL
- MTL_SYSTEM_ITEMS_KFV
- AHL_RESOURCES_V
- FND_LOOKUPS
APPS.AHL_PLANNING_FACTORS_V is not referenced by any database object
[top of page]
View: AHL_PLAN_VISITS_V
[top of page]
APPS.AHL_PLAN_VISITS_V references the following:
APPS
VIEW - AHL_SIMULATION_PLANS_VL
SYNONYM - AHL_UNIT_CONFIG_HEADERS
SYNONYM - AHL_VISITS_B
VIEW - AHL_VISITS_VL
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
- MO_GLOBAL
- ORG_ORGANIZATION_DEFINITIONS
APPS.AHL_PLAN_VISITS_V is not referenced by any database object
[top of page]
View: AHL_POSITION_ALTERNATES_V
[top of page]
APPS.AHL_POSITION_ALTERNATES_V references the following:
APPS
VIEW - AHL_ITEM_ASSOCIATIONS_VL
SYNONYM - AHL_ITEM_GROUPS_B
SYNONYM - AHL_MC_CONFIG_RELATIONS
SYNONYM - AHL_MC_HEADERS_B
SYNONYM - AHL_MC_PATH_POSITION_NODES
SYNONYM - AHL_MC_RELATIONSHIPS
APPS.AHL_POSITION_ALTERNATES_V is referenced by following:
APPS
VIEW - AHL_MR_ITEMS_V
VIEW - AHL_MR_ITEM_DETAILS_V
[top of page]
View: AHL_PP_ASSIGNMENT_V
[top of page]
APPS.AHL_PP_ASSIGNMENT_V references the following:
APPS
VIEW - AHL_PP_REQUIREMENT_V
SYNONYM - AHL_WORK_ASSIGNMENTS
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
SYNONYM - PER_PERSON_TYPES
- PER_PEOPLE_F
APPS.AHL_PP_ASSIGNMENT_V is not referenced by any database object
[top of page]
View: AHL_PP_EMPLOYEE_ASSIGN_V
[top of page]
APPS.AHL_PP_EMPLOYEE_ASSIGN_V references the following:
APPS
PACKAGE - AHL_COMPLETIONS_PVT
SYNONYM - AHL_DEPARTMENT_SHIFTS
SYNONYM - AHL_OPERATION_RESOURCES
PACKAGE - AHL_PRD_PRINT_PVT
PACKAGE - AHL_PRD_RESOURCE_TRANX_PVT
PACKAGE - AHL_PRD_SERN_CHANGE_PVT
PACKAGE - AHL_PRD_UTIL_PKG
PACKAGE - AHL_UTILITY_PVT
PACKAGE - AHL_UTIL_UC_PKG
PACKAGE - AHL_WARRANTY_ENTL_PVT
VIEW - AHL_WORKORDERS_V
VIEW - AHL_WORKORDER_OPERATIONS_V
SYNONYM - AHL_WORK_ASSIGNMENTS
SYNONYM - BOM_RESOURCES
PACKAGE - FND_GLOBAL
PACKAGE - FND_PROFILE
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
SYNONYM - PER_PERSON_TYPES
- MO_GLOBAL
- MFG_LOOKUPS
- PER_PEOPLE_F
APPS.AHL_PP_EMPLOYEE_ASSIGN_V is not referenced by any database object
[top of page]
View: AHL_PP_REQUIREMENT_V
[top of page]
APPS.AHL_PP_REQUIREMENT_V references the following:
APPS
VIEW - AHL_OPERATIONS_VL
SYNONYM - AHL_OPERATION_RESOURCES
SYNONYM - AHL_WORKORDERS
SYNONYM - AHL_WORKORDER_OPERATIONS
SYNONYM - BOM_RESOURCES
SYNONYM - WIP_OPERATIONS
SYNONYM - WIP_OPERATION_RESOURCES
- FND_LOOKUP_VALUES_VL
- MTL_UNITS_OF_MEASURE
- MFG_LOOKUPS
APPS.AHL_PP_REQUIREMENT_V is referenced by following:
APPS
VIEW - AHL_PP_ASSIGNMENT_V
[top of page]
View: AHL_PP_RESRC_REQ_ASG_V
[top of page]
APPS.AHL_PP_RESRC_REQ_ASG_V references the following:
APPS
SYNONYM - AHL_ALTERNATE_RESOURCES
PACKAGE - AHL_COMPLETIONS_PVT
PACKAGE - AHL_PRD_PRINT_PVT
PACKAGE - AHL_PRD_SERN_CHANGE_PVT
SYNONYM - AHL_RESOURCE_MAPPINGS
SYNONYM - AHL_RT_OPER_RESOURCES
PACKAGE - AHL_UTILITY_PVT
PACKAGE - AHL_UTIL_UC_PKG
PACKAGE - AHL_WARRANTY_ENTL_PVT
VIEW - AHL_WORKORDERS_V
VIEW - AHL_WORKORDER_OPERATIONS_V
SYNONYM - BOM_DEPARTMENT_RESOURCES
SYNONYM - BOM_RESOURCES
PACKAGE - FND_GLOBAL
PACKAGE - FND_PROFILE
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
- MO_GLOBAL
- MTL_UNITS_OF_MEASURE
- MFG_LOOKUPS
- FND_LOOKUP_VALUES_VL
APPS.AHL_PP_RESRC_REQ_ASG_V is not referenced by any database object
[top of page]
View: AHL_PRODTYPE_ZONES_V
[top of page]
APPS.AHL_PRODTYPE_ZONES_V references the following:
APPS
SYNONYM - AHL_PRODTYPE_ZONES
- FND_LOOKUP_VALUES_VL
APPS.AHL_PRODTYPE_ZONES_V is not referenced by any database object
[top of page]
View: AHL_PROG_TYPE_SUBTYPES_V
[top of page]
APPS.AHL_PROG_TYPE_SUBTYPES_V references the following:
APPS
SYNONYM - AHL_PROG_TYPE_SUBTYPES
- FND_LOOKUP_VALUES_VL
APPS.AHL_PROG_TYPE_SUBTYPES_V is not referenced by any database object
[top of page]
View: AHL_REFERENCE_DOC_V
[top of page]
APPS.AHL_REFERENCE_DOC_V references the following:
APPS
VIEW - AHL_DOCUMENTS_VL
SYNONYM - AHL_DOC_REVISIONS_B
VIEW - AHL_DOC_TITLE_ASSOS_VL
- AHL_DOC_FILE_ASSOC_VL
- FND_LOOKUP_VALUES_VL
APPS.AHL_REFERENCE_DOC_V is not referenced by any database object
[top of page]
View: AHL_RELATIONSHIPS_VL
[top of page]
APPS.AHL_RELATIONSHIPS_VL references the following:
APPS
SYNONYM - AHL_RELATIONSHIPS_B
SYNONYM - AHL_RELATIONSHIPS_TL
APPS.AHL_RELATIONSHIPS_VL is not referenced by any database object
[top of page]
View: AHL_RESOURCES_V
[top of page]
APPS.AHL_RESOURCES_V references the following:
APPS
SYNONYM - AHL_RESOURCES
- MFG_LOOKUPS
APPS.AHL_RESOURCES_V is not referenced by any database object
[top of page]
View: AHL_RESOURCE_MAPPINGS_V
[top of page]
APPS.AHL_RESOURCE_MAPPINGS_V references the following:
APPS
SYNONYM - AHL_RESOURCE_MAPPINGS
SYNONYM - BOM_DEPARTMENTS
SYNONYM - BOM_RESOURCES
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
- MFG_LOOKUPS
- HR_ORGANIZATION_UNITS
APPS.AHL_RESOURCE_MAPPINGS_V is not referenced by any database object
[top of page]
View: AHL_RESOURCE_SKILLS_V
[top of page]
APPS.AHL_RESOURCE_SKILLS_V references the following:
APPS
SYNONYM - AHL_RESOURCES
SYNONYM - AHL_RESOURCE_SKILLS
SYNONYM - PER_COMPETENCES
SYNONYM - PER_QUALIFICATION_TYPES
SYNONYM - PER_RATING_LEVELS
APPS.AHL_RESOURCE_SKILLS_V is not referenced by any database object
[top of page]
View: AHL_ROUTES_APP_V
[top of page]
APPS.AHL_ROUTES_APP_V references the following:
APPS
VIEW - AHL_ROUTES_B_KFV
SYNONYM - AHL_ROUTES_TL
PACKAGE - FND_PROFILE
APPS.AHL_ROUTES_APP_V is referenced by following:
APPS
VIEW - AHL_MR_ROUTES_V
[top of page]
View: AHL_ROUTES_B_KFV
[top of page]
APPS.AHL_ROUTES_B_KFV references the following:
APPS
SYNONYM - AHL_ROUTES_B
APPS.AHL_ROUTES_B_KFV is referenced by following:
APPS
VIEW - AHL_ROUTES_APP_V
VIEW - AHL_ROUTES_VL
[top of page]
View: AHL_ROUTES_H_VL
[top of page]
APPS.AHL_ROUTES_H_VL references the following:
APPS
SYNONYM - AHL_ROUTES_H_B
SYNONYM - AHL_ROUTES_H_TL
APPS.AHL_ROUTES_H_VL is not referenced by any database object
[top of page]
View: AHL_ROUTES_V
[top of page]
APPS.AHL_ROUTES_V references the following:
APPS
SYNONYM - AHL_ROUTES_TL
SYNONYM - AHL_WARRANTY_TEMPLATES_B
SYNONYM - FND_LOOKUP_VALUES
PACKAGE - FND_PROFILE
SYNONYM - HZ_PARTIES
SYNONYM - JTF_TASK_TEMP_GROUPS_B
SYNONYM - JTF_TASK_TEMP_GROUPS_TL
SYNONYM - QA_CHAR_VALUE_LOOKUPS
SYNONYM - WIP_ACCOUNTING_CLASSES
- AHL_ROUTES_B_KFV
- MTL_SYSTEM_ITEMS_KFV
APPS.AHL_ROUTES_V is not referenced by any database object
[top of page]
View: AHL_ROUTES_VL
[top of page]
APPS.AHL_ROUTES_VL references the following:
APPS
VIEW - AHL_ROUTES_B_KFV
SYNONYM - AHL_ROUTES_TL
APPS.AHL_ROUTES_VL is referenced by following:
APPS
VIEW - AHL_ALL_WORKORDERS_V
VIEW - AHL_SRH_WO_HISTORY_V
VIEW - AHL_WORKORDERS_V
[top of page]
View: AHL_ROUTE_EFFECTIVITIES_V
[top of page]
APPS.AHL_ROUTE_EFFECTIVITIES_V references the following:
APPS
SYNONYM - AHL_ITEM_COMPOSITIONS
SYNONYM - AHL_MC_HEADERS_B
SYNONYM - AHL_MC_HEADERS_TL
SYNONYM - AHL_ROUTES_B
SYNONYM - AHL_ROUTES_TL
SYNONYM - AHL_ROUTE_EFFECTIVITIES
PACKAGE - FND_PROFILE
SYNONYM - MTL_PARAMETERS
- MTL_SYSTEM_ITEMS_KFV
APPS.AHL_ROUTE_EFFECTIVITIES_V is not referenced by any database object
[top of page]
View: AHL_ROUTE_MR_V
[top of page]
APPS.AHL_ROUTE_MR_V references the following:
APPS
SYNONYM - AHL_MR_HEADERS_B
SYNONYM - AHL_MR_ROUTES
SYNONYM - AHL_ROUTES_B
PACKAGE - FND_PROFILE
APPS.AHL_ROUTE_MR_V is not referenced by any database object
[top of page]
View: AHL_ROUTE_OPERATIONS_V
[top of page]
APPS.AHL_ROUTE_OPERATIONS_V references the following:
APPS
VIEW - AHL_OPERATIONS_VL
SYNONYM - AHL_ROUTE_OPERATIONS
- FND_LOOKUP_VALUES_VL
APPS.AHL_ROUTE_OPERATIONS_V is not referenced by any database object
[top of page]
View: AHL_RT_OPER_DEPENDENCIES_V
[top of page]
APPS.AHL_RT_OPER_DEPENDENCIES_V references the following:
APPS
SYNONYM - AHL_ROUTE_OPERATIONS
SYNONYM - AHL_RT_OPER_DEPENDENCIES
- FND_LOOKUP_VALUES_VL
- AHL_OPERATIONS_VL
APPS.AHL_RT_OPER_DEPENDENCIES_V is referenced by following:
APPS
PACKAGE BODY - AHL_RM_ROUTE_PVT
PACKAGE BODY - AHL_RM_RT_OP_DEP_PVT
[top of page]
View: AHL_RT_OPER_LABOR_V
[top of page]
APPS.AHL_RT_OPER_LABOR_V references the following:
APPS
SYNONYM - AHL_RT_OPER_LABOR
SYNONYM - PER_COMPETENCES
SYNONYM - PER_RATING_LEVELS
APPS.AHL_RT_OPER_LABOR_V is not referenced by any database object
[top of page]
View: AHL_RT_OPER_MATERIALS_V
[top of page]
APPS.AHL_RT_OPER_MATERIALS_V references the following:
APPS
VIEW - AHL_ITEM_GROUPS_VL
SYNONYM - AHL_MC_HEADERS_B
SYNONYM - AHL_MC_RELATIONSHIPS
PACKAGE - AHL_RM_ROUTE_UTIL
SYNONYM - AHL_RT_OPER_MATERIALS
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
SYNONYM - MTL_PARAMETERS
- MTL_UNITS_OF_MEASURE_VL
- MTL_SYSTEM_ITEMS_KFV
- FND_LOOKUP_VALUES_VL
APPS.AHL_RT_OPER_MATERIALS_V is not referenced by any database object
[top of page]
View: AHL_RT_OPER_RESOURCES_V
[top of page]
APPS.AHL_RT_OPER_RESOURCES_V references the following:
APPS
SYNONYM - AHL_RT_OPER_RESOURCES
SYNONYM - CST_ACTIVITIES
- AHL_RESOURCES_V
- MFG_LOOKUPS
APPS.AHL_RT_OPER_RESOURCES_V is not referenced by any database object
[top of page]
View: AHL_SCHEDULE_MATERIALS_V
[top of page]
APPS.AHL_SCHEDULE_MATERIALS_V references the following:
APPS
PACKAGE - AHL_COMPLETIONS_PVT
SYNONYM - AHL_ITEM_GROUPS_B
SYNONYM - AHL_MC_HEADERS_B
SYNONYM - AHL_MC_RELATIONSHIPS
PACKAGE - AHL_PP_MATERIALS_PVT
PACKAGE - AHL_PRD_PRINT_PVT
PACKAGE - AHL_PRD_SERN_CHANGE_PVT
PACKAGE - AHL_PRD_UTIL_PKG
SYNONYM - AHL_SCHEDULE_MATERIALS
PACKAGE - AHL_UTILITY_PVT
PACKAGE - AHL_UTIL_UC_PKG
PACKAGE - AHL_WARRANTY_ENTL_PVT
VIEW - AHL_WORKORDERS_V
PACKAGE - FND_GLOBAL
PACKAGE - FND_PROFILE
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
SYNONYM - MTL_RESERVATIONS
SYNONYM - WIP_REQUIREMENT_OPERATIONS
- MTL_SYSTEM_ITEMS_KFV
- FND_LOOKUP_VALUES_VL
- MO_GLOBAL
APPS.AHL_SCHEDULE_MATERIALS_V is not referenced by any database object
[top of page]
View: AHL_SEARCH_TEMPLATES_V
[top of page]
APPS.AHL_SEARCH_TEMPLATES_V references the following:
APPS
VIEW - AHL_VISITS_VL
- FND_LOOKUP_VALUES_VL
- MTL_SYSTEM_ITEMS_B_KFV
APPS.AHL_SEARCH_TEMPLATES_V is not referenced by any database object
[top of page]
View: AHL_SEARCH_TEMPLATE_TASK_V
[top of page]
APPS.AHL_SEARCH_TEMPLATE_TASK_V references the following:
APPS
VIEW - AHL_MR_HEADERS_APP_V
VIEW - AHL_MR_HEADERS_VL
VIEW - AHL_MR_ROUTES_V
VIEW - AHL_VISITS_VL
VIEW - AHL_VISIT_TASKS_VL
PACKAGE - FND_PROFILE
- FND_LOOKUP_VALUES_VL
- MTL_SYSTEM_ITEMS_B_KFV
APPS.AHL_SEARCH_TEMPLATE_TASK_V is not referenced by any database object
[top of page]
View: AHL_SEARCH_VISITS_V
[top of page]
APPS.AHL_SEARCH_VISITS_V references the following:
APPS
VIEW - AHL_SIMULATION_PLANS_VL
SYNONYM - AHL_UNIT_CONFIG_HEADERS
VIEW - AHL_VISITS_VL
SYNONYM - BOM_DEPARTMENTS
SYNONYM - CSI_ITEM_INSTANCES
SYNONYM - FND_CONCURRENT_REQUESTS
PACKAGE - FND_GLOBAL
SYNONYM - HR_ALL_ORGANIZATION_UNITS
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
- FND_LOOKUP_VALUES_VL
- FND_LOOKUPS
- ORG_ORGANIZATION_DEFINITIONS
- CS_INCIDENTS_ALL_B
- PA_PROJECTS
- MTL_SYSTEM_ITEMS_B_KFV
- MO_GLOBAL
APPS.AHL_SEARCH_VISITS_V is not referenced by any database object
[top of page]
View: AHL_SEARCH_VISIT_TASK_V
[top of page]
APPS.AHL_SEARCH_VISIT_TASK_V references the following:
APPS
VIEW - AHL_MR_HEADERS_VL
VIEW - AHL_MR_ROUTES_V
SYNONYM - AHL_ROUTES_B
SYNONYM - AHL_UNIT_EFFECTIVITIES_B
VIEW - AHL_VISITS_VL
VIEW - AHL_VISIT_TASKS_VL
SYNONYM - AHL_WARRANTY_CLAIMS_B
SYNONYM - AHL_WARRANTY_CONTRACTS_B
PACKAGE - AHL_WARRANTY_CONTRACTS_PVT
SYNONYM - AHL_WARRANTY_ENTITLEMENTS
PACKAGE - AHL_WARRANTY_ENTL_PVT
SYNONYM - AHL_WORKORDERS
SYNONYM - BOM_DEPARTMENTS
SYNONYM - CSI_ITEM_INSTANCES
PACKAGE - FND_PROFILE
- FND_LOOKUP_VALUES_VL
- AHL_VWP_STAGES_VL
- MTL_SYSTEM_ITEMS_B_KFV
- CS_INCIDENTS_ALL_B
- PA_LOOKUPS
APPS.AHL_SEARCH_VISIT_TASK_V is not referenced by any database object
[top of page]
View: AHL_SERIAL_NUMBER_CHANGE_V
[top of page]
APPS.AHL_SERIAL_NUMBER_CHANGE_V references the following:
APPS
SYNONYM - AHL_OSP_ORDERS_B
SYNONYM - AHL_OSP_ORDER_LINES
SYNONYM - AHL_WORKORDERS
SYNONYM - CSI_IEA_VALUES
SYNONYM - CSI_IEA_VALUES_H
SYNONYM - CSI_ITEM_INSTANCES
SYNONYM - CSI_ITEM_INSTANCES_H
SYNONYM - CSI_TRANSACTIONS
SYNONYM - CSI_TXN_TYPES
- MTL_SYSTEM_ITEMS_KFV
- FND_LOOKUP_VALUES_VL
APPS.AHL_SERIAL_NUMBER_CHANGE_V is not referenced by any database object
[top of page]
View: AHL_SIMULATION_FORECAST_V
[top of page]
APPS.AHL_SIMULATION_FORECAST_V references the following:
APPS
SYNONYM - AHL_FLEET_HEADERS_B
SYNONYM - AHL_MC_HEADERS_B
SYNONYM - AHL_MR_HEADERS_B
VIEW - AHL_UE_ORGS_DEPTS_V
SYNONYM - AHL_UE_SIMULATIONS
SYNONYM - AHL_UNIT_CONFIG_HEADERS
PACKAGE - AHL_UTIL_UC_PKG
SYNONYM - CSI_ITEM_INSTANCES
PACKAGE - FND_GLOBAL
SYNONYM - HR_ALL_ORGANIZATION_UNITS
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
SYNONYM - MTL_PARAMETERS
- FND_LOOKUPS
- MTL_SYSTEM_ITEMS_KFV
APPS.AHL_SIMULATION_FORECAST_V is not referenced by any database object
[top of page]
View: AHL_SIMULATION_PLANS_VL
[top of page]
APPS.AHL_SIMULATION_PLANS_VL references the following:
APPS
SYNONYM - AHL_SIMULATION_PLANS_B
SYNONYM - AHL_SIMULATION_PLANS_TL
APPS.AHL_SIMULATION_PLANS_VL is referenced by following:
APPS
VIEW - AHL_PLAN_VISITS_V
VIEW - AHL_SEARCH_VISITS_V
[top of page]
View: AHL_SPACES_VL
[top of page]
APPS.AHL_SPACES_VL references the following:
APPS
SYNONYM - AHL_SPACES_B
SYNONYM - AHL_SPACES_TL
APPS.AHL_SPACES_VL is referenced by following:
APPS
VIEW - AHL_SPACE_CAPBLTS_V
VIEW - AHL_SPACE_ORG_DETAILS_V
VIEW - AHL_SPACE_UNAVABL_V
[top of page]
View: AHL_SPACE_CAPBLTS_V
[top of page]
APPS.AHL_SPACE_CAPBLTS_V references the following:
APPS
VIEW - AHL_SPACES_VL
SYNONYM - AHL_SPACE_CAPABILITIES
SYNONYM - BOM_DEPARTMENTS
SYNONYM - HR_ALL_ORGANIZATION_UNITS
- FND_LOOKUP_VALUES_VL
- MTL_SYSTEM_ITEMS_B_KFV
APPS.AHL_SPACE_CAPBLTS_V is not referenced by any database object
[top of page]
View: AHL_SPACE_ORG_DETAILS_V
[top of page]
APPS.AHL_SPACE_ORG_DETAILS_V references the following:
APPS
VIEW - AHL_SPACES_VL
SYNONYM - BOM_DEPARTMENTS
SYNONYM - HR_ALL_ORGANIZATION_UNITS
APPS.AHL_SPACE_ORG_DETAILS_V is not referenced by any database object
[top of page]
View: AHL_SPACE_UNAVABL_V
[top of page]
APPS.AHL_SPACE_UNAVABL_V references the following:
APPS
VIEW - AHL_SPACES_VL
VIEW - AHL_SPACE_UNAVAILABLE_VL
SYNONYM - BOM_DEPARTMENTS
SYNONYM - HR_ALL_ORGANIZATION_UNITS
- FND_LOOKUP_VALUES_VL
APPS.AHL_SPACE_UNAVABL_V is not referenced by any database object
[top of page]
View: AHL_SPACE_UNAVAILABLE_VL
[top of page]
APPS.AHL_SPACE_UNAVAILABLE_VL references the following:
APPS
SYNONYM - AHL_SPACE_UNAVAILABLE_B
SYNONYM - AHL_SPACE_UNAVAILABLE_TL
APPS.AHL_SPACE_UNAVAILABLE_VL is referenced by following:
APPS
VIEW - AHL_SPACE_UNAVABL_V
[top of page]
View: AHL_SR_UE_ASSOCIATIONS_V
[top of page]
APPS.AHL_SR_UE_ASSOCIATIONS_V references the following:
APPS
VIEW - AHL_MR_HEADERS_VL
SYNONYM - AHL_UE_RELATIONSHIPS
VIEW - AHL_UNIT_EFFECTIVITIES_APP_V
PACKAGE - FND_PROFILE
- FND_LOOKUP_VALUES_VL
- CS_INCIDENTS_ALL_B
APPS.AHL_SR_UE_ASSOCIATIONS_V is not referenced by any database object
[top of page]
View: AHL_SUBSCRIPTIONS_VL
[top of page]
APPS.AHL_SUBSCRIPTIONS_VL references the following:
APPS
SYNONYM - AHL_SUBSCRIPTIONS_B
SYNONYM - AHL_SUBSCRIPTIONS_TL
APPS.AHL_SUBSCRIPTIONS_VL is not referenced by any database object
[top of page]
View: AHL_UC_HEADER_PATHS_V
[top of page]
APPS.AHL_UC_HEADER_PATHS_V references the following:
APPS
SYNONYM - AHL_MC_HEADERS_B
SYNONYM - AHL_MC_RELATIONSHIPS
SYNONYM - AHL_UNIT_CONFIG_HEADERS
SYNONYM - CSI_II_RELATIONSHIPS
APPS.AHL_UC_HEADER_PATHS_V is not referenced by any database object
[top of page]
View: AHL_UE_DEFERRAL_DETAILS_V
[top of page]
APPS.AHL_UE_DEFERRAL_DETAILS_V references the following:
APPS
VIEW - AHL_MR_HEADERS_V
SYNONYM - AHL_UNIT_DEFERRALS_B
VIEW - AHL_UNIT_EFFECTIVITIES_APP_V
SYNONYM - AHL_VISITS_B
SYNONYM - AHL_VISIT_TASKS_B
SYNONYM - CSI_ITEM_INSTANCES
PACKAGE - FND_GLOBAL
PACKAGE - FND_PROFILE
SYNONYM - QA_PLAN_COLLECTION_TRIGGERS
SYNONYM - QA_PLAN_TRANSACTIONS
SYNONYM - QA_RESULTS
- CS_INCIDENTS_ALL_VL
- FND_LOOKUP_VALUES_VL
- QA_PLANS_VAL_V
APPS.AHL_UE_DEFERRAL_DETAILS_V is referenced by following:
APPS
VIEW - AHL_MR_INSTANCES_V
VIEW - AHL_SRH_WO_HISTORY_V
[top of page]
View: AHL_UE_ORGS_DEPTS_V
[top of page]
APPS.AHL_UE_ORGS_DEPTS_V references the following:
APPS
VIEW - AHL_DEPARTMENT_SHIFTS_V
SYNONYM - AHL_FLEET_HEADERS_B
SYNONYM - AHL_MR_HEADERS_B
SYNONYM - AHL_MR_ORGANIZATIONS
SYNONYM - AHL_UE_SIMULATIONS
SYNONYM - AHL_UNIT_EFFECTIVITIES_B
SYNONYM - BOM_DEPARTMENTS
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
- HR_ORGANIZATION_UNITS
APPS.AHL_UE_ORGS_DEPTS_V is referenced by following:
APPS
VIEW - AHL_SIMULATION_FORECAST_V
[top of page]
View: AHL_UNIT_ALTERNATES_V
[top of page]
APPS.AHL_UNIT_ALTERNATES_V references the following:
APPS
SYNONYM - AHL_ITEM_ASSOCIATIONS_B
SYNONYM - AHL_MC_RELATIONSHIPS
PACKAGE - AHL_UTIL_UC_PKG
SYNONYM - CSI_II_RELATIONSHIPS
SYNONYM - CSI_ITEM_INSTANCES
SYNONYM - CSI_I_PARTIES
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
SYNONYM - HZ_PARTIES
VIEW - PO_VENDORS
PUBLIC
SYNONYM - DUAL
- MTL_SYSTEM_ITEMS_KFV
- ORG_ORGANIZATION_DEFINITIONS
- MTL_MATERIAL_STATUSES
- MO_GLOBAL
- CSI_LOOKUPS
- DUAL
- CSI_INST_EXTEND_ATTRIB_V
APPS.AHL_UNIT_ALTERNATES_V is not referenced by any database object
[top of page]
View: AHL_UNIT_CONFIG_HEADERS_V
[top of page]
APPS.AHL_UNIT_CONFIG_HEADERS_V references the following:
APPS
SYNONYM - AHL_MC_HEADERS_B
SYNONYM - AHL_MC_HEADERS_TL
SYNONYM - AHL_MC_RELATIONSHIPS
SYNONYM - AHL_UNIT_CONFIG_HEADERS
SYNONYM - CSI_II_RELATIONSHIPS
SYNONYM - CSI_ITEM_INSTANCES
SYNONYM - FND_LOOKUP_VALUES
SYNONYM - MTL_PARAMETERS
- INV_ORGANIZATION_INFO_V
- MTL_SYSTEM_ITEMS_KFV
- MO_GLOBAL
APPS.AHL_UNIT_CONFIG_HEADERS_V is not referenced by any database object
[top of page]
View: AHL_UNIT_DEFERRALS_VL
[top of page]
APPS.AHL_UNIT_DEFERRALS_VL references the following:
APPS
SYNONYM - AHL_UNIT_DEFERRALS_B
SYNONYM - AHL_UNIT_DEFERRALS_TL
APPS.AHL_UNIT_DEFERRALS_VL is not referenced by any database object
[top of page]
View: AHL_UNIT_DETAILS_V
[top of page]
APPS.AHL_UNIT_DETAILS_V references the following:
APPS
SYNONYM - AHL_MC_RELATIONSHIPS
SYNONYM - AHL_UNIT_CONFIG_HEADERS
SYNONYM - CSI_II_RELATIONSHIPS
SYNONYM - CSI_ITEM_INSTANCES
PACKAGE - FND_GLOBAL
- FND_LOOKUPS
- MTL_SYSTEM_ITEMS_KFV
- AHL_MC_HEADERS_VL
- CSI_INST_EXTEND_ATTRIB_V
APPS.AHL_UNIT_DETAILS_V is not referenced by any database object
[top of page]
View: AHL_UNIT_EFFECTIVITIES_APP_V
[top of page]
APPS.AHL_UNIT_EFFECTIVITIES_APP_V references the following:
APPS
VIEW - AHL_UNIT_EFFECTIVITIES_VL
PACKAGE - FND_PROFILE
APPS.AHL_UNIT_EFFECTIVITIES_APP_V is referenced by following:
APPS
VIEW - AHL_SR_UE_ASSOCIATIONS_V
VIEW - AHL_UE_DEFERRAL_DETAILS_V
VIEW - AHL_VISITS_INFO_V
[top of page]
View: AHL_UNIT_EFFECTIVITIES_V
[top of page]
APPS.AHL_UNIT_EFFECTIVITIES_V references the following:
APPS
SYNONYM - AHL_MR_HEADERS_B
SYNONYM - AHL_MR_HEADERS_TL
SYNONYM - AHL_MR_INTERVALS
SYNONYM - AHL_UE_RELATIONSHIPS
PACKAGE - AHL_UMP_UTIL_PKG
SYNONYM - AHL_UNIT_EFFECTIVITIES_B
SYNONYM - AHL_UNIT_EFFECTIVITIES_TL
SYNONYM - CSI_ITEM_INSTANCES
SYNONYM - CS_INCIDENTS_ALL_TL
SYNONYM - CS_INCIDENT_TYPES_TL
SYNONYM - FND_LOOKUP_VALUES
PACKAGE - FND_PROFILE
SYNONYM - OKC_K_HEADERS_ALL_B
SYNONYM - OKC_K_LINES_B
- CS_INCIDENT_TYPES_B
- MTL_SYSTEM_ITEMS_KFV
- CSI_COUNTER_TEMPLATE_VL
- CS_INCIDENTS_ALL_B
APPS.AHL_UNIT_EFFECTIVITIES_V is not referenced by any database object
[top of page]
View: AHL_UNIT_EFFECTIVITIES_VL
[top of page]
APPS.AHL_UNIT_EFFECTIVITIES_VL references the following:
APPS
SYNONYM - AHL_UNIT_EFFECTIVITIES_B
SYNONYM - AHL_UNIT_EFFECTIVITIES_TL
APPS.AHL_UNIT_EFFECTIVITIES_VL is referenced by following:
APPS
VIEW - AHL_UNIT_EFFECTIVITIES_APP_V
[top of page]
View: AHL_UNIT_HEADER_DETAILS_V
[top of page]
APPS.AHL_UNIT_HEADER_DETAILS_V references the following:
APPS
SYNONYM - AHL_MC_RELATIONSHIPS
SYNONYM - AHL_UNIT_CONFIG_HEADERS
PACKAGE - AHL_UTIL_UC_PKG
SYNONYM - CSI_ITEM_INSTANCES
PACKAGE - FND_GLOBAL
SYNONYM - WIP_ENTITIES
- CSI_INST_PARTY_DETAILS_V
- FND_LOOKUPS
- MTL_SYSTEM_ITEMS_KFV
- AHL_MC_HEADERS_VL
APPS.AHL_UNIT_HEADER_DETAILS_V is not referenced by any database object
[top of page]
View: AHL_UNIT_INSTALLED_DETAILS_V
[top of page]
APPS.AHL_UNIT_INSTALLED_DETAILS_V references the following:
APPS
PACKAGE - AHL_UTIL_UC_PKG
SYNONYM - CSI_ITEM_INSTANCES
PACKAGE - FND_GLOBAL
SYNONYM - MTL_PARAMETERS
SYNONYM - MTL_SYSTEM_ITEMS_TL
SYNONYM - WIP_ENTITIES
- MTL_SYSTEM_ITEMS_KFV
- MTL_MATERIAL_STATUSES
- CSI_INST_PARTY_DETAILS_V
- CSI_INST_EXTEND_ATTRIB_V
- FND_LOOKUPS
- CSI_LOOKUPS
APPS.AHL_UNIT_INSTALLED_DETAILS_V is not referenced by any database object
[top of page]
View: AHL_USER_STATUSES_V
[top of page]
APPS.AHL_USER_STATUSES_V references the following:
APPS
VIEW - AHL_USER_STATUSES_VL
- FND_LOOKUP_VALUES_VL
- FND_LOOKUP_TYPES_VL
APPS.AHL_USER_STATUSES_V is not referenced by any database object
[top of page]
View: AHL_USER_STATUSES_VL
[top of page]
APPS.AHL_USER_STATUSES_VL references the following:
APPS
SYNONYM - AHL_USER_STATUSES_B
SYNONYM - AHL_USER_STATUSES_TL
APPS.AHL_USER_STATUSES_VL is referenced by following:
APPS
VIEW - AHL_USER_STATUSES_V
[top of page]
View: AHL_UTILIZATION_FORECAST_V
[top of page]
APPS.AHL_UTILIZATION_FORECAST_V references the following:
APPS
SYNONYM - AHL_UF_DETAILS
SYNONYM - AHL_UF_HEADERS
APPS.AHL_UTILIZATION_FORECAST_V is not referenced by any database object
[top of page]
View: AHL_VISITS_INFO_V
[top of page]
APPS.AHL_VISITS_INFO_V references the following:
APPS
SYNONYM - AHL_MC_HEADERS_B
SYNONYM - AHL_UNIT_CONFIG_HEADERS
VIEW - AHL_UNIT_EFFECTIVITIES_APP_V
PACKAGE - AHL_UTILITY_PVT
SYNONYM - AHL_VISIT_TASKS_B
SYNONYM - BOM_DEPARTMENTS
SYNONYM - CSI_ITEM_INSTANCES
PACKAGE - FND_PROFILE
SYNONYM - HR_ALL_ORGANIZATION_UNITS
- AHL_VISIT_TASKS_VL
- AHL_SIMULATION_PLANS_VL
- MTL_SYSTEM_ITEMS_KFV
- FND_LOOKUP_VALUES_VL
- AHL_VISITS_VL
APPS.AHL_VISITS_INFO_V is not referenced by any database object
[top of page]
View: AHL_VISITS_VL
[top of page]
APPS.AHL_VISITS_VL references the following:
APPS
SYNONYM - AHL_VISITS_B
SYNONYM - AHL_VISITS_TL
APPS.AHL_VISITS_VL is referenced by following:
APPS
VIEW - AHL_ALL_WORKORDERS_V
VIEW - AHL_JOB_OPER_MATERIALS_V
VIEW - AHL_PLAN_VISITS_V
VIEW - AHL_PRD_DISPOSITIONS_V
VIEW - AHL_PRD_VISITS_V
VIEW - AHL_SEARCH_TEMPLATES_V
VIEW - AHL_SEARCH_TEMPLATE_TASK_V
VIEW - AHL_SEARCH_VISITS_V
VIEW - AHL_SEARCH_VISIT_TASK_V
VIEW - AHL_SEARCH_WORKORDERS_V
VIEW - AHL_SRH_MR_HISTORY_ALL_V
VIEW - AHL_SRH_WO_HISTORY_V
VIEW - AHL_VISIT_MR_V
VIEW - AHL_VISIT_TASKS_V
VIEW - AHL_WORKORDERS_V
VIEW - AHL_WORKORDER_TASKS_V
[top of page]
View: AHL_VISIT_DETAILS_V
[top of page]
APPS.AHL_VISIT_DETAILS_V references the following:
APPS
SYNONYM - AHL_UNIT_EFFECTIVITIES_B
PACKAGE - AHL_UTILITY_PVT
SYNONYM - AHL_VISIT_TASKS_B
SYNONYM - BOM_DEPARTMENTS
SYNONYM - CSI_ITEM_INSTANCES
SYNONYM - HR_ALL_ORGANIZATION_UNITS
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
SYNONYM - MTL_PARAMETERS
- ORG_ORGANIZATION_DEFINITIONS
- AHL_VISITS_VL
- MTL_SYSTEM_ITEMS_B_KFV
- MO_GLOBAL
- FND_LOOKUP_VALUES_VL
- AHL_SIMULATION_PLANS_VL
APPS.AHL_VISIT_DETAILS_V is not referenced by any database object
[top of page]
View: AHL_VISIT_MR_V
[top of page]
APPS.AHL_VISIT_MR_V references the following:
APPS
VIEW - AHL_MR_HEADERS_VL
VIEW - AHL_VISITS_VL
VIEW - AHL_VISIT_TASKS_VL
SYNONYM - CSI_ITEM_INSTANCES
- MTL_SYSTEM_ITEMS_B_KFV
APPS.AHL_VISIT_MR_V is not referenced by any database object
[top of page]
View: AHL_VISIT_TASKS_V
[top of page]
APPS.AHL_VISIT_TASKS_V references the following:
APPS
SYNONYM - AHL_SIMULATION_PLANS_B
VIEW - AHL_VISITS_VL
SYNONYM - AHL_VISIT_TASKS_B
SYNONYM - AHL_VISIT_TASKS_TL
- FND_LOOKUP_VALUES_VL
APPS.AHL_VISIT_TASKS_V is referenced by following:
APPS
VIEW - AHL_VISIT_TASK_MATRL_V
[top of page]
View: AHL_VISIT_TASKS_VL
[top of page]
APPS.AHL_VISIT_TASKS_VL references the following:
APPS
SYNONYM - AHL_VISIT_TASKS_B
SYNONYM - AHL_VISIT_TASKS_TL
APPS.AHL_VISIT_TASKS_VL is referenced by following:
APPS
VIEW - AHL_ALL_WORKORDERS_V
VIEW - AHL_PRD_DISPOSITIONS_V
VIEW - AHL_SEARCH_TEMPLATE_TASK_V
VIEW - AHL_SEARCH_VISIT_TASK_V
VIEW - AHL_SRH_MR_HISTORY_ALL_V
VIEW - AHL_SRH_WO_HISTORY_V
VIEW - AHL_VISIT_MR_V
VIEW - AHL_VISIT_TASK_MATRL_V
VIEW - AHL_WORKORDERS_V
VIEW - AHL_WORKORDER_TASKS_V
[top of page]
View: AHL_VISIT_TASK_MATRL_V
[top of page]
APPS.AHL_VISIT_TASK_MATRL_V references the following:
APPS
PACKAGE - AHL_MC_PATH_POSITION_PVT
SYNONYM - AHL_MC_RELATIONSHIPS
SYNONYM - AHL_RT_OPER_MATERIALS
SYNONYM - AHL_SCHEDULE_MATERIALS
VIEW - AHL_VISIT_TASKS_V
VIEW - AHL_VISIT_TASKS_VL
SYNONYM - MTL_SYSTEM_ITEMS_TL
- AHL_MC_HEADERS_VL
- MTL_SYSTEM_ITEMS_KFV
APPS.AHL_VISIT_TASK_MATRL_V is not referenced by any database object
[top of page]
View: AHL_VISIT_TYPES_VL
[top of page]
APPS.AHL_VISIT_TYPES_VL references the following:
APPS
SYNONYM - AHL_VISIT_TYPES_B
SYNONYM - AHL_VISIT_TYPES_TL
- FND_LOOKUP_VALUES_VL
APPS.AHL_VISIT_TYPES_VL is not referenced by any database object
[top of page]
View: AHL_VISIT_TYPE_STAGES_VL
[top of page]
APPS.AHL_VISIT_TYPE_STAGES_VL references the following:
APPS
SYNONYM - AHL_VISIT_TYPE_STAGES_B
SYNONYM - AHL_VISIT_TYPE_STAGES_TL
APPS.AHL_VISIT_TYPE_STAGES_VL is not referenced by any database object
[top of page]
View: AHL_VWP_ROLLUP_COSTS_V
[top of page]
APPS.AHL_VWP_ROLLUP_COSTS_V references the following:
APPS
SYNONYM - CST_EAM_ROLLUP_COSTS
APPS.AHL_VWP_ROLLUP_COSTS_V is not referenced by any database object
[top of page]
View: AHL_WARRANTY_CLAIMS_VL
[top of page]
APPS.AHL_WARRANTY_CLAIMS_VL references the following:
APPS
SYNONYM - AHL_WARRANTY_CLAIMS_B
SYNONYM - AHL_WARRANTY_CLAIMS_TL
APPS.AHL_WARRANTY_CLAIMS_VL is not referenced by any database object
[top of page]
View: AHL_WARRANTY_CONTRACTS_VL
[top of page]
APPS.AHL_WARRANTY_CONTRACTS_VL references the following:
APPS
SYNONYM - AHL_WARRANTY_CONTRACTS_B
SYNONYM - AHL_WARRANTY_CONTRACTS_TL
APPS.AHL_WARRANTY_CONTRACTS_VL is not referenced by any database object
[top of page]
View: AHL_WARRANTY_CONT_CTR_VL
[top of page]
APPS.AHL_WARRANTY_CONT_CTR_VL references the following:
APPS
SYNONYM - AHL_WARRANTY_CONT_CTR_B
SYNONYM - AHL_WARRANTY_CONT_CTR_TL
APPS.AHL_WARRANTY_CONT_CTR_VL is not referenced by any database object
[top of page]
View: AHL_WARRANTY_TEMPLATES_VL
[top of page]
APPS.AHL_WARRANTY_TEMPLATES_VL references the following:
APPS
SYNONYM - AHL_WARRANTY_TEMPLATES_B
SYNONYM - AHL_WARRANTY_TEMPLATES_TL
APPS.AHL_WARRANTY_TEMPLATES_VL is not referenced by any database object
[top of page]
View: AHL_WARRANTY_TMPL_CTR_VL
[top of page]
APPS.AHL_WARRANTY_TMPL_CTR_VL references the following:
APPS
SYNONYM - AHL_WARRANTY_TMPL_CTR_B
SYNONYM - AHL_WARRANTY_TMPL_CTR_TL
APPS.AHL_WARRANTY_TMPL_CTR_VL is not referenced by any database object
[top of page]
View: AHL_WF_MAPPING_V
[top of page]
APPS.AHL_WF_MAPPING_V references the following:
APPS
SYNONYM - AHL_WF_MAPPING
- WF_RUNNABLE_PROCESSES_V
- FND_LOOKUP_VALUES_VL
APPS.AHL_WF_MAPPING_V is not referenced by any database object
[top of page]
View: AHL_WIP_RESOURCE_TXNS_V
[top of page]
APPS.AHL_WIP_RESOURCE_TXNS_V references the following:
APPS
SYNONYM - AHL_WORKORDERS
SYNONYM - BOM_DEPARTMENTS
SYNONYM - BOM_RESOURCES
SYNONYM - CST_ACTIVITIES
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
SYNONYM - MTL_TRANSACTION_REASONS
SYNONYM - WIP_COST_TXN_INTERFACE
SYNONYM - WIP_ENTITIES
SYNONYM - WIP_OPERATION_RESOURCES
SYNONYM - WIP_TRANSACTIONS
- MTL_UNITS_OF_MEASURE
- FND_LOOKUP_VALUES_VL
- MFG_LOOKUPS
- PER_PEOPLE_F
APPS.AHL_WIP_RESOURCE_TXNS_V is not referenced by any database object
[top of page]
View: AHL_WORKORDERS_OSP_V
[top of page]
APPS.AHL_WORKORDERS_OSP_V references the following:
APPS
SYNONYM - AHL_ROUTES_B
SYNONYM - AHL_VISITS_B
SYNONYM - AHL_VISIT_TASKS_B
SYNONYM - AHL_WORKORDERS
SYNONYM - BOM_DEPARTMENTS
SYNONYM - CSI_ITEM_INSTANCES
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
SYNONYM - PA_TASKS
SYNONYM - WIP_DISCRETE_JOBS
- ORG_ORGANIZATION_DEFINITIONS
- MO_GLOBAL
- MTL_SYSTEM_ITEMS_KFV
- PA_PROJECTS_ALL
APPS.AHL_WORKORDERS_OSP_V is not referenced by any database object
[top of page]
View: AHL_WORKORDERS_V
[top of page]
APPS.AHL_WORKORDERS_V references the following:
APPS
PACKAGE - AHL_COMPLETIONS_PVT
SYNONYM - AHL_MR_HEADERS_B
VIEW - AHL_MR_ROUTES_APP_V
SYNONYM - AHL_OSP_ORDERS_B
SYNONYM - AHL_OSP_ORDER_LINES
PACKAGE - AHL_PRD_PRINT_PVT
PACKAGE - AHL_PRD_SERN_CHANGE_PVT
VIEW - AHL_ROUTES_VL
SYNONYM - AHL_UNIT_EFFECTIVITIES_B
PACKAGE - AHL_UTILITY_PVT
PACKAGE - AHL_UTIL_UC_PKG
VIEW - AHL_VISITS_VL
SYNONYM - AHL_VISIT_INST_ROUTINGS
VIEW - AHL_VISIT_TASKS_VL
SYNONYM - AHL_WARRANTY_CLAIMS_B
SYNONYM - AHL_WARRANTY_CONTRACTS_B
SYNONYM - AHL_WARRANTY_ENTITLEMENTS
PACKAGE - AHL_WARRANTY_ENTL_PVT
SYNONYM - AHL_WORKORDERS
SYNONYM - BOM_DEPARTMENTS
SYNONYM - CSI_ITEM_INSTANCES
PACKAGE - FND_GLOBAL
PACKAGE - FND_PROFILE
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
SYNONYM - MTL_RESERVATIONS
SYNONYM - PA_TASKS
SYNONYM - QA_PLAN_COLLECTION_TRIGGERS
SYNONYM - QA_PLAN_TRANSACTIONS
SYNONYM - QA_RESULTS
SYNONYM - WIP_DISCRETE_JOBS
- PA_LOOKUPS
- QA_PLANS_VAL_V
- HR_ORGANIZATION_UNITS
- MTL_SYSTEM_ITEMS_KFV
- MFG_LOOKUPS
- MTL_ITEM_LOCATIONS_KFV
- CS_INCIDENTS_ALL_B
- MO_GLOBAL
- ORG_ORGANIZATION_DEFINITIONS
- FND_LOOKUP_VALUES_VL
- PA_PROJECTS_ALL
APPS.AHL_WORKORDERS_V is referenced by following:
APPS
VIEW - AHL_PP_EMPLOYEE_ASSIGN_V
VIEW - AHL_PP_RESRC_REQ_ASG_V
VIEW - AHL_SCHEDULE_MATERIALS_V
[top of page]
View: AHL_WORKORDER_OPERATIONS_V
[top of page]
APPS.AHL_WORKORDER_OPERATIONS_V references the following:
APPS
VIEW - AHL_OPERATIONS_B_KFV
SYNONYM - AHL_WORKORDERS
SYNONYM - AHL_WORKORDER_OPERATIONS
SYNONYM - BOM_DEPARTMENTS
SYNONYM - WIP_OPERATIONS
- FND_LOOKUP_VALUES_VL
APPS.AHL_WORKORDER_OPERATIONS_V is referenced by following:
APPS
VIEW - AHL_JOB_OPER_MATERIALS_V
VIEW - AHL_PP_EMPLOYEE_ASSIGN_V
VIEW - AHL_PP_RESRC_REQ_ASG_V
[top of page]