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 AHL_MR_EFFECTIVITY_DTLS_V

Line 481: FROM AHL_MR_EFFECTIVITY_DTLS_V

477: attribute12,
478: attribute13,
479: attribute14,
480: attribute15
481: FROM AHL_MR_EFFECTIVITY_DTLS_V
482: WHERE mr_effectivity_detail_id = c_mr_effectivity_detail_id;
483:
484: BEGIN
485:

Line 825: FROM AHL_MR_EFFECTIVITY_DTLS_V

821: manufacturer,
822: manufacture_date_from,
823: manufacture_date_to,
824: country
825: FROM AHL_MR_EFFECTIVITY_DTLS_V
826: WHERE mr_effectivity_id = c_mr_effectivity_id
827: GROUP BY serial_number_from,
828: serial_number_to,
829: manufacturer,

Line 890: FROM AHL_MR_EFFECTIVITY_DTLS_V

886: IS
887: SELECT serial_number_from,
888: serial_number_to,
889: MR_EFFECTIVITY_DETAIL_ID
890: FROM AHL_MR_EFFECTIVITY_DTLS_V
891: WHERE mr_effectivity_id = c_mr_effectivity_id;
892:
893:
894: Cursor find_min_max_serials ( c_mr_effectivity_id NUMBER )