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_MR_EFFECTIVITY_PVT dependencies on AHL_MR_EFFECTIVITY_DTLS

Line 963: FROM AHL_MR_EFFECTIVITY_DTLS_APP_V EFD,

959:
960: CURSOR get_eff_dtls_rec ( c_mr_effectivity_id NUMBER )
961: IS
962: SELECT DISTINCT EFD.manufacturer_id
963: FROM AHL_MR_EFFECTIVITY_DTLS_APP_V EFD,
964: AHL_MR_EFFECTIVITIES_APP_V EF
965: WHERE EFD.manufacturer_id IS NOT NULL
966: AND EFD.mr_effectivity_id = EF.mr_effectivity_id
967: AND EF.mr_effectivity_id = c_mr_effectivity_id;

Line 1701: DELETE AHL_MR_EFFECTIVITY_DTLS

1697: FND_MSG_PUB.add;
1698: END IF;
1699:
1700: -- Delete the record in related Tables
1701: DELETE AHL_MR_EFFECTIVITY_DTLS
1702: WHERE mr_effectivity_id = p_x_effectivity_tbl(i).mr_effectivity_id;
1703:
1704: -- If the record does not exist, then, Continue.
1705: IF ( SQL%ROWCOUNT = 0 ) THEN