ZSP_ODM_OPTY_V

Details

• Schema: FUSION

• Object owner: ZSP

• Object type: VIEW

Columns

Name

REVN_WID SALES_ACCOUNT_ID CUSTOMER_WID INTEGRATION_ID PROD_WID INVENTORY_ITEM_ID INVENTORY_ORG_ID PROD_GROUP_ID CURR_SSTAGE_WID BUDGETED_FLG CHAMPION_FLG CHANNEL_TYPE SALES_METHOD REVENUE SALE_PRICE TIME_TO_CLOSE REVN_CLOSED_DT STATUS_CATEGORY OPTY_SALES_STG OPTY_SALES_METHOD OPTY_SALES_STG_STATUS OPTY_STATUS REVN_CREATION_DATE REVN_STATUS REVN_SALES_CREDIT_TYP REVN_CLOSED_OPTY_LINE_REVN OPTY_OPEN_DT OPTY_CLOSED_DT

Query

SQL_Statement

SELECT "REVN_WID", "SALES_ACCOUNT_ID", "CUSTOMER_WID", "INTEGRATION_ID", "PROD_WID", "INVENTORY_ITEM_ID", "INVENTORY_ORG_ID", "PROD_GROUP_ID", "CURR_SSTAGE_WID", "BUDGETED_FLG", "CHAMPION_FLG", "CHANNEL_TYPE", "SALES_METHOD", "REVENUE", "SALE_PRICE", "TIME_TO_CLOSE", REVN_CLOSED_DT AS "REVN_CLOSED_DT", "STATUS_CATEGORY", "OPTY_SALES_STG", "OPTY_SALES_METHOD", "OPTY_SALES_STG_STATUS", "STATUS_CD" AS OPTY_STATUS, REVN_CREATION_DT AS REVN_CREATION_DATE, "REVN_STATUS", "SALES_CREDIT_TYP" AS REVN_SALES_CREDIT_TYP, "REVN_CLOSED_OPTY_LINE_REVN", OPTY_OPEN_DT AS OPTY_OPEN_DT, OPTY_CLOSED_DT AS OPTY_CLOSED_DT FROM zsp_odm_revn_v WHERE STATUS_CATEGORY='WON'