ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 35DAEBF1A17015D9E0630100007F37DFY select fav.application_name application, fdsc.table_name, fdsc.name category, gl.name ledger, decode(fdsa.method_code,'A','Automatic','M','Manual',fdsa.method_code) method, fdsa.start_date, fdsa.end_date, fds.name sequence_name, fds.start_date sequence_start_date, fds.end_date sequence_end_date, decode(fds.type,'A','Automatic','M','Manual','G','Gapless') sequence_type, xxen_util.yes(fds.message_flag) message, fds.initial_value, (select ds.last_number from dba_sequences ds where fds.db_sequence_name=ds.sequence_name and ds.sequence_owner='APPLSYS') last_number, fds.db_sequence_name, fds.table_name, fds.audit_table_name, xxen_util.user_name(fdsa.created_by) created_by, xxen_util.client_time(fdsa.creation_date) creation_date, xxen_util.user_name(fdsa.last_updated_by) last_updated_by, xxen_util.client_time(fdsa.last_update_date) last_update_date, xxen_util.user_name(fds.created_by) sequence_created_by, xxen_util.client_time(fds.creation_date) sequence_creation_date, xxen_util.user_name(fds.last_updated_by) sequence_last_updated_by, xxen_util.client_time(fds.last_update_date) sequence_last_update_date, fdsa.doc_sequence_assignment_id, fdsa.doc_sequence_id, fdsa.category_code from fnd_application_vl fav, fnd_doc_sequence_assignments fdsa, fnd_document_sequences fds, gl_ledgers gl, fnd_doc_sequence_categories fdsc where 1=1 and fav.application_id=fdsa.application_id and fdsa.doc_sequence_id=fds.doc_sequence_id and fdsa.set_of_books_id=gl.ledger_id(+) and fdsa.application_id=fdsc.application_id(+) and fdsa.category_code=fdsc.code(+) order by fdsa.application_id, fdsa.set_of_books_id, fdsa.category_code, fdsa.method_code, fdsa.start_date US FND Document Sequence Assignments Document sequence asssignments to application tables, ledgers and categories, including sequence details such as database sequence name and last seqeunce number. Enginatics 1=1 1 10 1=1 fav.application_name=:application_name LOV FND Application Name 8E2FF36EDE9879D2E0530100007F1FF2 Y select fav.application_name value, fav.application_short_name description from fnd_application_vl fav order by fav.application_name US Application 2 20 1=1 gl.name=:ledger LOV GL Ledger 8E2FF36EDEB879D2E0530100007F1FF2 Y select gl.name value, fifsv.id_flex_structure_name||': '||decode(gl.ledger_category_code,'NONE',xxen_util.meaning(gl.object_type_code,'LEDGERS',101),xxen_util.meaning(gl.ledger_category_code,'GL_ASF_LEDGER_CATEGORY',101))||': '||gl.description description from gl_ledgers gl, fnd_id_flex_structures_vl fifsv where (:$flex$.ledger_category is null or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y')) and (:$flex$.chart_of_accounts is null or xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y') and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) and gl.chart_of_accounts_id=fifsv.id_flex_num and fifsv.id_flex_code='GL#' and fifsv.application_id=101 order by fifsv.id_flex_structure_name, decode(gl.ledger_category_code,'PRIMARY',1,'SECONDARY',2,'ALC',3,'NONE',4), gl.name coalesce(xxen_util.previous_parameter_value(:parameter_id),xxen_util.default_ledger) US Ledger