FND Design Data [Home] [Help]

Table: MR_ACTN_TBL

Product: GMP - Process Manufacturing Process Planning
Description: MRP Action messages.
Implementation/DBA Data: TableGMP.MR_ACTN_TBL
Primary Key: MR_ACTN_TBLI1
  1. ColumnMRP_ID
  2. ColumnITEM_ID
  3. ColumnWHSE_CODE
  4. ColumnEVENT_DATE
  5. ColumnACTION_NO
Primary Key: MR_ACTN_TBL_PK
  1. ColumnMRP_ID
  2. ColumnACTION_NO
Foreign Keys
Table
Foreign Table Foreign Key Column
MR_ACTN_TBL FK Joins to TableFM_FORM_MST MR_ACTN_TBL.FORMULA_ID
MR_ACTN_TBL FK Joins to TableIC_ITEM_MST_B MR_ACTN_TBL.ITEM_ID
MR_ACTN_TBL FK Joins to TableIC_ITEM_MST MR_ACTN_TBL.ITEM_ID
MR_ACTN_TBL FK Joins to TableIC_WHSE_MST MR_ACTN_TBL.WHSE_CODE
MR_ACTN_TBL FK Joins to TableIC_WHSE_MST MR_ACTN_TBL.WHSE_CODE_2
MR_ACTN_TBL FK Joins to TableMR_PARM_DTL MR_ACTN_TBL.MRP_ID
MR_ACTN_TBL FK Joins to TableSY_DOCS_MST MR_ACTN_TBL.DOC_TYPE
MR_ACTN_TBL FK Joins to TableSY_ORGN_MST_B MR_ACTN_TBL.ORGN_CODE
MR_ACTN_TBL FK Joins to TableSY_ORGN_MST MR_ACTN_TBL.ORGN_CODE
TableMR_PEGG_TBL FK Joins to MR_ACTN_TBL MR_PEGG_TBL.MRP_ID
MR_PEGG_TBL.ACTION_NO