eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[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:	JA.JAI_PO_OSP_FORM_NUMBERS

Primary Key: JAI_PO_OSP_FORM_NUMBERS_PK

FORM_NUM_GENERATOR_ID

Primary Key: JAI_PO_OSP_FORM_NUMBERS_UK1

ORGANIZATION_ID
LOCATION_ID
FIN_YEAR

Foreign Keys

Table		Foreign Table	Foreign Key Column
JAI_PO_OSP_FORM_NUMBERS		HR_ALL_ORGANIZATION_UNITS	JAI_PO_OSP_FORM_NUMBERS.ORGANIZATION_ID
JAI_PO_OSP_FORM_NUMBERS		HR_LOCATIONS_ALL	JAI_PO_OSP_FORM_NUMBERS.LOCATION_ID