VIEW: APPS.GL_BUDGET_ENTITIES_CURRENT_V

Source

View Text - Preformatted

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))

View Text - HTML Formatted

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))