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: FA_MAINT_SCHEDULE_HDR

Product:	OFA - Assets
Description:	Stores information about maintenance scheduling requests
Implementation/DBA Data:	FA.FA_MAINT_SCHEDULE_HDR

Primary Key: FA_MAINT_SCHEDULE_HDR_PK

SCHEDULE_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
FA_MAINT_SCHEDULE_HDR	FA_BOOK_CONTROLS	FA_MAINT_SCHEDULE_HDR.BOOK_TYPE_CODE
FA_MAINT_SCHEDULE_HDR	FA_ADDITIONS_B	FA_MAINT_SCHEDULE_HDR.FROM_ASSET_NUMBER
FA_MAINT_SCHEDULE_HDR	FA_ADDITIONS_B	FA_MAINT_SCHEDULE_HDR.TO_ASSET_NUMBER
FA_MAINT_SCHEDULE_HDR	FA_CATEGORIES_B	FA_MAINT_SCHEDULE_HDR.CATEGORY_ID
FA_MAINT_SCHEDULE_HDR	FA_LOCATIONS	FA_MAINT_SCHEDULE_HDR.LOCATION_ID
FA_MAINT_SCHEDULE_HDR	FND_CURRENCIES	FA_MAINT_SCHEDULE_HDR.CURRENCY_CODE
FA_MAINT_SCHEDULE_HDR	FND_CONCURRENT_REQUESTS	FA_MAINT_SCHEDULE_HDR.CONCURRENT_REQUEST_ID