FND Design Data [Home] [Help]

Table: EAM_OP_COMPLETION_TXNS

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