FND Design Data [Home] [Help]

Table: SY_ORGN_MST_B

Product: GMA - Process Manufacturing Systems
Description: Organization code master Base Table.
Implementation/DBA Data: TableGMA.SY_ORGN_MST_B
Primary Key: SY_ORGN_MST_B_PK
  1. ColumnORGN_CODE
Primary Key: SY_ORGN_MST_B_U1
  1. ColumnORGANIZATION_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
SY_ORGN_MST_B FK Joins to TableSY_ADDR_MST SY_ORGN_MST_B.ADDR_ID
SY_ORGN_MST_B FK Joins to TableSY_DOCS_SEQ SY_ORGN_MST_B.SY_ORGN_MST_DOC_TYPE
SY_ORGN_MST_B.SY_ORGN_MST_ORGN_CODE
SY_ORGN_MST_B FK Joins to TableSY_ORGN_MST_B SY_ORGN_MST_B.CO_CODE
SY_ORGN_MST_B FK Joins to TableSY_ORGN_MST_B SY_ORGN_MST_B.PARENT_ORGN_CODE
SY_ORGN_MST_B FK Joins to TableSY_TEXT_HDR SY_ORGN_MST_B.TEXT_CODE
SY_ORGN_MST_B FK Joins to TableTX_TLOC_CDS SY_ORGN_MST_B.TAXLOC_CODE
TableCM_BRDN_DTL FK Joins to SY_ORGN_MST_B CM_BRDN_DTL.ORGN_CODE
TableCM_CLDR_HDR_B FK Joins to SY_ORGN_MST_B CM_CLDR_HDR_B.CO_CODE
TableCM_CMPT_MTL FK Joins to SY_ORGN_MST_B CM_CMPT_MTL.CO_CODE
TableCM_RSRC_DTL FK Joins to SY_ORGN_MST_B CM_RSRC_DTL.ORGN_CODE
TableCM_WHSE_EFF FK Joins to SY_ORGN_MST_B CM_WHSE_EFF.ORGN_CODE
TableCM_WHSE_SRC FK Joins to SY_ORGN_MST_B CM_WHSE_SRC.ORGN_CODE
TableCR_RSRC_DTL FK Joins to SY_ORGN_MST_B CR_RSRC_DTL.ORGN_CODE
TableFC_FCST_DTL FK Joins to SY_ORGN_MST_B FC_FCST_DTL.ORGN_CODE
TableFM_CONF_TBL FK Joins to SY_ORGN_MST_B FM_CONF_TBL.ORGN_CODE
TableGL_ACCT_MAP FK Joins to SY_ORGN_MST_B GL_ACCT_MAP.ORGN_CODE
TableGL_ACCU_MAP FK Joins to SY_ORGN_MST_B GL_ACCU_MAP.ORGN_CODE
TableGL_ITEM_CST FK Joins to SY_ORGN_MST_B GL_ITEM_CST.ORGN_CODE
TableGL_LEDG_MAP FK Joins to SY_ORGN_MST_B GL_LEDG_MAP.ORGN_CODE
TableGL_PLCY_MST FK Joins to SY_ORGN_MST_B GL_PLCY_MST.CO_CODE
TableGL_SETU_ERR FK Joins to SY_ORGN_MST_B GL_SETU_ERR.CO_CODE
TableGMD_RECIPE_PROCESS_PARAMETERS FK Joins to SY_ORGN_MST_B GMD_RECIPE_PROCESS_PARAMETERS.ORGN_CODE
TableGMD_TESTS_B FK Joins to SY_ORGN_MST_B GMD_TESTS_B.ORGN_CODE
TableGMF_BURDEN_PERCENTAGES FK Joins to SY_ORGN_MST_B GMF_BURDEN_PERCENTAGES.ORGN_CODE
TableGMF_BURDEN_PRIORITIES FK Joins to SY_ORGN_MST_B GMF_BURDEN_PRIORITIES.CO_CODE
TableGMP_FORM_EFF FK Joins to SY_ORGN_MST_B GMP_FORM_EFF.PLANT_CODE
TableGMP_ITEM_APS FK Joins to SY_ORGN_MST_B GMP_ITEM_APS.PLANT_CODE
TableGMP_ITEM_WPS FK Joins to SY_ORGN_MST_B GMP_ITEM_WPS.PLANT_CODE
TableGR_OTHER_NAMES_TL FK Joins to SY_ORGN_MST_B GR_OTHER_NAMES_TL.ORGN_CODE
TableIC_ADJS_JNL FK Joins to SY_ORGN_MST_B IC_ADJS_JNL.ORGN_CODE
TableIC_ADJS_JNL FK Joins to SY_ORGN_MST_B IC_ADJS_JNL.CO_CODE
TableIC_CLDR_HDR_B FK Joins to SY_ORGN_MST_B IC_CLDR_HDR_B.ORGN_CODE
TableIC_CYCL_HDR FK Joins to SY_ORGN_MST_B IC_CYCL_HDR.ORGN_CODE
TableIC_JRNL_MST FK Joins to SY_ORGN_MST_B IC_JRNL_MST.ORGN_CODE
TableIC_PLNT_INV FK Joins to SY_ORGN_MST_B IC_PLNT_INV.ORGN_CODE
TableIC_TRAN_ARC FK Joins to SY_ORGN_MST_B IC_TRAN_ARC.ORGN_CODE
TableIC_TRAN_ARC FK Joins to SY_ORGN_MST_B IC_TRAN_ARC.CO_CODE
TableIC_TRAN_CMP FK Joins to SY_ORGN_MST_B IC_TRAN_CMP.ORGN_CODE
TableIC_TRAN_CMP FK Joins to SY_ORGN_MST_B IC_TRAN_CMP.CO_CODE
TableIC_TRAN_PND FK Joins to SY_ORGN_MST_B IC_TRAN_PND.ORGN_CODE
TableIC_TRAN_PND FK Joins to SY_ORGN_MST_B IC_TRAN_PND.CO_CODE
TableIC_WHSE_MST FK Joins to SY_ORGN_MST_B IC_WHSE_MST.ORGN_CODE
TableIC_XFER_MST FK Joins to SY_ORGN_MST_B IC_XFER_MST.ORGN_CODE
TableMR_ACTN_TBL FK Joins to SY_ORGN_MST_B MR_ACTN_TBL.ORGN_CODE
TableMR_MESG_TBL FK Joins to SY_ORGN_MST_B MR_MESG_TBL.ORGN_CODE
TableMR_TRAN_TBL FK Joins to SY_ORGN_MST_B MR_TRAN_TBL.ORGN_CODE
TableMR_TRAN_TBL FK Joins to SY_ORGN_MST_B MR_TRAN_TBL.CO_CODE
TableOP_BILL_LAD FK Joins to SY_ORGN_MST_B OP_BILL_LAD.ORGN_CODE
TableOP_CUST_MST_OPM FK Joins to SY_ORGN_MST_B OP_CUST_MST_OPM.CO_CODE
TableOP_CUST_MST FK Joins to SY_ORGN_MST_B OP_CUST_MST.CO_CODE
TableOP_ORDR_HDR FK Joins to SY_ORGN_MST_B OP_ORDR_HDR.ORGN_CODE
TableOP_PRCE_EFF FK Joins to SY_ORGN_MST_B OP_PRCE_EFF.ORGN_CODE
TableOP_SLSR_MST FK Joins to SY_ORGN_MST_B OP_SLSR_MST.CO_CODE
TablePC_TRAN_PND FK Joins to SY_ORGN_MST_B PC_TRAN_PND.ORGN_CODE
TablePM_BTCH_HDR FK Joins to SY_ORGN_MST_B PM_BTCH_HDR.PLANT_CODE
TablePO_BPOS_HDR FK Joins to SY_ORGN_MST_B PO_BPOS_HDR.ORGN_CODE
TablePO_DIST_DTL FK Joins to SY_ORGN_MST_B PO_DIST_DTL.CO_CODE
TablePO_ORDR_HDR FK Joins to SY_ORGN_MST_B PO_ORDR_HDR.ORGN_CODE
TablePO_RECV_HDR FK Joins to SY_ORGN_MST_B PO_RECV_HDR.ORGN_CODE
TablePO_RTRN_HDR FK Joins to SY_ORGN_MST_B PO_RTRN_HDR.ORGN_CODE
TablePO_VEND_MST FK Joins to SY_ORGN_MST_B PO_VEND_MST.CO_CODE
TablePS_SCHD_DTL FK Joins to SY_ORGN_MST_B PS_SCHD_DTL.ORGN_CODE
TablePS_SCHD_HDR FK Joins to SY_ORGN_MST_B PS_SCHD_HDR.ORGN_CODE
TablePS_WHSE_EFF FK Joins to SY_ORGN_MST_B PS_WHSE_EFF.PLANT_CODE
TableQC_ASSY_TYP FK Joins to SY_ORGN_MST_B QC_ASSY_TYP.ORGN_CODE
TableQC_RSLT_MST FK Joins to SY_ORGN_MST_B QC_RSLT_MST.ORGN_CODE
TableQC_SMPL_MST FK Joins to SY_ORGN_MST_B QC_SMPL_MST.ORGN_CODE
TableQC_SPEC_MST FK Joins to SY_ORGN_MST_B QC_SPEC_MST.ORGN_CODE
TableSY_SOFT_DTL FK Joins to SY_ORGN_MST_B SY_SOFT_DTL.CO_CODE
TableSY_CMPY_MST FK Joins to SY_ORGN_MST_B SY_CMPY_MST.CO_CODE
TableSY_DOCS_SEQ FK Joins to SY_ORGN_MST_B SY_DOCS_SEQ.ORGN_CODE
TableSY_DOCS_SEQ FK Joins to SY_ORGN_MST_B SY_DOCS_SEQ.SY_DOCS_SEQ_ORGN_CODE
TableSY_DOCS_SEQ FK Joins to SY_ORGN_MST_B SY_DOCS_SEQ.SY_DOCS_SEQ_ORGN_CODE2
TableSY_DOCS_SEQ FK Joins to SY_ORGN_MST_B SY_DOCS_SEQ.SY_DOCS_SEQ_ORGN_CODE3
TableSY_EXCP_TBL FK Joins to SY_ORGN_MST_B SY_EXCP_TBL.CO_CODE
TableSY_ORGN_MST_B FK Joins to SY_ORGN_MST_B SY_ORGN_MST_B.CO_CODE
TableSY_ORGN_MST_B FK Joins to SY_ORGN_MST_B SY_ORGN_MST_B.PARENT_ORGN_CODE
TableSY_ORGN_USR FK Joins to SY_ORGN_MST_B SY_ORGN_USR.ORGN_CODE