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®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, 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_APPROVAL_API

TABLE - AHL.AHL_APPROVAL_RULES_B

TABLE - AHL.AHL_APPROVAL_RULES_TL

TABLE - AHL.AHL_APPROVERS

TABLE - AHL.AHL_CTR_UPDATE_RULES

TABLE - AHL.AHL_DEPARTMENT_SHIFTS

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_EVENT_ASSOCIATIONS

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_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_MR_ACTIONS_B

TABLE - AHL.AHL_MR_ACTIONS_TL

TABLE - AHL.AHL_MR_EFFECTIVITIES

TABLE - AHL.AHL_MR_EFFECTIVITY_DTLS

TABLE - AHL.AHL_MR_HEADERS_B

TABLE - AHL.AHL_MR_HEADERS_TL

TABLE - AHL.AHL_MR_INTERVALS

TABLE - AHL.AHL_MR_RELATIONSHIPS

TABLE - AHL.AHL_MR_ROUTES

TABLE - AHL.AHL_MR_ROUTE_SEQUENCES

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_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_PRD_MB_UC_DETAILS

TABLE - AHL.AHL_PRODTYPE_ZONES

TABLE - AHL.AHL_PROG_TYPE_SUBTYPES

TABLE - AHL.AHL_RECIPIENT_DOCUMENTS

TABLE - AHL.AHL_RELATIONSHIPS_B

TABLE - AHL.AHL_RELATIONSHIPS_TL

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_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_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_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_UC_HEADERS_H

TABLE - AHL.AHL_UE_RELATIONSHIPS

TABLE - AHL.AHL_UF_DETAILS

TABLE - AHL.AHL_UF_HEADERS

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_THRESHOLDS

TABLE - AHL.AHL_USER_STATUSES_B

TABLE - AHL.AHL_USER_STATUSES_TL

TABLE - AHL.AHL_VISITS_B

TABLE - AHL.AHL_VISITS_TL

TABLE - AHL.AHL_VISIT_TASKS_B

TABLE - AHL.AHL_VISIT_TASKS_TL

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_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_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_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_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_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_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_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_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_VWP_ROLLUP_COSTS_V

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

Primary Key: AHL_ALTERNATE_RESOURCES_PK

1. ALTERNATE_RESOURCE_ID

Foreign Keys from this table:

Comments

This table stores the alternate ASO resources for the resource requirements.

Indexes

Columns

[top of page]

AHL.AHL_ALTERNATE_RESOURCES does not reference any database object

AHL.AHL_ALTERNATE_RESOURCES is referenced by following:

APPS

SYNONYM - AHL_ALTERNATE_RESOURCES

[top of page]

Table: AHL_APPLICABLE_INSTANCES

Comments

Indexes

Columns

