View: GL_BUDGET_TRANSFER_V

Product:	GL - General Ledger
Description:	10SC ONLY
Implementation/DBA Data:	APPS.GL_BUDGET_TRANSFER_V

View Text

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

Columns