FND Design Data [Home] [Help]

Table: SY_ADDR_MST

Product: GMA - Process Manufacturing Systems
Description: OPM Address master. Table which stores addresses for all Oracle Process
Implementation/DBA Data: TableGMA.SY_ADDR_MST
Primary Key: SY_ADDR_MST_PK
  1. ColumnADDR_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
TableGR_RECIPIENT_ADDRESSES FK Joins to SY_ADDR_MST GR_RECIPIENT_ADDRESSES.ADDR_ID
TableIC_WHSE_MST FK Joins to SY_ADDR_MST IC_WHSE_MST.ADDR_ID
TableOP_BILL_LAD FK Joins to SY_ADDR_MST OP_BILL_LAD.BOLADDR_ID
TableOP_CUST_CON FK Joins to SY_ADDR_MST OP_CUST_CON.ADDR_ID
TableOP_CUST_MST_OPM FK Joins to SY_ADDR_MST OP_CUST_MST_OPM.ADDR_ID
TableOP_CUST_MST_OPM FK Joins to SY_ADDR_MST OP_CUST_MST_OPM.MAILADDR_ID
TableOP_CUST_MST FK Joins to SY_ADDR_MST OP_CUST_MST.ADDR_ID
TableOP_CUST_MST FK Joins to SY_ADDR_MST OP_CUST_MST.MAILADDR_ID
TableOP_FOBC_MST FK Joins to SY_ADDR_MST OP_FOBC_MST.ADDR_ID
TableOP_LKBX_MST FK Joins to SY_ADDR_MST OP_LKBX_MST.ADDR_ID
TableOP_ORDR_DTL FK Joins to SY_ADDR_MST OP_ORDR_DTL.SHIPADDR_ID
TableOP_ORDR_HDR FK Joins to SY_ADDR_MST OP_ORDR_HDR.SHIPADDR_ID
TableOP_PORT_MST FK Joins to SY_ADDR_MST OP_PORT_MST.ADDR_ID
TableOP_PRSL_DTL FK Joins to SY_ADDR_MST OP_PRSL_DTL.SHIPADDR_ID
TableOP_PRSL_HDR FK Joins to SY_ADDR_MST OP_PRSL_HDR.SHIPADDR_ID
TableOP_RELS_SCH FK Joins to SY_ADDR_MST OP_RELS_SCH.SHIPADDR_ID
TableOP_SHIP_MST FK Joins to SY_ADDR_MST OP_SHIP_MST.ADDR_ID
TableOP_SLSR_MST FK Joins to SY_ADDR_MST OP_SLSR_MST.ADDR_ID
TablePO_BPOS_DTL FK Joins to SY_ADDR_MST PO_BPOS_DTL.RECVADDR_ID
TablePO_BPOS_HDR FK Joins to SY_ADDR_MST PO_BPOS_HDR.ORGNADDR_ID
TablePO_ORDR_DTL FK Joins to SY_ADDR_MST PO_ORDR_DTL.RECVADDR_ID
TablePO_ORDR_HDR FK Joins to SY_ADDR_MST PO_ORDR_HDR.RECVADDR_ID
TablePO_RECV_DTL FK Joins to SY_ADDR_MST PO_RECV_DTL.RECVADDR_ID
TablePO_RELS_SCH FK Joins to SY_ADDR_MST PO_RELS_SCH.RECVADDR_ID
TablePO_RTRN_HDR FK Joins to SY_ADDR_MST PO_RTRN_HDR.RTRNADDR_ID
TablePO_VEND_MST FK Joins to SY_ADDR_MST PO_VEND_MST.ADDR_ID
TablePO_VEND_MST FK Joins to SY_ADDR_MST PO_VEND_MST.MAILADDR_ID
TableSY_ORGN_MST_B FK Joins to SY_ADDR_MST SY_ORGN_MST_B.ADDR_ID
TableSY_ORGN_MST FK Joins to SY_ADDR_MST SY_ORGN_MST.ADDR_ID
TableTX_TAXA_MST FK Joins to SY_ADDR_MST TX_TAXA_MST.ADDR_ID