eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.GL_BUDGET_TRANSFER_V

Source

View Text - Preformatted


SELECT 'N' ENABLE_BUDGETARY_CONTROL_FLAG, int.rowid FROM_ROW_ID, int.status_description TO_ROW_ID, int.ledger_id LEDGER_ID, int.group_id GROUP_ID, src.user_je_source_name USER_JE_SOURCE_NAME, src.je_source_name JE_SOURCE_NAME, cat.user_je_category_name USER_JE_CATEGORY_NAME, cat.je_category_name JE_CATEGORY_NAME, int.period_name PERIOD_NAME, per.period_year PERIOD_YEAR, per.period_num PERIOD_NUM, per.quarter_num QUARTER_NUM, int.actual_flag ACTUAL_FLAG, int.budget_version_id BUDGET_VERSION_ID, int.currency_code CURRENCY_CODE, int.code_combination_id FROM_CODE_COMBINATION_ID, int.je_batch_id COMBINATION_NUMBER, abs( nvl(int.entered_dr,0) - nvl(int.entered_cr,0)) TRANSFER_AMOUNT, int.entered_dr FROM_ENTERED_DR, int.entered_cr FROM_ENTERED_CR, to_int.entered_dr TO_ENTERED_DR, to_int.entered_cr TO_ENTERED_CR, int.accounting_date ACCOUNTED_DATE, int.reference1 JE_BATCH_NAME, int.date_created CREATION_DATE, int.created_by CREATED_BY, int.status STATUS, sysdate LAST_UPDATE_DATE, 0 LAST_UPDATED_BY FROM gl_je_sources src, gl_interface int, gl_je_categories cat, gl_period_statuses per, gl_interface to_int WHERE src.je_source_name = 'Transfer' AND int.user_je_source_name = src.user_je_source_name AND cat.je_category_name = 'Budget' AND cat.user_je_category_name = int.user_je_category_name AND per.application_id = 101 AND per.ledger_id = int.ledger_id AND per.period_name = int.period_name AND to_int.rowid = int.status_description UNION SELECT 'Y' ENABLE_BUDGETARY_CONTROL_FLAG, pkt.rowid FROM_ROW_ID, pkt.reference2 TO_ROW_ID, pkt.ledger_id LEDGER_ID, pkt.packet_id GROUP_ID, src.user_je_source_name USER_JE_SOURCE_NAME, src.je_source_name JE_SOURCE_NAME, cat.user_je_category_name USER_JE_CATEGORY_NAME, cat.je_category_name JE_CATEGORY_NAME, pkt.period_name PERIOD_NAME, pkt.period_year PERIOD_YEAR, pkt.period_num PERIOD_NUM, pkt.quarter_num QUARTER_NUM, pkt.actual_flag ACTUAL_FLAG, pkt.budget_version_id BUDGET_VERSION_ID, pkt.currency_code CURRENCY_CODE, pkt.code_combination_id FROM_CODE_COMBINATION_ID, to_number(pkt.reference1) COMBINATION_NUMBER, abs( nvl(pkt.entered_dr, 0) - nvl(pkt.entered_cr, 0)) TRANSFER_AMOUNT, pkt.entered_dr FROM_ENTERED_DR, pkt.entered_cr FROM_ENTERED_CR, to_pkt.entered_dr TO_ENTERED_DR, to_pkt.entered_cr TO_ENTERED_CR, sysdate ACCOUNTED_DATE, pkt.reference1 JE_BATCH_NAME, sysdate CREATION_DATE, 0 CREATED_BY, pkt.status_code STATUS, pkt.last_update_date LAST_UPDATE_DATE, pkt.last_updated_by LAST_UPDATED_BY FROM gl_bc_packets pkt, gl_je_sources src, gl_je_categories cat, gl_bc_packets to_pkt WHERE pkt.je_source_name = 'Transfer' AND pkt.je_category_name = 'Budget' AND src.je_source_name = pkt.je_source_name AND cat.je_category_name = pkt.je_category_name AND to_pkt.rowid = pkt.reference2

View Text - HTML Formatted

