FND Design Data [Home] [Help]

Table: SO_ORDER_APPROVALS

Product: OE - Order Entry
Description: Order-level approvals
Implementation/DBA Data: TableOE.SO_ORDER_APPROVALS
Primary Key: SO_ORDER_APPROVALS_UK1
  1. ColumnHEADER_ID
  2. ColumnORDER_APPROVAL_ID
Primary Key: SO_ORDER_APROVALS_PK
  1. ColumnORDER_APPROVAL_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
SO_ORDER_APPROVALS FK Joins to TableRA_CUSTOMERS SO_ORDER_APPROVALS.CUSTOMER_ID
SO_ORDER_APPROVALS FK Joins to TableSO_ORDER_TYPES_115_ALL SO_ORDER_APPROVALS.ORDER_TYPE_ID
SO_ORDER_APPROVALS FK Joins to TableSO_ACTIONS SO_ORDER_APPROVALS.ACTION_ID
SO_ORDER_APPROVALS FK Joins to TableSO_RESULTS_B SO_ORDER_APPROVALS.RESULT_ID
SO_ORDER_APPROVALS FK Joins to TableSO_HEADERS_ALL SO_ORDER_APPROVALS.HEADER_ID
SO_ORDER_APPROVALS FK Joins to TableFND_USER SO_ORDER_APPROVALS.APPROVER_ID