ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN ABB647A6C7E33F01E053B46B63585EC2Y SELECT GL_DATE ,CREATED_BY ,CREATION_DATE ,LAST_UPDATE_DATE ,GL_TRANSFER_DATE ,REFERENCE_DATE ,COMPLETED_DATE ,TRANSACTION_NUMBER ,TRANSACTION_DATE ,ACCOUNTING_SEQUENCE_NAME ,ACCOUNTING_SEQUENCE_VERSION ,ACCOUNTING_SEQUENCE_NUMBER ,REPORTING_SEQUENCE_NAME ,REPORTING_SEQUENCE_VERSION ,REPORTING_SEQUENCE_NUMBER ,DOCUMENT_CATEGORY ,DOCUMENT_SEQUENCE_NAME ,DOCUMENT_SEQUENCE_NUMBER ,GL_DOCUMENT_SEQUENCE_NAME ,GL_DOCUMENT_SEQUENCE_NUMBER ,APPLICATION_ID ,APPLICATION_NAME ,HEADER_ID ,HEADER_DESCRIPTION ,FUND_STATUS ,JE_CATEGORY_NAME ,JE_SOURCE_NAME ,EVENT_ID ,EVENT_DATE ,EVENT_NUMBER ,EVENT_CLASS_CODE ,EVENT_CLASS_NAME ,EVENT_TYPE_CODE ,EVENT_TYPE_NAME ,GL_BATCH_NAME ,POSTED_DATE ,GL_JE_NAME ,GL_LINE_NUMBER ,LINE_NUMBER ,ORIG_LINE_NUMBER ,ACCOUNTING_CLASS_CODE ,ACCOUNTING_CLASS_NAME ,LINE_DESCRIPTION ,ENTERED_CURRENCY ,CONVERSION_RATE ,CONVERSION_RATE_DATE ,CONVERSION_RATE_TYPE_CODE ,CONVERSION_RATE_TYPE ,ENTERED_DR ,ENTERED_CR ,UNROUNDED_ACCOUNTED_DR ,UNROUNDED_ACCOUNTED_CR ,ACCOUNTED_DR ,ACCOUNTED_CR ,STATISTICAL_AMOUNT ,RECONCILIATION_REFERENCE ,ATTRIBUTE_CATEGORY ,ATTRIBUTE1 ,ATTRIBUTE2 ,ATTRIBUTE3 ,ATTRIBUTE4 ,ATTRIBUTE5 ,ATTRIBUTE6 ,ATTRIBUTE7 ,ATTRIBUTE8 ,ATTRIBUTE9 ,ATTRIBUTE10 ,PARTY_TYPE_CODE ,PARTY_TYPE ,PARTY_NUMBER ,PARTY_NAME ,PARTY_TYPE_TAXPAYER_ID ,PARTY_TAX_REGISTRATION_NUMBER ,PARTY_SITE_NUMBER ,PARTY_SITE_NAME ,PARTY_SITE_TAX_RGSTN_NUMBER ,USER_TRX_IDENTIFIER_NAME_1 ,USER_TRX_IDENTIFIER_VALUE_1 ,USER_TRX_IDENTIFIER_NAME_2 ,USER_TRX_IDENTIFIER_VALUE_2 ,USER_TRX_IDENTIFIER_NAME_3 ,USER_TRX_IDENTIFIER_VALUE_3 ,USER_TRX_IDENTIFIER_NAME_4 ,USER_TRX_IDENTIFIER_VALUE_4 ,USER_TRX_IDENTIFIER_NAME_5 ,USER_TRX_IDENTIFIER_VALUE_5 ,USER_TRX_IDENTIFIER_NAME_6 ,USER_TRX_IDENTIFIER_VALUE_6 ,USER_TRX_IDENTIFIER_NAME_7 ,USER_TRX_IDENTIFIER_VALUE_7 ,USER_TRX_IDENTIFIER_NAME_8 ,USER_TRX_IDENTIFIER_VALUE_8 ,USER_TRX_IDENTIFIER_NAME_9 ,USER_TRX_IDENTIFIER_VALUE_9 ,USER_TRX_IDENTIFIER_NAME_10 ,USER_TRX_IDENTIFIER_VALUE_10 ,LEGAL_ENTITY_ID ,LEGAL_ENTITY_NAME ,LE_ADDRESS_LINE_1 ,LE_ADDRESS_LINE_2 ,LE_ADDRESS_LINE_3 ,LE_CITY ,LE_REGION_1 ,LE_REGION_2 ,LE_REGION_3 ,LE_POSTAL_CODE ,LE_COUNTRY ,LE_REGISTRATION_NUMBER ,LE_REGISTRATION_EFFECTIVE_FROM ,LE_BR_DAILY_INSCRIPTION_NUMBER ,LE_BR_DAILY_INSCRIPTION_DATE ,LE_BR_DAILY_ENTITY ,LE_BR_DAILY_LOCATION ,LE_BR_DIRECTOR_NUMBER ,LE_BR_ACCOUNTANT_NUMBER ,LE_BR_ACCOUNTANT_NAME ,LEDGER_ID ,LEDGER_SHORT_NAME ,LEDGER_DESCRIPTION ,LEDGER_NAME ,LEDGER_CURRENCY ,PERIOD_YEAR ,PERIOD_NUMBER ,PERIOD_NAME ,PERIOD_START_DATE ,PERIOD_END_DATE ,BALANCE_TYPE_CODE ,BALANCE_TYPE ,BUDGET_NAME ,ENCUMBRANCE_TYPE ,SLA_BEGIN_BALANCE_DR ,SLA_BEGIN_BALANCE_CR ,SLA_PERIOD_NET_DR ,SLA_PERIOD_NET_CR ,BEGIN_BALANCE_DR ,BEGIN_BALANCE_CR ,PERIOD_NET_DR ,PERIOD_NET_CR ,CODE_COMBINATION_ID ,ACCOUNTING_CODE_COMBINATION ,CODE_COMBINATION_DESCRIPTION ,CONTROL_ACCOUNT_FLAG ,CONTROL_ACCOUNT ,BALANCING_SEGMENT ,NATURAL_ACCOUNT_SEGMENT ,COST_CENTER_SEGMENT ,MANAGEMENT_SEGMENT ,INTERCOMPANY_SEGMENT ,BALANCING_SEGMENT_DESC ,NATURAL_ACCOUNT_DESC ,COST_CENTER_DESC ,MANAGEMENT_SEGMENT_DESC ,INTERCOMPANY_SEGMENT_DESC ,SEGMENT1 ,SEGMENT2 ,SEGMENT3 ,SEGMENT4 ,SEGMENT5 ,SEGMENT6 ,SEGMENT7 ,SEGMENT8 ,SEGMENT9 ,SEGMENT10 ,SEGMENT11 ,SEGMENT12 ,SEGMENT13 ,SEGMENT14 ,SEGMENT15 ,SEGMENT16 ,SEGMENT17 ,SEGMENT18 ,SEGMENT19 ,SEGMENT20 ,SEGMENT21 ,SEGMENT22 ,SEGMENT23 ,SEGMENT24 ,SEGMENT25 ,SEGMENT26 ,SEGMENT27 ,SEGMENT28 ,SEGMENT29 ,SEGMENT30 ,BEGIN_RUNNING_TOTAL_CR ,BEGIN_RUNNING_TOTAL_DR ,END_RUNNING_TOTAL_CR ,END_RUNNING_TOTAL_DR ,JE_SOURCE_PERIOD_DR ,JE_SOURCE_PERIOD_CR FROM xxen_account_analysis WHERE 1=1 and gl_date between '&P_GL_DATE_FROM' and '&P_GL_DATE_TO' and segment1 || '-' || segment2 || '-' || segment3 || '-' || segment4 || '-' || segment5 between :P_ACCOUNT_FLEXFIELD_FROM and :P_ACCOUNT_FLEXFIELD_TO XLA XXXLAAARPT US XX Account Analysis Application: Subledger Accounting Source: XX Account Analysis Report Short Name: XXXLAAARPT DB package: XLA_ACCT_ANALYSIS_RPT_PKG BI Publisher &p_gl_date_from &p_gl_date_to 1=1 :p_account_flexfield_from :p_account_flexfield_to 1 -20 1=1 :p_coa_id = :p_coa_id Char US P_COA_ID 2 -10 1=1 :p_ledger_id = :p_ledger_id LOV Oracle XLA_SRS_JELINES_LEDGERS Y select ledger_id id, name value, description description from gl_ledgers a where (nvl(fnd_profile.value('XLA_USE_LEDGER_SECURITY'),'N')='N' or exists (select 1 from gl_access_set_ledgers b where b.ledger_id=a.ledger_id and b.access_set_id in (decode (:$flex$.xla_srs_subledgers ,101 ,null ,decode (fnd_profile.value('XLA_USE_LEDGER_SECURITY') ,'Y' ,fnd_profile.value('XLA_GL_SECONDARY_ACCESS_SET_ID') ,null ) ) ,decode (:$flex$.xla_srs_subledgers ,101 ,fnd_profile.value('GL_ACCESS_SET_ID') ,decode (fnd_profile.value('XLA_USE_LEDGER_SECURITY') ,'Y' ,fnd_profile.value('GL_ACCESS_SET_ID') ,b.access_set_id ) ) ) ) ) and exists (select 1 from gl_ledger_relationships c where decode(a.ledger_category_code,'NONE',c.target_ledger_id,a.ledger_id)=c.target_ledger_id and ((decode(a.ledger_category_code,'NONE','PRIMARY',c.target_ledger_category_code)='PRIMARY' and decode(a.ledger_category_code,'NONE','NONE',c.relationship_type_code)='NONE') or(c.target_ledger_category_code in ('SECONDARY','ALC') and c.relationship_type_code='SUBLEDGER') ) ) order by value,description 976 Y US Ledger/Ledger Set Internal Identifier for ledger or ledger set 3 20 1=1 :p_period_from = :p_period_from LOV Oracle XLA_SRS_JELINES_PERIOD_FROM Y select period_name id, period_name value, null description from gl_ledgers gl,gl_periods glp where gl.ledger_id=:$flex$.xla_srs_jelines_ledgers and gl.period_set_name=glp.period_set_name and gl.accounted_period_type=glp.period_type and glp.adjustment_period_flag='N' order by glp.period_year desc,glp.period_num desc Y US Period From Start period from the calendar attached to the ledger or ledger set 4 &p_gl_date_from SELECT to_char(glp.start_date,'YYYY-MM-DD') FROM gl_periods glp, gl_ledgers gl WHERE gl.ledger_id = 976 AND glp.period_set_name = gl.period_set_name AND glp.period_name = :period_from US Period From 5 30 1=1 :p_period_to = :p_period_to LOV Oracle Y SELECT :$flex$.period_from FROM DUAL Y US Period To End period from the calendar attached to the ledger or ledger set 6 &p_gl_date_to SELECT to_char(glp.end_date,'YYYY-MM-DD') FROM gl_periods glp, gl_ledgers gl WHERE gl.ledger_id = 976 AND glp.period_set_name = gl.period_set_name AND glp.period_name = :period_to US Period To 7 70 :p_account_flexfield_from Char 00-000-0000-0000-000 Y US Account Flexfield From Start of the range for the accouting flexfield 8 80 :p_account_flexfield_to Char 99-999-9999-9999-999 Y US Account Flexfield To End of the range for the accounting flexfield