View: AST_LS_OPP_BSC_V

View Text

SELECT OPP.LEAD_ID
, OPP.LEAD_NUMBER
, OPP.CUSTOMER_ID
, OPP.ORG_ID
, PARTY.PARTY_NAME CUSTOMER_NAME
, OPP.ADDRESS_ID
, OPP.SALES_STAGE_ID
, ASS.NAME SALES_STAGE
, OPP.SECURITY_GROUP_ID
, OPP.STATUS STATUS_CODE
, AST.MEANING STATUS
, OPP.CHANNEL_CODE
, OPP.TOTAL_AMOUNT REVENUE_AMOUNT
, OPP.WIN_PROBABILITY
, OPP.PARENT_PROJECT
, OPP.TOTAL_AMOUNT
, OPP.CURRENCY_CODE
, OPP.DECISION_DATE
, OPP.LEAD_SOURCE_CODE
, OPP.SOURCE_PROMOTION_ID CAMPAIGN_ID
, NULL CAMPAIGN_CODE
, NULL SALES_REP_FIRST_NAME
, NULL SALES_REP_LAST_NAME
, NULL CONTACT_FIRST_NAME
, NULL CONTACT_LAST_NAME
, PARTY.ADDRESS1
, PARTY.ADDRESS2
, PARTY.ADDRESS3
, PARTY.ADDRESS4
, PARTY.CITY
, PARTY.STATE
, PARTY.COUNTRY
, PARTY.POSTAL_CODE
, OPP.ATTRIBUTE_CATEGORY
, OPP.ATTRIBUTE1
, OPP.ATTRIBUTE2
, OPP.ATTRIBUTE3
, OPP.ATTRIBUTE4
, OPP.ATTRIBUTE5
, OPP.ATTRIBUTE6
, OPP.ATTRIBUTE7
, OPP.ATTRIBUTE8
, OPP.ATTRIBUTE9
, OPP.ATTRIBUTE10
, OPP.ATTRIBUTE11
, OPP.ATTRIBUTE12
, OPP.ATTRIBUTE13
, OPP.ATTRIBUTE14
, OPP.ATTRIBUTE15
, OPP.DESCRIPTION
, OPP.CREATION_DATE
, OPP.LAST_UPDATE_DATE
FROM AS_LEADS_ALL OPP
, HZ_PARTIES PARTY
, AS_SALES_STAGES_ALL_VL ASS
, AS_STATUSES_VL AST
WHERE OPP.CUSTOMER_ID = PARTY.PARTY_ID
AND OPP.SALES_STAGE_ID = ASS.SALES_STAGE_ID
AND OPP.STATUS = AST.STATUS_CODE

Columns