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 1741: from csi_item_instances CSI,

1737:
1738: Cursor find_min_max_serials ( c_mr_effectivity_id NUMBER )
1739: IS
1740: select distinct MIN(CSI.serial_number) , MAX(CSI.serial_number)
1741: from csi_item_instances CSI,
1742: AHL_MR_EFFECTIVITIES EFF
1743: where
1744: EFF.MR_EFFECTIVITY_ID = c_mr_effectivity_id and
1745: CSI.inventory_item_id = EFF.inventory_item_id

Line 1748: from csi_item_instances CSI,

1744: EFF.MR_EFFECTIVITY_ID = c_mr_effectivity_id and
1745: CSI.inventory_item_id = EFF.inventory_item_id
1746: UNION
1747: select distinct MIN(CSI.serial_number) , MAX(CSI.serial_number)
1748: from csi_item_instances CSI,
1749: ahl_position_alternates_v PA,
1750: AHL_MR_EFFECTIVITIES EFF
1751: where
1752: EFF.MR_EFFECTIVITY_ID = c_mr_effectivity_id and