View: GL_TRANSLATION_STATUSES_V

Product:	GL - General Ledger
Description:
Implementation/DBA Data:	APPS.GL_TRANSLATION_STATUSES_V

View Text

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

Columns