APPS.AHL_FMP_MR_EFFECTIVITY_PVT dependencies on AHL_MR_EFFECTIVITIES_APP_V

Line 891: AHL_MR_EFFECTIVITIES_APP_V EF

887: CURSOR get_eff_dtls_rec ( c_mr_effectivity_id NUMBER )
888: IS
889: SELECT DISTINCT EFD.manufacturer_id
890: FROM AHL_MR_EFFECTIVITY_DTLS_APP_V EFD,
891: AHL_MR_EFFECTIVITIES_APP_V EF
892: WHERE EFD.manufacturer_id IS NOT NULL
893: AND EFD.mr_effectivity_id = EF.mr_effectivity_id
894: AND EF.mr_effectivity_id = c_mr_effectivity_id;
895:

Line 900: AHL_MR_EFFECTIVITIES_APP_V EF

896: CURSOR get_intervals_rec ( c_mr_effectivity_id NUMBER )
897: IS
898: SELECT DISTINCT INT.counter_id
899: FROM AHL_MR_INTERVALS_APP_V INT,
900: AHL_MR_EFFECTIVITIES_APP_V EF
901: WHERE INT.mr_effectivity_id = EF.mr_effectivity_id
902: AND EF.mr_effectivity_id = c_mr_effectivity_id;
903:
904: -- Tamal [MEL/CDL RM-FMP Enhancements] Begins here...

Line 1157: FROM AHL_MR_EFFECTIVITIES_APP_V

1153:
1154: CURSOR get_dup_name ( c_mr_header_id NUMBER )
1155: IS
1156: SELECT name
1157: FROM AHL_MR_EFFECTIVITIES_APP_V
1158: WHERE mr_header_id = c_mr_header_id
1159: GROUP BY name
1160: HAVING count(*) > 1;
1161:

Line 1165: FROM AHL_MR_EFFECTIVITIES_APP_V

1161:
1162: CURSOR get_dup_item ( c_mr_header_id NUMBER )
1163: IS
1164: SELECT inventory_item_id
1165: FROM AHL_MR_EFFECTIVITIES_APP_V
1166: WHERE mr_header_id = c_mr_header_id
1167: GROUP BY inventory_item_id
1168: HAVING count(*) > 1;
1169: