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.

APPS.AHL_FMP_EFFECTIVITY_DTL_PVT dependencies on CSI_ITEM_INSTANCES

Line 897: from csi_item_instances CSI,

893:
894: Cursor find_min_max_serials ( c_mr_effectivity_id NUMBER )
895: IS
896: select distinct MIN(CSI.serial_number) , MAX(CSI.serial_number)
897: from csi_item_instances CSI,
898: AHL_MR_EFFECTIVITIES EFF
899: where
900: EFF.MR_EFFECTIVITY_ID = c_mr_effectivity_id and
901: CSI.inventory_item_id = EFF.inventory_item_id

Line 904: from csi_item_instances CSI,

900: EFF.MR_EFFECTIVITY_ID = c_mr_effectivity_id and
901: CSI.inventory_item_id = EFF.inventory_item_id
902: UNION
903: select distinct MIN(CSI.serial_number) , MAX(CSI.serial_number)
904: from csi_item_instances CSI,
905: ahl_position_alternates_v PA,
906: AHL_MR_EFFECTIVITIES EFF
907: where
908: EFF.MR_EFFECTIVITY_ID = c_mr_effectivity_id and