View: ASF_FORECAST_OPPWS_SUBMIT_V

View Text

SELECT OW.OPP_WORKSHEET_LINE_ID
, OW.FORECAST_WORKSHEET_ID
, OW.LAST_UPDATE_DATE
, OW.LAST_UPDATED_BY
, OW.CREATION_DATE
, OW.CREATED_BY
, OW.LAST_UPDATE_LOGIN
, OW.FORECAST_ID
, OW.FORECAST_CATEGORY_ID
, OW.SALESFORCE_ID
, OW.SALES_GROUP_ID
, OW.PERIOD_NAME
, OW.CURRENCY_CODE
, OW.CREDIT_TYPE_ID
, OW.STATUS_CODE
, OW.START_DATE_ACTIVE
, OW.END_DATE_ACTIVE
, OW.EMPLOYEE_PERSON_ID EMPLOYEE_NUMBER
, PA.SOURCE_FIRST_NAME FIRST_NAME
, PA.SOURCE_LAST_NAME LAST_NAME
, PA.SOURCE_ID
, OW.LEAD_ID
, LEAD.DESCRIPTION
, HZP.PARTY_ID
, HZP.PARTY_NAME
, HZP.PARTY_TYPE
, OW.DECISION_DATE
, OW.FORECAST_DATE
, OW.SALES_STAGE_ID
, STAGE.NAME SALES_STAGE
, OW.WIN_PROBABILITY
, OW.STATUS
, STATUS.MEANING STATUS_MEANING
, OW.WEIGHTED_AMOUNT_FLAG
, OW.WEIGHTED_AMOUNT
, OW.AMOUNT_FLAG TOTAL_AMOUNT_FLAG
, OW.AMOUNT TOTAL_AMOUNT
, OW.WORST_FORECAST_AMOUNT_FLAG
, OW.WORST_FORECAST_AMOUNT
, OW.FORECAST_AMOUNT_FLAG
, OW.FORECAST_AMOUNT
, OW.BEST_FORECAST_AMOUNT_FLAG
, OW.BEST_FORECAST_AMOUNT
, OW.RESOURCE_ID
FROM AS_LEADS_ALL LEAD
, HZ_PARTIES HZP
, AS_OPP_WORKSHEET_LINES OW
, AS_STATUSES_VL STATUS
, AS_SALES_STAGES_ALL_VL STAGE
, JTF_RS_RESOURCE_EXTNS PA
WHERE OW.LEAD_ID = LEAD.LEAD_ID
AND OW.STATUS_CODE = 'SUBMITTED'
AND OW.STATUS = STATUS.STATUS_CODE
AND LEAD.CUSTOMER_ID = HZP.PARTY_ID
AND OW.SALES_STAGE_ID = STAGE.SALES_STAGE_ID
AND OW.RESOURCE_ID = PA.RESOURCE_ID

Columns