Tuesday, September 12, 2017

API to get Accounting Key Flexfield Concatenated Segment Description (GL_FLEXFIELDS_PKG.GET_CONCAT_DESCRIPTION)

SELECT gcc.concatenated_segments,
       GL_FLEXFIELDS_PKG.GET_CONCAT_DESCRIPTION( gcc.chart_of_accounts_id,
                                                 gcc.code_combination_id
                                               ) acc_description
FROM gl_code_combinations_kfv gcc;

No comments:

Post a Comment

API to Delete FND Application (FND_APPLICATION_PKG.DELETE_ROW)

BEGIN    FND_APPLICATION_PKG.DELETE_ROW (X_APPLICATION_ID => 20003); END; /