Skip to main content

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 […]

Read More

oracle apps General Ledger Query to delete the budget lines from Budget Interface Table in R12

  General Ledger SELECT Query to get the details for the Budget Name and Budget Entity Name SELECT GBI.* FROM GL_BUDGET_INTERFACE GBI WHERE 1=1 AND GBI.LEDGER_ID = <PROVIDE_LEDGER_ID> AND GBI.BUDGET_NAME= ‘<PROVIDE_BUDGET_NAME>’ AND GBI.BUDGET_ENTITY_NAME= ‘<PROVIDE_BUDGET_ENTITY_NAME>’ AND GBI.FISCAL_YEAR = ‘<PROVIDE_FISCAL_YEAR>’ –2016   Get the count for the Budget lines from the Budget Interface Table that need to […]

Read More

oracle apps General Ledger SQL to get the complete workflow Item and process activities for a particular Journal Batch

General Ledger SQL Query  to get Journal Batch workflow Item and process activities: SELECT WF_PROCESS.PROCESS_NAME, WF_IT_ACT_STATUS.* FROM WF_ITEM_ACTIVITY_STATUSES WF_IT_ACT_STATUS, WF_PROCESS_ACTIVITIES WF_PROCESS WHERE 1=1 AND ITEM_KEY LIKE ‘%<PROVIDE_JE_BATCH_ID>%’ AND WF_IT_ACT_STATUS.ITEM_TYPE = ‘GLBATCH’ AND WF_PROCESS.INSTANCE_ID = WF_IT_ACT_STATUS.PROCESS_ACTIVITY ORDER BY BEGIN_DATE, END_DATE

Read More

Copy Protected by Chetan's WP-Copyprotect.