摘要：
FUNCTION get_acc_type(p_sob_id IN NUMBER, p_account_code IN VARCHAR2) RETURN VARCHAR2 IS l_acc_type VARCHAR2(1); BEGIN SELECT substr(ffvl.compiled_value_attributes, -1) INTO l_acc_type FROM gl_sets_of_books sob, fnd_id_flex_structures_vl fifstv, fnd_id_flex_segments fifsg, fnd_flex_values_vl ffvl WH 阅读全文