APPS.AHL_FMP_MR_EFFECTIVITY_PVT dependencies on AHL_MR_EFFECTIVITIES_APP_V

Line 964: AHL_MR_EFFECTIVITIES_APP_V EF

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;
968:

Line 973: AHL_MR_EFFECTIVITIES_APP_V EF

969: CURSOR get_intervals_rec ( c_mr_effectivity_id NUMBER )
970: IS
971: SELECT DISTINCT INT.counter_id
972: FROM AHL_MR_INTERVALS_APP_V INT,
973: AHL_MR_EFFECTIVITIES_APP_V EF
974: WHERE INT.mr_effectivity_id = EF.mr_effectivity_id
975: AND EF.mr_effectivity_id = c_mr_effectivity_id;
976:
977: -- Tamal [MEL/CDL RM-FMP Enhancements] Begins here...

Line 1242: FROM AHL_MR_EFFECTIVITIES_APP_V

1238:
1239: CURSOR get_dup_name ( c_mr_header_id NUMBER )
1240: IS
1241: SELECT name
1242: FROM AHL_MR_EFFECTIVITIES_APP_V
1243: WHERE mr_header_id = c_mr_header_id
1244: GROUP BY name
1245: HAVING count(*) > 1;
1246:

Line 1250: FROM AHL_MR_EFFECTIVITIES_APP_V

1246:
1247: CURSOR get_dup_item ( c_mr_header_id NUMBER )
1248: IS
1249: SELECT inventory_item_id
1250: FROM AHL_MR_EFFECTIVITIES_APP_V
1251: WHERE mr_header_id = c_mr_header_id
1252: GROUP BY inventory_item_id
1253: HAVING count(*) > 1;
1254: