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 508: FROM AHL_MR_EFFECTIVITY_DTLS_APP_V

504: ATTRIBUTE12,
505: ATTRIBUTE13,
506: ATTRIBUTE14,
507: ATTRIBUTE15
508: FROM AHL_MR_EFFECTIVITY_DTLS_APP_V
509: WHERE MR_EFFECTIVITY_ID=C_MR_EFFECTIVITY_ID;
510:
511: CURSOR CurGetRelationDet
512: IS

Line 1028: INSERT INTO AHL_MR_EFFECTIVITY_DTLS

1024:
1025: IF CurGetEffectDTLS%FOUND
1026: THEN
1027:
1028: INSERT INTO AHL_MR_EFFECTIVITY_DTLS
1029: (
1030: MR_EFFECTIVITY_DETAIL_ID,
1031: MR_EFFECTIVITY_ID,
1032: EXCLUDE_FLAG,

Line 1064: AHL_MR_EFFECTIVITY_DTLS_S.NEXTVAL,

1060: ATTRIBUTE15
1061: )
1062: VALUES
1063: (
1064: AHL_MR_EFFECTIVITY_DTLS_S.NEXTVAL,
1065: l_new_mr_EFFECTIVITY_ID,
1066: l_mr_effect_dtls_rec.EXCLUDE_FLAG,
1067: l_mr_effect_dtls_rec.MANUFACTURER_ID,
1068: l_mr_effect_dtls_rec.COUNTRY_CODE,