Data retrieval from GL Code Combinations

Query to get all records from GL_CODE_COMBINATIONS which are updated after last_run_date derived

Query to get all records from GL_CODE_COMBINATIONS which are updated after last_run_date derived SELECT GCC.CODE_COMBINATION_ID ,GCC.ALTERNATE_CODE_COMBINATION_ID ,GCC.CHART_OF_ACCOUNTS_ID ,GCC.DETAIL_POSTING_ALLOWED_FLAG ,GCC.DETAIL_BUDGETING_ALLOWED_FLAG ,GCC.ACCOUNT_TYPE ,GCC.ENABLED_FLAG ,GCC.SUMMARY_FLAG ,GCC.SEGMENT1 ,GCC.SEGMENT2 ,GCC.SEGMENT3 ,GCC.SEGMENT4 ,GCC.SEGMENT5 ,GCC.SEGMENT6 ,GCC.SEGMENT7 ,GCC.SEGMENT8 ,GCC.SEGMENT9 ,GCC.SEGMENT10 ,GCC.SEGMENT11 ,GCC.SEGMENT12 ,GCC.START_DATE_ACTIVE ,GCC.END_DATE_ACTIVE ,GCC.JGZZ_RECON_FLAG ,GCC.PRESERVE_FLAG ,GCC.DESCRIPTION ,GCC.TEMPLATE_ID ,GCC.ALLOCATION_CREATE_FLAG FROM   GL_CODE_COMBINATIONS GCC WHERE  GCC.LAST_UPDATE_DATE > TO_DATE (G_DT_LAST_RUN_DATE, ‘DD-MM-YYYY HH24:MI:SS’) AND    GCC.ATTRIBUTE1 IS NULL […]

Scroll to top
Copy Protected by Chetan's WP-Copyprotect.