View: GL_BUDGET_ENTITIES_CURRENT_V

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

View Text

SELECT BE.BUDGET_ENTITY_ID BUDGET_ENTITY_ID
, BE.NAME NAME
, BE.LEDGER_ID LEDGER_ID
, BE.BUDGET_PASSWORD_REQUIRED_FLAG BUDGET_PASSWORD_REQUIRED_FLAG
, BE.ENCRYPTED_BUDGET_PASSWORD ENCRYPTED_BUDGET_PASSWORD
, BE.DESCRIPTION DESCRIPTION
, BE.SEGMENT1_TYPE SEGMENT1_TYPE
, BE.SEGMENT2_TYPE SEGMENT2_TYPE
, BE.SEGMENT3_TYPE SEGMENT3_TYPE
, BE.SEGMENT4_TYPE SEGMENT4_TYPE
, BE.SEGMENT5_TYPE SEGMENT5_TYPE
, BE.SEGMENT6_TYPE SEGMENT6_TYPE
, BE.SEGMENT7_TYPE SEGMENT7_TYPE
, BE.SEGMENT8_TYPE SEGMENT8_TYPE
, BE.SEGMENT9_TYPE SEGMENT9_TYPE
, BE.SEGMENT10_TYPE SEGMENT10_TYPE
, BE.SEGMENT11_TYPE SEGMENT11_TYPE
, BE.SEGMENT12_TYPE SEGMENT12_TYPE
, BE.SEGMENT13_TYPE SEGMENT13_TYPE
, BE.SEGMENT14_TYPE SEGMENT14_TYPE
, BE.SEGMENT15_TYPE SEGMENT15_TYPE
, BE.SEGMENT16_TYPE SEGMENT16_TYPE
, BE.SEGMENT17_TYPE SEGMENT17_TYPE
, BE.SEGMENT18_TYPE SEGMENT18_TYPE
, BE.SEGMENT19_TYPE SEGMENT19_TYPE
, BE.SEGMENT20_TYPE SEGMENT20_TYPE
, BE.SEGMENT21_TYPE SEGMENT21_TYPE
, BE.SEGMENT22_TYPE SEGMENT22_TYPE
, BE.SEGMENT23_TYPE SEGMENT23_TYPE
, BE.SEGMENT24_TYPE SEGMENT24_TYPE
, BE.SEGMENT25_TYPE SEGMENT25_TYPE
, BE.SEGMENT26_TYPE SEGMENT26_TYPE
, BE.SEGMENT27_TYPE SEGMENT27_TYPE
, BE.SEGMENT28_TYPE SEGMENT28_TYPE
, BE.SEGMENT29_TYPE SEGMENT29_TYPE
, BE.SEGMENT30_TYPE SEGMENT30_TYPE
, DECODE(BE.SECURITY_FLAG
, 'Y'
, DECODE(FND_DATA_SECURITY.CHECK_FUNCTION(1.0
, 'GL_DAS_BUDGET_ORG_V'
, 'GL_DAS_BUDGET_ORG'
, TO_CHAR(BE.BUDGET_ENTITY_ID)
, NULL
, NULL
, NULL
, NULL
, FND_GLOBAL.USER_NAME)
, 'T'
, 'Y'
, 'N')
, 'Y') VIEW_PRIVILEGE
, DECODE(BE.SECURITY_FLAG
, 'Y'
, DECODE(FND_DATA_SECURITY.CHECK_FUNCTION(1.0
, 'GL_DAS_BUDGET_ORG_U'
, 'GL_DAS_BUDGET_ORG'
, TO_CHAR(BE.BUDGET_ENTITY_ID)
, NULL
, NULL
, NULL
, NULL
, FND_GLOBAL.USER_NAME)
, 'T'
, 'Y'
, 'N')
, 'Y') USE_PRIVILEGE
FROM GL_BUDGET_ENTITIES BE
WHERE BE.STATUS_CODE <> 'D'
AND TRUNC(SYSDATE) BETWEEN NVL(TRUNC(START_DATE)
, TRUNC(SYSDATE - 1))
AND NVL(TRUNC(END_DATE)
, TRUNC(SYSDATE + 1))

Columns