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

Line 518: FROM AHL_MR_EFFECTIVITY_DTLS_APP_V

514: ATTRIBUTE12,
515: ATTRIBUTE13,
516: ATTRIBUTE14,
517: ATTRIBUTE15
518: FROM AHL_MR_EFFECTIVITY_DTLS_APP_V
519: WHERE MR_EFFECTIVITY_ID=C_MR_EFFECTIVITY_ID;
520:
521: -- Effectivity Details
522: CURSOR CurGetEffectExtDTLS(C_MR_EFFECTIVITY_ID NUMBER)

Line 1186: INSERT INTO AHL_MR_EFFECTIVITY_DTLS

1182:
1183: IF CurGetEffectDTLS%FOUND
1184: THEN
1185:
1186: INSERT INTO AHL_MR_EFFECTIVITY_DTLS
1187: (
1188: MR_EFFECTIVITY_DETAIL_ID,
1189: MR_EFFECTIVITY_ID,
1190: EXCLUDE_FLAG,

Line 1222: AHL_MR_EFFECTIVITY_DTLS_S.NEXTVAL,

1218: ATTRIBUTE15
1219: )
1220: VALUES
1221: (
1222: AHL_MR_EFFECTIVITY_DTLS_S.NEXTVAL,
1223: l_new_mr_EFFECTIVITY_ID,
1224: l_mr_effect_dtls_rec.EXCLUDE_FLAG,
1225: l_mr_effect_dtls_rec.MANUFACTURER_ID,
1226: l_mr_effect_dtls_rec.COUNTRY_CODE,