FND Design Data [Home] [Help]

Table: SY_ORGN_MST

Product: GMA - Process Manufacturing Systems
Description: Organization code master.
Implementation/DBA Data: Not implemented in this database
Primary Key: SY_ORGN_MST_PK
  1. ColumnORGN_CODE
Primary Key: SY_ORGN_MST_U1
  1. ColumnORGANIZATION_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
SY_ORGN_MST FK Joins to TableSY_ADDR_MST SY_ORGN_MST.ADDR_ID
SY_ORGN_MST FK Joins to TableSY_DOCS_SEQ SY_ORGN_MST.SY_ORGN_MST_DOC_TYPE
SY_ORGN_MST.SY_ORGN_MST_ORGN_CODE
SY_ORGN_MST FK Joins to TableSY_ORGN_MST SY_ORGN_MST.CO_CODE
SY_ORGN_MST FK Joins to TableSY_ORGN_MST SY_ORGN_MST.PARENT_ORGN_CODE
SY_ORGN_MST FK Joins to TableSY_TEXT_HDR SY_ORGN_MST.TEXT_CODE
SY_ORGN_MST FK Joins to TableTX_TLOC_CDS SY_ORGN_MST.TAXLOC_CODE
TableCM_BRDN_DTL FK Joins to SY_ORGN_MST CM_BRDN_DTL.ORGN_CODE
TableCM_CLDR_HDR FK Joins to SY_ORGN_MST CM_CLDR_HDR.CO_CODE
TableCM_CMPT_MTL FK Joins to SY_ORGN_MST CM_CMPT_MTL.CO_CODE
TableCM_RSRC_DTL FK Joins to SY_ORGN_MST CM_RSRC_DTL.ORGN_CODE
TableCM_WHSE_EFF FK Joins to SY_ORGN_MST CM_WHSE_EFF.ORGN_CODE
TableCM_WHSE_SRC FK Joins to SY_ORGN_MST CM_WHSE_SRC.ORGN_CODE
TableCR_RSRC_DTL FK Joins to SY_ORGN_MST CR_RSRC_DTL.ORGN_CODE
TableFC_FCST_DTL FK Joins to SY_ORGN_MST FC_FCST_DTL.ORGN_CODE
TableFM_CONF_TBL FK Joins to SY_ORGN_MST FM_CONF_TBL.ORGN_CODE
TableFM_FORM_EFF FK Joins to SY_ORGN_MST FM_FORM_EFF.ORGN_CODE
TableGL_ACCT_MAP FK Joins to SY_ORGN_MST GL_ACCT_MAP.ORGN_CODE
TableGL_ACCU_MAP FK Joins to SY_ORGN_MST GL_ACCU_MAP.ORGN_CODE
TableGL_ITEM_CST FK Joins to SY_ORGN_MST GL_ITEM_CST.ORGN_CODE
TableGL_LEDG_MAP FK Joins to SY_ORGN_MST GL_LEDG_MAP.ORGN_CODE
TableGL_PLCY_MST FK Joins to SY_ORGN_MST GL_PLCY_MST.CO_CODE
TableGL_SETU_ERR FK Joins to SY_ORGN_MST GL_SETU_ERR.CO_CODE
TableGMF_BURDEN_PRIORITIES FK Joins to SY_ORGN_MST GMF_BURDEN_PRIORITIES.CO_CODE
TableGMP_FORM_EFF FK Joins to SY_ORGN_MST GMP_FORM_EFF.PLANT_CODE
TableGMP_ITEM_APS FK Joins to SY_ORGN_MST GMP_ITEM_APS.PLANT_CODE
TableIC_ADJS_JNL FK Joins to SY_ORGN_MST IC_ADJS_JNL.ORGN_CODE
TableIC_ADJS_JNL FK Joins to SY_ORGN_MST IC_ADJS_JNL.CO_CODE
TableIC_CLDR_HDR FK Joins to SY_ORGN_MST IC_CLDR_HDR.ORGN_CODE
TableIC_CYCL_HDR FK Joins to SY_ORGN_MST IC_CYCL_HDR.ORGN_CODE
TableIC_JRNL_MST FK Joins to SY_ORGN_MST IC_JRNL_MST.ORGN_CODE
TableIC_PLNT_INV FK Joins to SY_ORGN_MST IC_PLNT_INV.ORGN_CODE
TableIC_TRAN_ARC FK Joins to SY_ORGN_MST IC_TRAN_ARC.ORGN_CODE
TableIC_TRAN_ARC FK Joins to SY_ORGN_MST IC_TRAN_ARC.CO_CODE
TableIC_TRAN_CMP FK Joins to SY_ORGN_MST IC_TRAN_CMP.ORGN_CODE
TableIC_TRAN_CMP FK Joins to SY_ORGN_MST IC_TRAN_CMP.CO_CODE
TableIC_TRAN_PND FK Joins to SY_ORGN_MST IC_TRAN_PND.ORGN_CODE
TableIC_TRAN_PND FK Joins to SY_ORGN_MST IC_TRAN_PND.CO_CODE
TableIC_WHSE_MST FK Joins to SY_ORGN_MST IC_WHSE_MST.ORGN_CODE
TableIC_XFER_MST FK Joins to SY_ORGN_MST IC_XFER_MST.ORGN_CODE
TableMR_ACTN_TBL FK Joins to SY_ORGN_MST MR_ACTN_TBL.ORGN_CODE
TableMR_MESG_TBL FK Joins to SY_ORGN_MST MR_MESG_TBL.ORGN_CODE
TableMR_TRAN_TBL FK Joins to SY_ORGN_MST MR_TRAN_TBL.ORGN_CODE
TableMR_TRAN_TBL FK Joins to SY_ORGN_MST MR_TRAN_TBL.CO_CODE
TableOP_BILL_LAD FK Joins to SY_ORGN_MST OP_BILL_LAD.ORGN_CODE
TableOP_CUST_MST FK Joins to SY_ORGN_MST OP_CUST_MST.CO_CODE
TableOP_ORDR_HDR FK Joins to SY_ORGN_MST OP_ORDR_HDR.ORGN_CODE
TableOP_PRCE_EFF FK Joins to SY_ORGN_MST OP_PRCE_EFF.ORGN_CODE
TableOP_SLSR_MST FK Joins to SY_ORGN_MST OP_SLSR_MST.CO_CODE
TablePC_TRAN_PND FK Joins to SY_ORGN_MST PC_TRAN_PND.ORGN_CODE
TablePM_BTCH_HDR FK Joins to SY_ORGN_MST PM_BTCH_HDR.PLANT_CODE
TablePO_BPOS_HDR FK Joins to SY_ORGN_MST PO_BPOS_HDR.ORGN_CODE
TablePO_DIST_DTL FK Joins to SY_ORGN_MST PO_DIST_DTL.CO_CODE
TablePO_ORDR_HDR FK Joins to SY_ORGN_MST PO_ORDR_HDR.ORGN_CODE
TablePO_RECV_HDR FK Joins to SY_ORGN_MST PO_RECV_HDR.ORGN_CODE
TablePO_RTRN_HDR FK Joins to SY_ORGN_MST PO_RTRN_HDR.ORGN_CODE
TablePO_VEND_MST FK Joins to SY_ORGN_MST PO_VEND_MST.CO_CODE
TablePS_SCHD_DTL FK Joins to SY_ORGN_MST PS_SCHD_DTL.ORGN_CODE
TablePS_SCHD_HDR FK Joins to SY_ORGN_MST PS_SCHD_HDR.ORGN_CODE
TablePS_WHSE_EFF FK Joins to SY_ORGN_MST PS_WHSE_EFF.PLANT_CODE
TableQC_ASSY_TYP FK Joins to SY_ORGN_MST QC_ASSY_TYP.ORGN_CODE
TableQC_RSLT_MST FK Joins to SY_ORGN_MST QC_RSLT_MST.ORGN_CODE
TableQC_SMPL_MST FK Joins to SY_ORGN_MST QC_SMPL_MST.ORGN_CODE
TableQC_SPEC_MST FK Joins to SY_ORGN_MST QC_SPEC_MST.ORGN_CODE
TableRH_MORD_IMP FK Joins to SY_ORGN_MST RH_MORD_IMP.ORGN_CODE
TableSY_SOFT_DTL FK Joins to SY_ORGN_MST SY_SOFT_DTL.CO_CODE
TableSY_CMPY_MST FK Joins to SY_ORGN_MST SY_CMPY_MST.CO_CODE
TableSY_DOCS_SEQ FK Joins to SY_ORGN_MST SY_DOCS_SEQ.ORGN_CODE
TableSY_DOCS_SEQ FK Joins to SY_ORGN_MST SY_DOCS_SEQ.SY_DOCS_SEQ_ORGN_CODE
TableSY_DOCS_SEQ FK Joins to SY_ORGN_MST SY_DOCS_SEQ.SY_DOCS_SEQ_ORGN_CODE2
TableSY_DOCS_SEQ FK Joins to SY_ORGN_MST SY_DOCS_SEQ.SY_DOCS_SEQ_ORGN_CODE3
TableSY_EXCP_TBL FK Joins to SY_ORGN_MST SY_EXCP_TBL.CO_CODE
TableSY_ORGN_MST FK Joins to SY_ORGN_MST SY_ORGN_MST.CO_CODE
TableSY_ORGN_MST FK Joins to SY_ORGN_MST SY_ORGN_MST.PARENT_ORGN_CODE
TableSY_ORGN_USR FK Joins to SY_ORGN_MST SY_ORGN_USR.ORGN_CODE