VIEW: APPS.GL_TRANSLATION_STATUSES_V

Source

View Text - Preformatted

SELECT PS.period_name PERIOD, PS.period_year PERIOD_YEAR, PS.period_num PERIOD_NUM, TS.ledger_id LEDGER_ID, TS.target_currency CURRENCY_CODE, TS.actual_flag ACTUAL_FLAG, TS.bal_seg_value BALANCING_SEGMENT_VALUE, TS.status STATUS, TS.last_run_date DATE_LAST_RUN, BV.budget_name TARGET_BUDGET_NAME, TS.target_budget_version_id TARGET_BUDGET_VERSION_ID, TS.average_translation_flag AVERAGE_TRANSLATION_FLAG, TS.rowid ROW_ID, TS.creation_date CREATION_DATE, TS.created_by CREATED_BY, TS.last_update_date LAST_UPDATE_DATE, TS.last_updated_by LAST_UPDATED_BY, TS.last_update_login LAST_UPDATE_LOGIN, TS.request_id REQ_ID, TS.program_application_id PROGRAM_APPLICATION_ID, TS.program_id PROGRAM_ID, TS.program_update_date PROGRAM_UPDATE_ID FROM gl_translation_statuses TS, gl_budget_versions BV, gl_period_statuses PS WHERE PS.application_id = 101 AND TS.ledger_id = PS.ledger_id AND TS.period_name = PS.period_name AND TS.target_budget_version_id = BV.budget_version_id(+)

View Text - HTML Formatted

SELECT PS.PERIOD_NAME PERIOD
, PS.PERIOD_YEAR PERIOD_YEAR
, PS.PERIOD_NUM PERIOD_NUM
, TS.LEDGER_ID LEDGER_ID
, TS.TARGET_CURRENCY CURRENCY_CODE
, TS.ACTUAL_FLAG ACTUAL_FLAG
, TS.BAL_SEG_VALUE BALANCING_SEGMENT_VALUE
, TS.STATUS STATUS
, TS.LAST_RUN_DATE DATE_LAST_RUN
, BV.BUDGET_NAME TARGET_BUDGET_NAME
, TS.TARGET_BUDGET_VERSION_ID TARGET_BUDGET_VERSION_ID
, TS.AVERAGE_TRANSLATION_FLAG AVERAGE_TRANSLATION_FLAG
, TS.ROWID ROW_ID
, TS.CREATION_DATE CREATION_DATE
, TS.CREATED_BY CREATED_BY
, TS.LAST_UPDATE_DATE LAST_UPDATE_DATE
, TS.LAST_UPDATED_BY LAST_UPDATED_BY
, TS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TS.REQUEST_ID REQ_ID
, TS.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, TS.PROGRAM_ID PROGRAM_ID
, TS.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_ID
FROM GL_TRANSLATION_STATUSES TS
, GL_BUDGET_VERSIONS BV
, GL_PERIOD_STATUSES PS
WHERE PS.APPLICATION_ID = 101
AND TS.LEDGER_ID = PS.LEDGER_ID
AND TS.PERIOD_NAME = PS.PERIOD_NAME
AND TS.TARGET_BUDGET_VERSION_ID = BV.BUDGET_VERSION_ID(+)