FND Design Data [Home] [Help]

Table: MR_TRAN_TBL

Product: GMP - Process Manufacturing Process Planning
Description: MRP transactions.
Implementation/DBA Data: TableGMP.MR_TRAN_TBL
Primary Key: MR_TRAN_TBLI1
  1. ColumnMRP_ID
  2. ColumnITEM_ID
  3. ColumnWHSE_CODE
  4. ColumnTRANS_DATE
  5. ColumnLINE_NO
Primary Key: MR_TRAN_TBL_PK
  1. ColumnMRP_ID
  2. ColumnLINE_NO
Foreign Keys
Table
Foreign Table Foreign Key Column
MR_TRAN_TBL FK Joins to TableIC_ITEM_MST_B MR_TRAN_TBL.ITEM_ID
MR_TRAN_TBL FK Joins to TableIC_ITEM_MST MR_TRAN_TBL.ITEM_ID
MR_TRAN_TBL FK Joins to TableIC_WHSE_MST MR_TRAN_TBL.WHSE_CODE
MR_TRAN_TBL FK Joins to TableMR_PARM_DTL MR_TRAN_TBL.MRP_ID
MR_TRAN_TBL FK Joins to TableSY_ORGN_MST_B MR_TRAN_TBL.ORGN_CODE
MR_TRAN_TBL FK Joins to TableSY_ORGN_MST_B MR_TRAN_TBL.CO_CODE
MR_TRAN_TBL FK Joins to TableSY_ORGN_MST MR_TRAN_TBL.ORGN_CODE
MR_TRAN_TBL FK Joins to TableSY_ORGN_MST MR_TRAN_TBL.CO_CODE
MR_TRAN_TBL FK Joins to TableSY_UOMS_MST MR_TRAN_TBL.TRANS_UM