DBA Data[Home] [Help]

APPS.GMD_SPEC_GRP dependencies on MTL_UNITS_OF_MEASURE

Line 970: FROM gmd_spec_tests_b st, mtl_units_of_measure um

966: RETURN BOOLEAN IS
967:
968: CURSOR c_class_combo (p_spec_name VARCHAR2, p_spec_vers NUMBER, p_to_uom VARCHAR2) IS
969: SELECT 1
970: FROM gmd_spec_tests_b st, mtl_units_of_measure um
971: WHERE st.spec_id = p_spec_id
972: AND st.test_id <> p_test_id
973: AND st.to_qty_uom = um.uom_code
974: AND um.uom_class =

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

971: WHERE st.spec_id = p_spec_id
972: AND st.test_id <> p_test_id
973: AND st.to_qty_uom = um.uom_code
974: AND um.uom_class =
975: (select uom_class from mtl_units_of_measure where uom_code = p_to_uom);
976:
977: dummy PLS_INTEGER;
978:
979: BEGIN