[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

Comments

Indexes

Columns

[top of page]

AHL.AHL_APPLICABLE_MRS does not reference any database object

AHL.AHL_APPLICABLE_MRS is referenced by following:

APPS

SYNONYM - AHL_APPLICABLE_MRS

[top of page]

Table: AHL_APPROVAL_API

Primary Key: AHL_APPROVAL_APU_PK

1. APPROVAL_API_ID

Comments

This table stores information about apis for approval rules

Indexes

Columns

[top of page]

AHL.AHL_APPROVAL_API does not reference any database object

AHL.AHL_APPROVAL_API is referenced by following:

APPS

SYNONYM - AHL_APPROVAL_API

[top of page]

Table: AHL_APPROVAL_RULES_B

Primary Key: AHL_APPROVAL_RULES_B_PK

1. APPROVAL_RULE_ID

Foreign Keys to this table:

Comments

This table stores information about approval rules

Indexes

Columns

[top of page]

AHL.AHL_APPROVAL_RULES_B does not reference any database object

AHL.AHL_APPROVAL_RULES_B is referenced by following:

APPS

SYNONYM - AHL_APPROVAL_RULES_B

[top of page]

Table: AHL_APPROVAL_RULES_TL

Primary Key: AHL_APPROVAL_RULES_TL_PK

1. APPROVAL_RULE_ID
2. LANGUAGE

Foreign Keys from this table:

Comments

This table stores information about translated columns for approval rules

Indexes

Columns

[top of page]

AHL.AHL_APPROVAL_RULES_TL does not reference any database object

AHL.AHL_APPROVAL_RULES_TL is referenced by following:

APPS

SYNONYM - AHL_APPROVAL_RULES_TL

[top of page]

Table: AHL_APPROVERS

Primary Key: AHL_APPROVERS_PK

1. APPROVAL_APPROVER_ID

Foreign Keys from this table:

Comments

This table stores information about approvers

Indexes

Columns

[top of page]

AHL.AHL_APPROVERS does not reference any database object

AHL.AHL_APPROVERS is referenced by following:

APPS

SYNONYM - AHL_APPROVERS

[top of page]

Table: AHL_CTR_UPDATE_RULES

Primary Key: AHL_CTR_UPDATE_RULES_PK

1. CTR_UPDATE_RULE_ID

Primary Key: AHL_CTR_UPDATE_RULES_UK1

1. RELATIONSHIP_ID
2. UOM_CODE
3. RULE_CODE

Foreign Keys from this table:

Comments

This table will store rules to update counters for a position with respect to its parent position.

Indexes

Columns

[top of page]

AHL.AHL_CTR_UPDATE_RULES does not reference any database object

AHL.AHL_CTR_UPDATE_RULES is referenced by following:

APPS

SYNONYM - AHL_CTR_UPDATE_RULES

[top of page]

Table: AHL_DEPARTMENT_SHIFTS

Primary Key: AHL_DEPARTMENT_SHIFTS_PK

1. AHL_DEPARTMENT_SHIFTS_ID

Foreign Keys from this table:

Comments

This table stores information about department shifts

Indexes

Columns

[top of page]

AHL.AHL_DEPARTMENT_SHIFTS does not reference any database object

AHL.AHL_DEPARTMENT_SHIFTS is referenced by following:

APPS

SYNONYM - AHL_DEPARTMENT_SHIFTS

[top of page]

Table: AHL_DOCUMENTS_B

Primary Key: AHL_DOCUMENTS_B_PK

1. DOCUMENT_ID

Primary Key: AHL_DOCUMENTS_B_UK1

1. DOCUMENT_NO

Foreign Keys from this table:

Foreign Keys to this table:

Comments

This table stores information about documents, which are provided by suppliers of a product or any other manuals used in the ASO industry. It stores Associations between documents and sub types, operator codes, product type codes and sources of the documents. This information is utilized in the Route Management, Unit Configuration and Master Configuration modules.

Indexes

Columns

[top of page]

AHL.AHL_DOCUMENTS_B does not reference any database object

AHL.AHL_DOCUMENTS_B is referenced by following:

APPS

SYNONYM - AHL_DOCUMENTS_B

[top of page]

Table: AHL_DOCUMENTS_TL

Primary Key: AHL_DOCUMENTS_TL_PK

1. DOCUMENT_ID
2. LANGUAGE

Foreign Keys from this table:

Comments

This table stores the translated column information for document.

Indexes

Columns

[top of page]

AHL.AHL_DOCUMENTS_TL does not reference any database object

AHL.AHL_DOCUMENTS_TL is referenced by following:

APPS

SYNONYM - AHL_DOCUMENTS_TL

[top of page]

Table: AHL_DOCUMENT_SUB_TYPES

Primary Key: AHL_DOCUMENT_SUB_TYPES_PK

1. DOCUMENT_SUB_TYPE_ID

Primary Key: AHL_DOCUMENT_SUB_TYPES_UK1

1. DOC_TYPE_CODE
2. DOC_SUB_TYPE_CODE

Comments

This table stores association information between document types and document sub types.

Indexes

Columns

[top of page]

AHL.AHL_DOCUMENT_SUB_TYPES does not reference any database object

AHL.AHL_DOCUMENT_SUB_TYPES is referenced by following:

APPS

SYNONYM - AHL_DOCUMENT_SUB_TYPES

[top of page]

Table: AHL_DOC_FILE_ASSOC_B

Primary Key: AHL_DOC_FILE_ASSOC_B_PK1

1. ASSOCIATION_ID

Foreign Keys from this table:

Comments

This table stores files association with document. As a part of 11.5.10 Enhancements

Columns

[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:

APPS

SYNONYM - AHL_DOC_FILE_ASSOC_B

[top of page]

Table: AHL_DOC_FILE_ASSOC_TL

Comments

This table stores the translated values for AHL_DOC_FILE_ASSOC_B

Indexes

Columns

[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:

APPS

SYNONYM - AHL_DOC_FILE_ASSOC_TL

[top of page]

Table: AHL_DOC_REVISIONS_B

Primary Key: AHL_DOC_REVISIONS_B_PK

1. DOC_REVISION_ID

Primary Key: AHL_DOC_REVISIONS_B_UK1

1. DOCUMENT_ID
2. REVISION_NO

Foreign Keys from this table:

Foreign Keys to this table:

Comments

This table stores revision information of a document.

Indexes

Columns

[top of page]

AHL.AHL_DOC_REVISIONS_B does not reference any database object

AHL.AHL_DOC_REVISIONS_B is referenced by following:

APPS

SYNONYM - AHL_DOC_REVISIONS_B

[top of page]

Table: AHL_DOC_REVISIONS_TL

Primary Key: AHL_DOC_REVISIONS_TL_PK

1. DOC_REVISION_ID
2. LANGUAGE

Foreign Keys from this table:

Comments

This table stores the translated column information of a document revision.

Indexes

Columns

[top of page]

AHL.AHL_DOC_REVISIONS_TL does not reference any database object

AHL.AHL_DOC_REVISIONS_TL is referenced by following:

APPS

SYNONYM - AHL_DOC_REVISIONS_TL

[top of page]

Table: AHL_DOC_REVISION_COPIES

Primary Key: AHL_DOC_REVISION_COPIES_PK

1. DOC_REVISION_COPY_ID

Primary Key: AHL_DOC_REVISION_COPIES_UK1

1. DOC_REVISION_ID
2. RECEIVED_BY_PARTY_ID

Foreign Keys from this table:

Comments

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes

Columns

[top of page]

AHL.AHL_DOC_REVISION_COPIES does not reference any database object

AHL.AHL_DOC_REVISION_COPIES is referenced by following:

APPS

SYNONYM - AHL_DOC_REVISION_COPIES

[top of page]

Table: AHL_DOC_TITLE_ASSOS_B

Primary Key: AHL_DOC_TITLE_ASSOS_B_PK

1. DOC_TITLE_ASSO_ID

Primary Key: AHL_DOC_TITLE_ASSOS_B_UK1

1. ASO_OBJECT_ID
2. ASO_OBJECT_TYPE_CODE
3. DOCUMENT_ID
4. DOC_REVISION_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

This table stores association between document or document revision and ASO object (ASO object could be a route, master configuration, unit configuration, etc.).

Indexes

Columns

[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:

APPS

SYNONYM - AHL_DOC_TITLE_ASSOS_B

[top of page]

Table: AHL_DOC_TITLE_ASSOS_TL

Primary Key: AHL_DOC_TITLE_ASSOS_TL_PK

1. DOC_TITLE_ASSO_ID
2. LANGUAGE

Foreign Keys from this table:

Comments

This table stores the translated columns information for the association between document or document revision and ASO object.

Indexes

Columns

[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:

APPS

SYNONYM - AHL_DOC_TITLE_ASSOS_TL

[top of page]

Table: AHL_EVENT_ASSOCIATIONS

Primary Key: AHL_EVENT_ASSOCIATIONS_PK

1. EVENT_ASSOCIATION_ID

Primary Key: AHL_EVENT_ASSOCIATIONS_UK1

1. RELATIONSHIP_ID
2. EVENT_ID

Foreign Keys from this table:

Comments

This table is an intersection table to store the association between events and positions.

Indexes

Columns

[top of page]

AHL.AHL_EVENT_ASSOCIATIONS does not reference any database object

AHL.AHL_EVENT_ASSOCIATIONS is referenced by following:

APPS

SYNONYM - AHL_EVENT_ASSOCIATIONS

[top of page]

Table: AHL_ITEM_ASSOCIATIONS_B

Primary Key: AHL_ITEM_ASSOCIATIONS_B_PK

1. ITEM_ASSOCIATION_ID

Foreign Keys to this table:

Comments

This table is an intersection table to store the association between item group and the inventory item.

Indexes

Columns

[top of page]

AHL.AHL_ITEM_ASSOCIATIONS_B does not reference any database object

AHL.AHL_ITEM_ASSOCIATIONS_B is referenced by following:

APPS

SYNONYM - AHL_ITEM_ASSOCIATIONS_B

[top of page]

Table: AHL_ITEM_ASSOCIATIONS_B_H

Primary Key: AHL_ITEM_ASSOCIATIONS_B_H_PK

1. ITEM_ASSOCIATION_H_ID

Foreign Keys from this table:

Comments

This group is the assocation of the Item Group Associations

Indexes

Columns

[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:

APPS

SYNONYM - AHL_ITEM_ASSOCIATIONS_B_H

[top of page]

Table: AHL_ITEM_ASSOCIATIONS_TL

Primary Key: AHL_ITEM_ASSOCIATIONS_TL_PK

1. ITEM_ASSOCIATION_ID
2. LANGUAGE

Foreign Keys from this table:

Comments

This table is an intersection table to store the association between item group and the inventory item.

Indexes

Columns

[top of page]

AHL.AHL_ITEM_ASSOCIATIONS_TL does not reference any database object

AHL.AHL_ITEM_ASSOCIATIONS_TL is referenced by following:

APPS

SYNONYM - AHL_ITEM_ASSOCIATIONS_TL

[top of page]

Table: AHL_ITEM_ASSOCIATIONS_TL_H

Primary Key: AHL_ITEM_ASSOCIATIONS_TL_H_PK

1. ITEM_ASSOCIATION_H_ID
2. LANGUAGE

Foreign Keys from this table:

Comments

This is hisory table for Item Associations.

Indexes

Columns

[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:

APPS

SYNONYM - AHL_ITEM_ASSOCIATIONS_TL_H

[top of page]

Table: AHL_ITEM_COMPOSITIONS

Primary Key: AHL_ITEM_COMPOSITIONS_PK

1. ITEM_COMPOSITION_ID

Primary Key: AHL_ITEM_COMPOSITIONS_UK1

1. INVENTORY_ITEM_ID
2. INVENTORY_MASTER_ORG_ID
3. APPROVAL_STATUS_CODE

Foreign Keys to this table:

Comments

This table stores information about item compositions header .

Indexes

Columns

[top of page]

AHL.AHL_ITEM_COMPOSITIONS does not reference any database object

AHL.AHL_ITEM_COMPOSITIONS is referenced by following:

APPS

SYNONYM - AHL_ITEM_COMPOSITIONS

[top of page]

Table: AHL_ITEM_COMP_DETAILS

Primary Key: AHL_ITEM_COMP_DETAILS_PK

1. ITEM_COMP_DETAIL_ID

Foreign Keys from this table:

Comments

This table stores the details of Non-Tracked Items/ Item Groups associated with a Item Composition in the header table.

Indexes

Columns

[top of page]

AHL.AHL_ITEM_COMP_DETAILS does not reference any database object

AHL.AHL_ITEM_COMP_DETAILS is referenced by following:

APPS

SYNONYM - AHL_ITEM_COMP_DETAILS

[top of page]

Table: AHL_ITEM_GROUPS_B

Primary Key: AHL_ITEM_GROUPS_B_PK

1. ITEM_GROUP_ID

Primary Key: AHL_ITEM_GROUPS_B_UK1

1. NAME

Foreign Keys to this table:

Comments

This table stores information about item groups. Items are grouped so that each group could be used in positions multiple times.

Indexes

Columns

[top of page]

AHL.AHL_ITEM_GROUPS_B does not reference any database object

AHL.AHL_ITEM_GROUPS_B is referenced by following:

APPS

SYNONYM - AHL_ITEM_GROUPS_B

[top of page]

Table: AHL_ITEM_GROUPS_B_H

Primary Key: AHL_ITEM_GROUPS_B_H_PK

1. ITEM_GROUP_H_ID

Foreign Keys from this table:

Comments

This table stores History about item groups.

Indexes

Columns

[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:

APPS

SYNONYM - AHL_ITEM_GROUPS_B_H

[top of page]

Table: AHL_ITEM_GROUPS_TL

Primary Key: AHL_ITEM_GROUPS_TL_PK

1. ITEM_GROUP_ID
2. LANGUAGE

Foreign Keys from this table:

Comments

This table stores translated information about item groups.

Indexes

Columns

[top of page]

AHL.AHL_ITEM_GROUPS_TL does not reference any database object

AHL.AHL_ITEM_GROUPS_TL is referenced by following:

APPS

SYNONYM - AHL_ITEM_GROUPS_TL

[top of page]

Table: AHL_ITEM_GROUPS_TL_H

Primary Key: AHL_ITEM_GROUPS_TL_H_PK

1. ITEM_GROUP_H_ID
2. LANGUAGE

Foreign Keys from this table:

Comments

This table stores translated information about item groups History

Indexes

Columns

[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:

APPS

SYNONYM - AHL_ITEM_GROUPS_TL_H

[top of page]

Table: AHL_MC_CONFIG_RELATIONS

Primary Key: AHL_MC_CONFIG_RELATIONS_PK

1. MC_CONFIG_RELATION_ID

Primary Key: AHL_MC_CONFIG_RELATIONS_UK1

1. RELATIONSHIP_ID
2. MC_HEADER_ID

Foreign Keys from this table:

Comments

This table maps sub configuration with Parent Master Configurations

Indexes

Columns

[top of page]

AHL.AHL_MC_CONFIG_RELATIONS does not reference any database object

AHL.AHL_MC_CONFIG_RELATIONS is referenced by following:

APPS

SYNONYM - AHL_MC_CONFIG_RELATIONS

[top of page]

Table: AHL_MC_HEADERS_B

Primary Key: AHL_MC_HEADERS_B_PK

1. MC_HEADER_ID

Primary Key: AHL_MC_HEADERS_B_UK1

1. MC_ID
2. VERSION_NUMBER

Primary Key: AHL_MC_HEADERS_B_UK2

1. NAME
2. REVISION

Primary Key: AHL_MC_HEADERS_B_UK3

1. VERSION_NUMBER
2. NAME

Primary Key: AHL_MC_HEADERS_B_UK4

1. MC_ID
2. REVISION

Foreign Keys to this table:

Comments

Stores Master Configuration Header details

Indexes

Columns

[top of page]

AHL.AHL_MC_HEADERS_B does not reference any database object

AHL.AHL_MC_HEADERS_B is referenced by following:

APPS

SYNONYM - AHL_MC_HEADERS_B

[top of page]

Table: AHL_MC_HEADERS_TL

Primary Key: AHL_MC_HEADERS_TL_PK

1. MC_HEADER_ID
2. LANGUAGE

Foreign Keys from this table:

Comments

This table stores translatable Master Configuration header information

Indexes

Columns

[top of page]

AHL.AHL_MC_HEADERS_TL does not reference any database object

AHL.AHL_MC_HEADERS_TL is referenced by following:

APPS

SYNONYM - AHL_MC_HEADERS_TL

[top of page]

Table: AHL_MC_PATH_POSITIONS