FND Design Data [Home] [Help]

Table: AS_OPP_WORKSHEET_LINES

Product: AS - Sales Foundation
Description: Table to store the forecast information on all possible opportunities for individual or sales group
Implementation/DBA Data: TableOSM.AS_OPP_WORKSHEET_LINES
Primary Key: AS_OPP_WORKSHEET_LINES_PK
  1. ColumnFORECAST_WORKSHEET_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
AS_OPP_WORKSHEET_LINES FK Joins to TableAS_LEADS_ALL AS_OPP_WORKSHEET_LINES.LEAD_ID
AS_OPP_WORKSHEET_LINES FK Joins to TableAS_FORECAST_WORKSHEETS AS_OPP_WORKSHEET_LINES.FORECAST_WORKSHEET_ID
AS_OPP_WORKSHEET_LINES FK Joins to TableAS_SALES_STAGES_ALL_B AS_OPP_WORKSHEET_LINES.SALES_STAGE_ID
AS_OPP_WORKSHEET_LINES FK Joins to TableHZ_PARTIES AS_OPP_WORKSHEET_LINES.CUSTOMER_ID
AS_OPP_WORKSHEET_LINES FK Joins to TableAS_STATUSES_B AS_OPP_WORKSHEET_LINES.STATUS