FND Design Data [Home] [Help]

Table: PO_LOCATION_ASSOCIATIONS

Product: PO - Purchasing
Description: Location associations to customers and customer sites
Implementation/DBA Data: Not implemented in this database
Primary Key: PO_LOCATION_ASSOCATIONS_PK
  1. ColumnLOCATION_ID
Primary Key: PO_LOCATION_ASSOCATIONS_UPK01
  1. ColumnSITE_USE_ID
  2. ColumnLOCATION_ID
Primary Key: PO_LOCATION_ASSOCIATIONS_UK02
  1. ColumnSUBINVENTORY
  2. ColumnLOCATION_ID
Primary Key: PO_LOCATION_ASSOCIATIONS_UK03
  1. ColumnLOCATION_ID
  2. ColumnSUBINVENTORY
  3. ColumnSITE_USE_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PO_LOCATION_ASSOCIATIONS FK Joins to TableRA_CUSTOMERS PO_LOCATION_ASSOCIATIONS.CUSTOMER_ID
PO_LOCATION_ASSOCIATIONS FK Joins to TableRA_ADDRESSES_ALL PO_LOCATION_ASSOCIATIONS.ADDRESS_ID
PO_LOCATION_ASSOCIATIONS FK Joins to TableRA_SITE_USES_ALL PO_LOCATION_ASSOCIATIONS.SITE_USE_ID
TableWSH_CALENDAR_ASSIGNMENTS FK Joins to PO_LOCATION_ASSOCIATIONS WSH_CALENDAR_ASSIGNMENTS.LOCATION_ASSOCIATION_ID