FND Design Data [Home] [Help]

Table: JAI_PO_OSP_FORM_NUMBERS

Product: JA - Asia/Pacific Localizations
Description: Holds unique combination of OrganizationID, LocationID, Fin_Year as 57F4 Form No
Implementation/DBA Data: TableJA.JAI_PO_OSP_FORM_NUMBERS
Primary Key: JAI_PO_OSP_FORM_NUMBERS_PK
  1. ColumnFORM_NUM_GENERATOR_ID
Primary Key: JAI_PO_OSP_FORM_NUMBERS_UK1
  1. ColumnORGANIZATION_ID
  2. ColumnLOCATION_ID
  3. ColumnFIN_YEAR
Foreign Keys
Table
Foreign Table Foreign Key Column
JAI_PO_OSP_FORM_NUMBERS FK Joins to TableHR_ALL_ORGANIZATION_UNITS JAI_PO_OSP_FORM_NUMBERS.ORGANIZATION_ID
JAI_PO_OSP_FORM_NUMBERS FK Joins to TableHR_LOCATIONS_ALL JAI_PO_OSP_FORM_NUMBERS.LOCATION_ID