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_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
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:
APPS
SYNONYM - 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 referenced by following:
APPS
SYNONYM - AHL_APPLICABLE_MRS
[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:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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:
APPS
SYNONYM - AHL_APPROVERS
[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
%
[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
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:
APPS
SYNONYM - AHL_DEPARTMENT_SHIFTS
[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:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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
[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
Description: This table stores the translated values for 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:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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:
APPS
SYNONYM - AHL_DOC_REVISIONS_TL
[top of page]
Table: AHL_DOC_REVISION_COPIES
Description: 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:
APPS
SYNONYM - 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_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:
APPS
SYNONYM - 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:
APPS
SYNONYM - AHL_DOC_TITLE_ASSOS_TL
[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:
APPS
SYNONYM - AHL_EVENT_ASSOCIATIONS
[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:
APPS
SYNONYM - 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
[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
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:
APPS
SYNONYM - 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
%
[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
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_RT_OPER_MATERIALS.ITEM_COMP_DETAIL_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:
APPS
SYNONYM - 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_COMP_DETAILS.ITEM_GROUP_ID
AHL_ITEM_GROUPS_B
[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
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_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:
APPS
SYNONYM - 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
[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
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:
APPS
SYNONYM - 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
%
[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
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:
APPS
SYNONYM - AHL_MC_CONFIG_RELATIONS
[top of page]
Table: AHL_MC_HEADERS_B
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_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:
APPS
SYNONYM - 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
%
[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
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_RT_OPER_MATERIALS.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:
APPS
SYNONYM - 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
%
[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:
APPS
SYNONYM - 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_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_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:
APPS
SYNONYM - 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
%
[top of page]
AHL.AHL_MC_RULES_B does not reference any database object
AHL.AHL_MC_RULES_B is referenced by following:
APPS
SYNONYM - 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
%
[top of page]
AHL.AHL_MC_RULES_TL does not reference any database object
AHL.AHL_MC_RULES_TL is referenced by following:
APPS
SYNONYM - 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_RULE_STATEMENTS.SUBJECT_ID
%
AHL_MC_RULE_STATEMENTS.SUBJECT_ID
AHL_MC_RULE_STATEMENTS
AHL_MC_RULE_STATEMENTS.OBJECT_ID
%
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:
APPS
SYNONYM - AHL_MC_RULE_STATEMENTS
[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:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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_RELATIONSHIPS_B
AHL_MR_EFFECTIVITIES.INVENTORY_ITEM_ID
AHL_MR_EFFECTIVITIES.INVENTORY_ORG_ID
MTL_SYSTEM_ITEMS_B
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AHL_MR_EFFECTIVITY_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:
APPS
SYNONYM - 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:
APPS
SYNONYM - AHL_MR_EFFECTIVITY_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
Foreign Keys to this table:
Foreign Key Column
Foreign Table
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:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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:
APPS
SYNONYM - AHL_MR_INTERVALS
[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:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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:
APPS
SYNONYM - AHL_MR_ROUTE_SEQUENCES
[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_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:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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_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:
APPS
SYNONYM - AHL_OPERATION_RESOURCES
[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
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:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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
[top of page]
AHL.AHL_OSP_ORDER_LINES does not reference any database object
AHL.AHL_OSP_ORDER_LINES is referenced by following:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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
[top of page]
AHL.AHL_PART_CHANGES does not reference any database object
AHL.AHL_PART_CHANGES is referenced by following:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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_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:
APPS
SYNONYM - 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:
APPS
SYNONYM - AHL_PC_NODES_TL
[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:
APPS
SYNONYM - 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:
APPS
SYNONYM - AHL_PROG_TYPE_SUBTYPES
[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:
APPS
SYNONYM - 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_MR_EFFECTIVITIES.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:
APPS
SYNONYM - 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:
APPS
SYNONYM - AHL_RELATIONSHIPS_TL
[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:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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
AHL_ROUTES_B.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
AHL_ROUTES_B.ACCOUNTING_CLASS_ORG_ID
WIP_ACCOUNTING_CLASSES
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_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:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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.MC_HEADER_ID
AHL_MC_HEADERS_B
[top of page]
AHL.AHL_ROUTE_EFFECTIVITIES does not reference any database object
AHL.AHL_ROUTE_EFFECTIVITIES is referenced by following:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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:
APPS
SYNONYM - AHL_ROUTE_OPERATIONS_H
[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:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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
AHL_RT_OPER_MATERIALS.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_COMPOSITIONS
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:
APPS
SYNONYM - 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
AHL_RT_OPER_MATERIALS_H.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:
APPS
SYNONYM - 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:
APPS
SYNONYM - AHL_RT_OPER_RESOURCES
[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
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:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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:
APPS
SYNONYM - AHL_SPACE_UNAVAILABLE_TL
[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:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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:
APPS
SYNONYM - AHL_TASK_LINKS
[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:
APPS
SYNONYM - 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:
APPS
SYNONYM - AHL_UE_RELATIONSHIPS
[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:
APPS
SYNONYM - 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
AHL_UF_HEADERS.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:
APPS
SYNONYM - AHL_UF_HEADERS
[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:
APPS
SYNONYM - 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
[top of page]
AHL.AHL_UNIT_CONFIG_HEADERS does not reference any database object
AHL.AHL_UNIT_CONFIG_HEADERS is referenced by following:
APPS
SYNONYM - 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
[top of page]
AHL.AHL_UNIT_DEFERRALS_B does not reference any database object
AHL.AHL_UNIT_DEFERRALS_B is referenced by following:
APPS
SYNONYM - AHL_UNIT_DEFERRALS_B
[top of page]
Table: AHL_UNIT_DEFERRALS_TL
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
%
[top of page]
AHL.AHL_UNIT_DEFERRALS_TL does not reference any database object
AHL.AHL_UNIT_DEFERRALS_TL is referenced by following:
APPS
SYNONYM - 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: 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.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
Foreign Keys to 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
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:
APPS
SYNONYM - 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:
APPS
SYNONYM - AHL_UNIT_EFFECTIVITIES_TL
[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
%
[top of page]
AHL.AHL_UNIT_THRESHOLDS does not reference any database object
AHL.AHL_UNIT_THRESHOLDS is referenced by following:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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:
APPS
SYNONYM - AHL_USER_STATUSES_TL
[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
AHL_VISITS_B.ITEM_ORGANIZATION_ID
MTL_SYSTEM_ITEMS_B
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_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:
APPS
SYNONYM - 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:
APPS
SYNONYM - AHL_VISITS_TL
[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.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
AHL_VISIT_TASKS_B.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_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:
APPS
SYNONYM - 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:
APPS
SYNONYM - AHL_VISIT_TASKS_TL
[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:
APPS
SYNONYM - 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_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:
APPS
SYNONYM - 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
AHL_WORKORDER_MTL_TXNS.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
AHL_WORKORDER_MTL_TXNS.ORGANIZATION_ID
MTL_SYSTEM_ITEMS_B
AHL_WORKORDER_MTL_TXNS.SUBINVENTORY_CODE
AHL_WORKORDER_MTL_TXNS.ORGANIZATION_ID
MTL_SECONDARY_INVENTORIES
AHL_WORKORDER_MTL_TXNS.TRANSACTION_TYPE_ID
MTL_TRANSACTION_TYPES
AHL_WORKORDER_MTL_TXNS.INVENTORY_ITEM_ID
AHL_WORKORDER_MTL_TXNS.ORGANIZATION_ID
AHL_WORKORDER_MTL_TXNS.LOT_NUMBER
MTL_LOT_NUMBERS
AHL_WORKORDER_MTL_TXNS.SERIAL_NUMBER
AHL_WORKORDER_MTL_TXNS.INVENTORY_ITEM_ID
AHL_WORKORDER_MTL_TXNS.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
[top of page]
AHL.AHL_WORKORDER_MTL_TXNS does not reference any database object
AHL.AHL_WORKORDER_MTL_TXNS is referenced by following:
APPS
SYNONYM - 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_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:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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:
APPS
SYNONYM - AHL_WORK_ASSIGNMENTS
[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:
APPS
SYNONYM - 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
SYNONYM - CS_INCIDENTS_ALL_B
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUP_VALUES_VL
PACKAGE - FND_PROFILE
PACKAGE - HR_GENERAL
VIEW - HR_ORGANIZATION_UNITS
PACKAGE - HR_SECURITY
VIEW - MFG_LOOKUPS
PACKAGE - MO_GLOBAL
VIEW - MTL_ITEM_LOCATIONS_KFV
SYNONYM - MTL_SYSTEM_ITEMS_KFV
VIEW - ORG_ORGANIZATION_DEFINITIONS
SYNONYM - PA_PROJECTS_ALL
SYNONYM - PA_TASKS
VIEW - QA_PLANS_VAL_V
SYNONYM - QA_PLAN_COLLECTION_TRIGGERS
SYNONYM - QA_PLAN_TRANSACTIONS
SYNONYM - QA_RESULTS
SYNONYM - WIP_DISCRETE_JOBS
APPS.AHL_ALL_WORKORDERS_V is referenced by following:
APPS
PACKAGE BODY - AHL_PRD_WORKORDER_PVT
[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 referenced by following:
APPS
PACKAGE BODY - AHL_RM_RT_OPER_RESOURCE_PVT
[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
VIEW - FND_LOOKUP_VALUES_VL
APPS.AHL_APPROVAL_RULES_V is referenced by following:
APPS
PACKAGE BODY - AHL_APPROVALS_PVT
[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
PACKAGE BODY - AHL_APPROVALS_PVT
VIEW - AHL_APPROVAL_RULES_V
PACKAGE BODY - AHL_RM_APPROVAL_PVT
[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
VIEW - 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
VIEW - AHL_JTF_RS_EMP_V
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUP_VALUES_VL
VIEW - JTF_RS_ROLE_RELATIONS_VL
APPS.AHL_APPROVERS_V is referenced by following:
APPS
PACKAGE BODY - AHL_RM_APPROVAL_PVT
[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
VIEW - BOM_DEPARTMENTS_V
SYNONYM - BOM_SHIFT_TIMES
SYNONYM - BOM_WORKDAY_PATTERNS
SYNONYM - HR_ALL_ORGANIZATION_UNITS
PACKAGE - HR_GENERAL
VIEW - MTL_ITEM_LOCATIONS_KFV
APPS.AHL_DEPARTMENT_SHIFTS_V is referenced by following:
APPS
PACKAGE BODY - AHL_LTP_SIMUL_PLAN_PVT
[top of page]
View: AHL_DOCUMENTS_V
[top of page]
APPS.AHL_DOCUMENTS_V references the following:
APPS
VIEW - AHL_DOCUMENTS_VL
VIEW - FND_LOOKUP_VALUES_VL
SYNONYM - HZ_PARTIES
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
PACKAGE BODY - AHL_DI_ASSO_DOCASO_PVT
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
VIEW - 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:
APPS
VIEW - AHL_DOC_FILE_ASSOC_VL
VIEW - FND_LOOKUP_VALUES_VL
APPS.AHL_DOC_FILE_ASSOC_V is referenced by following:
APPS
PACKAGE BODY - AHL_DI_DOC_REVISION_PVT
PACKAGE BODY - AHL_DI_FILEUPLOAD_PVT
[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 referenced by following:
APPS
VIEW - AHL_DOC_FILE_ASSOC_V
VIEW - AHL_REFERENCE_DOC_V
[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
VIEW - FND_LOOKUP_VALUES_VL
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
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
PACKAGE BODY - AHL_FMP_MR_REVISION_PVT
[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
PACKAGE BODY - AHL_DI_ASSO_DOCASO_PVT
PACKAGE BODY - AHL_DI_ASSO_DOC_ASO_PVT
PACKAGE BODY - AHL_DI_ASSO_DOC_GEN_PVT
VIEW - AHL_DOCUMENT_ASSOS_V
VIEW - AHL_DOC_TYPE_ASSOS_V
PACKAGE BODY - AHL_PC_HEADER_PVT
VIEW - AHL_REFERENCE_DOC_V
PACKAGE BODY - AHL_RM_OPERATION_PVT
PACKAGE BODY - AHL_RM_ROUTE_PVT
[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
VIEW - 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_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
VIEW - PER_PEOPLE_F
SYNONYM - PER_PERSON_TYPES
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 referenced by following:
APPS
PACKAGE BODY - AHL_MC_ITEMGROUP_PVT
[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
PACKAGE BODY - AHL_FMP_COMMON_PVT
VIEW - AHL_ITEM_ASSOCIATIONS_V
PACKAGE BODY - AHL_LTP_REQST_MATRL_PVT
PACKAGE BODY - AHL_MC_ITEMGROUP_PUB
PACKAGE BODY - AHL_MC_ITEMGROUP_PVT
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:
APPS
VIEW - FND_LOOKUP_VALUES_VL
SYNONYM - MTL_SYSTEM_ITEMS_KFV
VIEW - MTL_UNITS_OF_MEASURE_VL
APPS.AHL_ITEM_CLASS_UOM_V is referenced by following:
APPS
PACKAGE BODY - AHL_OSP_ORDERS_PVT
PACKAGE BODY - AHL_RM_ROUTE_UTIL
[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
VIEW - 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
VIEW - FND_LOOKUP_VALUES_VL
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
APPS.AHL_ITEM_COMP_V is referenced by following:
APPS
PACKAGE BODY - AHL_ITEMCOMP_APPROVAL_PVT
PACKAGE BODY - AHL_MC_ITEM_COMP_PVT
[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
VIEW - 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
PACKAGE BODY - AHL_ITEMGROUPS_APPROVAL_PVT
VIEW - AHL_ITEM_COMP_DETAIL_V
VIEW - AHL_ITEM_GROUPS_V
PACKAGE BODY - AHL_MC_ITEMGROUP_PVT
PACKAGE BODY - AHL_MC_ITEM_COMP_PUB
PACKAGE BODY - AHL_MC_ITEM_COMP_PVT
PACKAGE - AHL_RM_ROUTE_UTIL
PACKAGE BODY - 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
VIEW - MTL_SYSTEM_ITEMS_VL
SYNONYM - WIP_REQUIREMENT_OPERATIONS
APPS.AHL_JOB_OPER_MATERIALS_V is referenced by following:
APPS
PACKAGE BODY - AHL_COMPLETIONS_PVT
PACKAGE BODY - AHL_PP_MATERIALS_PVT
PACKAGE BODY - AHL_PRD_WORKORDER_PVT
[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 referenced by following:
APPS
VIEW - AHL_APPROVERS_V
PACKAGE BODY - AHL_GENERIC_APRV_PVT
PACKAGE BODY - AHL_OPERATIONS_APPROVAL_PVT
PACKAGE BODY - AHL_PP_MATERIALS_PVT
PACKAGE BODY - AHL_RM_APPROVAL_PVT
[top of page]
View: AHL_MASTER_CONFIG_DETAILS_V
[top of page]
APPS.AHL_MASTER_CONFIG_DETAILS_V references the following:
APPS
VIEW - AHL_MC_HEADERS_V
VIEW - 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
VIEW - FND_LOOKUP_VALUES_VL
APPS.AHL_MC_HEADERS_V is referenced by following:
APPS
VIEW - AHL_MASTER_CONFIG_DETAILS_V
PACKAGE BODY - AHL_MC_MASTERCONFIG_PVT
PACKAGE BODY - AHL_MC_NODE_PVT
PACKAGE BODY - AHL_MC_PATH_POSITION_PVT
PACKAGE BODY - AHL_MC_RULE_PVT
PACKAGE BODY - AHL_MC_TREE_PVT
PACKAGE - AHL_RM_ROUTE_UTIL
PACKAGE BODY - AHL_RM_ROUTE_UTIL
[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 referenced by following:
APPS
PACKAGE BODY - AHL_MC_MASTERCONFIG_PVT
VIEW - AHL_UNIT_DETAILS_V
VIEW - AHL_UNIT_HEADER_DETAILS_V
VIEW - AHL_VISIT_TASK_MATRL_V
[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
VIEW - FND_LOOKUP_VALUES_VL
APPS.AHL_MC_RELATIONSHIPS_V is referenced by following:
APPS
VIEW - AHL_MASTER_CONFIG_DETAILS_V
PACKAGE BODY - AHL_MC_MASTERCONFIG_PVT
PACKAGE BODY - AHL_MC_NODE_PVT
PACKAGE BODY - AHL_PRD_LOV_SERVICE_PVT
[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 referenced by following:
APPS
PACKAGE BODY - AHL_MC_RULE_ENGINE_PVT
PACKAGE BODY - AHL_MC_RULE_PVT
[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
VIEW - FND_LOOKUP_VALUES_VL
SYNONYM - QA_PLANS
APPS.AHL_MR_ACTIONS_V is referenced by following:
APPS
PACKAGE BODY - AHL_FMP_MR_ACTION_PVT
[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_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 - 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_MR_EFFECTIVITIES
VIEW - AHL_MR_HEADERS_APP_V
PACKAGE - FND_PROFILE
APPS.AHL_MR_EFFECTIVITIES_APP_V is referenced by following:
APPS
PACKAGE BODY - AHL_FMP_COMMON_PVT
PACKAGE BODY - AHL_FMP_MR_EFFECTIVITY_PVT
PACKAGE BODY - AHL_FMP_MR_INTERVAL_PVT
PACKAGE BODY - AHL_FMP_MR_REVISION_PVT
PACKAGE BODY - AHL_FMP_PVT
VIEW - AHL_MR_EFFECTIVITIES_V
VIEW - AHL_MR_EFFECTIVITY_DTLS_APP_V
VIEW - AHL_MR_INTERVALS_APP_V
PACKAGE BODY - AHL_UMP_PROCESSUNIT_PVT
[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
VIEW - AHL_POSITION_ALTERNATES_V
VIEW - FND_LOOKUP_VALUES_VL
PACKAGE - FND_PROFILE
SYNONYM - MTL_SYSTEM_ITEMS_KFV
APPS.AHL_MR_EFFECTIVITIES_V is referenced by following:
APPS
PACKAGE BODY - AHL_FMP_EFFECTIVITY_DTL_PVT
PACKAGE BODY - AHL_FMP_MR_EFFECTIVITY_PVT
PACKAGE BODY - AHL_FMP_MR_INTERVAL_PVT
[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 referenced by following:
APPS
PACKAGE BODY - AHL_FMP_MR_EFFECTIVITY_PVT
PACKAGE BODY - AHL_FMP_MR_REVISION_PVT
[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
VIEW - FND_LOOKUP_VALUES_VL
VIEW - FND_TERRITORIES_VL
SYNONYM - MTL_MANUFACTURERS
APPS.AHL_MR_EFFECTIVITY_DTLS_V is referenced by following:
APPS
PACKAGE BODY - AHL_FMP_EFFECTIVITY_DTL_PVT
[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
PACKAGE BODY - AHL_COMPLETIONS_PVT
PACKAGE BODY - AHL_FMP_COMMON_PVT
PACKAGE BODY - AHL_FMP_MR_DOC_ASSO_PVT
PACKAGE BODY - AHL_FMP_MR_HEADER_PVT
PACKAGE BODY - AHL_FMP_MR_INTERVAL_PVT
PACKAGE BODY - AHL_FMP_MR_RELATION_PVT
PACKAGE BODY - AHL_FMP_MR_REVISION_PVT
PACKAGE BODY - AHL_FMP_MR_ROUTE_PVT
PACKAGE BODY - AHL_FMP_MR_ROUTE_SEQNCE_PVT
PACKAGE BODY - AHL_FMP_MR_VISIT_TYPES_PVT
PACKAGE BODY - AHL_FMP_PVT
PACKAGE BODY - AHL_MEL_CDL_HEADERS_PVT
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_RELATIONSHIPS_APP_V
VIEW - AHL_MR_ROUTES_APP_V
VIEW - AHL_MR_ROUTE_SEQUENCES_APP_V
VIEW - AHL_MR_VISIT_TYPES_APP_V
PACKAGE BODY - AHL_PC_HEADER_PVT
PACKAGE BODY - AHL_PC_NODE_PVT
VIEW - AHL_SEARCH_TEMPLATE_TASK_V
VIEW - AHL_SRH_WO_HISTORY_V
PACKAGE BODY - AHL_UMP_PROCESSUNIT_PVT
PACKAGE BODY - AHL_UMP_SR_PVT
PACKAGE BODY - AHL_UMP_UNITMAINT_PVT
PACKAGE BODY - AHL_UMP_UNPLANNED_PVT
PACKAGE BODY - AHL_VWP_MR_CST_PR_PVT
PACKAGE BODY - AHL_VWP_PROJ_PROD_PVT
PACKAGE BODY - AHL_VWP_RULES_PVT
PACKAGE BODY - AHL_VWP_TASKS_PVT
PACKAGE BODY - AHL_VWP_UNPLAN_TASKS_PVT
PACKAGE BODY - AHL_VWP_VISIT_CST_PR_PVT
[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 - FND_LOOKUP_VALUES
VIEW - FND_LOOKUP_VALUES_VL
PACKAGE - FND_PROFILE
SYNONYM - MTL_SYSTEM_ITEMS_KFV
SYNONYM - QA_CHAR_VALUE_LOOKUPS
APPS.AHL_MR_HEADERS_V is referenced by following:
APPS
PACKAGE BODY - AHL_FMP_MR_HEADER_PVT
VIEW - AHL_UE_DEFERRAL_DETAILS_V
PACKAGE BODY - AHL_UMP_UTIL_PKG
PACKAGE BODY - AHL_VWP_PROJ_PROD_PVT
[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
PACKAGE BODY - AHL_LTP_SIMUL_PLAN_PVT
VIEW - AHL_MR_HEADERS_APP_V
VIEW - AHL_SEARCH_TEMPLATE_TASK_V
VIEW - AHL_SEARCH_VISIT_TASK_V
VIEW - AHL_SR_UE_ASSOCIATIONS_V
PACKAGE BODY - AHL_UMP_PROCESSUNIT_PVT
PACKAGE BODY - AHL_UMP_UNITMAINT_PVT
VIEW - AHL_VISIT_MR_V
PACKAGE BODY - AHL_VWP_MR_CST_PR_PVT
PACKAGE BODY - AHL_VWP_RULES_PVT
PACKAGE BODY - AHL_VWP_TASKS_PVT
PACKAGE BODY - AHL_VWP_TASK_CST_PR_PVT
PACKAGE BODY - CSF_PREVENTIVE_MAINTENANCE_PVT
[top of page]
View: AHL_MR_INSTANCES_V
[top of page]
APPS.AHL_MR_INSTANCES_V references the following:
APPS
PACKAGE - AHL_COMPLETIONS_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
VIEW - CS_INCIDENTS_ALL_VL
VIEW - CS_INCIDENT_TYPES_VL
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUP_VALUES_VL
PACKAGE - FND_PROFILE
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
PACKAGE - MO_GLOBAL
VIEW - ORG_ORGANIZATION_DEFINITIONS
SYNONYM - WIP_DISCRETE_JOBS
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
SYNONYM - AHL_UE_RELATIONSHIPS
PACKAGE - AHL_UTILITY_PVT
PACKAGE - FND_GLOBAL
PACKAGE - FND_PROFILE
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
PACKAGE - 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 referenced by following:
APPS
PACKAGE BODY - AHL_FMP_COMMON_PVT
PACKAGE BODY - AHL_FMP_MR_EFFECTIVITY_PVT
PACKAGE BODY - AHL_FMP_MR_INTERVAL_PVT
PACKAGE BODY - AHL_FMP_MR_REVISION_PVT
PACKAGE BODY - AHL_VWP_TASKS_PVT
[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
SYNONYM - CS_COUNTERS
PACKAGE - FND_PROFILE
VIEW - MTL_UNITS_OF_MEASURE_VL
APPS.AHL_MR_INTERVALS_V is referenced by following:
APPS
PACKAGE BODY - AHL_COMPLETIONS_PVT
PACKAGE BODY - AHL_FMP_MR_INTERVAL_PVT
PACKAGE BODY - AHL_PRD_DF_PVT
PACKAGE BODY - AHL_UMP_PROCESSUNIT_PVT
[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
SYNONYM - MTL_SYSTEM_ITEMS_KFV
APPS.AHL_MR_ITEMS_V is referenced by following:
APPS
PACKAGE BODY - AHL_VWP_UNPLAN_TASKS_PVT
[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_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 - FND_LOOKUP_VALUES
PACKAGE - FND_PROFILE
SYNONYM - 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
VIEW - FND_LOOKUP_VALUES_VL
PACKAGE - FND_PROFILE
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
VIEW - AHL_MR_HEADERS_APP_V
SYNONYM - AHL_MR_RELATIONSHIPS
PACKAGE - FND_PROFILE
APPS.AHL_MR_RELATIONSHIPS_APP_V is referenced by following:
APPS
PACKAGE BODY - AHL_FMP_MR_REVISION_PVT
[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
PACKAGE BODY - AHL_FMP_MR_ROUTE_SEQNCE_PVT
PACKAGE BODY - AHL_LTP_REQST_MATRL_PVT
PACKAGE BODY - AHL_LTP_RESRC_LEVL_PVT
VIEW - AHL_MR_ROUTES_V
VIEW - AHL_MR_ROUTE_SEQUENCES_APP_V
VIEW - AHL_SRH_WO_HISTORY_V
PACKAGE BODY - AHL_VWP_TIMES_PVT
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
VIEW - FND_LOOKUP_VALUES_VL
PACKAGE - FND_PROFILE
SYNONYM - HZ_PARTIES
APPS.AHL_MR_ROUTES_V is referenced by following:
APPS
PACKAGE BODY - AHL_FMP_MR_ROUTE_PVT
PACKAGE BODY - AHL_FMP_MR_ROUTE_SEQNCE_PVT
PACKAGE BODY - AHL_PRD_WORKORDER_PVT
VIEW - AHL_SEARCH_TEMPLATE_TASK_V
VIEW - AHL_SEARCH_VISIT_TASK_V
PACKAGE BODY - AHL_VWP_PROJ_PROD_PVT
PACKAGE BODY - AHL_VWP_RULES_PVT
PACKAGE BODY - AHL_VWP_TASK_CST_PR_PVT
PACKAGE BODY - AHL_VWP_VISITS_STAGES_PVT
[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 referenced by following:
APPS
PACKAGE BODY - AHL_FMP_MR_ROUTE_SEQNCE_PVT
PACKAGE BODY - AHL_VWP_RULES_PVT
[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
VIEW - HR_ORGANIZATION_UNITS
PACKAGE - HR_SECURITY
SYNONYM - MTL_PARAMETERS
SYNONYM - 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
PACKAGE BODY - AHL_MC_ITEMGROUP_PUB
PACKAGE BODY - AHL_MC_ITEMGROUP_PVT
PACKAGE BODY - AHL_MC_ITEM_COMP_PUB
PACKAGE BODY - AHL_MC_ITEM_COMP_PVT
PACKAGE BODY - AHL_RM_ROUTE_UTIL
[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
VIEW - HR_ORGANIZATION_UNITS
PACKAGE - HR_SECURITY
PACKAGE - MO_GLOBAL
SYNONYM - MTL_PARAMETERS
SYNONYM - MTL_SYSTEM_ITEMS_KFV
VIEW - ORG_ORGANIZATION_DEFINITIONS
APPS.AHL_MTL_ITEMS_OU_V is referenced by following:
APPS
PACKAGE BODY - AHL_MC_ITEM_COMP_PUB
PACKAGE BODY - AHL_MC_ITEM_COMP_PVT
VIEW - AHL_OSP_INV_ITEMS_V
PACKAGE BODY - AHL_OSP_ORDERS_PVT
PACKAGE BODY - AHL_UC_UTILIZATION_PVT
[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
PACKAGE BODY - AHL_LTP_MTL_REQ_PVT
PACKAGE BODY - AHL_LTP_RESRC_LEVL_PVT
PACKAGE BODY - AHL_OPERATIONS_APPROVAL_PVT
VIEW - AHL_OPERATIONS_VL
PACKAGE BODY - AHL_PRD_OPERATIONS_PVT
PACKAGE BODY - AHL_PRD_WORKORDER_PVT
PACKAGE BODY - AHL_RM_APPROVAL_PVT
PACKAGE - AHL_RM_OP_ROUTE_AS_PVT
PACKAGE BODY - AHL_RM_ROUTE_UTIL
PACKAGE - AHL_RM_ROUTE_UTIL
PACKAGE BODY - AHL_VWP_PRICE_PVT
PACKAGE BODY - AHL_VWP_TIMES_PVT
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
VIEW - FND_LOOKUP_VALUES_VL
VIEW - QA_CHAR_VALUE_LOOKUPS_V
APPS.AHL_OPERATIONS_V is referenced by following:
APPS
PACKAGE - AHL_RM_OPERATION_PVT
PACKAGE BODY - AHL_RM_OPERATION_PVT
[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
PACKAGE BODY - AHL_LTP_RESRC_LEVL_PVT
VIEW - AHL_OPERATIONS_V
VIEW - AHL_PP_REQUIREMENT_V
PACKAGE BODY - AHL_PRD_OPERATIONS_PVT
PACKAGE BODY - AHL_PRD_WORKORDER_PVT
PACKAGE BODY - AHL_RM_ROUTE_UTIL
VIEW - AHL_ROUTE_OPERATIONS_V
PACKAGE BODY - AHL_VWP_PRICE_PVT
PACKAGE BODY - AHL_VWP_TIMES_PVT
[top of page]
View: AHL_OPERATION_PHASES_V
[top of page]
APPS.AHL_OPERATION_PHASES_V references the following:
APPS
SYNONYM - AHL_OPERATION_PHASES
VIEW - 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
SYNONYM - FND_LOOKUP_VALUES
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
SYNONYM - HZ_PARTIES
PACKAGE - MO_GLOBAL
SYNONYM - OE_ORDER_HEADERS_ALL
SYNONYM - OKC_K_HEADERS_B
VIEW - PO_AGENTS_NAME_V
PACKAGE - PO_BUYER_WORKLOAD_SV
SYNONYM - PO_HEADERS
SYNONYM - PO_REQUISITION_HEADERS_ALL
VIEW - PO_VENDORS
VIEW - PO_VENDOR_CONTACTS
VIEW - 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
PACKAGE BODY - AHL_OSP_ORDERS_PVT
PACKAGE BODY - AHL_OSP_PO_PVT
PACKAGE BODY - AHL_OSP_PO_REQ_PVT
PACKAGE BODY - AHL_OSP_SHIPMENT_PUB
[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
VIEW - AHL_WORKORDERS_OSP_V
SYNONYM - CSI_ITEM_INSTANCES
VIEW - FND_LOOKUP_VALUES_VL
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
PACKAGE - MO_GLOBAL
SYNONYM - MTL_SYSTEM_ITEMS_KFV
SYNONYM - PO_LINE_TYPES
APPS.AHL_OSP_ORDER_LINES_V is referenced by following:
APPS
PACKAGE BODY - AHL_RA_ANALYSER_PVT
[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
SYNONYM - HZ_LOCATIONS
SYNONYM - HZ_PARTIES
SYNONYM - HZ_PARTY_SITES
PACKAGE - MO_GLOBAL
VIEW - PO_VENDORS
VIEW - 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
SYNONYM - 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
VIEW - 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
PACKAGE BODY - AHL_PC_APPROVAL_PVT
VIEW - AHL_PC_HEADERS_V
PACKAGE BODY - AHL_PC_HEADER_PVT
[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
PACKAGE BODY - AHL_PC_HEADER_PVT
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_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
PACKAGE - MO_GLOBAL
VIEW - 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
PACKAGE BODY - AHL_FMP_COMMON_PVT
PACKAGE BODY - AHL_FMP_EFFECTIVITY_DTL_PVT
PACKAGE BODY - AHL_FMP_MR_EFFECTIVITY_PVT
VIEW - AHL_MR_EFFECTIVITIES_V
VIEW - AHL_MR_ITEMS_V
VIEW - AHL_MR_ITEM_DETAILS_V
PACKAGE BODY - AHL_RM_ROUTE_UTIL
[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
VIEW - PER_PEOPLE_F
SYNONYM - PER_PERSON_TYPES
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_RESOURCE_TRANX_PVT
PACKAGE - AHL_PRD_SERN_CHANGE_PVT
PACKAGE - AHL_PRD_UTIL_PKG
PACKAGE - AHL_UTILITY_PVT
PACKAGE - AHL_UTIL_UC_PKG
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
VIEW - MFG_LOOKUPS
PACKAGE - MO_GLOBAL
VIEW - PER_PEOPLE_F
SYNONYM - PER_PERSON_TYPES
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
VIEW - FND_LOOKUP_VALUES_VL
VIEW - MFG_LOOKUPS
SYNONYM - MTL_UNITS_OF_MEASURE
SYNONYM - WIP_OPERATIONS
SYNONYM - WIP_OPERATION_RESOURCES
APPS.AHL_PP_REQUIREMENT_V is referenced by following:
APPS
VIEW - AHL_PP_ASSIGNMENT_V
PACKAGE BODY - AHL_PP_RESRC_ASSIGN_PVT
PACKAGE BODY - AHL_PRD_RESOURCE_TRANX_PVT
PACKAGE BODY - AHL_PRD_UTIL_PKG
PACKAGE BODY - AHL_VWP_PRICE_PVT
[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_SERN_CHANGE_PVT
SYNONYM - AHL_RESOURCE_MAPPINGS
SYNONYM - AHL_RT_OPER_RESOURCES
PACKAGE - AHL_UTILITY_PVT
PACKAGE - AHL_UTIL_UC_PKG
VIEW - AHL_WORKORDERS_V
VIEW - AHL_WORKORDER_OPERATIONS_V
SYNONYM - BOM_DEPARTMENT_RESOURCES
SYNONYM - BOM_RESOURCES
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUP_VALUES_VL
PACKAGE - FND_PROFILE
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
VIEW - MFG_LOOKUPS
PACKAGE - MO_GLOBAL
SYNONYM - MTL_UNITS_OF_MEASURE
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
VIEW - FND_LOOKUP_VALUES_VL
APPS.AHL_PRODTYPE_ZONES_V is referenced by following:
APPS
PACKAGE BODY - AHL_RM_PROD_ZONE_AS_PVT
[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
VIEW - 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
VIEW - AHL_DOC_FILE_ASSOC_VL
SYNONYM - AHL_DOC_REVISIONS_B
VIEW - AHL_DOC_TITLE_ASSOS_VL
VIEW - FND_LOOKUP_VALUES_VL
APPS.AHL_REFERENCE_DOC_V is referenced by following:
APPS
PACKAGE BODY - AHL_PRD_WO_PUB
[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
VIEW - MFG_LOOKUPS
APPS.AHL_RESOURCES_V is referenced by following:
APPS
VIEW - AHL_RT_OPER_RESOURCES_V
[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
VIEW - HR_ORGANIZATION_UNITS
PACKAGE - HR_SECURITY
VIEW - MFG_LOOKUPS
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
PACKAGE BODY - AHL_FMP_MR_REVISION_PVT
PACKAGE BODY - AHL_FMP_MR_ROUTE_PVT
PACKAGE BODY - AHL_FMP_MR_ROUTE_SEQNCE_PVT
VIEW - AHL_MR_ROUTES_V
PACKAGE BODY - AHL_PRD_WORKORDER_PVT
PACKAGE BODY - AHL_RM_APPROVAL_PVT
PACKAGE BODY - AHL_RM_ASSO_DOCASO_PVT
PACKAGE BODY - AHL_RM_MATERIAL_AS_PVT
PACKAGE BODY - AHL_RM_OP_ROUTE_AS_PVT
PACKAGE BODY - AHL_RM_PROD_ZONE_AS_PVT
PACKAGE BODY - AHL_RM_ROUTE_PVT
PACKAGE BODY - AHL_RM_ROUTE_UTIL
PACKAGE BODY - AHL_RM_RT_OPER_PANEL_PVT
PACKAGE BODY - AHL_RM_RT_OPER_RESOURCE_PVT
PACKAGE BODY - AHL_ROUTE_APPROVAL_PVT
PACKAGE BODY - AHL_VWP_PROJ_PROD_PVT
PACKAGE BODY - AHL_VWP_TASKS_PVT
PACKAGE BODY - AHL_VWP_TIMES_PVT
[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
PACKAGE BODY - AHL_RM_ROUTE_PVT
VIEW - AHL_ROUTES_APP_V
VIEW - AHL_ROUTES_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
VIEW - AHL_ROUTES_B_KFV
SYNONYM - AHL_ROUTES_TL
SYNONYM - FND_LOOKUP_VALUES
PACKAGE - FND_PROFILE
SYNONYM - HZ_PARTIES
SYNONYM - JTF_TASK_TEMP_GROUPS_B
SYNONYM - JTF_TASK_TEMP_GROUPS_TL
SYNONYM - MTL_SYSTEM_ITEMS_KFV
SYNONYM - QA_CHAR_VALUE_LOOKUPS
SYNONYM - WIP_ACCOUNTING_CLASSES
APPS.AHL_ROUTES_V is referenced by following:
APPS
PACKAGE BODY - AHL_ENIGMA_ROUTE_OP_PUB
PACKAGE BODY - AHL_RM_ROUTE_PVT
[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
PACKAGE BODY - AHL_RM_APPROVAL_PVT
VIEW - AHL_SRH_WO_HISTORY_V
PACKAGE BODY - AHL_VWP_PROJ_PROD_PVT
PACKAGE BODY - AHL_VWP_RULES_PVT
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
SYNONYM - MTL_SYSTEM_ITEMS_KFV
APPS.AHL_ROUTE_EFFECTIVITIES_V is referenced by following:
APPS
PACKAGE BODY - AHL_RM_MATERIAL_AS_PVT
[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
VIEW - FND_LOOKUP_VALUES_VL
APPS.AHL_ROUTE_OPERATIONS_V is referenced by following:
APPS
PACKAGE BODY - AHL_LTP_REQST_MATRL_PVT
PACKAGE BODY - AHL_RM_OP_ROUTE_AS_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
PACKAGE - AHL_RM_ROUTE_UTIL
SYNONYM - AHL_RT_OPER_MATERIALS
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
SYNONYM - MTL_PARAMETERS
SYNONYM - MTL_SYSTEM_ITEMS_KFV
VIEW - MTL_UNITS_OF_MEASURE_VL
APPS.AHL_RT_OPER_MATERIALS_V is referenced by following:
APPS
PACKAGE BODY - AHL_RM_MATERIAL_AS_PVT
[top of page]
View: AHL_RT_OPER_RESOURCES_V
[top of page]
APPS.AHL_RT_OPER_RESOURCES_V references the following:
APPS
VIEW - AHL_RESOURCES_V
SYNONYM - AHL_RT_OPER_RESOURCES
SYNONYM - CST_ACTIVITIES
VIEW - MFG_LOOKUPS
APPS.AHL_RT_OPER_RESOURCES_V is referenced by following:
APPS
PACKAGE BODY - AHL_RM_RT_OPER_RESOURCE_PVT
[top of page]
View: AHL_SCHEDULE_MATERIALS_V
[top of page]
APPS.AHL_SCHEDULE_MATERIALS_V references the following:
APPS
PACKAGE - AHL_COMPLETIONS_PVT
PACKAGE - AHL_PP_MATERIALS_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
VIEW - AHL_WORKORDERS_V
PACKAGE - FND_GLOBAL
PACKAGE - FND_PROFILE
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
PACKAGE - MO_GLOBAL
SYNONYM - MTL_RESERVATIONS
SYNONYM - MTL_SYSTEM_ITEMS_KFV
SYNONYM - WIP_REQUIREMENT_OPERATIONS
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
VIEW - FND_LOOKUP_VALUES_VL
VIEW - 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
VIEW - FND_LOOKUP_VALUES_VL
PACKAGE - FND_PROFILE
VIEW - 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 - CS_INCIDENTS_ALL_B
VIEW - FND_LOOKUP_VALUES_VL
SYNONYM - HR_ALL_ORGANIZATION_UNITS
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
PACKAGE - MO_GLOBAL
VIEW - MTL_SYSTEM_ITEMS_B_KFV
VIEW - ORG_ORGANIZATION_DEFINITIONS
SYNONYM - PA_PROJECTS
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
VIEW - AHL_VWP_STAGES_VL
SYNONYM - AHL_WORKORDERS
SYNONYM - BOM_DEPARTMENTS
SYNONYM - CSI_ITEM_INSTANCES
SYNONYM - CS_INCIDENTS_ALL_B
VIEW - FND_LOOKUP_VALUES_VL
PACKAGE - FND_PROFILE
VIEW - MTL_SYSTEM_ITEMS_B_KFV
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
VIEW - FND_LOOKUP_VALUES_VL
SYNONYM - MTL_SYSTEM_ITEMS_KFV
APPS.AHL_SERIAL_NUMBER_CHANGE_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
PACKAGE BODY - AHL_LTP_SIMUL_PLAN_PVT
PACKAGE BODY - AHL_LTP_SPACE_SCHEDULE_PVT
VIEW - AHL_PLAN_VISITS_V
VIEW - AHL_SEARCH_VISITS_V
VIEW - AHL_VISITS_INFO_V
VIEW - AHL_VISIT_DETAILS_V
PACKAGE BODY - AHL_VWP_PROJ_PROD_PVT
PACKAGE BODY - AHL_VWP_RULES_PVT
PACKAGE BODY - AHL_VWP_VISITS_PVT
[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
PACKAGE BODY - AHL_APPR_SPACE_CAPB_PVT
PACKAGE BODY - AHL_APPR_SPACE_UNAVL_PVT
PACKAGE BODY - AHL_LTP_SPACE_ASSIGN_PVT
PACKAGE BODY - AHL_LTP_SPACE_CAPB_PVT
PACKAGE BODY - AHL_LTP_SPACE_SCHEDULE_PVT
PACKAGE BODY - AHL_LTP_SPACE_UNAVL_PVT
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
VIEW - FND_LOOKUP_VALUES_VL
SYNONYM - HR_ALL_ORGANIZATION_UNITS
VIEW - 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
VIEW - FND_LOOKUP_VALUES_VL
SYNONYM - HR_ALL_ORGANIZATION_UNITS
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
PACKAGE BODY - AHL_APPR_SPACE_UNAVL_PVT
PACKAGE BODY - AHL_LTP_SPACE_UNAVL_PVT
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
SYNONYM - CS_INCIDENTS_ALL_B
VIEW - FND_LOOKUP_VALUES_VL
PACKAGE - FND_PROFILE
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 referenced by following:
APPS
PACKAGE BODY - AHL_FMP_PVT
PACKAGE BODY - AHL_MC_PATH_POSITION_PVT
[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
VIEW - CS_INCIDENTS_ALL_VL
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUP_VALUES_VL
PACKAGE - FND_PROFILE
VIEW - QA_PLANS_VAL_V
SYNONYM - QA_PLAN_COLLECTION_TRIGGERS
SYNONYM - QA_PLAN_TRANSACTIONS
SYNONYM - QA_RESULTS
APPS.AHL_UE_DEFERRAL_DETAILS_V is referenced by following:
APPS
VIEW - AHL_MR_INSTANCES_V
PACKAGE BODY - AHL_PRD_DF_PVT
VIEW - AHL_SRH_MR_HISTORY_V
VIEW - AHL_SRH_WO_HISTORY_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
VIEW - CSI_INST_EXTEND_ATTRIB_V
SYNONYM - CSI_ITEM_INSTANCES
SYNONYM - CSI_I_PARTIES
VIEW - CSI_LOOKUPS
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
SYNONYM - HZ_PARTIES
PACKAGE - MO_GLOBAL
SYNONYM - MTL_MATERIAL_STATUSES
SYNONYM - MTL_SYSTEM_ITEMS_KFV
VIEW - ORG_ORGANIZATION_DEFINITIONS
VIEW - PO_VENDORS
PUBLIC
SYNONYM - DUAL
- DUAL
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
VIEW - INV_ORGANIZATION_INFO_V
PACKAGE - MO_GLOBAL
SYNONYM - MTL_PARAMETERS
SYNONYM - MTL_SYSTEM_ITEMS_KFV
APPS.AHL_UNIT_CONFIG_HEADERS_V is referenced by following:
APPS
PACKAGE BODY - AHL_PRD_MRSHL_PVT
PACKAGE BODY - AHL_UC_INSTANCE_PVT
PACKAGE BODY - AHL_UC_UNITCONFIG_PVT
[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 referenced by following:
APPS
PACKAGE BODY - AHL_PRD_DF_PVT
PACKAGE BODY - AHL_UMP_NONROUTINES_PVT
PACKAGE BODY - AHL_UMP_PROCESSUNIT_PVT
PACKAGE BODY - AHL_UMP_UNITMAINT_PVT
[top of page]
View: AHL_UNIT_DETAILS_V
[top of page]
APPS.AHL_UNIT_DETAILS_V references the following:
APPS
VIEW - AHL_MC_HEADERS_VL
SYNONYM - AHL_MC_RELATIONSHIPS
SYNONYM - AHL_UNIT_CONFIG_HEADERS
SYNONYM - CSI_II_RELATIONSHIPS
VIEW - CSI_INST_EXTEND_ATTRIB_V
SYNONYM - CSI_ITEM_INSTANCES
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUPS
SYNONYM - MTL_SYSTEM_ITEMS_KFV
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
PACKAGE BODY - AHL_COMPLETIONS_PVT
PACKAGE BODY - AHL_LTP_SPACE_SCHEDULE_PVT
VIEW - AHL_SR_UE_ASSOCIATIONS_V
VIEW - AHL_UE_DEFERRAL_DETAILS_V
PACKAGE BODY - AHL_UMP_NONROUTINES_PVT
PACKAGE BODY - AHL_UMP_PROCESSUNIT_EXTN_PVT
PACKAGE BODY - AHL_UMP_PROCESSUNIT_PVT
PACKAGE BODY - AHL_UMP_SR_PVT
PACKAGE BODY - AHL_UMP_UNITMAINT_PVT
PACKAGE BODY - AHL_UMP_UNPLANNED_PVT
VIEW - AHL_VISITS_INFO_V
PACKAGE BODY - CSF_PREVENTIVE_MAINTENANCE_PVT
PACKAGE BODY - CS_SR_STATUS_PROPAGATION_PKG
[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
VIEW - CSI_COUNTER_TEMPLATE_VL
SYNONYM - CSI_ITEM_INSTANCES
SYNONYM - CS_INCIDENTS_ALL_B
SYNONYM - CS_INCIDENTS_ALL_TL
SYNONYM - CS_INCIDENT_TYPES_B
SYNONYM - CS_INCIDENT_TYPES_TL
SYNONYM - FND_LOOKUP_VALUES
PACKAGE - FND_PROFILE
SYNONYM - MTL_SYSTEM_ITEMS_KFV
SYNONYM - OKC_K_HEADERS_ALL_B
SYNONYM - OKC_K_LINES_B
APPS.AHL_UNIT_EFFECTIVITIES_V is referenced by following:
APPS
PACKAGE BODY - AHL_COMPLETIONS_PVT
PACKAGE BODY - AHL_PRD_DF_PVT
PACKAGE BODY - AHL_QA_RESULTS_PVT
PACKAGE BODY - AHL_UMP_SMRINSTANCE_PVT
PACKAGE BODY - AHL_VWP_RULES_PVT
[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
PACKAGE BODY - AHL_PRD_DF_PVT
PACKAGE BODY - AHL_PRD_VISITS_PVT
PACKAGE BODY - AHL_UMP_PROCESSUNIT_EXTN_PVT
PACKAGE BODY - AHL_UMP_PROCESSUNIT_PVT
PACKAGE BODY - AHL_UMP_UNITMAINT_PVT
PACKAGE BODY - AHL_UMP_UTIL_PKG
VIEW - AHL_UNIT_EFFECTIVITIES_APP_V
PACKAGE BODY - AHL_VWP_PLAN_TASKS_PVT
PACKAGE BODY - AHL_VWP_RULES_PVT
PACKAGE BODY - AHL_VWP_TASKS_PVT
PACKAGE BODY - AHL_VWP_VISITS_PVT
PACKAGE BODY - CSF_WF_EVENT_SUBSCR_PKG
[top of page]
View: AHL_UNIT_HEADER_DETAILS_V
[top of page]
APPS.AHL_UNIT_HEADER_DETAILS_V references the following:
APPS
VIEW - AHL_MC_HEADERS_VL
SYNONYM - AHL_MC_RELATIONSHIPS
SYNONYM - AHL_UNIT_CONFIG_HEADERS
PACKAGE - AHL_UTIL_UC_PKG
VIEW - CSI_INST_PARTY_DETAILS_V
SYNONYM - CSI_ITEM_INSTANCES
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUPS
SYNONYM - MTL_SYSTEM_ITEMS_KFV
SYNONYM - WIP_ENTITIES
APPS.AHL_UNIT_HEADER_DETAILS_V is referenced by following:
APPS
PACKAGE BODY - AHL_UMP_UF_PVT
[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
VIEW - CSI_INST_EXTEND_ATTRIB_V
VIEW - CSI_INST_PARTY_DETAILS_V
SYNONYM - CSI_ITEM_INSTANCES
VIEW - CSI_LOOKUPS
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUPS
SYNONYM - MTL_MATERIAL_STATUSES
SYNONYM - MTL_PARAMETERS
SYNONYM - MTL_SYSTEM_ITEMS_KFV
SYNONYM - MTL_SYSTEM_ITEMS_TL
SYNONYM - WIP_ENTITIES
APPS.AHL_UNIT_INSTALLED_DETAILS_V is referenced by following:
APPS
PACKAGE BODY - AHL_FMP_PVT
PACKAGE BODY - AHL_UC_INSTANCE_PVT
[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
VIEW - FND_LOOKUP_TYPES_VL
VIEW - FND_LOOKUP_VALUES_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
PACKAGE BODY - AHL_UTILITY_PVT
[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 referenced by following:
APPS
PACKAGE BODY - AHL_PC_NODE_PVT
[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
VIEW - AHL_SIMULATION_PLANS_VL
SYNONYM - AHL_UNIT_CONFIG_HEADERS
VIEW - AHL_UNIT_EFFECTIVITIES_APP_V
PACKAGE - AHL_UTILITY_PVT
VIEW - AHL_VISITS_VL
SYNONYM - AHL_VISIT_TASKS_B
VIEW - AHL_VISIT_TASKS_VL
SYNONYM - BOM_DEPARTMENTS
SYNONYM - CSI_ITEM_INSTANCES
VIEW - FND_LOOKUP_VALUES_VL
PACKAGE - FND_PROFILE
SYNONYM - HR_ALL_ORGANIZATION_UNITS
SYNONYM - MTL_SYSTEM_ITEMS_KFV
APPS.AHL_VISITS_INFO_V is referenced by following:
APPS
VIEW - AHL_SRH_MR_HISTORY_V
[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
PACKAGE BODY - AHL_LTP_REQST_MATRL_PVT
PACKAGE BODY - AHL_LTP_RESRC_LEVL_PVT
PACKAGE BODY - AHL_LTP_SIMUL_PLAN_PVT
PACKAGE BODY - AHL_LTP_SPACE_ASSIGN_PVT
PACKAGE BODY - AHL_LTP_SPACE_SCHEDULE_PVT
PACKAGE BODY - AHL_OSP_UTIL_PKG
VIEW - AHL_PLAN_VISITS_V
PACKAGE BODY - AHL_PP_MATERIALS_PVT
VIEW - AHL_PRD_DISPOSITIONS_V
PACKAGE BODY - AHL_PRD_DISPOSITION_PVT
PACKAGE BODY - AHL_PRD_VISITS_PVT
VIEW - AHL_PRD_VISITS_V
PACKAGE BODY - AHL_RM_APPROVAL_PVT
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_WO_HISTORY_V
VIEW - AHL_VISITS_INFO_V
VIEW - AHL_VISIT_DETAILS_V
VIEW - AHL_VISIT_MR_V
VIEW - AHL_VISIT_TASKS_V
PACKAGE BODY - AHL_VWP_COST_PVT
PACKAGE BODY - AHL_VWP_MR_CST_PR_PVT
PACKAGE BODY - AHL_VWP_PLAN_TASKS_PVT
PACKAGE BODY - AHL_VWP_PROJ_PROD_PVT
PACKAGE BODY - AHL_VWP_RULES_PVT
PACKAGE BODY - AHL_VWP_TASKS_LINKS_PVT
PACKAGE BODY - AHL_VWP_TASKS_PVT
PACKAGE BODY - AHL_VWP_TASK_CST_PR_PVT
PACKAGE BODY - AHL_VWP_UNPLAN_TASKS_PVT
PACKAGE BODY - AHL_VWP_VISITS_PVT
PACKAGE BODY - AHL_VWP_VISITS_STAGES_PVT
PACKAGE BODY - AHL_VWP_VISIT_CST_PR_PVT
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
VIEW - AHL_SIMULATION_PLANS_VL
SYNONYM - AHL_UNIT_EFFECTIVITIES_B
PACKAGE - AHL_UTILITY_PVT
VIEW - AHL_VISITS_VL
SYNONYM - AHL_VISIT_TASKS_B
SYNONYM - BOM_DEPARTMENTS
SYNONYM - CSI_ITEM_INSTANCES
VIEW - FND_LOOKUP_VALUES_VL
SYNONYM - HR_ALL_ORGANIZATION_UNITS
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
PACKAGE - MO_GLOBAL
SYNONYM - MTL_PARAMETERS
VIEW - MTL_SYSTEM_ITEMS_B_KFV
VIEW - ORG_ORGANIZATION_DEFINITIONS
APPS.AHL_VISIT_DETAILS_V is referenced by following:
APPS
PACKAGE BODY - AHL_LTP_SPACE_SCHEDULE_PVT
[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
VIEW - 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
VIEW - FND_LOOKUP_VALUES_VL
APPS.AHL_VISIT_TASKS_V is referenced by following:
APPS
PACKAGE BODY - AHL_LTP_MATRL_AVAL_PVT
VIEW - AHL_SRH_MR_HISTORY_V
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
PACKAGE BODY - AHL_LTP_REQST_MATRL_PVT
PACKAGE BODY - AHL_LTP_RESRC_LEVL_PVT
PACKAGE BODY - AHL_LTP_SIMUL_PLAN_PVT
PACKAGE BODY - AHL_LTP_SPACE_SCHEDULE_PVT
PACKAGE BODY - AHL_OSP_UTIL_PKG
VIEW - AHL_PRD_DISPOSITIONS_V
PACKAGE BODY - AHL_PRD_DISPOSITION_PVT
PACKAGE BODY - AHL_PRD_WORKORDER_PVT
VIEW - AHL_SEARCH_TEMPLATE_TASK_V
VIEW - AHL_SEARCH_VISIT_TASK_V
VIEW - AHL_SRH_WO_HISTORY_V
VIEW - AHL_VISITS_INFO_V
VIEW - AHL_VISIT_MR_V
VIEW - AHL_VISIT_TASK_MATRL_V
PACKAGE BODY - AHL_VWP_COST_PVT
PACKAGE BODY - AHL_VWP_MR_CST_PR_PVT
PACKAGE BODY - AHL_VWP_PLAN_TASKS_PVT
PACKAGE BODY - AHL_VWP_PROJ_PROD_PVT
PACKAGE BODY - AHL_VWP_RULES_PVT
PACKAGE BODY - AHL_VWP_TASKS_LINKS_PVT
PACKAGE BODY - AHL_VWP_TASKS_PVT
PACKAGE BODY - AHL_VWP_TASK_CST_PR_PVT
PACKAGE BODY - AHL_VWP_UNPLAN_TASKS_PVT
PACKAGE BODY - AHL_VWP_VISITS_PVT
PACKAGE BODY - AHL_VWP_VISIT_CST_PR_PVT
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
VIEW - AHL_MC_HEADERS_VL
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_KFV
SYNONYM - MTL_SYSTEM_ITEMS_TL
APPS.AHL_VISIT_TASK_MATRL_V is referenced by following:
APPS
PACKAGE BODY - AHL_LTP_MATRL_AVAL_PVT
PACKAGE BODY - AHL_LTP_REQST_MATRL_PVT
[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 referenced by following:
APPS
PACKAGE BODY - AHL_VWP_COST_PVT
[top of page]
View: AHL_WF_MAPPING_V
[top of page]
APPS.AHL_WF_MAPPING_V references the following:
APPS
SYNONYM - AHL_WF_MAPPING
VIEW - FND_LOOKUP_VALUES_VL
VIEW - WF_RUNNABLE_PROCESSES_V
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
VIEW - FND_LOOKUP_VALUES_VL
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
VIEW - MFG_LOOKUPS
SYNONYM - MTL_TRANSACTION_REASONS
SYNONYM - MTL_UNITS_OF_MEASURE
VIEW - PER_PEOPLE_F
SYNONYM - WIP_COST_TXN_INTERFACE
SYNONYM - WIP_ENTITIES
SYNONYM - WIP_TRANSACTIONS
APPS.AHL_WIP_RESOURCE_TXNS_V is referenced by following:
APPS
PACKAGE BODY - AHL_PRD_WO_PUB
PACKAGE BODY - AHL_VWP_PRICE_PVT
[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
PACKAGE - MO_GLOBAL
SYNONYM - MTL_SYSTEM_ITEMS_KFV
VIEW - ORG_ORGANIZATION_DEFINITIONS
SYNONYM - PA_PROJECTS_ALL
SYNONYM - PA_TASKS
SYNONYM - WIP_DISCRETE_JOBS
APPS.AHL_WORKORDERS_OSP_V is referenced by following:
APPS
VIEW - AHL_OSP_ORDER_LINES_V
[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_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
VIEW - AHL_VISIT_TASKS_VL
SYNONYM - AHL_WORKORDERS
SYNONYM - BOM_DEPARTMENTS
SYNONYM - CSI_ITEM_INSTANCES
SYNONYM - CS_INCIDENTS_ALL_B
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUP_VALUES_VL
PACKAGE - FND_PROFILE
PACKAGE - HR_GENERAL
VIEW - HR_ORGANIZATION_UNITS
PACKAGE - HR_SECURITY
VIEW - MFG_LOOKUPS
PACKAGE - MO_GLOBAL
VIEW - MTL_ITEM_LOCATIONS_KFV
SYNONYM - MTL_SYSTEM_ITEMS_KFV
VIEW - ORG_ORGANIZATION_DEFINITIONS
SYNONYM - PA_PROJECTS_ALL
SYNONYM - PA_TASKS
VIEW - QA_PLANS_VAL_V
SYNONYM - QA_PLAN_COLLECTION_TRIGGERS
SYNONYM - QA_PLAN_TRANSACTIONS
SYNONYM - QA_RESULTS
SYNONYM - WIP_DISCRETE_JOBS
APPS.AHL_WORKORDERS_V is referenced by following:
APPS
VIEW - AHL_PP_EMPLOYEE_ASSIGN_V
VIEW - AHL_PP_RESRC_REQ_ASG_V
PACKAGE BODY - AHL_PRD_SERN_CHANGE_PVT
VIEW - AHL_SCHEDULE_MATERIALS_V
VIEW - AHL_SRH_MR_HISTORY_V
PACKAGE BODY - AHL_VWP_MR_CST_PR_PVT
PACKAGE BODY - AHL_VWP_VISIT_CST_PR_PVT
[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
VIEW - FND_LOOKUP_VALUES_VL
SYNONYM - WIP_OPERATIONS
APPS.AHL_WORKORDER_OPERATIONS_V is referenced by following:
APPS
PACKAGE BODY - AHL_COMPLETIONS_PVT
VIEW - AHL_JOB_OPER_MATERIALS_V
VIEW - AHL_PP_EMPLOYEE_ASSIGN_V
PACKAGE BODY - AHL_PP_MATERIALS_PVT
PACKAGE BODY - AHL_PP_RESRC_REQUIRE_PVT
VIEW - AHL_PP_RESRC_REQ_ASG_V
PACKAGE BODY - AHL_PRD_LOV_SERVICE_PVT
PACKAGE BODY - AHL_PRD_MTLTXN_PVT
PACKAGE BODY - AHL_PRD_OPERATIONS_PVT
PACKAGE BODY - AHL_PRD_RESOURCE_TRANX_PVT
PACKAGE BODY - AHL_PRD_UTIL_PKG
PACKAGE BODY - AHL_PRD_WO_PUB
PACKAGE BODY - AHL_VWP_PRICE_PVT
[top of page]