SELECT 'N' ENABLE_BUDGETARY_CONTROL_FLAG
, INT.ROWID FROM_ROW_ID
, INT.STATUS_DESCRIPTION TO_ROW_ID
, INT.LEDGER_ID LEDGER_ID
, INT.GROUP_ID GROUP_ID
, SRC.USER_JE_SOURCE_NAME USER_JE_SOURCE_NAME
, SRC.JE_SOURCE_NAME JE_SOURCE_NAME
, CAT.USER_JE_CATEGORY_NAME USER_JE_CATEGORY_NAME
, CAT.JE_CATEGORY_NAME JE_CATEGORY_NAME
, INT.PERIOD_NAME PERIOD_NAME
, PER.PERIOD_YEAR PERIOD_YEAR
, PER.PERIOD_NUM PERIOD_NUM
, PER.QUARTER_NUM QUARTER_NUM
, INT.ACTUAL_FLAG ACTUAL_FLAG
, INT.BUDGET_VERSION_ID BUDGET_VERSION_ID
, INT.CURRENCY_CODE CURRENCY_CODE
, INT.CODE_COMBINATION_ID FROM_CODE_COMBINATION_ID
, INT.JE_BATCH_ID COMBINATION_NUMBER
, ABS( NVL(INT.ENTERED_DR
, 0) - NVL(INT.ENTERED_CR
, 0)) TRANSFER_AMOUNT
, INT.ENTERED_DR FROM_ENTERED_DR
, INT.ENTERED_CR FROM_ENTERED_CR
, TO_INT.ENTERED_DR TO_ENTERED_DR
, TO_INT.ENTERED_CR TO_ENTERED_CR
, INT.ACCOUNTING_DATE ACCOUNTED_DATE
, INT.REFERENCE1 JE_BATCH_NAME
, INT.DATE_CREATED CREATION_DATE
, INT.CREATED_BY CREATED_BY
, INT.STATUS STATUS
, SYSDATE LAST_UPDATE_DATE
, 0 LAST_UPDATED_BY
FROM GL_JE_SOURCES SRC
, GL_INTERFACE INT
, GL_JE_CATEGORIES CAT
, GL_PERIOD_STATUSES PER
, GL_INTERFACE TO_INT
WHERE SRC.JE_SOURCE_NAME = 'TRANSFER'
AND INT.USER_JE_SOURCE_NAME = SRC.USER_JE_SOURCE_NAME
AND CAT.JE_CATEGORY_NAME = 'BUDGET'
AND CAT.USER_JE_CATEGORY_NAME = INT.USER_JE_CATEGORY_NAME
AND PER.APPLICATION_ID = 101
AND PER.LEDGER_ID = INT.LEDGER_ID
AND PER.PERIOD_NAME = INT.PERIOD_NAME
AND TO_INT.ROWID = INT.STATUS_DESCRIPTION UNION SELECT 'Y' ENABLE_BUDGETARY_CONTROL_FLAG
, PKT.ROWID FROM_ROW_ID
, PKT.REFERENCE2 TO_ROW_ID
, PKT.LEDGER_ID LEDGER_ID
, PKT.PACKET_ID GROUP_ID
, SRC.USER_JE_SOURCE_NAME USER_JE_SOURCE_NAME
, SRC.JE_SOURCE_NAME JE_SOURCE_NAME
, CAT.USER_JE_CATEGORY_NAME USER_JE_CATEGORY_NAME
, CAT.JE_CATEGORY_NAME JE_CATEGORY_NAME
, PKT.PERIOD_NAME PERIOD_NAME
, PKT.PERIOD_YEAR PERIOD_YEAR
, PKT.PERIOD_NUM PERIOD_NUM
, PKT.QUARTER_NUM QUARTER_NUM
, PKT.ACTUAL_FLAG ACTUAL_FLAG
, PKT.BUDGET_VERSION_ID BUDGET_VERSION_ID
, PKT.CURRENCY_CODE CURRENCY_CODE
, PKT.CODE_COMBINATION_ID FROM_CODE_COMBINATION_ID
, TO_NUMBER(PKT.REFERENCE1) COMBINATION_NUMBER
, ABS( NVL(PKT.ENTERED_DR
, 0) - NVL(PKT.ENTERED_CR
, 0)) TRANSFER_AMOUNT
, PKT.ENTERED_DR FROM_ENTERED_DR
, PKT.ENTERED_CR FROM_ENTERED_CR
, TO_PKT.ENTERED_DR TO_ENTERED_DR
, TO_PKT.ENTERED_CR TO_ENTERED_CR
, SYSDATE ACCOUNTED_DATE
, PKT.REFERENCE1 JE_BATCH_NAME
, SYSDATE CREATION_DATE
, 0 CREATED_BY
, PKT.STATUS_CODE STATUS
, PKT.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PKT.LAST_UPDATED_BY LAST_UPDATED_BY
FROM GL_BC_PACKETS PKT
, GL_JE_SOURCES SRC
, GL_JE_CATEGORIES CAT
, GL_BC_PACKETS TO_PKT
WHERE PKT.JE_SOURCE_NAME = 'TRANSFER'
AND PKT.JE_CATEGORY_NAME = 'BUDGET'
AND SRC.JE_SOURCE_NAME = PKT.JE_SOURCE_NAME
AND CAT.JE_CATEGORY_NAME = PKT.JE_CATEGORY_NAME
AND TO_PKT.ROWID = PKT.REFERENCE2