ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 08006129DF803B87E06362FB0905246DY select 1 from dual where 1=1 IGC IGCBAPRR_XML US IGC Commitment Budgetary Control Archive Purge Imported from BI Publisher Description: Commitment Budgetary Control Archive Purge Report Application: Contract Commitment Source: Commitment Budgetary Control Archive Purge Report (XML) Short Name: IGCBAPRR_XML DB package: IGCBAPRR RDF 1=1 :p_conc_request_id 1 -10 :p_set_of_books_id Number fnd_profile.value('GL_SET_OF_BKS_ID') Y US Ledger Id Ledger Id 2 10 :p_fiscal_year LOV Oracle IGC_FISCAL_YEAR Y select period_year id, period_year value, null description from gl_period_statuses a where application_id=(select application_id from fnd_application where application_short_name='SQLGL') and set_of_books_id=(select to_number(o2.org_information3) from hr_organization_information o1, hr_organization_information o2, gl_ledgers_public_v gl where o1.organization_id=o2.organization_id and o1.organization_id= mo_global.get_current_org_id and o1.org_information_context='CLASS' and o2.org_information_context= 'Operating Unit Information' and o1.org_information1='OPERATING_UNIT' and o1.org_information2='Y' and o2.org_information3=gl.ledger_id ) and rowid= (select max(rowid) from gl_period_statuses b where b.application_id=a.application_id and b.period_year=a.period_year and b.set_of_books_id=(select to_number(o2.org_information3) from hr_organization_information o1, hr_organization_information o2, gl_ledgers_public_v gl where o1.organization_id=o2.organization_id and o1.organization_id= mo_global.get_current_org_id and o1.org_information_context='CLASS' and o2.org_information_context= 'Operating Unit Information' and o1.org_information1='OPERATING_UNIT' and o1.org_information2='Y' and o2.org_information3=gl.ledger_id ) ) order by period_year Y US Fiscal Year Fiscal Year 3 20 :p_report_mode LOV Oracle IGC_ARC_PURGE_CODE Y select lookup_code id, meaning value, null description from fnd_lookup_values where lookup_type='IGC_ARCH_PUR_TYPE' and language=userenv ('LANG') order by value,description Y US Run Mode Mode