FND Design Data [Home] [Help]

Table: PS_WHSE_EFF

Product: GMP - Process Manufacturing Process Planning
Description: Plant-warehouse relationship (effectivity).
Implementation/DBA Data: TableGMP.PS_WHSE_EFF
Primary Key: PS_WHSE_EFF_PK
  1. ColumnPSWHSE_EFF_ID
Primary Key: PS_WHSE_EFF_U1
  1. ColumnPLANT_CODE
  2. ColumnWHSE_CODE
  3. ColumnWHSE_ITEM_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PS_WHSE_EFF FK Joins to TableIC_ITEM_MST_B PS_WHSE_EFF.WHSE_ITEM_ID
PS_WHSE_EFF FK Joins to TableIC_ITEM_MST PS_WHSE_EFF.WHSE_ITEM_ID
PS_WHSE_EFF FK Joins to TableIC_WHSE_MST PS_WHSE_EFF.WHSE_CODE
PS_WHSE_EFF FK Joins to TablePS_TEXT_HDR PS_WHSE_EFF.TEXT_CODE
PS_WHSE_EFF FK Joins to TableSY_ORGN_MST_B PS_WHSE_EFF.PLANT_CODE
PS_WHSE_EFF FK Joins to TableSY_ORGN_MST PS_WHSE_EFF.PLANT_CODE