Product: | ASF - Sales Online |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT PW.FST_SALES_CATEGORY_ID
, PW.INTEREST_TYPE_ID
, PW.LAST_UPDATE_DATE
, PW.PROD_WORKSHEET_LINE_ID
, PW.FORECAST_WORKSHEET_ID
, PW.LAST_UPDATED_BY
, PW.CURRENCY_CODE
, PW.WEIGHTED_PIPELINE_AMOUNT_FLAG
, PW.WEIGHTED_PIPELINE_AMOUNT
, PW.PIPELINE_AMOUNT
, PW.PIPELINE_AMOUNT_FLAG
, PW.WON_PIPELINE_AMOUNT_FLAG
, PW.WON_PIPELINE_AMOUNT
, PW.WORST_FORECAST_AMOUNT_FLAG
, PW.WORST_FORECAST_AMOUNT
, PW.FORECAST_AMOUNT_FLAG
, PW.FORECAST_AMOUNT
, PW.BEST_FORECAST_AMOUNT_FLAG
, PW.BEST_FORECAST_AMOUNT
, PW.PERIOD_NAME
, RES.SOURCE_NAME FULLNAME
, PW.FORECAST_CATEGORY_ID
, FC.FORECAST_CATEGORY_NAME
, PW.CREDIT_TYPE_ID
, CT.NAME
, PW.SALESFORCE_ID
FROM AS_PROD_WORKSHEET_LINES PW
, JTF_RS_RESOURCE_EXTNS RES
, AS_FORECAST_CATEGORIES FC
, ASO_I_SALES_CREDIT_TYPES_V CT
WHERE PW.STATUS_CODE = 'SUBMITTED'
AND RES.RESOURCE_ID = PW.SALESFORCE_ID
AND PW.FORECAST_CATEGORY_ID=FC.FORECAST_CATEGORY_ID
AND PW.CREDIT_TYPE_ID=CT.SALES_CREDIT_TYPE_ID UNION ALL SELECT PW.FST_SALES_CATEGORY_ID
, PW.INTEREST_TYPE_ID
, PW.LAST_UPDATE_DATE
, PW.PROD_WORKSHEET_LINE_ID
, PW.FORECAST_WORKSHEET_ID
, PW.LAST_UPDATED_BY
, PW.CURRENCY_CODE
, PW.WEIGHTED_PIPELINE_AMOUNT_FLAG
, PW.WEIGHTED_PIPELINE_AMOUNT
, PW.PIPELINE_AMOUNT
, PW.PIPELINE_AMOUNT_FLAG
, PW.WON_PIPELINE_AMOUNT_FLAG
, PW.WON_PIPELINE_AMOUNT
, PW.WORST_FORECAST_AMOUNT_FLAG
, PW.WORST_FORECAST_AMOUNT
, PW.FORECAST_AMOUNT_FLAG
, PW.FORECAST_AMOUNT
, PW.BEST_FORECAST_AMOUNT_FLAG
, PW.BEST_FORECAST_AMOUNT
, PW.PERIOD_NAME
, GTL.GROUP_NAME FULLNAME
, PW.FORECAST_CATEGORY_ID
, FC.FORECAST_CATEGORY_NAME
, PW.CREDIT_TYPE_ID
, CT.NAME
, PW.SALESFORCE_ID
FROM AS_PROD_WORKSHEET_LINES PW
, JTF_RS_GROUPS_TL GTL
, AS_FORECAST_CATEGORIES FC
, ASO_I_SALES_CREDIT_TYPES_V CT
WHERE PW.STATUS_CODE = 'SUBMITTED'
AND PW.SALESFORCE_ID IS NULL
AND GTL.GROUP_ID = PW.SALES_GROUP_ID
AND GTL.LANGUAGE = USERENV('LANG')
AND PW.FORECAST_CATEGORY_ID=FC.FORECAST_CATEGORY_ID
AND PW.CREDIT_TYPE_ID=CT.SALES_CREDIT_TYPE_ID