FND Design Data [Home] [Help]

Table: GL_PERIOD_STATUSES

Product: GL - General Ledger
Description: Calendar period statuses
Implementation/DBA Data: TableGL.GL_PERIOD_STATUSES
Primary Key: GL_PERIOD_STATUSES_PK
  1. ColumnAPPLICATION_ID
  2. ColumnSET_OF_BOOKS_ID
  3. ColumnPERIOD_NAME
Primary Key: GL_PERIOD_STATUSES_UK1
  1. ColumnAPPLICATION_ID
  2. ColumnSET_OF_BOOKS_ID
  3. ColumnPERIOD_YEAR
  4. ColumnPERIOD_NUM
Foreign Keys
Table
Foreign Table Foreign Key Column
GL_PERIOD_STATUSES FK Joins to Table% GL_PERIOD_STATUSES.SET_OF_BOOKS_ID
GL_PERIOD_STATUSES FK Joins to TableGL_PERIOD_TYPES GL_PERIOD_STATUSES.PERIOD_TYPE
GL_PERIOD_STATUSES FK Joins to TableFND_APPLICATION GL_PERIOD_STATUSES.APPLICATION_ID
TableAX_BALANCES FK Joins to GL_PERIOD_STATUSES AX_BALANCES.APPLICATION_ID
AX_BALANCES.SET_OF_BOOKS_ID
AX_BALANCES.PERIOD_NAME
TableAX_SLE_HEADERS FK Joins to GL_PERIOD_STATUSES AX_SLE_HEADERS.APPLICATION_ID
AX_SLE_HEADERS.SET_OF_BOOKS_ID
AX_SLE_HEADERS.PERIOD_NAME