Monthly Archives: October 2020

–###################################################################### — Script to get chart of account details from Oracle Apps financials –##################################################################### SELECT gcc.code_combination_id, gcc.segment1, DECODE (gcc.segment1, NULL, ”, apps.gl_flexfields_pkg.get_description_sql (gcc.chart_of_accounts_id, 1, gcc.segment1 ) ) seg1_desc, gcc.segment2, DECODE (gcc.segment2, NULL, ”, apps.gl_flexfields_pkg.get_description_sql (gcc.chart_of_accounts_id, 2, gcc.segment2 ) ) seg2_desc, … Continue reading →