VIEW: XLA.XLA_BALANCE_STATUSES#

Source

View Text - Preformatted

select APPLICATION_ID APPLICATION_ID, LEDGER_ID LEDGER_ID, CODE_COMBINATION_ID CODE_COMBINATION_ID, BALANCE_SOURCE_CODE BALANCE_SOURCE_CODE, BALANCE_STATUS_CODE BALANCE_STATUS_CODE, EFFECTIVE_PERIOD_NUM EFFECTIVE_PERIOD_NUM, RECREATE_PARTY_TYPE_CODE RECREATE_PARTY_TYPE_CODE, RECREATE_PARTY_ID RECREATE_PARTY_ID, RECREATE_PARTY_SITE_ID RECREATE_PARTY_SITE_ID, BALANCING_SEGMENT BALANCING_SEGMENT, NATURAL_ACCOUNT_SEGMENT NATURAL_ACCOUNT_SEGMENT, ACCOUNT_TYPE ACCOUNT_TYPE, WARNING_FLAG WARNING_FLAG, RECREATE_EFFECTIVE_PERIOD_NUM RECREATE_EFFECTIVE_PERIOD_NUM, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, REQUEST_ID REQUEST_ID from "XLA"."XLA_BALANCE_STATUSES"

View Text - HTML Formatted

SELECT APPLICATION_ID APPLICATION_ID
, LEDGER_ID LEDGER_ID
, CODE_COMBINATION_ID CODE_COMBINATION_ID
, BALANCE_SOURCE_CODE BALANCE_SOURCE_CODE
, BALANCE_STATUS_CODE BALANCE_STATUS_CODE
, EFFECTIVE_PERIOD_NUM EFFECTIVE_PERIOD_NUM
, RECREATE_PARTY_TYPE_CODE RECREATE_PARTY_TYPE_CODE
, RECREATE_PARTY_ID RECREATE_PARTY_ID
, RECREATE_PARTY_SITE_ID RECREATE_PARTY_SITE_ID
, BALANCING_SEGMENT BALANCING_SEGMENT
, NATURAL_ACCOUNT_SEGMENT NATURAL_ACCOUNT_SEGMENT
, ACCOUNT_TYPE ACCOUNT_TYPE
, WARNING_FLAG WARNING_FLAG
, RECREATE_EFFECTIVE_PERIOD_NUM RECREATE_EFFECTIVE_PERIOD_NUM
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, REQUEST_ID REQUEST_ID
FROM "XLA"."XLA_BALANCE_STATUSES"