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.

[Home] [Help]

Table: AHL_PRD_DISPOSITIONS_B

Product:	AHL - Complex Maintenance Repair and Overhaul
Description:	Store information about workorders's disposiiton
Implementation/DBA Data:	AHL.AHL_PRD_DISPOSITIONS_B

Primary Key: AHL_PRD_DISPOSITIONS_B_PK

DISPOSITION_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
AHL_PRD_DISPOSITIONS_B	AHL_WORKORDERS	AHL_PRD_DISPOSITIONS_B.WORKORDER_ID
AHL_PRD_DISPOSITIONS_B	AHL_WORKORDER_OPERATIONS	AHL_PRD_DISPOSITIONS_B.WO_OPERATION_ID
AHL_PRD_DISPOSITIONS_B	AHL_PART_CHANGES	AHL_PRD_DISPOSITIONS_B.PART_CHANGE_ID
AHL_PRD_DISPOSITIONS_B	AHL_MC_PATH_POSITIONS	AHL_PRD_DISPOSITIONS_B.PATH_POSITION_ID
AHL_PRD_DISPOSITIONS_B	MTL_SYSTEM_ITEMS_B	AHL_PRD_DISPOSITIONS_B.INVENTORY_ITEM_ID AHL_PRD_DISPOSITIONS_B.ORGANIZATION_ID
AHL_PRD_DISPOSITIONS_B	AHL_ITEM_GROUPS_B	AHL_PRD_DISPOSITIONS_B.ITEM_GROUP_ID
AHL_PRD_DISPOSITIONS_B	CSI_ITEM_INSTANCES	AHL_PRD_DISPOSITIONS_B.INSTANCE_ID
AHL_PRD_DISPOSITIONS_B	CS_INCIDENTS_ALL_B	AHL_PRD_DISPOSITIONS_B.PRIMARY_SERVICE_REQUEST_ID
AHL_PRD_DISPOSITIONS_B	AHL_WORKORDERS	AHL_PRD_DISPOSITIONS_B.NON_ROUTINE_WORKORDER_ID
AHL_PRD_DISPOSITIONS_TL	AHL_PRD_DISPOSITIONS_B	AHL_PRD_DISPOSITIONS_TL.DISPOSITION_ID
AHL_PRD_DISPOSITIONS_TL_H	AHL_PRD_DISPOSITIONS_B	AHL_PRD_DISPOSITIONS_TL_H.DISPOSITION_ID
AHL_PRD_DISP_MTL_TXNS	AHL_PRD_DISPOSITIONS_B	AHL_PRD_DISP_MTL_TXNS.DISPOSITION_ID