APPS.GMDFMVAL_PUB dependencies on GMD_MATERIAL_EFFECTIVITIES_VW

Line 996: FROM gmd_material_effectivities_vw vw

992: SELECT * FROM fm_matl_dtl WHERE formulaline_id = vFormulaline_id;
993:
994: CURSOR get_item_substitution(vFormula_id Number, vFormulaline_id Number, vItem_id Number, vDate Date) IS
995: SELECT *
996: FROM gmd_material_effectivities_vw vw
997: WHERE vw.formula_id = vFormula_id
998: AND vw.formulaline_id = vFormulaline_id
999: AND vw.line_item_id = vItem_id
1000: AND vw.start_date <= vDate

Line 1330: FROM gmd_material_effectivities_vw

1326:
1327: --Check substitution records for the formulaline_id.
1328: SELECT count(*)
1329: INTO l_subst_recs
1330: FROM gmd_material_effectivities_vw
1331: WHERE formula_id = get_fmline_rec.formula_id
1332: AND formulaline_id = get_fmline_rec.formulaline_id;
1333:
1334: IF l_subst_recs <= 1 THEN

Line 1360: FROM gmd_material_effectivities_vw

1356:
1357: --Check substitution records for the formulaline_id.
1358: SELECT count(*)
1359: INTO l_subst_recs
1360: FROM gmd_material_effectivities_vw
1361: WHERE formula_id = get_fmline_rec.formula_id
1362: AND formulaline_id = get_fmline_rec.formulaline_id;
1363:
1364: IF l_subst_recs <= 1 THEN

Line 1428: FROM gmd_material_effectivities_vw

1424:
1425: --Check substitution records for the formulaline_id.
1426: SELECT count(*)
1427: INTO l_subst_recs
1428: FROM gmd_material_effectivities_vw
1429: WHERE formula_id = get_fmline_rec.formula_id
1430: AND formulaline_id = get_fmline_rec.formulaline_id;
1431:
1432: IF l_subst_recs <= 1 THEN