DBA Data[Home] [Help]

APPS.GMD_SPEC_GRP dependencies on MTL_UNITS_OF_MEASURE

Line 1012: FROM gmd_spec_tests_b st, mtl_units_of_measure um

1008: RETURN BOOLEAN IS
1009:
1010: CURSOR c_class_combo (p_spec_name VARCHAR2, p_spec_vers NUMBER, p_to_uom VARCHAR2) IS
1011: SELECT 1
1012: FROM gmd_spec_tests_b st, mtl_units_of_measure um
1013: WHERE st.spec_id = p_spec_id
1014: AND st.test_id <> p_test_id
1015: AND st.to_qty_uom = um.uom_code
1016: AND um.uom_class =

Line 1017: (select uom_class from mtl_units_of_measure where uom_code = p_to_uom);

1013: WHERE st.spec_id = p_spec_id
1014: AND st.test_id <> p_test_id
1015: AND st.to_qty_uom = um.uom_code
1016: AND um.uom_class =
1017: (select uom_class from mtl_units_of_measure where uom_code = p_to_uom);
1018:
1019: dummy PLS_INTEGER;
1020:
1021: BEGIN