ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN F197EA704D3C076AE0530100007F65F9 select null action_, null status_, null message_, null request_id_, null modified_columns_, chartorowid(null) row_id, to_number(null) group_id, 'Vision Operations (USA)' ledger_name, 'Operations' organization, 'CORPORATE 2000' budget, 'Spreadsheet' source, 'Adjustment' category, 'Yes' check_if_journal_balanced, 'Dummy' batch_name, 'Dummy' approval_status, 'Dummy' batch_description, 'Dummy' journal_name, 'Dummy' journal_description, 'Dummy' journal_reference, 'GBP' currency, sysdate accounting_date, 'Jan-99' period, to_char(null) account_alias, to_char(null) concatenated_segments, to_char(null) gl_segment1, to_char(null) gl_segment2, to_char(null) gl_segment3, to_char(null) gl_segment4, to_char(null) gl_segment5, to_char(null) gl_segment6, to_char(null) gl_segment7, to_char(null) gl_segment8, to_char(null) gl_segment9, to_char(null) gl_segment10, to_char(null) gl_segment11, to_char(null) gl_segment12, to_char(null) gl_segment13, to_char(null) gl_segment14, to_char(null) gl_segment15, 0 debit, 0 credit, 0 stat_amount, 'Yes' reverse_journal, 'Jan-99' reversal_period, 'User' conversion_type, sysdate conversion_date, 1 conversion_rate, 'Dummy' line_description, 'A' actual_flag, 'INV' encumbrance_type, null attach_upload_file, null status, sysdate date_created, to_number(null) created_by, to_number(null) user_id, null summary_flag, null post_to_suspense_flag, null submit_approval, null submit_posting, null line_dff_context, null gl_je_line_attribute1, null gl_je_line_attribute2, null gl_je_line_attribute3, null gl_je_line_attribute4, null gl_je_line_attribute5, null gl_je_line_attribute6, null gl_je_line_attribute7, null gl_je_line_attribute8, null gl_je_line_attribute9, null gl_je_line_attribute10, null attachment_category_, null attachment_title_, null attachment_description_, null attachment_type_, null attachment_content_, null attachment_file_id_, 0 upload_row from dual where 1=1 and 1=0 and :p_actual_flag=:p_actual_flag and nvl(:p_foreign_currency_flag,'No')=nvl(:p_foreign_currency_flag,'No') and :p_create_summary_jnl=:p_create_summary_jnl and :p_post_to_suspense_flag=:p_post_to_suspense_flag Y U SQLGL GLLEZLSRS A Y xxen_gl_upload.insert_gl_interface xxen_gl_upload.submit_gl_import xxen_gl_upload.validate_journal_line( p_ledger=>:$column$.ledger_name, p_segment1=>:$column$.gl_segment1, p_segment2=>:$column$.gl_segment2, p_segment3=>:$column$.gl_segment3, p_segment4=>:$column$.gl_segment4, p_segment5=>:$column$.gl_segment5, p_segment6=>:$column$.gl_segment6, p_segment7=>:$column$.gl_segment7, p_segment8=>:$column$.gl_segment8, p_segment9=>:$column$.gl_segment9, p_segment10=>:$column$.gl_segment10, p_segment11=>:$column$.gl_segment11, p_segment12=>:$column$.gl_segment12, p_segment13=>:$column$.gl_segment13, p_segment14=>:$column$.gl_segment14, p_segment15=>:$column$.gl_segment15, p_context=>:$column$.line_dff_context, p_attribute1=>:$column$.gl_je_line_attribute1, p_attribute2=>:$column$.gl_je_line_attribute2, p_attribute3=>:$column$.gl_je_line_attribute3, p_attribute4=>:$column$.gl_je_line_attribute4, p_attribute5=>:$column$.gl_je_line_attribute5, p_attribute6=>:$column$.gl_je_line_attribute6, p_attribute7=>:$column$.gl_je_line_attribute7, p_attribute8=>:$column$.gl_je_line_attribute8, p_attribute9=>:$column$.gl_je_line_attribute9, p_attribute10=>:$column$.gl_je_line_attribute10, p_debit=>:$column$.debit, p_credit=>:$column$.credit, p_currency=>:$column$.currency, p_stat_amount=>:$column$.stat_amount ) F GL Journal Upload Chargement du journal GL Des modèles sont fournis pour les types de journaux suivants - Réels fonctionnels - Réels étrangers - Journaux de budget - Journaux d'encaissement US GL Journal Upload GL Journal Upload Templates are provided for the following Journal Types - Functional Actuals - Foreign Actuals - Budget Journals - Encumbrance Journals Submit for Approval --------------------------- Imported Journals requiring approval can be submitted for approval after import if they are eligble. Submit Journal Post --------------------------- Imported Journals can be submitted for immediate posting after import if they are eligible. In order to submit journals for posting, the current responsibility must have access to post journals. Enginatics R12 only Upload 1=1 :p_actual_flag :p_create_summary_jnl :p_foreign_currency_flag :p_post_to_suspense_flag 1 -40 :p_create_summary_jnl LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description N Y US Create Summary Journal 2 -30 :p_post_to_suspense_flag LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description N Y US Post Errors to Suspense 3 -5 1=1 :ledger=:ledger Char xxen_util.default_ledger US Ledger 4 10 :p_actual_flag LOV custom Y select flvv.meaning value, flvv.lookup_code description from fnd_lookup_values_vl flvv where flvv.lookup_type='XLA_BALANCE_TYPE' and flvv.view_application_id=602 and flvv.security_group_id=0 order by flvv.meaning xxen_util.meaning('A','XLA_BALANCE_TYPE',602) Y US Journal Type 5 20 :p_foreign_currency_flag LOV custom Y select xxen_util.meaning('Y','YES_NO',0) value, null description from dual where (select flvv.lookup_code from fnd_lookup_values_vl flvv where flvv.lookup_type = 'XLA_BALANCE_TYPE' and flvv.view_application_id = 602 and flvv.description = :$flex$.Journal_Type) != 'E' US Allow Foreign Currency 6 30 1=1 :attach_upload_file_to_journal=:attach_upload_file_to_journal LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description N Y US Attach Upload file to Journal 7 40 1=1 :submit_for_approval=:submit_for_approval LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description N Y US Submit for Approval 8 50 1=1 :submit_posting=:submit_posting LOV custom Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' and (lookup_code = 'N' or xxen_gl_upload.responsibility_can_post = 'Y' ) order by value,description N Y US Submit Journal Post 9 60 1=1 :check_if_journal_balanced=:check_if_journal_balanced LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description US Check if Journal Balanced :$flex$.Journal_Type Journal Type Allow Foreign Currency D0E50AE6CA4D24EC86A678182B431DE9 Budget Journal SYSADMIN -9.001 ACCOUNT 7 ACCOUNTING_DATE 10 ACCOUNT_ALIAS 9 APPROVAL_STATUS 30 BATCH_DESCRIPTION 29 BATCH_NAME 3 BUDGET 5 CATEGORY 11 CONCATENATED_SEGMENTS 28 CREDIT 6 CURRENCY -6.0007 CURRENCY_CODE 27 DEBIT -6.001 GL_ACCOUNT -6.0009 GL_ACCOUNT_ALIAS 12 GL_SEGMENT1 21 GL_SEGMENT10 22 GL_SEGMENT11 23 GL_SEGMENT12 24 GL_SEGMENT13 25 GL_SEGMENT14 26 GL_SEGMENT15 13 GL_SEGMENT2 14 GL_SEGMENT3 15 GL_SEGMENT4 16 GL_SEGMENT5 17 GL_SEGMENT6 18 GL_SEGMENT7 19 GL_SEGMENT8 20 GL_SEGMENT9 32 JOURNAL_DESCRIPTION -12.0013 JOURNAL_LINE_DESCRIPTION 31 JOURNAL_NAME 33 JOURNAL_REFERENCE 1 LEDGER_NAME 34 LINE_DESCRIPTION 2 ORGANIZATION 8 PERIOD -6.0008 PERIOD_NAME 4 SOURCE -2.0004 USER_JE_CATEGORY_NAME -2.0003 USER_JE_SOURCE_NAME Allow Foreign Currency Yes Journal Type Budget S Site 09893E41313B169ADA325A275247D02E Budget Journal (with attachment) ENGINATICS -9.001 ACCOUNT 7 ACCOUNTING_DATE 10 ACCOUNT_ALIAS 9 APPROVAL_STATUS 35 ATTACHMENT_CATEGORY_ 39 ATTACHMENT_CONTENT_ 37 ATTACHMENT_DESCRIPTION_ 40 ATTACHMENT_FILE_ID_ 36 ATTACHMENT_TITLE_ 38 ATTACHMENT_TYPE_ 30 BATCH_DESCRIPTION 29 BATCH_NAME 3 BUDGET 5 CATEGORY 11 CONCATENATED_SEGMENTS 28 CREDIT 6 CURRENCY -6.0007 CURRENCY_CODE 27 DEBIT -6.001 GL_ACCOUNT -6.0009 GL_ACCOUNT_ALIAS 12 GL_SEGMENT1 21 GL_SEGMENT10 22 GL_SEGMENT11 23 GL_SEGMENT12 24 GL_SEGMENT13 25 GL_SEGMENT14 26 GL_SEGMENT15 13 GL_SEGMENT2 14 GL_SEGMENT3 15 GL_SEGMENT4 16 GL_SEGMENT5 17 GL_SEGMENT6 18 GL_SEGMENT7 19 GL_SEGMENT8 20 GL_SEGMENT9 32 JOURNAL_DESCRIPTION -12.0013 JOURNAL_LINE_DESCRIPTION 31 JOURNAL_NAME 33 JOURNAL_REFERENCE 1 LEDGER_NAME 34 LINE_DESCRIPTION 2 ORGANIZATION 8 PERIOD -6.0008 PERIOD_NAME 4 SOURCE -2.0004 USER_JE_CATEGORY_NAME -2.0003 USER_JE_SOURCE_NAME Allow Foreign Currency Yes Journal Type Budget S Site D4A8098E9B460ED1D5EDC23324B812FF Budget Journal(with attachment) ENGINATICS -9.001 ACCOUNT 7 ACCOUNTING_DATE 10 ACCOUNT_ALIAS 9 APPROVAL_STATUS 35 ATTACHMENT_CATEGORY_ 39 ATTACHMENT_CONTENT_ 37 ATTACHMENT_DESCRIPTION_ 40 ATTACHMENT_FILE_ID_ 36 ATTACHMENT_TITLE_ 38 ATTACHMENT_TYPE_ 30 BATCH_DESCRIPTION 29 BATCH_NAME 3 BUDGET 5 CATEGORY 11 CONCATENATED_SEGMENTS 28 CREDIT 6 CURRENCY -6.0007 CURRENCY_CODE 27 DEBIT -6.001 GL_ACCOUNT -6.0009 GL_ACCOUNT_ALIAS 12 GL_SEGMENT1 21 GL_SEGMENT10 22 GL_SEGMENT11 23 GL_SEGMENT12 24 GL_SEGMENT13 25 GL_SEGMENT14 26 GL_SEGMENT15 13 GL_SEGMENT2 14 GL_SEGMENT3 15 GL_SEGMENT4 16 GL_SEGMENT5 17 GL_SEGMENT6 18 GL_SEGMENT7 19 GL_SEGMENT8 20 GL_SEGMENT9 32 JOURNAL_DESCRIPTION -12.0013 JOURNAL_LINE_DESCRIPTION 31 JOURNAL_NAME 33 JOURNAL_REFERENCE 1 LEDGER_NAME 34 LINE_DESCRIPTION 2 ORGANIZATION 8 PERIOD -6.0008 PERIOD_NAME 4 SOURCE -2.0004 USER_JE_CATEGORY_NAME -2.0003 USER_JE_SOURCE_NAME Allow Foreign Currency Yes Journal Type Budget S Site D1B99279E7D8BB52C411A494A4DFAABF Encumbrance Journal SYSADMIN -8.0009 ACCOUNT 6 ACCOUNTING_DATE 9 ACCOUNT_ALIAS 8 APPROVAL_STATUS 31 BATCH_DESCRIPTION 30 BATCH_NAME 4 CATEGORY 10 CONCATENATED_SEGMENTS 27 CREDIT 5 CURRENCY -6.0007 CURRENCY_CODE 26 DEBIT 2 ENCUMBRANCE_TYPE -6.001 GL_ACCOUNT -6.0009 GL_ACCOUNT_ALIAS 11 GL_SEGMENT1 20 GL_SEGMENT10 21 GL_SEGMENT11 22 GL_SEGMENT12 23 GL_SEGMENT13 24 GL_SEGMENT14 25 GL_SEGMENT15 12 GL_SEGMENT2 13 GL_SEGMENT3 14 GL_SEGMENT4 15 GL_SEGMENT5 16 GL_SEGMENT6 17 GL_SEGMENT7 18 GL_SEGMENT8 19 GL_SEGMENT9 33 JOURNAL_DESCRIPTION -12.0013 JOURNAL_LINE_DESCRIPTION 32 JOURNAL_NAME 34 JOURNAL_REFERENCE -.0001 LEDGER 1 LEDGER_NAME 35 LINE_DESCRIPTION 7 PERIOD -6.0008 PERIOD_NAME 29 REVERSAL_PERIOD 28 REVERSE_JOURNAL 3 SOURCE -2.0004 USER_JE_CATEGORY_NAME -2.0003 USER_JE_SOURCE_NAME Allow Foreign Currency Check if Journal Balanced Y Journal Type Encumbrance S Site Allow Foreign Currency 0D30BFA34E86E7E54505F29223798329 Encumbrance Journal (with attachment) ENGINATICS -8.0009 ACCOUNT 6 ACCOUNTING_DATE 9 ACCOUNT_ALIAS 8 APPROVAL_STATUS 36 ATTACHMENT_CATEGORY_ 40 ATTACHMENT_CONTENT_ 38 ATTACHMENT_DESCRIPTION_ 41 ATTACHMENT_FILE_ID_ 37 ATTACHMENT_TITLE_ 39 ATTACHMENT_TYPE_ 31 BATCH_DESCRIPTION 30 BATCH_NAME 4 CATEGORY 10 CONCATENATED_SEGMENTS 27 CREDIT 5 CURRENCY -6.0007 CURRENCY_CODE 26 DEBIT 2 ENCUMBRANCE_TYPE -6.001 GL_ACCOUNT -6.0009 GL_ACCOUNT_ALIAS 11 GL_SEGMENT1 20 GL_SEGMENT10 21 GL_SEGMENT11 22 GL_SEGMENT12 23 GL_SEGMENT13 24 GL_SEGMENT14 25 GL_SEGMENT15 12 GL_SEGMENT2 13 GL_SEGMENT3 14 GL_SEGMENT4 15 GL_SEGMENT5 16 GL_SEGMENT6 17 GL_SEGMENT7 18 GL_SEGMENT8 19 GL_SEGMENT9 33 JOURNAL_DESCRIPTION -12.0013 JOURNAL_LINE_DESCRIPTION 32 JOURNAL_NAME 34 JOURNAL_REFERENCE -.0001 LEDGER 1 LEDGER_NAME 35 LINE_DESCRIPTION 7 PERIOD -6.0008 PERIOD_NAME 29 REVERSAL_PERIOD 28 REVERSE_JOURNAL 3 SOURCE -2.0004 USER_JE_CATEGORY_NAME -2.0003 USER_JE_SOURCE_NAME Allow Foreign Currency Check if Journal Balanced Y Journal Type Encumbrance S Site Allow Foreign Currency 79DDDE53537FB03B05BEDAF6D8FA31AD Encumbrance Journal(with attachment) ENGINATICS -8.0009 ACCOUNT 6 ACCOUNTING_DATE 9 ACCOUNT_ALIAS 8 APPROVAL_STATUS 36 ATTACHMENT_CATEGORY_ 40 ATTACHMENT_CONTENT_ 38 ATTACHMENT_DESCRIPTION_ 41 ATTACHMENT_FILE_ID_ 37 ATTACHMENT_TITLE_ 39 ATTACHMENT_TYPE_ 31 BATCH_DESCRIPTION 30 BATCH_NAME 4 CATEGORY 10 CONCATENATED_SEGMENTS 27 CREDIT 5 CURRENCY -6.0007 CURRENCY_CODE 26 DEBIT 2 ENCUMBRANCE_TYPE -6.001 GL_ACCOUNT -6.0009 GL_ACCOUNT_ALIAS 11 GL_SEGMENT1 20 GL_SEGMENT10 21 GL_SEGMENT11 22 GL_SEGMENT12 23 GL_SEGMENT13 24 GL_SEGMENT14 25 GL_SEGMENT15 12 GL_SEGMENT2 13 GL_SEGMENT3 14 GL_SEGMENT4 15 GL_SEGMENT5 16 GL_SEGMENT6 17 GL_SEGMENT7 18 GL_SEGMENT8 19 GL_SEGMENT9 33 JOURNAL_DESCRIPTION -12.0013 JOURNAL_LINE_DESCRIPTION 32 JOURNAL_NAME 34 JOURNAL_REFERENCE -.0001 LEDGER 1 LEDGER_NAME 35 LINE_DESCRIPTION 7 PERIOD -6.0008 PERIOD_NAME 29 REVERSAL_PERIOD 28 REVERSE_JOURNAL 3 SOURCE -2.0004 USER_JE_CATEGORY_NAME -2.0003 USER_JE_SOURCE_NAME Allow Foreign Currency Journal Type Encumbrance S Site Allow Foreign Currency 6DECDD5D0679C80FFD06DBF8EE2CDF06 Foreign Actuals SYSADMIN -7.0008 ACCOUNT 5 ACCOUNTING_DATE Y 8 ACCOUNT_ALIAS 7 APPROVAL_STATUS 33 BATCH_DESCRIPTION 32 BATCH_NAME 3 CATEGORY Y 9 CONCATENATED_SEGMENTS 30 CONVERSION_DATE 31 CONVERSION_RATE 29 CONVERSION_TYPE 26 CREDIT 4 CURRENCY Y -5.0006 CURRENCY_CODE 25 DEBIT -7.001 GL_ACCOUNT -7.0009 GL_ACCOUNT_ALIAS 10 GL_SEGMENT1 19 GL_SEGMENT10 20 GL_SEGMENT11 21 GL_SEGMENT12 22 GL_SEGMENT13 23 GL_SEGMENT14 24 GL_SEGMENT15 11 GL_SEGMENT2 12 GL_SEGMENT3 13 GL_SEGMENT4 14 GL_SEGMENT5 15 GL_SEGMENT6 16 GL_SEGMENT7 17 GL_SEGMENT8 18 GL_SEGMENT9 35 JOURNAL_DESCRIPTION -15.0016 JOURNAL_LINE_DESCRIPTION 34 JOURNAL_NAME 36 JOURNAL_REFERENCE 1 LEDGER_NAME Y 37 LINE_DESCRIPTION 6 PERIOD Y -7.0008 PERIOD_NAME 28 REVERSAL_PERIOD 27 REVERSE_JOURNAL 2 SOURCE Y -1.0003 USER_JE_CATEGORY_NAME -1.0002 USER_JE_SOURCE_NAME Allow Foreign Currency Yes Check if Journal Balanced Y S Site FFE5F03EB17DF29FF64E28C17DD5FF02 Foreign Actuals (with attachment) ENGINATICS -7.0008 ACCOUNT 5 ACCOUNTING_DATE Y 8 ACCOUNT_ALIAS 7 APPROVAL_STATUS 38 ATTACHMENT_CATEGORY_ 42 ATTACHMENT_CONTENT_ 40 ATTACHMENT_DESCRIPTION_ 43 ATTACHMENT_FILE_ID_ 39 ATTACHMENT_TITLE_ 41 ATTACHMENT_TYPE_ 33 BATCH_DESCRIPTION 32 BATCH_NAME 3 CATEGORY Y 9 CONCATENATED_SEGMENTS 30 CONVERSION_DATE 31 CONVERSION_RATE 29 CONVERSION_TYPE 26 CREDIT 4 CURRENCY Y -5.0006 CURRENCY_CODE 25 DEBIT -7.001 GL_ACCOUNT -7.0009 GL_ACCOUNT_ALIAS 10 GL_SEGMENT1 19 GL_SEGMENT10 20 GL_SEGMENT11 21 GL_SEGMENT12 22 GL_SEGMENT13 23 GL_SEGMENT14 24 GL_SEGMENT15 11 GL_SEGMENT2 12 GL_SEGMENT3 13 GL_SEGMENT4 14 GL_SEGMENT5 15 GL_SEGMENT6 16 GL_SEGMENT7 17 GL_SEGMENT8 18 GL_SEGMENT9 35 JOURNAL_DESCRIPTION -15.0016 JOURNAL_LINE_DESCRIPTION 34 JOURNAL_NAME 36 JOURNAL_REFERENCE 1 LEDGER_NAME Y 37 LINE_DESCRIPTION 6 PERIOD Y -7.0008 PERIOD_NAME 28 REVERSAL_PERIOD 27 REVERSE_JOURNAL 2 SOURCE Y -1.0003 USER_JE_CATEGORY_NAME -1.0002 USER_JE_SOURCE_NAME Allow Foreign Currency Yes Check if Journal Balanced Y S Site 59DE0EEF902030E44C77A44CDD381D5E Foreign Actuals(with attachment) ENGINATICS -7.0008 ACCOUNT 5 ACCOUNTING_DATE Y 8 ACCOUNT_ALIAS 7 APPROVAL_STATUS 38 ATTACHMENT_CATEGORY_ 42 ATTACHMENT_CONTENT_ 40 ATTACHMENT_DESCRIPTION_ 43 ATTACHMENT_FILE_ID_ 39 ATTACHMENT_TITLE_ 41 ATTACHMENT_TYPE_ 33 BATCH_DESCRIPTION 32 BATCH_NAME 3 CATEGORY Y 9 CONCATENATED_SEGMENTS 30 CONVERSION_DATE 31 CONVERSION_RATE 29 CONVERSION_TYPE 26 CREDIT 4 CURRENCY Y -5.0006 CURRENCY_CODE 25 DEBIT -7.001 GL_ACCOUNT -7.0009 GL_ACCOUNT_ALIAS 10 GL_SEGMENT1 19 GL_SEGMENT10 20 GL_SEGMENT11 21 GL_SEGMENT12 22 GL_SEGMENT13 23 GL_SEGMENT14 24 GL_SEGMENT15 11 GL_SEGMENT2 12 GL_SEGMENT3 13 GL_SEGMENT4 14 GL_SEGMENT5 15 GL_SEGMENT6 16 GL_SEGMENT7 17 GL_SEGMENT8 18 GL_SEGMENT9 35 JOURNAL_DESCRIPTION -15.0016 JOURNAL_LINE_DESCRIPTION 34 JOURNAL_NAME 36 JOURNAL_REFERENCE 1 LEDGER_NAME Y 37 LINE_DESCRIPTION 6 PERIOD Y -7.0008 PERIOD_NAME 28 REVERSAL_PERIOD 27 REVERSE_JOURNAL 2 SOURCE Y -1.0003 USER_JE_CATEGORY_NAME -1.0002 USER_JE_SOURCE_NAME Allow Foreign Currency Yes S Site 7433D633C001FDE15E6F19BFEC8EDD16 Functional Actuals SYSADMIN -7.0008 ACCOUNT 5 ACCOUNTING_DATE 8 ACCOUNT_ALIAS 7 APPROVAL_STATUS 31 BATCH_DESCRIPTION 30 BATCH_NAME 3 CATEGORY 9 CONCATENATED_SEGMENTS 26 CREDIT 4 CURRENCY -5.0006 CURRENCY_CODE 25 DEBIT -7.001 GL_ACCOUNT -7.0009 GL_ACCOUNT_ALIAS 10 GL_SEGMENT1 19 GL_SEGMENT10 20 GL_SEGMENT11 21 GL_SEGMENT12 22 GL_SEGMENT13 23 GL_SEGMENT14 24 GL_SEGMENT15 11 GL_SEGMENT2 12 GL_SEGMENT3 13 GL_SEGMENT4 14 GL_SEGMENT5 15 GL_SEGMENT6 16 GL_SEGMENT7 17 GL_SEGMENT8 18 GL_SEGMENT9 33 JOURNAL_DESCRIPTION -12.0013 JOURNAL_LINE_DESCRIPTION 32 JOURNAL_NAME 34 JOURNAL_REFERENCE -.0001 LEDGER 1 LEDGER_NAME 35 LINE_DESCRIPTION 6 PERIOD -7.0008 PERIOD_NAME 29 REVERSAL_PERIOD 28 REVERSE_JOURNAL 2 SOURCE 27 STAT_AMOUNT -1.0003 USER_JE_CATEGORY_NAME -1.0002 USER_JE_SOURCE_NAME Check if Journal Balanced Y S Site Allow Foreign Currency 22ABB80775071D641F3C86DF6028075B Functional Actuals (with attachment) ENGINATICS -7.0008 ACCOUNT 5 ACCOUNTING_DATE 8 ACCOUNT_ALIAS 7 APPROVAL_STATUS 36 ATTACHMENT_CATEGORY_ 40 ATTACHMENT_CONTENT_ 38 ATTACHMENT_DESCRIPTION_ 41 ATTACHMENT_FILE_ID_ 37 ATTACHMENT_TITLE_ 39 ATTACHMENT_TYPE_ 31 BATCH_DESCRIPTION 30 BATCH_NAME 3 CATEGORY 9 CONCATENATED_SEGMENTS 26 CREDIT 4 CURRENCY -5.0006 CURRENCY_CODE 25 DEBIT -7.001 GL_ACCOUNT -7.0009 GL_ACCOUNT_ALIAS 10 GL_SEGMENT1 19 GL_SEGMENT10 20 GL_SEGMENT11 21 GL_SEGMENT12 22 GL_SEGMENT13 23 GL_SEGMENT14 24 GL_SEGMENT15 11 GL_SEGMENT2 12 GL_SEGMENT3 13 GL_SEGMENT4 14 GL_SEGMENT5 15 GL_SEGMENT6 16 GL_SEGMENT7 17 GL_SEGMENT8 18 GL_SEGMENT9 33 JOURNAL_DESCRIPTION -12.0013 JOURNAL_LINE_DESCRIPTION 32 JOURNAL_NAME 34 JOURNAL_REFERENCE -.0001 LEDGER 1 LEDGER_NAME 35 LINE_DESCRIPTION 6 PERIOD -7.0008 PERIOD_NAME 29 REVERSAL_PERIOD 28 REVERSE_JOURNAL 2 SOURCE 27 STAT_AMOUNT -1.0003 USER_JE_CATEGORY_NAME -1.0002 USER_JE_SOURCE_NAME Check if Journal Balanced Y S Site Allow Foreign Currency 4071B8B50CA3F48378A45B42C396C1C0 Functional Actuals(with attachment) ENGINATICS -7.0008 ACCOUNT 5 ACCOUNTING_DATE 8 ACCOUNT_ALIAS 7 APPROVAL_STATUS 36 ATTACHMENT_CATEGORY_ 40 ATTACHMENT_CONTENT_ 38 ATTACHMENT_DESCRIPTION_ 41 ATTACHMENT_FILE_ID_ 37 ATTACHMENT_TITLE_ 39 ATTACHMENT_TYPE_ 31 BATCH_DESCRIPTION 30 BATCH_NAME 3 CATEGORY 9 CONCATENATED_SEGMENTS 26 CREDIT 4 CURRENCY -5.0006 CURRENCY_CODE 25 DEBIT -7.001 GL_ACCOUNT -7.0009 GL_ACCOUNT_ALIAS 10 GL_SEGMENT1 19 GL_SEGMENT10 20 GL_SEGMENT11 21 GL_SEGMENT12 22 GL_SEGMENT13 23 GL_SEGMENT14 24 GL_SEGMENT15 11 GL_SEGMENT2 12 GL_SEGMENT3 13 GL_SEGMENT4 14 GL_SEGMENT5 15 GL_SEGMENT6 16 GL_SEGMENT7 17 GL_SEGMENT8 18 GL_SEGMENT9 33 JOURNAL_DESCRIPTION -12.0013 JOURNAL_LINE_DESCRIPTION 32 JOURNAL_NAME 34 JOURNAL_REFERENCE -.0001 LEDGER 1 LEDGER_NAME 35 LINE_DESCRIPTION 6 PERIOD -7.0008 PERIOD_NAME 29 REVERSAL_PERIOD 28 REVERSE_JOURNAL 2 SOURCE 27 STAT_AMOUNT -1.0003 USER_JE_CATEGORY_NAME -1.0002 USER_JE_SOURCE_NAME S Site Allow Foreign Currency ENGINATICS 22ABB80775071D641F3C86DF6028075B ASHISH.SAKLANI 4071B8B50CA3F48378A45B42C396C1C0 ERIC.CLEGG 6DECDD5D0679C80FFD06DBF8EE2CDF06 MRUGESH.POOJARY 22ABB80775071D641F3C86DF6028075B 7433D633C001FDE15E6F19BFEC8EDD16 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 REQUEST_ID_ Char varchar2 Y Y 5 MODIFIED_COLUMNS_ Char varchar2 Y 6 ROW_ID Rowid rowid Y Y 7 GROUP_ID Number number Y Y 8 LEDGER_NAME LOV custom varchar2 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 select gl.ledger_id id, gl.name value from gl_ledgers gl Y Y 9 ORGANIZATION LOV custom varchar2 Y select gbecv.budget_entity_id id, gbecv.name value, gbecv.description description from gl_ledgers gl, gl_budget_entities_current_v gbecv where gl.name = :$column$.ledger_name and gbecv.ledger_id = gl.ledger_id and gbecv.use_privilege = 'Y' order by value 10 BUDGET LOV custom varchar2 Y select gbv.budget_version_id id, gbv.budget_name value, gbv.description from gl_budgets_v gbv where gbv.ledger_name = :$column$.ledger_name and gbv.status in ('C','O') and gbv.latest_opened_year is not null and ( :$column$.organization is null or exists (select null from gl_budget_entities_current_v gbecv, gl_entity_budgets geb where gbecv.name = :$column$.organization and gbecv.budget_entity_id = geb.budget_entity_id and geb.budget_version_id = gbv.budget_version_id ) ) order by value select gbv.budget_version_id id, gbv.budget_name value from gl_budgets_v gbv 11 SOURCE LOV custom varchar2 Y select gjsv.user_je_source_name value, gjsv.description from gl_je_sources_v gjsv Y Y 12 CATEGORY LOV custom varchar2 Y select gjcv.user_je_category_name value, gjcv.description from gl_je_categories_v gjcv Y 13 CHECK_IF_JOURNAL_BALANCED Char varchar2 :$flex$.check_if_journal_balanced Y 14 BATCH_NAME Char varchar2 15 APPROVAL_STATUS Char varchar2 16 BATCH_DESCRIPTION Char varchar2 17 JOURNAL_NAME Char varchar2 18 JOURNAL_DESCRIPTION Char varchar2 19 JOURNAL_REFERENCE Char varchar2 20 CURRENCY LOV custom varchar2 Y select fcv.currency_code id, fcv.currency_code value, fcv.description from fnd_currencies_vl fcv where fcv.enabled_flag='Y' and ( ( (:$flex$.allow_foreign_currency = xxen_util.meaning('Y','YES_NO',0) or fcv.currency_code = 'STAT') and xxen_util.lookup_code(:$flex$.journal_type,'XLA_BALANCE_TYPE',602) != 'E' ) or fcv.currency_code = (select gl.currency_code from gl_ledgers gl where gl.name = :$column$.ledger_name) ) order by fcv.currency_code Y 21 ACCOUNTING_DATE Date date Y 22 PERIOD LOV custom varchar2 Y select gps.period_name id, gps.period_name value, xxen_util.meaning(gps.closing_status,'CLOSING_STATUS',101)||': '||fnd_date.date_to_displaydate(gps.start_date)||' - '||fnd_date.date_to_displaydate(gps.end_date) description from gl_ledgers gl, gl_period_statuses gps where gl.name = :$column$.ledger_name and gps.ledger_id = gl.ledger_id and gps.application_id = 101 and gps.closing_status='O' and :$column$.accounting_date between gps.start_date and gps.end_date order by gps.start_date desc select gps.period_name from gl_ledgers gl, gl_period_statuses gps where gl.name = :$column$.ledger_name and gps.ledger_id = gl.ledger_id and gps.application_id = 101 and gps.closing_status='O' and :$column$.accounting_date between gps.start_date and gps.end_date Y 23 ACCOUNT_ALIAS LOV custom varchar2 Y select fsfa.alias_name id, fsfa.alias_name value, fsfa.concatenated_segments || ' (' || flvv.description || ')' description from gl_ledgers gl, fnd_shorthand_flex_aliases fsfa, gl_code_combinations_kfv gcck, fnd_lookup_values_vl flvv where gl.name=:$column$.ledger_name and fsfa.application_id = 101 and fsfa.id_flex_code = 'GL#' and fsfa.id_flex_num = gl.chart_of_accounts_id and fsfa.enabled_flag = 'Y' and trunc(sysdate) between nvl(fsfa.start_date_active,trunc(sysdate)) and nvl(fsfa.end_date_active,trunc(sysdate)) and gcck.chart_of_accounts_id = gl.chart_of_accounts_id and gcck.concatenated_segments = fsfa.concatenated_segments and gcck.enabled_flag = 'Y' and gcck.summary_flag = 'N' and trunc(sysdate) between nvl(gcck.start_date_active,trunc(sysdate)) and nvl(gcck.end_date_active,trunc(sysdate)) and decode(xxen_util.lookup_code(:$flex$.journal_type,'XLA_BALANCE_TYPE',602),'B',gcck.detail_budgeting_allowed,gcck.detail_posting_allowed) = 'Y' and flvv.lookup_type = 'ACCOUNT TYPE' and flvv.view_application_id = 101 and flvv.lookup_code = gcck.gl_account_type order by value 24 CONCATENATED_SEGMENTS LOV custom varchar2 Y Y select gcck.code_combination_id id, gcck.concatenated_segments value, xxen_util.segments_description(gcck.code_combination_id) || ' (' || flvv.description || ')' description from gl_code_combinations_kfv gcck, gl_ledgers gl, fnd_lookup_values_vl flvv where gcck.chart_of_accounts_id=gl.chart_of_accounts_id and gl.name=:$column$.ledger_name and gcck.enabled_flag = 'Y' and gcck.summary_flag = 'N' and trunc(sysdate) between nvl(gcck.start_date_active,trunc(sysdate)) and nvl(gcck.end_date_active,trunc(sysdate)) and decode(xxen_util.lookup_code(:$flex$.journal_type,'XLA_BALANCE_TYPE',602),'B',gcck.detail_budgeting_allowed,gcck.detail_posting_allowed) = 'Y' and flvv.lookup_type = 'ACCOUNT TYPE' and flvv.view_application_id = 101 and flvv.lookup_code = gcck.gl_account_type and (:$column$.account_alias is null or gcck.concatenated_segments = (select fsfa.concatenated_segments from fnd_shorthand_flex_aliases fsfa where fsfa.application_id = 101 and fsfa.id_flex_code = 'GL#' and fsfa.id_flex_num = gl.chart_of_accounts_id and fsfa.enabled_flag = 'Y' and trunc(sysdate) between nvl(fsfa.start_date_active,trunc(sysdate)) and nvl(fsfa.end_date_active,trunc(sysdate)) and fsfa.alias_name = :$column$.account_alias ) ) order by value select gcck.concatenated_segments value from gl_code_combinations_kfv gcck, gl_ledgers gl, fnd_lookup_values_vl flvv where gcck.chart_of_accounts_id=gl.chart_of_accounts_id and gl.name=:$column$.ledger_name and gcck.enabled_flag = 'Y' and gcck.summary_flag = 'N' and trunc(sysdate) between nvl(gcck.start_date_active,trunc(sysdate)) and nvl(gcck.end_date_active,trunc(sysdate)) and decode(xxen_util.lookup_code(:$flex$.journal_type,'XLA_BALANCE_TYPE',602),'B',gcck.detail_budgeting_allowed,gcck.detail_posting_allowed) = 'Y' and flvv.lookup_type = 'ACCOUNT TYPE' and flvv.view_application_id = 101 and flvv.lookup_code = gcck.gl_account_type and gcck.concatenated_segments = (select fsfa.concatenated_segments from fnd_shorthand_flex_aliases fsfa where fsfa.application_id = 101 and fsfa.id_flex_code = 'GL#' and fsfa.id_flex_num = gl.chart_of_accounts_id and fsfa.enabled_flag = 'Y' and trunc(sysdate) between nvl(fsfa.start_date_active,trunc(sysdate)) and nvl(fsfa.end_date_active,trunc(sysdate)) and fsfa.alias_name = :$column$.account_alias ) 25 GL_SEGMENT1 LOV custom varchar2 Y select distinct ffvv.flex_value id, ffvv.flex_value value, ffvv.description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and fifsgv.application_column_name='SEGMENT1' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) and fifsgv.id_flex_num in ( select /*+ no_unnest*/ gl.chart_of_accounts_id from gl_ledgers gl where gl.name=:$column$.ledger_name) and ( :$column$.concatenated_segments is null or ffvv.flex_value = (select gcck.segment1 from gl_code_combinations_kfv gcck where gcck.concatenated_segments=:$column$.concatenated_segments and gcck.chart_of_accounts_id=fifsgv.id_flex_num ) ) order by ffvv.flex_value select distinct ffvv.flex_value value from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.application_column_name='SEGMENT1' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and fifsgv.id_flex_num in ( select /*+ no_unnest*/ gl.chart_of_accounts_id from gl_ledgers gl where gl.name=:$column$.ledger_name) and ( :$column$.concatenated_segments is null or ffvv.flex_value = (select gcck.segment1 from gl_code_combinations_kfv gcck where gcck.concatenated_segments=:$column$.concatenated_segments and gcck.chart_of_accounts_id=fifsgv.id_flex_num ) ) 26 GL_SEGMENT2 LOV custom varchar2 Y select distinct ffvv.flex_value id, ffvv.flex_value value, ffvv.description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and fifsgv.application_column_name='SEGMENT2' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) and fifsgv.id_flex_num in ( select /*+ no_unnest*/ gl.chart_of_accounts_id from gl_ledgers gl where gl.name=:$column$.ledger_name) and ( :$column$.concatenated_segments is null or ffvv.flex_value = (select gcck.segment2 from gl_code_combinations_kfv gcck where gcck.concatenated_segments=:$column$.concatenated_segments and gcck.chart_of_accounts_id=fifsgv.id_flex_num ) ) order by ffvv.flex_value select distinct ffvv.flex_value value from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.application_column_name='SEGMENT2' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and fifsgv.id_flex_num in ( select /*+ no_unnest*/ gl.chart_of_accounts_id from gl_ledgers gl where gl.name=:$column$.ledger_name) and ( :$column$.concatenated_segments is null or ffvv.flex_value = (select gcck.segment2 from gl_code_combinations_kfv gcck where gcck.concatenated_segments=:$column$.concatenated_segments and gcck.chart_of_accounts_id=fifsgv.id_flex_num ) ) 27 GL_SEGMENT3 LOV custom varchar2 Y select distinct ffvv.flex_value id, ffvv.flex_value value, ffvv.description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and fifsgv.application_column_name='SEGMENT3' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) and fifsgv.id_flex_num in ( select /*+ no_unnest*/ gl.chart_of_accounts_id from gl_ledgers gl where gl.name=:$column$.ledger_name) and ( :$column$.concatenated_segments is null or ffvv.flex_value = (select gcck.segment3 from gl_code_combinations_kfv gcck where gcck.concatenated_segments=:$column$.concatenated_segments and gcck.chart_of_accounts_id=fifsgv.id_flex_num ) ) order by ffvv.flex_value select distinct ffvv.flex_value value from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.application_column_name='SEGMENT3' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and fifsgv.id_flex_num in ( select /*+ no_unnest*/ gl.chart_of_accounts_id from gl_ledgers gl where gl.name=:$column$.ledger_name) and ( :$column$.concatenated_segments is null or ffvv.flex_value = (select gcck.segment3 from gl_code_combinations_kfv gcck where gcck.concatenated_segments=:$column$.concatenated_segments and gcck.chart_of_accounts_id=fifsgv.id_flex_num ) ) 28 GL_SEGMENT4 LOV custom varchar2 Y select distinct ffvv.flex_value id, ffvv.flex_value value, ffvv.description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and fifsgv.application_column_name='SEGMENT4' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) and fifsgv.id_flex_num in ( select /*+ no_unnest*/ gl.chart_of_accounts_id from gl_ledgers gl where gl.name=:$column$.ledger_name) and ( :$column$.concatenated_segments is null or ffvv.flex_value = (select gcck.segment4 from gl_code_combinations_kfv gcck where gcck.concatenated_segments=:$column$.concatenated_segments and gcck.chart_of_accounts_id=fifsgv.id_flex_num ) ) order by ffvv.flex_value select distinct ffvv.flex_value value from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.application_column_name='SEGMENT4' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and fifsgv.id_flex_num in ( select /*+ no_unnest*/ gl.chart_of_accounts_id from gl_ledgers gl where gl.name=:$column$.ledger_name) and ( :$column$.concatenated_segments is null or ffvv.flex_value = (select gcck.segment4 from gl_code_combinations_kfv gcck where gcck.concatenated_segments=:$column$.concatenated_segments and gcck.chart_of_accounts_id=fifsgv.id_flex_num ) ) 29 GL_SEGMENT5 LOV custom varchar2 Y select distinct ffvv.flex_value id, ffvv.flex_value value, ffvv.description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and fifsgv.application_column_name='SEGMENT5' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) and fifsgv.id_flex_num in ( select /*+ no_unnest*/ gl.chart_of_accounts_id from gl_ledgers gl where gl.name=:$column$.ledger_name) and ( :$column$.concatenated_segments is null or ffvv.flex_value = (select gcck.segment5 from gl_code_combinations_kfv gcck where gcck.concatenated_segments=:$column$.concatenated_segments and gcck.chart_of_accounts_id=fifsgv.id_flex_num ) ) order by ffvv.flex_value select distinct ffvv.flex_value value from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.application_column_name='SEGMENT5' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and fifsgv.id_flex_num in ( select /*+ no_unnest*/ gl.chart_of_accounts_id from gl_ledgers gl where gl.name=:$column$.ledger_name) and ( :$column$.concatenated_segments is null or ffvv.flex_value = (select gcck.segment5 from gl_code_combinations_kfv gcck where gcck.concatenated_segments=:$column$.concatenated_segments and gcck.chart_of_accounts_id=fifsgv.id_flex_num ) ) 30 GL_SEGMENT6 LOV custom varchar2 Y select distinct ffvv.flex_value id, ffvv.flex_value value, ffvv.description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and fifsgv.application_column_name='SEGMENT6' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) and fifsgv.id_flex_num in ( select /*+ no_unnest*/ gl.chart_of_accounts_id from gl_ledgers gl where gl.name=:$column$.ledger_name) and ( :$column$.concatenated_segments is null or ffvv.flex_value = (select gcck.segment6 from gl_code_combinations_kfv gcck where gcck.concatenated_segments=:$column$.concatenated_segments and gcck.chart_of_accounts_id=fifsgv.id_flex_num ) ) order by ffvv.flex_value select distinct ffvv.flex_value value from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.application_column_name='SEGMENT6' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and fifsgv.id_flex_num in ( select /*+ no_unnest*/ gl.chart_of_accounts_id from gl_ledgers gl where gl.name=:$column$.ledger_name) and ( :$column$.concatenated_segments is null or ffvv.flex_value = (select gcck.segment6 from gl_code_combinations_kfv gcck where gcck.concatenated_segments=:$column$.concatenated_segments and gcck.chart_of_accounts_id=fifsgv.id_flex_num ) ) 31 GL_SEGMENT7 LOV custom varchar2 Y select distinct ffvv.flex_value id, ffvv.flex_value value, ffvv.description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and fifsgv.application_column_name='SEGMENT7' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) and fifsgv.id_flex_num in ( select /*+ no_unnest*/ gl.chart_of_accounts_id from gl_ledgers gl where gl.name=:$column$.ledger_name) and ( :$column$.concatenated_segments is null or ffvv.flex_value = (select gcck.segment7 from gl_code_combinations_kfv gcck where gcck.concatenated_segments=:$column$.concatenated_segments and gcck.chart_of_accounts_id=fifsgv.id_flex_num ) ) order by ffvv.flex_value select distinct ffvv.flex_value value from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.application_column_name='SEGMENT7' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and fifsgv.id_flex_num in ( select /*+ no_unnest*/ gl.chart_of_accounts_id from gl_ledgers gl where gl.name=:$column$.ledger_name) and ( :$column$.concatenated_segments is null or ffvv.flex_value = (select gcck.segment7 from gl_code_combinations_kfv gcck where gcck.concatenated_segments=:$column$.concatenated_segments and gcck.chart_of_accounts_id=fifsgv.id_flex_num ) ) 32 GL_SEGMENT8 LOV custom varchar2 Y select distinct ffvv.flex_value id, ffvv.flex_value value, ffvv.description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and fifsgv.application_column_name='SEGMENT8' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) and fifsgv.id_flex_num in ( select /*+ no_unnest*/ gl.chart_of_accounts_id from gl_ledgers gl where gl.name=:$column$.ledger_name) and ( :$column$.concatenated_segments is null or ffvv.flex_value = (select gcck.segment8 from gl_code_combinations_kfv gcck where gcck.concatenated_segments=:$column$.concatenated_segments and gcck.chart_of_accounts_id=fifsgv.id_flex_num ) ) order by ffvv.flex_value select distinct ffvv.flex_value value from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.application_column_name='SEGMENT8' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and fifsgv.id_flex_num in ( select /*+ no_unnest*/ gl.chart_of_accounts_id from gl_ledgers gl where gl.name=:$column$.ledger_name) and ( :$column$.concatenated_segments is null or ffvv.flex_value = (select gcck.segment8 from gl_code_combinations_kfv gcck where gcck.concatenated_segments=:$column$.concatenated_segments and gcck.chart_of_accounts_id=fifsgv.id_flex_num ) ) 33 GL_SEGMENT9 LOV custom varchar2 Y select distinct ffvv.flex_value id, ffvv.flex_value value, ffvv.description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and fifsgv.application_column_name='SEGMENT9' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) and fifsgv.id_flex_num in ( select /*+ no_unnest*/ gl.chart_of_accounts_id from gl_ledgers gl where gl.name=:$column$.ledger_name) and ( :$column$.concatenated_segments is null or ffvv.flex_value = (select gcck.segment9 from gl_code_combinations_kfv gcck where gcck.concatenated_segments=:$column$.concatenated_segments and gcck.chart_of_accounts_id=fifsgv.id_flex_num ) ) order by ffvv.flex_value select distinct ffvv.flex_value value from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.application_column_name='SEGMENT9' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and fifsgv.id_flex_num in ( select /*+ no_unnest*/ gl.chart_of_accounts_id from gl_ledgers gl where gl.name=:$column$.ledger_name) and ( :$column$.concatenated_segments is null or ffvv.flex_value = (select gcck.segment9 from gl_code_combinations_kfv gcck where gcck.concatenated_segments=:$column$.concatenated_segments and gcck.chart_of_accounts_id=fifsgv.id_flex_num ) ) 34 GL_SEGMENT10 LOV custom varchar2 Y select distinct ffvv.flex_value id, ffvv.flex_value value, ffvv.description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and fifsgv.application_column_name='SEGMENT10' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) and fifsgv.id_flex_num in ( select /*+ no_unnest*/ gl.chart_of_accounts_id from gl_ledgers gl where gl.name=:$column$.ledger_name) and ( :$column$.concatenated_segments is null or ffvv.flex_value = (select gcck.segment10 from gl_code_combinations_kfv gcck where gcck.concatenated_segments=:$column$.concatenated_segments and gcck.chart_of_accounts_id=fifsgv.id_flex_num ) ) order by ffvv.flex_value select distinct ffvv.flex_value value from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.application_column_name='SEGMENT10' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and fifsgv.id_flex_num in ( select /*+ no_unnest*/ gl.chart_of_accounts_id from gl_ledgers gl where gl.name=:$column$.ledger_name) and ( :$column$.concatenated_segments is null or ffvv.flex_value = (select gcck.segment10 from gl_code_combinations_kfv gcck where gcck.concatenated_segments=:$column$.concatenated_segments and gcck.chart_of_accounts_id=fifsgv.id_flex_num ) ) 35 GL_SEGMENT11 LOV custom varchar2 Y select distinct ffvv.flex_value id, ffvv.flex_value value, ffvv.description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and fifsgv.application_column_name='SEGMENT11' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) and fifsgv.id_flex_num in ( select /*+ no_unnest*/ gl.chart_of_accounts_id from gl_ledgers gl where gl.name=:$column$.ledger_name) and ( :$column$.concatenated_segments is null or ffvv.flex_value = (select gcck.segment11 from gl_code_combinations_kfv gcck where gcck.concatenated_segments=:$column$.concatenated_segments and gcck.chart_of_accounts_id=fifsgv.id_flex_num ) ) order by ffvv.flex_value select distinct ffvv.flex_value value from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.application_column_name='SEGMENT11' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and fifsgv.id_flex_num in ( select /*+ no_unnest*/ gl.chart_of_accounts_id from gl_ledgers gl where gl.name=:$column$.ledger_name) and ( :$column$.concatenated_segments is null or ffvv.flex_value = (select gcck.segment11 from gl_code_combinations_kfv gcck where gcck.concatenated_segments=:$column$.concatenated_segments and gcck.chart_of_accounts_id=fifsgv.id_flex_num ) ) 36 GL_SEGMENT12 LOV custom varchar2 Y select distinct ffvv.flex_value id, ffvv.flex_value value, ffvv.description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and fifsgv.application_column_name='SEGMENT12' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) and fifsgv.id_flex_num in ( select /*+ no_unnest*/ gl.chart_of_accounts_id from gl_ledgers gl where gl.name=:$column$.ledger_name) and ( :$column$.concatenated_segments is null or ffvv.flex_value = (select gcck.segment12 from gl_code_combinations_kfv gcck where gcck.concatenated_segments=:$column$.concatenated_segments and gcck.chart_of_accounts_id=fifsgv.id_flex_num ) ) order by ffvv.flex_value select distinct ffvv.flex_value value from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.application_column_name='SEGMENT12' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and fifsgv.id_flex_num in ( select /*+ no_unnest*/ gl.chart_of_accounts_id from gl_ledgers gl where gl.name=:$column$.ledger_name) and ( :$column$.concatenated_segments is null or ffvv.flex_value = (select gcck.segment12 from gl_code_combinations_kfv gcck where gcck.concatenated_segments=:$column$.concatenated_segments and gcck.chart_of_accounts_id=fifsgv.id_flex_num ) ) 37 GL_SEGMENT13 LOV custom varchar2 Y select distinct ffvv.flex_value id, ffvv.flex_value value, ffvv.description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and fifsgv.application_column_name='SEGMENT13' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) and fifsgv.id_flex_num in ( select /*+ no_unnest*/ gl.chart_of_accounts_id from gl_ledgers gl where gl.name=:$column$.ledger_name) and ( :$column$.concatenated_segments is null or ffvv.flex_value = (select gcck.segment13 from gl_code_combinations_kfv gcck where gcck.concatenated_segments=:$column$.concatenated_segments and gcck.chart_of_accounts_id=fifsgv.id_flex_num ) ) order by ffvv.flex_value select distinct ffvv.flex_value value from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.application_column_name='SEGMENT13' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and fifsgv.id_flex_num in ( select /*+ no_unnest*/ gl.chart_of_accounts_id from gl_ledgers gl where gl.name=:$column$.ledger_name) and ( :$column$.concatenated_segments is null or ffvv.flex_value = (select gcck.segment13 from gl_code_combinations_kfv gcck where gcck.concatenated_segments=:$column$.concatenated_segments and gcck.chart_of_accounts_id=fifsgv.id_flex_num ) ) 38 GL_SEGMENT14 LOV custom varchar2 Y select distinct ffvv.flex_value id, ffvv.flex_value value, ffvv.description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and fifsgv.application_column_name='SEGMENT14' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) and fifsgv.id_flex_num in ( select /*+ no_unnest*/ gl.chart_of_accounts_id from gl_ledgers gl where gl.name=:$column$.ledger_name) and ( :$column$.concatenated_segments is null or ffvv.flex_value = (select gcck.segment14 from gl_code_combinations_kfv gcck where gcck.concatenated_segments=:$column$.concatenated_segments and gcck.chart_of_accounts_id=fifsgv.id_flex_num ) ) order by ffvv.flex_value select distinct ffvv.flex_value value from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.application_column_name='SEGMENT14' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and fifsgv.id_flex_num in ( select /*+ no_unnest*/ gl.chart_of_accounts_id from gl_ledgers gl where gl.name=:$column$.ledger_name) and ( :$column$.concatenated_segments is null or ffvv.flex_value = (select gcck.segment14 from gl_code_combinations_kfv gcck where gcck.concatenated_segments=:$column$.concatenated_segments and gcck.chart_of_accounts_id=fifsgv.id_flex_num ) ) 39 GL_SEGMENT15 LOV custom varchar2 Y select distinct ffvv.flex_value id, ffvv.flex_value value, ffvv.description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and fifsgv.application_column_name='SEGMENT15' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) and fifsgv.id_flex_num in ( select /*+ no_unnest*/ gl.chart_of_accounts_id from gl_ledgers gl where gl.name=:$column$.ledger_name) and ( :$column$.concatenated_segments is null or ffvv.flex_value = (select gcck.segment15 from gl_code_combinations_kfv gcck where gcck.concatenated_segments=:$column$.concatenated_segments and gcck.chart_of_accounts_id=fifsgv.id_flex_num ) ) order by ffvv.flex_value select distinct ffvv.flex_value value from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.application_column_name='SEGMENT15' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and fifsgv.id_flex_num in ( select /*+ no_unnest*/ gl.chart_of_accounts_id from gl_ledgers gl where gl.name=:$column$.ledger_name) and ( :$column$.concatenated_segments is null or ffvv.flex_value = (select gcck.segment15 from gl_code_combinations_kfv gcck where gcck.concatenated_segments=:$column$.concatenated_segments and gcck.chart_of_accounts_id=fifsgv.id_flex_num ) ) 40 DEBIT Number number 41 CREDIT Number number 42 STAT_AMOUNT Number number 43 REVERSE_JOURNAL LOV Oracle varchar2 Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description 44 REVERSAL_PERIOD LOV custom varchar2 Y select gps.period_name value, xxen_util.meaning(gps.closing_status,'CLOSING_STATUS',101)||': '||fnd_date.date_to_displaydate(gps.start_date)||' - '||fnd_date.date_to_displaydate(gps.end_date) description from gl_ledgers gl, gl_period_statuses gps where gl.name = :$column$.ledger_name and gps.ledger_id = gl.ledger_id and gps.application_id = 101 and :$column$.accounting_date < gps.start_date and :$column$.reverse_journal = xxen_util.meaning('Y','YES_NO',0) order by gps.start_date desc 45 CONVERSION_TYPE LOV custom varchar2 Y select gdct.user_conversion_type value, gdct.description from gl_daily_conversion_types gdct order by 1 46 CONVERSION_DATE Date date 47 CONVERSION_RATE LOV custom number select gdr.conversion_rate id, gdr.conversion_rate value, gdct.user_conversion_type || ' - ' || to_char(gdr.conversion_date,'DD-Mon-YYYY') description from gl_ledgers gl, gl_daily_conversion_types gdct, gl_daily_rates gdr where gl.name = :$column$.ledger_name and gdct.user_conversion_type = :$column$.conversion_type and gdr.conversion_type = gdct.conversion_type and gdr.from_currency = :$column$.currency and gdr.to_currency = gl.currency_code and gdr.conversion_date = :$column$.conversion_date 48 LINE_DESCRIPTION Char varchar2 49 ACTUAL_FLAG LOV custom varchar2 Y select 'A' value,'Actuals' description from dual union all select 'B' value,'Budget' description from dual union all select 'E' value,'Encumbrance' description from dual xxen_util.lookup_code(:$flex$.journal_type,'XLA_BALANCE_TYPE',602) Y 50 ENCUMBRANCE_TYPE LOV custom varchar2 Y select gctv.encumbrance_type_id id, gctv.encumbrance_type value, gctv.description from gl_encumbrance_types_v gctv order by value select gct.encumbrance_type_id id, gct.encumbrance_type value from gl_encumbrance_types gct 51 ATTACH_UPLOAD_FILE Char varchar2 :$flex$.attach_upload_file_to_journal Y 52 STATUS Char varchar2 NEW Y 53 DATE_CREATED DateTime date sysdate Y 54 CREATED_BY Number number fnd_global.user_id Y 55 USER_ID Number number fnd_global.user_id Y 56 SUMMARY_FLAG Char varchar2 :$flex$.create_summary_journal Y 57 POST_TO_SUSPENSE_FLAG Char varchar2 :$flex$.post_errors_to_suspense Y 58 SUBMIT_APPROVAL Char varchar2 :$flex$.Submit_for_Approval Y 59 SUBMIT_POSTING Char varchar2 :$flex$.Submit_Journal_Post Y 60 LINE_DFF_CONTEXT LOV custom varchar2 Y select distinct fdfcv.descriptive_flex_context_name value, fdfcv.description from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts_vl fdfcv where fdfcv.application_id = fdfv.application_id and fdfcv.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfcv.enabled_flag = 'Y' and fdfv.application_id = 101 and fdfv.descriptive_flexfield_name = 'GL_JE_LINES' and fdfcv.descriptive_flex_context_code != 'Global Data Elements' order by fdfcv.descriptive_flex_context_name 61 GL_JE_LINE_ATTRIBUTE1 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 101, p_descriptive_flexfield_name => 'GL_JE_LINES', p_context_name => :$column$.line_dff_context, p_column_name => 'ATTRIBUTE1', p_attribute1 => :$column$.gl_je_line_attribute1, p_attribute2 => :$column$.gl_je_line_attribute2, p_attribute3 => :$column$.gl_je_line_attribute3, p_attribute4 => :$column$.gl_je_line_attribute4, p_attribute5 => :$column$.gl_je_line_attribute5, p_attribute6 => :$column$.gl_je_line_attribute6, p_attribute7 => :$column$.gl_je_line_attribute7, p_attribute8 => :$column$.gl_je_line_attribute8, p_attribute9 => :$column$.gl_je_line_attribute9, p_attribute10 => :$column$.gl_je_line_attribute10 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 101 and fdfv.descriptive_flexfield_name = 'GL_JE_LINES' and fdfcuv.application_column_name = 'ATTRIBUTE1' 62 GL_JE_LINE_ATTRIBUTE2 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 101, p_descriptive_flexfield_name => 'GL_JE_LINES', p_context_name => :$column$.line_dff_context, p_column_name => 'ATTRIBUTE2', p_attribute1 => :$column$.gl_je_line_attribute1, p_attribute2 => :$column$.gl_je_line_attribute2, p_attribute3 => :$column$.gl_je_line_attribute3, p_attribute4 => :$column$.gl_je_line_attribute4, p_attribute5 => :$column$.gl_je_line_attribute5, p_attribute6 => :$column$.gl_je_line_attribute6, p_attribute7 => :$column$.gl_je_line_attribute7, p_attribute8 => :$column$.gl_je_line_attribute8, p_attribute9 => :$column$.gl_je_line_attribute9, p_attribute10 => :$column$.gl_je_line_attribute10 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 101 and fdfv.descriptive_flexfield_name = 'GL_JE_LINES' and fdfcuv.application_column_name = 'ATTRIBUTE2' 63 GL_JE_LINE_ATTRIBUTE3 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 101, p_descriptive_flexfield_name => 'GL_JE_LINES', p_context_name => :$column$.line_dff_context, p_column_name => 'ATTRIBUTE3', p_attribute1 => :$column$.gl_je_line_attribute1, p_attribute2 => :$column$.gl_je_line_attribute2, p_attribute3 => :$column$.gl_je_line_attribute3, p_attribute4 => :$column$.gl_je_line_attribute4, p_attribute5 => :$column$.gl_je_line_attribute5, p_attribute6 => :$column$.gl_je_line_attribute6, p_attribute7 => :$column$.gl_je_line_attribute7, p_attribute8 => :$column$.gl_je_line_attribute8, p_attribute9 => :$column$.gl_je_line_attribute9, p_attribute10 => :$column$.gl_je_line_attribute10 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 101 and fdfv.descriptive_flexfield_name = 'GL_JE_LINES' and fdfcuv.application_column_name = 'ATTRIBUTE3' 64 GL_JE_LINE_ATTRIBUTE4 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 101, p_descriptive_flexfield_name => 'GL_JE_LINES', p_context_name => :$column$.line_dff_context, p_column_name => 'ATTRIBUTE4', p_attribute1 => :$column$.gl_je_line_attribute1, p_attribute2 => :$column$.gl_je_line_attribute2, p_attribute3 => :$column$.gl_je_line_attribute3, p_attribute4 => :$column$.gl_je_line_attribute4, p_attribute5 => :$column$.gl_je_line_attribute5, p_attribute6 => :$column$.gl_je_line_attribute6, p_attribute7 => :$column$.gl_je_line_attribute7, p_attribute8 => :$column$.gl_je_line_attribute8, p_attribute9 => :$column$.gl_je_line_attribute9, p_attribute10 => :$column$.gl_je_line_attribute10 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 101 and fdfv.descriptive_flexfield_name = 'GL_JE_LINES' and fdfcuv.application_column_name = 'ATTRIBUTE4' 65 GL_JE_LINE_ATTRIBUTE5 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 101, p_descriptive_flexfield_name => 'GL_JE_LINES', p_context_name => :$column$.line_dff_context, p_column_name => 'ATTRIBUTE5', p_attribute1 => :$column$.gl_je_line_attribute1, p_attribute2 => :$column$.gl_je_line_attribute2, p_attribute3 => :$column$.gl_je_line_attribute3, p_attribute4 => :$column$.gl_je_line_attribute4, p_attribute5 => :$column$.gl_je_line_attribute5, p_attribute6 => :$column$.gl_je_line_attribute6, p_attribute7 => :$column$.gl_je_line_attribute7, p_attribute8 => :$column$.gl_je_line_attribute8, p_attribute9 => :$column$.gl_je_line_attribute9, p_attribute10 => :$column$.gl_je_line_attribute10 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 101 and fdfv.descriptive_flexfield_name = 'GL_JE_LINES' and fdfcuv.application_column_name = 'ATTRIBUTE5' 66 GL_JE_LINE_ATTRIBUTE6 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 101, p_descriptive_flexfield_name => 'GL_JE_LINES', p_context_name => :$column$.line_dff_context, p_column_name => 'ATTRIBUTE6', p_attribute1 => :$column$.gl_je_line_attribute1, p_attribute2 => :$column$.gl_je_line_attribute2, p_attribute3 => :$column$.gl_je_line_attribute3, p_attribute4 => :$column$.gl_je_line_attribute4, p_attribute5 => :$column$.gl_je_line_attribute5, p_attribute6 => :$column$.gl_je_line_attribute6, p_attribute7 => :$column$.gl_je_line_attribute7, p_attribute8 => :$column$.gl_je_line_attribute8, p_attribute9 => :$column$.gl_je_line_attribute9, p_attribute10 => :$column$.gl_je_line_attribute10 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 101 and fdfv.descriptive_flexfield_name = 'GL_JE_LINES' and fdfcuv.application_column_name = 'ATTRIBUTE6' 67 GL_JE_LINE_ATTRIBUTE7 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 101, p_descriptive_flexfield_name => 'GL_JE_LINES', p_context_name => :$column$.line_dff_context, p_column_name => 'ATTRIBUTE7', p_attribute1 => :$column$.gl_je_line_attribute1, p_attribute2 => :$column$.gl_je_line_attribute2, p_attribute3 => :$column$.gl_je_line_attribute3, p_attribute4 => :$column$.gl_je_line_attribute4, p_attribute5 => :$column$.gl_je_line_attribute5, p_attribute6 => :$column$.gl_je_line_attribute6, p_attribute7 => :$column$.gl_je_line_attribute7, p_attribute8 => :$column$.gl_je_line_attribute8, p_attribute9 => :$column$.gl_je_line_attribute9, p_attribute10 => :$column$.gl_je_line_attribute10 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 101 and fdfv.descriptive_flexfield_name = 'GL_JE_LINES' and fdfcuv.application_column_name = 'ATTRIBUTE7' 68 GL_JE_LINE_ATTRIBUTE8 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 101, p_descriptive_flexfield_name => 'GL_JE_LINES', p_context_name => :$column$.line_dff_context, p_column_name => 'ATTRIBUTE8', p_attribute1 => :$column$.gl_je_line_attribute1, p_attribute2 => :$column$.gl_je_line_attribute2, p_attribute3 => :$column$.gl_je_line_attribute3, p_attribute4 => :$column$.gl_je_line_attribute4, p_attribute5 => :$column$.gl_je_line_attribute5, p_attribute6 => :$column$.gl_je_line_attribute6, p_attribute7 => :$column$.gl_je_line_attribute7, p_attribute8 => :$column$.gl_je_line_attribute8, p_attribute9 => :$column$.gl_je_line_attribute9, p_attribute10 => :$column$.gl_je_line_attribute10 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 101 and fdfv.descriptive_flexfield_name = 'GL_JE_LINES' and fdfcuv.application_column_name = 'ATTRIBUTE8' 69 GL_JE_LINE_ATTRIBUTE9 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 101, p_descriptive_flexfield_name => 'GL_JE_LINES', p_context_name => :$column$.line_dff_context, p_column_name => 'ATTRIBUTE9', p_attribute1 => :$column$.gl_je_line_attribute1, p_attribute2 => :$column$.gl_je_line_attribute2, p_attribute3 => :$column$.gl_je_line_attribute3, p_attribute4 => :$column$.gl_je_line_attribute4, p_attribute5 => :$column$.gl_je_line_attribute5, p_attribute6 => :$column$.gl_je_line_attribute6, p_attribute7 => :$column$.gl_je_line_attribute7, p_attribute8 => :$column$.gl_je_line_attribute8, p_attribute9 => :$column$.gl_je_line_attribute9, p_attribute10 => :$column$.gl_je_line_attribute10 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 101 and fdfv.descriptive_flexfield_name = 'GL_JE_LINES' and fdfcuv.application_column_name = 'ATTRIBUTE9' 70 GL_JE_LINE_ATTRIBUTE10 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 101, p_descriptive_flexfield_name => 'GL_JE_LINES', p_context_name => :$column$.line_dff_context, p_column_name => 'ATTRIBUTE10', p_attribute1 => :$column$.gl_je_line_attribute1, p_attribute2 => :$column$.gl_je_line_attribute2, p_attribute3 => :$column$.gl_je_line_attribute3, p_attribute4 => :$column$.gl_je_line_attribute4, p_attribute5 => :$column$.gl_je_line_attribute5, p_attribute6 => :$column$.gl_je_line_attribute6, p_attribute7 => :$column$.gl_je_line_attribute7, p_attribute8 => :$column$.gl_je_line_attribute8, p_attribute9 => :$column$.gl_je_line_attribute9, p_attribute10 => :$column$.gl_je_line_attribute10 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 101 and fdfv.descriptive_flexfield_name = 'GL_JE_LINES' and fdfcuv.application_column_name = 'ATTRIBUTE10' 71 ATTACHMENT_CATEGORY_ LOV custom varchar2 Y select fdcuv.user_name value, null description from fnd_doc_category_usages_vl fdcuv, fnd_attachment_functions af, fnd_document_categories fdc where fdcuv.attachment_function_id=af.attachment_function_id and af.function_name='GLXJEENT' and fdc.category_id=fdcuv.category_id and nvl(fdc.start_date_active,sysdate-1)<=sysdate and nvl(fdc.start_date_active,sysdate+1)>sysdate order by value 72 ATTACHMENT_TITLE_ Char varchar2 73 ATTACHMENT_DESCRIPTION_ Char varchar2 74 ATTACHMENT_TYPE_ LOV custom varchar2 Y select fddv.user_name value, null description from fnd_document_datatypes_vl fddv where fddv.name in ('SHORT_TEXT','FILE','WEB_PAGE') order by value 75 ATTACHMENT_CONTENT_ Char varchar2 76 ATTACHMENT_FILE_ID_ Char varchar2 77 UPLOAD_ROW Number number U 1 p_status in Char STATUS U 2 p_ledger_id in Number LEDGER_NAME U 3 p_accounting_date in Date ACCOUNTING_DATE U 4 p_currency_code in Char CURRENCY U 5 p_date_created in Date DATE_CREATED U 6 p_created_by in Number CREATED_BY U 7 p_check_if_balanced in Char Y CHECK_IF_JOURNAL_BALANCED U 8 p_actual_flag in Char ACTUAL_FLAG U 9 p_user_je_category_name in Char CATEGORY U 10 p_user_je_source_name in Char SOURCE U 11 p_currency_conversion_date in Date CONVERSION_DATE U 12 p_encumbrance_type_id in Number ENCUMBRANCE_TYPE U 13 p_budget_version_id in Number BUDGET U 14 p_user_currency_conv_type in Char CONVERSION_TYPE U 15 p_currency_conversion_rate in Number CONVERSION_RATE U 16 p_segment1 in Char GL_SEGMENT1 U 17 p_segment2 in Char GL_SEGMENT2 U 18 p_segment3 in Char GL_SEGMENT3 U 19 p_segment4 in Char GL_SEGMENT4 U 20 p_segment5 in Char GL_SEGMENT5 U 21 p_segment6 in Char GL_SEGMENT6 U 22 p_segment7 in Char GL_SEGMENT7 U 23 p_segment8 in Char GL_SEGMENT8 U 24 p_segment9 in Char GL_SEGMENT9 U 25 p_segment10 in Char GL_SEGMENT10 U 26 p_segment11 in Char GL_SEGMENT11 U 27 p_segment12 in Char GL_SEGMENT12 U 28 p_segment13 in Char GL_SEGMENT13 U 29 p_segment14 in Char GL_SEGMENT14 U 30 p_segment15 in Char GL_SEGMENT15 U 31 p_segment16 in Char U 32 p_segment17 in Char U 33 p_segment18 in Char U 34 p_segment19 in Char U 35 p_segment20 in Char U 36 p_segment21 in Char U 37 p_segment22 in Char U 38 p_segment23 in Char U 39 p_segment24 in Char U 40 p_segment25 in Char U 41 p_segment26 in Char U 42 p_segment27 in Char U 43 p_segment28 in Char U 44 p_segment29 in Char U 45 p_segment30 in Char U 46 p_entered_dr in Number DEBIT U 47 p_entered_cr in Number CREDIT U 48 p_accounted_dr in Number U 49 p_accounted_cr in Number U 50 p_transaction_date in Date U 51 p_reference1 in Char BATCH_NAME U 52 p_reference2 in Char BATCH_DESCRIPTION U 53 p_reference3 in Char U 54 p_reference4 in Char JOURNAL_NAME U 55 p_reference5 in Char JOURNAL_DESCRIPTION U 56 p_reference6 in Char JOURNAL_REFERENCE U 57 p_reference7 in Char REVERSE_JOURNAL U 58 p_reference8 in Char REVERSAL_PERIOD U 59 p_reference9 in Char U 60 p_reference10 in Char LINE_DESCRIPTION U 61 p_reference11 in Char U 62 p_reference12 in Char U 63 p_reference13 in Char U 64 p_reference14 in Char U 65 p_reference15 in Char U 66 p_reference16 in Char U 67 p_reference17 in Char U 68 p_reference18 in Char U 69 p_reference19 in Char U 70 p_reference20 in Char U 71 p_reference21 in Char U 72 p_reference22 in Char U 73 p_reference23 in Char U 74 p_reference24 in Char U 75 p_reference25 in Char U 76 p_reference26 in Char U 77 p_reference27 in Char U 78 p_reference28 in Char U 79 p_reference29 in Char U 80 p_reference30 in Char U 81 p_je_batch_id in Number U 82 p_period_name in Char PERIOD U 83 p_je_header_id in Number U 84 p_je_line_num in Number U 85 p_chart_of_accounts_id in Number U 86 p_functional_currency_code in Char U 87 p_code_combination_id in Number U 88 p_date_created_in_gl in Date U 89 p_warning_code in Char U 90 p_status_description in Char ROW_ID U 91 p_stat_amount in Number STAT_AMOUNT U 92 p_group_id in Number U 93 p_request_id in Number U 94 p_subledger_doc_sequence_id in Number U 95 p_subledger_doc_sequence_value in Number U 96 p_attribute1 in Char GL_JE_LINE_ATTRIBUTE1 U 97 p_attribute2 in Char GL_JE_LINE_ATTRIBUTE2 U 98 p_attribute3 in Char GL_JE_LINE_ATTRIBUTE3 U 99 p_attribute4 in Char GL_JE_LINE_ATTRIBUTE4 U 100 p_attribute5 in Char GL_JE_LINE_ATTRIBUTE5 U 101 p_attribute6 in Char GL_JE_LINE_ATTRIBUTE6 U 102 p_attribute7 in Char GL_JE_LINE_ATTRIBUTE7 U 103 p_attribute8 in Char GL_JE_LINE_ATTRIBUTE8 U 104 p_attribute9 in Char GL_JE_LINE_ATTRIBUTE9 U 105 p_attribute10 in Char GL_JE_LINE_ATTRIBUTE10 U 106 p_attribute11 in Char U 107 p_attribute12 in Char U 108 p_attribute13 in Char U 109 p_attribute14 in Char U 110 p_attribute15 in Char U 111 p_attribute16 in Char U 112 p_attribute17 in Char U 113 p_attribute18 in Char U 114 p_attribute19 in Char U 115 p_attribute20 in Char U 116 p_context in Char LINE_DFF_CONTEXT U 117 p_context2 in Char U 118 p_invoice_date in Date U 119 p_tax_code in Char U 120 p_invoice_identifier in Char U 121 p_invoice_amount in Number U 122 p_context3 in Char U 123 p_ussgl_transaction_code in Char U 124 p_descr_flex_error_message in Char U 125 p_jgzz_recon_ref in Char U 126 p_average_journal_flag in Char U 127 p_originating_bal_seg_value in Char U 128 p_gl_sl_link_id in Number U 129 p_gl_sl_link_table in Char U 130 p_reference_date in Date U 131 p_balancing_segment_value in Char U 132 p_management_segment_value in Char U 133 p_code_combination_id_interim in Number U 134 p_funds_reserved_flag in Char U 135 p_ledger_name in Char Y LEDGER_NAME value U 137 p_account_segments in Char Y CONCATENATED_SEGMENTS value U 141 p_row_id in/out Char ROW_ID U 142 request_id_ out Number REQUEST_ID_ U 143 status_ out Char STATUS_CODE_ U 144 message_ out Char MESSAGE_ P 1 p_je_source_name in Char SOURCE P 2 p_user_id in Number USER_ID P 3 p_ledger_id in Number LEDGER_NAME P 4 p_summary_flag in Char Y SUMMARY_FLAG P 5 p_post_to_suspense_flag in Char Y POST_TO_SUSPENSE_FLAG P 6 p_ledger_user_key1 in Char Y P 7 p_ledger_user_key2 in Char Y P 8 p_attach_upload_file in Char Y ATTACH_UPLOAD_FILE P 9 p_submit_approval in Char Y SUBMIT_APPROVAL P 10 p_submit_posting in Char Y SUBMIT_POSTING P 11 x_group_id out Number GROUP_ID P 12 request_id_ out Number REQUEST_ID_ P 13 status_ out Char STATUS_CODE_ P 14 message_ out Char MESSAGE_ Error SQL select xu.action_, xxen_upload.status_meaning(case when gi.status='PROCESSED' then xxen_upload.status_success else xxen_upload.status_error end) status_, nvl( ( select listagg(flv.meaning,',') within group (order by instr(','|| gi.status ||',',',' || flv.lookup_code || ',',1,1)) error_code from (select substr(fnm.message_text,1,4) lookup_code, ltrim(substr(fnm.message_text,7,2000)) meaning from fnd_new_messages fnm where fnm.application_id = 101 and fnm.language_code = userenv('lang') and fnm.message_name like 'R_LEZL%' and fnm.message_text like 'E___ %' ) flv where instr(','|| gi.status ||',',',' || flv.lookup_code || ',',1,1) > 0 ),xu.message_) message_, null request_id_, xu.modified_columns_, gi.rowid row_id, xu.group_id, xu.ledger_name, xu.organization, xu.budget, nvl(gi.user_je_source_name,xu.source) source, nvl(gi.user_je_category_name,xu.category) category, xu.check_if_journal_balanced, xu.batch_name, xu.approval_status, xu.batch_description, xu.journal_name, xu.journal_description, xu.journal_reference, nvl(gi.currency_code,xu.currency) currency, nvl(gi.accounting_date,xu.accounting_date) accounting_date, xu.period, xu.account_alias, xu.concatenated_segments, xu.gl_segment1, xu.gl_segment2, xu.gl_segment3, xu.gl_segment4, xu.gl_segment5, xu.gl_segment6, xu.gl_segment7, xu.gl_segment8, xu.gl_segment9, xu.gl_segment10, xu.gl_segment11, xu.gl_segment12, xu.gl_segment13, xu.gl_segment14, xu.gl_segment15, nvl(gi.entered_dr,to_number(xu.debit)) debit, nvl(gi.entered_cr,to_number(xu.credit)) credit, nvl(gi.stat_amount,xu.stat_amount) stat_amount, nvl(xxen_util.meaning(gi.reference7,'YES_NO',0),xu.reverse_journal) reverse_journal, nvl(gi.reference8,xu.reversal_period) reversal_period, nvl(gi.user_currency_conversion_type,xu.conversion_type) conversion_type, nvl(gi.currency_conversion_date,xu.conversion_date) conversion_date, nvl(to_number(gi.currency_conversion_rate),to_number(xu.conversion_rate)) conversion_rate, xu.line_description, nvl(gi.actual_flag,xu.actual_flag) actual_flag, xu.encumbrance_type, xu.attach_upload_file, xu.status, xu.date_created, to_number(xu.created_by) created_by, to_number(xu.user_id) user_id, xu.summary_flag, xu.post_to_suspense_flag, xu.submit_approval, xu.submit_posting, xu.line_dff_context, xu.gl_je_line_attribute1, xu.gl_je_line_attribute2, xu.gl_je_line_attribute3, xu.gl_je_line_attribute4, xu.gl_je_line_attribute5, xu.gl_je_line_attribute6, xu.gl_je_line_attribute7, xu.gl_je_line_attribute8, xu.gl_je_line_attribute9, xu.gl_je_line_attribute10, xu.attachment_category_, xu.attachment_title_, xu.attachment_description_, xu.attachment_type_, xu.attachment_content_, xu.attachment_file_id_, xu.upload_row from xxen_gl_journal_upload_9275_u xu, gl_interface gi where xu.row_id=gi.rowid(+) and (xu.status_code_<>'S' or nvl(gi.status,'PROCESSED')<>'PROCESSED') Order By upload_row Success SQL select xxen_upload.action_meaning(xxen_upload.action_create) action_, xxen_upload.status_meaning(xxen_upload.status_success) status_, nvl2(xu.message_,xu.message_||chr(10),null)||'Journal Name: '||gjh.name||', Batch Name: '||gjb.name message_, null request_id_, null modified_columns_, null row_id, to_number(null) group_id, gl.name ledger, null organization, gbv.budget_name, gjsv.user_je_source_name source, gjcv.user_je_category_name category, null check_if_journal_balanced, gjb.name batch_name, xxen_util.meaning(gjb.approval_status_code,'JE_BATCH_APPROVAL_STATUS',101) approval_status, gjb.description batch_description, gjh.name journal_name, gjh.description journal_description, gjh.external_reference journal_reference, gjh.currency_code currency, gjl.effective_date accounting_date, gjh.period_name period, ( select fsfa.alias_name from fnd_shorthand_flex_aliases fsfa where fsfa.application_id=101 and fsfa.id_flex_code='GL#' and fsfa.id_flex_num=gcck.chart_of_accounts_id and fsfa.concatenated_segments=gcck.concatenated_segments and fsfa.enabled_flag='Y' and trunc(sysdate) between nvl(fsfa.start_date_active,trunc(sysdate)) and nvl(fsfa.end_date_active,trunc(sysdate)) and rownum=1 ) account_alias, gcck.concatenated_segments account, gcck.segment1, gcck.segment2, gcck.segment3, gcck.segment4, gcck.segment5, gcck.segment6, gcck.segment7, gcck.segment8, gcck.segment9, gcck.segment10, gcck.segment11, gcck.segment12, gcck.segment13, gcck.segment14, gcck.segment15, gjl.entered_dr, gjl.entered_cr, gjl.stat_amount, xxen_util.meaning(gjh.accrual_rev_flag,'YES_NO',0) reverse_journal, gjh.accrual_rev_period_name reversal_period, gd.user_conversion_type, gjh.currency_conversion_date conversion_date, gjh.currency_conversion_rate, gjl.description journal_line_description, gjh.actual_flag, gct.encumbrance_type, null attach_upload_file, null status, to_date(null) date_created, to_number(null) created_by, to_number(null) user_id, null summary_flag, null post_to_suspense_flag, null submit_approval, null submit_posting, xxen_util.display_flexfield_context(101,'GL_JE_LINES',gjl.context) line_dff_context, xxen_util.display_flexfield_value(101,'GL_JE_LINES',gjl.context,'ATTRIBUTE1',gjl.rowid,gjl.attribute1) gl_je_line_attribute1, xxen_util.display_flexfield_value(101,'GL_JE_LINES',gjl.context,'ATTRIBUTE2',gjl.rowid,gjl.attribute2) gl_je_line_attribute2, xxen_util.display_flexfield_value(101,'GL_JE_LINES',gjl.context,'ATTRIBUTE3',gjl.rowid,gjl.attribute3) gl_je_line_attribute3, xxen_util.display_flexfield_value(101,'GL_JE_LINES',gjl.context,'ATTRIBUTE4',gjl.rowid,gjl.attribute4) gl_je_line_attribute4, xxen_util.display_flexfield_value(101,'GL_JE_LINES',gjl.context,'ATTRIBUTE5',gjl.rowid,gjl.attribute5) gl_je_line_attribute5, xxen_util.display_flexfield_value(101,'GL_JE_LINES',gjl.context,'ATTRIBUTE6',gjl.rowid,gjl.attribute6) gl_je_line_attribute6, xxen_util.display_flexfield_value(101,'GL_JE_LINES',gjl.context,'ATTRIBUTE7',gjl.rowid,gjl.attribute7) gl_je_line_attribute7, xxen_util.display_flexfield_value(101,'GL_JE_LINES',gjl.context,'ATTRIBUTE8',gjl.rowid,gjl.attribute8) gl_je_line_attribute8, xxen_util.display_flexfield_value(101,'GL_JE_LINES',gjl.context,'ATTRIBUTE9',gjl.rowid,gjl.attribute9) gl_je_line_attribute9, xxen_util.display_flexfield_value(101,'GL_JE_LINES',gjl.context,'ATTRIBUTE10',gjl.rowid,gjl.attribute10) gl_je_line_attribute10, xu.attachment_category_, xu.attachment_title_, xu.attachment_description_, xu.attachment_type_, xxen_upload.check_and_add_attachment( p_function_name=>'GLXJEENT', p_function_type=>'O', p_category_name=>xu.attachment_category_, p_entity_name=>'GL_JE_HEADERS', p_data_type=>xu.attachment_type_, p_title=>xu.attachment_title_, p_description=>xu.attachment_description_, p_text=>xu.attachment_content_, p_file_id=>xu.attachment_file_id_, p_pk1_value=>gjb.je_batch_id, p_pk2_value=>gjh.je_header_id ) attachment_content_, xu.attachment_file_id_, xu.upload_row from ( select distinct xu.group_id, xu.ledger_name, xu.source, xu.category, xu.currency, xu.period, xu.batch_name_, xu.journal_name_, max(xu.message_) keep (dense_rank first order by xu.upload_row) over (partition by xu.batch_name_,xu.journal_name_,xu.ledger_name,xu.source,xu.category,xu.currency,xu.period) message_, max(xu.attachment_category_) keep (dense_rank first order by xu.upload_row) over (partition by xu.batch_name_,xu.journal_name_,xu.ledger_name,xu.source,xu.category,xu.currency,xu.period) attachment_category_, max(xu.attachment_title_) keep (dense_rank first order by xu.upload_row) over (partition by xu.batch_name_,xu.journal_name_,xu.ledger_name,xu.source,xu.category,xu.currency,xu.period) attachment_title_, max(xu.attachment_description_) keep (dense_rank first order by xu.upload_row) over (partition by xu.batch_name_,xu.journal_name_,xu.ledger_name,xu.source,xu.category,xu.currency,xu.period) attachment_description_, max(xu.attachment_type_) keep (dense_rank first order by xu.upload_row) over (partition by xu.batch_name_,xu.journal_name_,xu.ledger_name,xu.source,xu.category,xu.currency,xu.period) attachment_type_, max(xu.attachment_content_) keep (dense_rank first order by xu.upload_row) over (partition by xu.batch_name_,xu.journal_name_,xu.ledger_name,xu.source,xu.category,xu.currency,xu.period) attachment_content_, max(xu.attachment_file_id_) keep (dense_rank first order by xu.upload_row) over (partition by xu.batch_name_,xu.journal_name_,xu.ledger_name,xu.source,xu.category,xu.currency,xu.period) attachment_file_id_, min(xu.upload_row) over (partition by xu.batch_name_,xu.journal_name_,xu.ledger_name,xu.source,xu.category,xu.currency,xu.period) upload_row from ( select substrb(case when xu.batch_name is not null then xu.batch_name||' ' end||xu.source||' '||xu.actual_flag||' '||xu.group_id,1,85)||' '||xu.request_id_ batch_name_, replace(substrb(case when xu.journal_name is not null then xu.journal_name||' '||chr(10) end||xu.category||' '||xu.currency,1,100),chr(10)) journal_name_, xu.* from xxen_gl_journal_upload_9275_u xu, gl_interface gi where xu.status_<>'E' and xu.row_id=gi.rowid(+) and nvl(gi.status,'PROCESSED')='PROCESSED' ) xu ) xu, gl_je_batches gjb, gl_je_headers gjh, gl_je_lines gjl, gl_ledgers gl, gl_je_sources_v gjsv, gl_je_categories_v gjcv, gl_code_combinations_kfv gcck, gl_encumbrance_types gct, gl_budgets_v gbv, gl_daily_conversion_types gd, fnd_user fu where xu.group_id=gjb.group_id and xu.batch_name_=gjb.name and xu.currency=gjh.currency_code and xu.period=gjh.period_name and gjh.name like xu.journal_name_||'%' and xu.source=gjsv.user_je_source_name and xu.category=gjcv.user_je_category_name and xu.ledger_name=gl.name and gjb.je_batch_id=gjh.je_batch_id and gjh.je_header_id=gjl.je_header_id and gjh.je_source=gjsv.je_source_name and gjh.je_category=gjcv.je_category_name and gjh.encumbrance_type_id=gct.encumbrance_type_id(+) and gjh.budget_version_id=gbv.budget_version_id(+) and gl.ledger_id=gjh.ledger_id and fu.user_id=gjl.created_by and nvl(gjh.currency_conversion_type,'!')=gd.conversion_type(+) and gcck.code_combination_id=gjl.code_combination_id LOV query :$column$.ledger_name LEDGER_NAME ACCOUNT_ALIAS LOV query :$flex$.journal_type Journal Type|:p_actual_flag| ACCOUNT_ALIAS Default value :$flex$.journal_type Journal Type|:p_actual_flag| ACTUAL_FLAG Default value :$flex$.attach_upload_file_to_journal Attach Upload file to Journal|1=1| ATTACH_UPLOAD_FILE LOV query :$column$.ledger_name LEDGER_NAME BUDGET LOV query :$column$.organization ORGANIZATION BUDGET Default value :$flex$.check_if_journal_balanced Check if Journal Balanced|1=1| CHECK_IF_JOURNAL_BALANCED LOV query :$column$.account_alias ACCOUNT_ALIAS CONCATENATED_SEGMENTS Default value :$column$.account_alias ACCOUNT_ALIAS CONCATENATED_SEGMENTS LOV query :$column$.ledger_name LEDGER_NAME CONCATENATED_SEGMENTS Default value :$column$.ledger_name LEDGER_NAME CONCATENATED_SEGMENTS Default value :$flex$.journal_type Journal Type|:p_actual_flag| CONCATENATED_SEGMENTS LOV query :$flex$.journal_type Journal Type|:p_actual_flag| CONCATENATED_SEGMENTS LOV query :$column$.conversion_date CONVERSION_DATE CONVERSION_RATE LOV query :$column$.conversion_type CONVERSION_TYPE CONVERSION_RATE LOV query :$column$.currency CURRENCY CONVERSION_RATE LOV query :$column$.ledger_name LEDGER_NAME CONVERSION_RATE LOV query :$column$.ledger_name LEDGER_NAME CURRENCY LOV query :$flex$.allow_foreign_currency Allow Foreign Currency|:p_foreign_currency_flag| CURRENCY LOV query :$flex$.journal_type Journal Type|:p_actual_flag| CURRENCY LOV query :$column$.gl_je_line_attribute1 GL_JE_LINE_ATTRIBUTE1 GL_JE_LINE_ATTRIBUTE1 LOV query :$column$.gl_je_line_attribute10 GL_JE_LINE_ATTRIBUTE10 GL_JE_LINE_ATTRIBUTE1 LOV query :$column$.gl_je_line_attribute2 GL_JE_LINE_ATTRIBUTE2 GL_JE_LINE_ATTRIBUTE1 LOV query :$column$.gl_je_line_attribute3 GL_JE_LINE_ATTRIBUTE3 GL_JE_LINE_ATTRIBUTE1 LOV query :$column$.gl_je_line_attribute4 GL_JE_LINE_ATTRIBUTE4 GL_JE_LINE_ATTRIBUTE1 LOV query :$column$.gl_je_line_attribute5 GL_JE_LINE_ATTRIBUTE5 GL_JE_LINE_ATTRIBUTE1 LOV query :$column$.gl_je_line_attribute6 GL_JE_LINE_ATTRIBUTE6 GL_JE_LINE_ATTRIBUTE1 LOV query :$column$.gl_je_line_attribute7 GL_JE_LINE_ATTRIBUTE7 GL_JE_LINE_ATTRIBUTE1 LOV query :$column$.gl_je_line_attribute8 GL_JE_LINE_ATTRIBUTE8 GL_JE_LINE_ATTRIBUTE1 LOV query :$column$.gl_je_line_attribute9 GL_JE_LINE_ATTRIBUTE9 GL_JE_LINE_ATTRIBUTE1 LOV query :$column$.line_dff_context LINE_DFF_CONTEXT GL_JE_LINE_ATTRIBUTE1 LOV query :$column$.gl_je_line_attribute1 GL_JE_LINE_ATTRIBUTE1 GL_JE_LINE_ATTRIBUTE10 LOV query :$column$.gl_je_line_attribute10 GL_JE_LINE_ATTRIBUTE10 GL_JE_LINE_ATTRIBUTE10 LOV query :$column$.gl_je_line_attribute2 GL_JE_LINE_ATTRIBUTE2 GL_JE_LINE_ATTRIBUTE10 LOV query :$column$.gl_je_line_attribute3 GL_JE_LINE_ATTRIBUTE3 GL_JE_LINE_ATTRIBUTE10 LOV query :$column$.gl_je_line_attribute4 GL_JE_LINE_ATTRIBUTE4 GL_JE_LINE_ATTRIBUTE10 LOV query :$column$.gl_je_line_attribute5 GL_JE_LINE_ATTRIBUTE5 GL_JE_LINE_ATTRIBUTE10 LOV query :$column$.gl_je_line_attribute6 GL_JE_LINE_ATTRIBUTE6 GL_JE_LINE_ATTRIBUTE10 LOV query :$column$.gl_je_line_attribute7 GL_JE_LINE_ATTRIBUTE7 GL_JE_LINE_ATTRIBUTE10 LOV query :$column$.gl_je_line_attribute8 GL_JE_LINE_ATTRIBUTE8 GL_JE_LINE_ATTRIBUTE10 LOV query :$column$.gl_je_line_attribute9 GL_JE_LINE_ATTRIBUTE9 GL_JE_LINE_ATTRIBUTE10 LOV query :$column$.line_dff_context LINE_DFF_CONTEXT GL_JE_LINE_ATTRIBUTE10 LOV query :$column$.gl_je_line_attribute1 GL_JE_LINE_ATTRIBUTE1 GL_JE_LINE_ATTRIBUTE2 LOV query :$column$.gl_je_line_attribute10 GL_JE_LINE_ATTRIBUTE10 GL_JE_LINE_ATTRIBUTE2 LOV query :$column$.gl_je_line_attribute2 GL_JE_LINE_ATTRIBUTE2 GL_JE_LINE_ATTRIBUTE2 LOV query :$column$.gl_je_line_attribute3 GL_JE_LINE_ATTRIBUTE3 GL_JE_LINE_ATTRIBUTE2 LOV query :$column$.gl_je_line_attribute4 GL_JE_LINE_ATTRIBUTE4 GL_JE_LINE_ATTRIBUTE2 LOV query :$column$.gl_je_line_attribute5 GL_JE_LINE_ATTRIBUTE5 GL_JE_LINE_ATTRIBUTE2 LOV query :$column$.gl_je_line_attribute6 GL_JE_LINE_ATTRIBUTE6 GL_JE_LINE_ATTRIBUTE2 LOV query :$column$.gl_je_line_attribute7 GL_JE_LINE_ATTRIBUTE7 GL_JE_LINE_ATTRIBUTE2 LOV query :$column$.gl_je_line_attribute8 GL_JE_LINE_ATTRIBUTE8 GL_JE_LINE_ATTRIBUTE2 LOV query :$column$.gl_je_line_attribute9 GL_JE_LINE_ATTRIBUTE9 GL_JE_LINE_ATTRIBUTE2 LOV query :$column$.line_dff_context LINE_DFF_CONTEXT GL_JE_LINE_ATTRIBUTE2 LOV query :$column$.gl_je_line_attribute1 GL_JE_LINE_ATTRIBUTE1 GL_JE_LINE_ATTRIBUTE3 LOV query :$column$.gl_je_line_attribute10 GL_JE_LINE_ATTRIBUTE10 GL_JE_LINE_ATTRIBUTE3 LOV query :$column$.gl_je_line_attribute2 GL_JE_LINE_ATTRIBUTE2 GL_JE_LINE_ATTRIBUTE3 LOV query :$column$.gl_je_line_attribute3 GL_JE_LINE_ATTRIBUTE3 GL_JE_LINE_ATTRIBUTE3 LOV query :$column$.gl_je_line_attribute4 GL_JE_LINE_ATTRIBUTE4 GL_JE_LINE_ATTRIBUTE3 LOV query :$column$.gl_je_line_attribute5 GL_JE_LINE_ATTRIBUTE5 GL_JE_LINE_ATTRIBUTE3 LOV query :$column$.gl_je_line_attribute6 GL_JE_LINE_ATTRIBUTE6 GL_JE_LINE_ATTRIBUTE3 LOV query :$column$.gl_je_line_attribute7 GL_JE_LINE_ATTRIBUTE7 GL_JE_LINE_ATTRIBUTE3 LOV query :$column$.gl_je_line_attribute8 GL_JE_LINE_ATTRIBUTE8 GL_JE_LINE_ATTRIBUTE3 LOV query :$column$.gl_je_line_attribute9 GL_JE_LINE_ATTRIBUTE9 GL_JE_LINE_ATTRIBUTE3 LOV query :$column$.line_dff_context LINE_DFF_CONTEXT GL_JE_LINE_ATTRIBUTE3 LOV query :$column$.gl_je_line_attribute1 GL_JE_LINE_ATTRIBUTE1 GL_JE_LINE_ATTRIBUTE4 LOV query :$column$.gl_je_line_attribute10 GL_JE_LINE_ATTRIBUTE10 GL_JE_LINE_ATTRIBUTE4 LOV query :$column$.gl_je_line_attribute2 GL_JE_LINE_ATTRIBUTE2 GL_JE_LINE_ATTRIBUTE4 LOV query :$column$.gl_je_line_attribute3 GL_JE_LINE_ATTRIBUTE3 GL_JE_LINE_ATTRIBUTE4 LOV query :$column$.gl_je_line_attribute4 GL_JE_LINE_ATTRIBUTE4 GL_JE_LINE_ATTRIBUTE4 LOV query :$column$.gl_je_line_attribute5 GL_JE_LINE_ATTRIBUTE5 GL_JE_LINE_ATTRIBUTE4 LOV query :$column$.gl_je_line_attribute6 GL_JE_LINE_ATTRIBUTE6 GL_JE_LINE_ATTRIBUTE4 LOV query :$column$.gl_je_line_attribute7 GL_JE_LINE_ATTRIBUTE7 GL_JE_LINE_ATTRIBUTE4 LOV query :$column$.gl_je_line_attribute8 GL_JE_LINE_ATTRIBUTE8 GL_JE_LINE_ATTRIBUTE4 LOV query :$column$.gl_je_line_attribute9 GL_JE_LINE_ATTRIBUTE9 GL_JE_LINE_ATTRIBUTE4 LOV query :$column$.line_dff_context LINE_DFF_CONTEXT GL_JE_LINE_ATTRIBUTE4 LOV query :$column$.gl_je_line_attribute1 GL_JE_LINE_ATTRIBUTE1 GL_JE_LINE_ATTRIBUTE5 LOV query :$column$.gl_je_line_attribute10 GL_JE_LINE_ATTRIBUTE10 GL_JE_LINE_ATTRIBUTE5 LOV query :$column$.gl_je_line_attribute2 GL_JE_LINE_ATTRIBUTE2 GL_JE_LINE_ATTRIBUTE5 LOV query :$column$.gl_je_line_attribute3 GL_JE_LINE_ATTRIBUTE3 GL_JE_LINE_ATTRIBUTE5 LOV query :$column$.gl_je_line_attribute4 GL_JE_LINE_ATTRIBUTE4 GL_JE_LINE_ATTRIBUTE5 LOV query :$column$.gl_je_line_attribute5 GL_JE_LINE_ATTRIBUTE5 GL_JE_LINE_ATTRIBUTE5 LOV query :$column$.gl_je_line_attribute6 GL_JE_LINE_ATTRIBUTE6 GL_JE_LINE_ATTRIBUTE5 LOV query :$column$.gl_je_line_attribute7 GL_JE_LINE_ATTRIBUTE7 GL_JE_LINE_ATTRIBUTE5 LOV query :$column$.gl_je_line_attribute8 GL_JE_LINE_ATTRIBUTE8 GL_JE_LINE_ATTRIBUTE5 LOV query :$column$.gl_je_line_attribute9 GL_JE_LINE_ATTRIBUTE9 GL_JE_LINE_ATTRIBUTE5 LOV query :$column$.line_dff_context LINE_DFF_CONTEXT GL_JE_LINE_ATTRIBUTE5 LOV query :$column$.gl_je_line_attribute1 GL_JE_LINE_ATTRIBUTE1 GL_JE_LINE_ATTRIBUTE6 LOV query :$column$.gl_je_line_attribute10 GL_JE_LINE_ATTRIBUTE10 GL_JE_LINE_ATTRIBUTE6 LOV query :$column$.gl_je_line_attribute2 GL_JE_LINE_ATTRIBUTE2 GL_JE_LINE_ATTRIBUTE6 LOV query :$column$.gl_je_line_attribute3 GL_JE_LINE_ATTRIBUTE3 GL_JE_LINE_ATTRIBUTE6 LOV query :$column$.gl_je_line_attribute4 GL_JE_LINE_ATTRIBUTE4 GL_JE_LINE_ATTRIBUTE6 LOV query :$column$.gl_je_line_attribute5 GL_JE_LINE_ATTRIBUTE5 GL_JE_LINE_ATTRIBUTE6 LOV query :$column$.gl_je_line_attribute6 GL_JE_LINE_ATTRIBUTE6 GL_JE_LINE_ATTRIBUTE6 LOV query :$column$.gl_je_line_attribute7 GL_JE_LINE_ATTRIBUTE7 GL_JE_LINE_ATTRIBUTE6 LOV query :$column$.gl_je_line_attribute8 GL_JE_LINE_ATTRIBUTE8 GL_JE_LINE_ATTRIBUTE6 LOV query :$column$.gl_je_line_attribute9 GL_JE_LINE_ATTRIBUTE9 GL_JE_LINE_ATTRIBUTE6 LOV query :$column$.line_dff_context LINE_DFF_CONTEXT GL_JE_LINE_ATTRIBUTE6 LOV query :$column$.gl_je_line_attribute1 GL_JE_LINE_ATTRIBUTE1 GL_JE_LINE_ATTRIBUTE7 LOV query :$column$.gl_je_line_attribute10 GL_JE_LINE_ATTRIBUTE10 GL_JE_LINE_ATTRIBUTE7 LOV query :$column$.gl_je_line_attribute2 GL_JE_LINE_ATTRIBUTE2 GL_JE_LINE_ATTRIBUTE7 LOV query :$column$.gl_je_line_attribute3 GL_JE_LINE_ATTRIBUTE3 GL_JE_LINE_ATTRIBUTE7 LOV query :$column$.gl_je_line_attribute4 GL_JE_LINE_ATTRIBUTE4 GL_JE_LINE_ATTRIBUTE7 LOV query :$column$.gl_je_line_attribute5 GL_JE_LINE_ATTRIBUTE5 GL_JE_LINE_ATTRIBUTE7 LOV query :$column$.gl_je_line_attribute6 GL_JE_LINE_ATTRIBUTE6 GL_JE_LINE_ATTRIBUTE7 LOV query :$column$.gl_je_line_attribute7 GL_JE_LINE_ATTRIBUTE7 GL_JE_LINE_ATTRIBUTE7 LOV query :$column$.gl_je_line_attribute8 GL_JE_LINE_ATTRIBUTE8 GL_JE_LINE_ATTRIBUTE7 LOV query :$column$.gl_je_line_attribute9 GL_JE_LINE_ATTRIBUTE9 GL_JE_LINE_ATTRIBUTE7 LOV query :$column$.line_dff_context LINE_DFF_CONTEXT GL_JE_LINE_ATTRIBUTE7 LOV query :$column$.gl_je_line_attribute1 GL_JE_LINE_ATTRIBUTE1 GL_JE_LINE_ATTRIBUTE8 LOV query :$column$.gl_je_line_attribute10 GL_JE_LINE_ATTRIBUTE10 GL_JE_LINE_ATTRIBUTE8 LOV query :$column$.gl_je_line_attribute2 GL_JE_LINE_ATTRIBUTE2 GL_JE_LINE_ATTRIBUTE8 LOV query :$column$.gl_je_line_attribute3 GL_JE_LINE_ATTRIBUTE3 GL_JE_LINE_ATTRIBUTE8 LOV query :$column$.gl_je_line_attribute4 GL_JE_LINE_ATTRIBUTE4 GL_JE_LINE_ATTRIBUTE8 LOV query :$column$.gl_je_line_attribute5 GL_JE_LINE_ATTRIBUTE5 GL_JE_LINE_ATTRIBUTE8 LOV query :$column$.gl_je_line_attribute6 GL_JE_LINE_ATTRIBUTE6 GL_JE_LINE_ATTRIBUTE8 LOV query :$column$.gl_je_line_attribute7 GL_JE_LINE_ATTRIBUTE7 GL_JE_LINE_ATTRIBUTE8 LOV query :$column$.gl_je_line_attribute8 GL_JE_LINE_ATTRIBUTE8 GL_JE_LINE_ATTRIBUTE8 LOV query :$column$.gl_je_line_attribute9 GL_JE_LINE_ATTRIBUTE9 GL_JE_LINE_ATTRIBUTE8 LOV query :$column$.line_dff_context LINE_DFF_CONTEXT GL_JE_LINE_ATTRIBUTE8 LOV query :$column$.gl_je_line_attribute1 GL_JE_LINE_ATTRIBUTE1 GL_JE_LINE_ATTRIBUTE9 LOV query :$column$.gl_je_line_attribute10 GL_JE_LINE_ATTRIBUTE10 GL_JE_LINE_ATTRIBUTE9 LOV query :$column$.gl_je_line_attribute2 GL_JE_LINE_ATTRIBUTE2 GL_JE_LINE_ATTRIBUTE9 LOV query :$column$.gl_je_line_attribute3 GL_JE_LINE_ATTRIBUTE3 GL_JE_LINE_ATTRIBUTE9 LOV query :$column$.gl_je_line_attribute4 GL_JE_LINE_ATTRIBUTE4 GL_JE_LINE_ATTRIBUTE9 LOV query :$column$.gl_je_line_attribute5 GL_JE_LINE_ATTRIBUTE5 GL_JE_LINE_ATTRIBUTE9 LOV query :$column$.gl_je_line_attribute6 GL_JE_LINE_ATTRIBUTE6 GL_JE_LINE_ATTRIBUTE9 LOV query :$column$.gl_je_line_attribute7 GL_JE_LINE_ATTRIBUTE7 GL_JE_LINE_ATTRIBUTE9 LOV query :$column$.gl_je_line_attribute8 GL_JE_LINE_ATTRIBUTE8 GL_JE_LINE_ATTRIBUTE9 LOV query :$column$.gl_je_line_attribute9 GL_JE_LINE_ATTRIBUTE9 GL_JE_LINE_ATTRIBUTE9 LOV query :$column$.line_dff_context LINE_DFF_CONTEXT GL_JE_LINE_ATTRIBUTE9 LOV query :$column$.concatenated_segments CONCATENATED_SEGMENTS GL_SEGMENT1 Default value :$column$.concatenated_segments CONCATENATED_SEGMENTS GL_SEGMENT1 Default value :$column$.ledger_name LEDGER_NAME GL_SEGMENT1 LOV query :$column$.ledger_name LEDGER_NAME GL_SEGMENT1 Default value :$column$.concatenated_segments CONCATENATED_SEGMENTS GL_SEGMENT10 LOV query :$column$.concatenated_segments CONCATENATED_SEGMENTS GL_SEGMENT10 Default value :$column$.ledger_name LEDGER_NAME GL_SEGMENT10 LOV query :$column$.ledger_name LEDGER_NAME GL_SEGMENT10 LOV query :$column$.concatenated_segments CONCATENATED_SEGMENTS GL_SEGMENT11 Default value :$column$.concatenated_segments CONCATENATED_SEGMENTS GL_SEGMENT11 Default value :$column$.ledger_name LEDGER_NAME GL_SEGMENT11 LOV query :$column$.ledger_name LEDGER_NAME GL_SEGMENT11 Default value :$column$.concatenated_segments CONCATENATED_SEGMENTS GL_SEGMENT12 LOV query :$column$.concatenated_segments CONCATENATED_SEGMENTS GL_SEGMENT12 Default value :$column$.ledger_name LEDGER_NAME GL_SEGMENT12 LOV query :$column$.ledger_name LEDGER_NAME GL_SEGMENT12 LOV query :$column$.concatenated_segments CONCATENATED_SEGMENTS GL_SEGMENT13 Default value :$column$.concatenated_segments CONCATENATED_SEGMENTS GL_SEGMENT13 Default value :$column$.ledger_name LEDGER_NAME GL_SEGMENT13 LOV query :$column$.ledger_name LEDGER_NAME GL_SEGMENT13 LOV query :$column$.concatenated_segments CONCATENATED_SEGMENTS GL_SEGMENT14 Default value :$column$.concatenated_segments CONCATENATED_SEGMENTS GL_SEGMENT14 LOV query :$column$.ledger_name LEDGER_NAME GL_SEGMENT14 Default value :$column$.ledger_name LEDGER_NAME GL_SEGMENT14 LOV query :$column$.concatenated_segments CONCATENATED_SEGMENTS GL_SEGMENT15 Default value :$column$.concatenated_segments CONCATENATED_SEGMENTS GL_SEGMENT15 LOV query :$column$.ledger_name LEDGER_NAME GL_SEGMENT15 Default value :$column$.ledger_name LEDGER_NAME GL_SEGMENT15 LOV query :$column$.concatenated_segments CONCATENATED_SEGMENTS GL_SEGMENT2 Default value :$column$.concatenated_segments CONCATENATED_SEGMENTS GL_SEGMENT2 LOV query :$column$.ledger_name LEDGER_NAME GL_SEGMENT2 Default value :$column$.ledger_name LEDGER_NAME GL_SEGMENT2 LOV query :$column$.concatenated_segments CONCATENATED_SEGMENTS GL_SEGMENT3 Default value :$column$.concatenated_segments CONCATENATED_SEGMENTS GL_SEGMENT3 Default value :$column$.ledger_name LEDGER_NAME GL_SEGMENT3 LOV query :$column$.ledger_name LEDGER_NAME GL_SEGMENT3 Default value :$column$.concatenated_segments CONCATENATED_SEGMENTS GL_SEGMENT4 LOV query :$column$.concatenated_segments CONCATENATED_SEGMENTS GL_SEGMENT4 LOV query :$column$.ledger_name LEDGER_NAME GL_SEGMENT4 Default value :$column$.ledger_name LEDGER_NAME GL_SEGMENT4 Default value :$column$.concatenated_segments CONCATENATED_SEGMENTS GL_SEGMENT5 LOV query :$column$.concatenated_segments CONCATENATED_SEGMENTS GL_SEGMENT5 Default value :$column$.ledger_name LEDGER_NAME GL_SEGMENT5 LOV query :$column$.ledger_name LEDGER_NAME GL_SEGMENT5 LOV query :$column$.concatenated_segments CONCATENATED_SEGMENTS GL_SEGMENT6 Default value :$column$.concatenated_segments CONCATENATED_SEGMENTS GL_SEGMENT6 LOV query :$column$.ledger_name LEDGER_NAME GL_SEGMENT6 Default value :$column$.ledger_name LEDGER_NAME GL_SEGMENT6 Default value :$column$.concatenated_segments CONCATENATED_SEGMENTS GL_SEGMENT7 LOV query :$column$.concatenated_segments CONCATENATED_SEGMENTS GL_SEGMENT7 LOV query :$column$.ledger_name LEDGER_NAME GL_SEGMENT7 Default value :$column$.ledger_name LEDGER_NAME GL_SEGMENT7 LOV query :$column$.concatenated_segments CONCATENATED_SEGMENTS GL_SEGMENT8 Default value :$column$.concatenated_segments CONCATENATED_SEGMENTS GL_SEGMENT8 LOV query :$column$.ledger_name LEDGER_NAME GL_SEGMENT8 Default value :$column$.ledger_name LEDGER_NAME GL_SEGMENT8 LOV query :$column$.concatenated_segments CONCATENATED_SEGMENTS GL_SEGMENT9 Default value :$column$.concatenated_segments CONCATENATED_SEGMENTS GL_SEGMENT9 LOV query :$column$.ledger_name LEDGER_NAME GL_SEGMENT9 Default value :$column$.ledger_name LEDGER_NAME GL_SEGMENT9 LOV query :$column$.ledger_name LEDGER_NAME ORGANIZATION LOV query :$column$.accounting_date ACCOUNTING_DATE PERIOD Default value :$column$.accounting_date ACCOUNTING_DATE PERIOD LOV query :$column$.ledger_name LEDGER_NAME PERIOD Default value :$column$.ledger_name LEDGER_NAME PERIOD Default value :$flex$.post_errors_to_suspense Post Errors to Suspense|:p_post_to_suspense_flag| POST_TO_SUSPENSE_FLAG LOV query :$column$.accounting_date ACCOUNTING_DATE REVERSAL_PERIOD LOV query :$column$.ledger_name LEDGER_NAME REVERSAL_PERIOD LOV query :$column$.reverse_journal REVERSE_JOURNAL REVERSAL_PERIOD Default value :$flex$.Submit_for_Approval Submit for Approval|1=1| SUBMIT_APPROVAL Default value :$flex$.Submit_Journal_Post Submit Journal Post|1=1| SUBMIT_POSTING Default value :$flex$.create_summary_journal Create Summary Journal|:p_create_summary_jnl| SUMMARY_FLAG Excel validation :$column$.credit CREDIT Excel validation :$column$.currency CURRENCY Excel validation :$column$.debit DEBIT Excel validation :$column$.gl_je_line_attribute1 GL_JE_LINE_ATTRIBUTE1 Excel validation :$column$.gl_je_line_attribute10 GL_JE_LINE_ATTRIBUTE10 Excel validation :$column$.gl_je_line_attribute2 GL_JE_LINE_ATTRIBUTE2 Excel validation :$column$.gl_je_line_attribute3 GL_JE_LINE_ATTRIBUTE3 Excel validation :$column$.gl_je_line_attribute4 GL_JE_LINE_ATTRIBUTE4 Excel validation :$column$.gl_je_line_attribute5 GL_JE_LINE_ATTRIBUTE5 Excel validation :$column$.gl_je_line_attribute6 GL_JE_LINE_ATTRIBUTE6 Excel validation :$column$.gl_je_line_attribute7 GL_JE_LINE_ATTRIBUTE7 Excel validation :$column$.gl_je_line_attribute8 GL_JE_LINE_ATTRIBUTE8 Excel validation :$column$.gl_je_line_attribute9 GL_JE_LINE_ATTRIBUTE9 Excel validation :$column$.gl_segment1 GL_SEGMENT1 Excel validation :$column$.gl_segment10 GL_SEGMENT10 Excel validation :$column$.gl_segment11 GL_SEGMENT11 Excel validation :$column$.gl_segment12 GL_SEGMENT12 Excel validation :$column$.gl_segment13 GL_SEGMENT13 Excel validation :$column$.gl_segment14 GL_SEGMENT14 Excel validation :$column$.gl_segment15 GL_SEGMENT15 Excel validation :$column$.gl_segment2 GL_SEGMENT2 Excel validation :$column$.gl_segment3 GL_SEGMENT3 Excel validation :$column$.gl_segment4 GL_SEGMENT4 Excel validation :$column$.gl_segment5 GL_SEGMENT5 Excel validation :$column$.gl_segment6 GL_SEGMENT6 Excel validation :$column$.gl_segment7 GL_SEGMENT7 Excel validation :$column$.gl_segment8 GL_SEGMENT8 Excel validation :$column$.gl_segment9 GL_SEGMENT9 Excel validation :$column$.ledger_name LEDGER_NAME Excel validation :$column$.line_dff_context LINE_DFF_CONTEXT Excel validation :$column$.stat_amount STAT_AMOUNT