GL Fusion Balance Transfer - Incremental
Description
Categories: BI Publisher
Imported from BI Publisher
Application: General Ledger
Source: Fusion Balance Transfer - Incremental
Short Name: GL_FUSION_TRANSFER_INC
DB package: GL_FUSION_TRANSFER_PKG
Application: General Ledger
Source: Fusion Balance Transfer - Incremental
Short Name: GL_FUSION_TRANSFER_INC
DB package: GL_FUSION_TRANSFER_PKG
Run
GL Fusion Balance Transfer - Incremental and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT track.system_id SYSTEM_ID, track.group_id GROUP_ID, track.status_code STATUS_CODE, track.original_first_period ORIGINAL_FIRST_PERIOD, track.xfer_request_id REQUEST_ID, :P_BI_TRANSFER_MODE TRANSFER_MODE, rel.target_ledger_name FROM_LEDGER_NAME, elgr.chart_of_accounts_id FROM_COA_ID, flgr.name TO_LEDGER_NAME, :P_BI_FROM_PERIOD_NAME FROM_PERIOD_NAME, nvl(pmap.to_period_name, :P_BI_FROM_PERIOD_NAME) TO_PERIOD_NAME, rel.target_currency_code LEDGER_CURRENCY, coamap.name COA_MAPPING_NAME, calmap.name CALENDAR_MAPPING_NAME FROM gl_xfr_tracking track, gl_ledger_relationships rel, gl_xfr_ledger_mappings lmap, gl_ledgers elgr, gl_xfr_ledgers flgr, gl_coa_mappings coamap, gl_xfr_calendar_mappings calmap, gl_xfr_period_mappings pmap WHERE track.xfer_request_id = &g_request_id_str AND track.system_id = &g_system_id_str AND rel.target_ledger_short_name = :P_BI_FROM_LEDGER_SHORTNAME AND rel.application_id = 101 AND rel.target_ledger_id = rel.source_ledger_id AND lmap.from_ledger_id = rel.target_ledger_id AND lmap.from_ledger_currency = rel.target_currency_code AND elgr.ledger_id = rel.target_ledger_id AND flgr.ledger_id = track.ledger_id AND coamap.coa_mapping_id(+) = lmap.coa_mapping_id AND calmap.calendar_mapping_id(+) = lmap.calendar_mapping_id AND pmap.calendar_mapping_id(+) = lmap.calendar_mapping_id AND pmap.from_period_name(+) = :P_BI_FROM_PERIOD_NAME |
Parameter Name | SQL text | Validation | |
---|---|---|---|
From Ledger |
|
LOV Oracle |