FND Design Data [Home] [Help]

Table: AS_STATUSES_B

Product: AS - Sales Foundation
Description: Hold three types of status, opportunity, lead and quote
Implementation/DBA Data: TableOSM.AS_STATUSES_B
Primary Key: AS_STATUSES_B_PK
  1. ColumnSTATUS_CODE
Foreign Keys
Table
Foreign Table Foreign Key Column
TableAS_LEADS_ALL FK Joins to AS_STATUSES_B AS_LEADS_ALL.STATUS
TableAS_OPP_WORKSHEET_LINES FK Joins to AS_STATUSES_B AS_OPP_WORKSHEET_LINES.STATUS
TableAS_SALES_LEADS FK Joins to AS_STATUSES_B AS_SALES_LEADS.STATUS_CODE
TableAS_SALES_CREDITS_DENORM FK Joins to AS_STATUSES_B AS_SALES_CREDITS_DENORM.STATUS_CODE
TableAS_STATUSES_TL FK Joins to AS_STATUSES_B AS_STATUSES_TL.STATUS_CODE
TablePV_ALLOWED_STATUSES FK Joins to AS_STATUSES_B PV_ALLOWED_STATUSES.TO_STATUS_CODE
TablePV_ALLOWED_STATUSES FK Joins to AS_STATUSES_B PV_ALLOWED_STATUSES.FROM_STATUS_CODE