DBA Data[Home] [Help]

APPS.BOM_VAL_TO_ID dependencies on MFG_LOOKUPS

Line 93: SELECT lookup_code INTO l_enforce_int_reqcode FROM mfg_lookups WHERE

89: RETURN NUMBER
90: IS
91: l_enforce_int_reqcode NUMBER;
92: BEGIN
93: SELECT lookup_code INTO l_enforce_int_reqcode FROM mfg_lookups WHERE
94: lookup_type = 'BOM_ENFORCE_INT_REQUIREMENTS' AND
95: upper(meaning) = upper(p_enforce_integer);
96: Return l_enforce_int_reqcode;
97: EXCEPTION WHEN OTHERS THEN