FND Design Data [Home] [Help]

Table: EAM_JOB_COMPLETION_TXNS

Product: EAM - Enterprise Asset Management
Description: Work Order Completion Transaction History
Implementation/DBA Data: TableEAM.EAM_JOB_COMPLETION_TXNS
Primary Key: EAM_JOB_COMPLETION_TXNS_PK
  1. ColumnTRANSACTION_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
EAM_JOB_COMPLETION_TXNS FK Joins to TableMTL_SERIAL_NUMBERS EAM_JOB_COMPLETION_TXNS.ASSET_NUMBER
EAM_JOB_COMPLETION_TXNS.ASSET_GROUP_ID
EAM_JOB_COMPLETION_TXNS.ORGANIZATION_ID
EAM_JOB_COMPLETION_TXNS FK Joins to TableMTL_SYSTEM_ITEMS_B EAM_JOB_COMPLETION_TXNS.ASSET_ACTIVITY_ID
EAM_JOB_COMPLETION_TXNS.ORGANIZATION_ID
EAM_JOB_COMPLETION_TXNS FK Joins to TableORG_ACCT_PERIODS EAM_JOB_COMPLETION_TXNS.ACCT_PERIOD_ID
EAM_JOB_COMPLETION_TXNS.ORGANIZATION_ID
EAM_JOB_COMPLETION_TXNS FK Joins to TableMTL_TRANSACTION_TYPES EAM_JOB_COMPLETION_TXNS.TRANSACTION_TYPE