VIEW: APPS.AST_LS_SALES_LEADS_BSC_V

Source

View Text - Preformatted

SELECT LDH.SALES_LEAD_ID , LDH.LEAD_NUMBER , LDH.CUSTOMER_ID , LDH.ADDRESS_ID , LDH.STATUS_CODE , LDH.PARENT_PROJECT , LDH.DESCRIPTION , LDH.DESCRIPTION , LDH.DECISION_TIMEFRAME_CODE , LDH.LEAD_RANK_CODE , LDH.CHANNEL_CODE , LDH.CREATION_DATE , LDH.CREATED_BY , CLOSE.MEANING , LDH.ASSIGN_TO_PERSON_ID , LDH.BUDGET_AMOUNT , LDH.BUDGET_STATUS_CODE , LDH.BUDGET_STATUS_CODE , LDH.CURRENCY_CODE , LDH.KEEP_FLAG , LDH.QUALIFIED_FLAG , LDH.URGENT_FLAG , LDH.ACCEPT_FLAG , LDH.VEHICLE_RESPONSE_CODE , LDH.DELETED_FLAG , LDH.SCORECARD_ID , LDH.ASSIGN_SALES_GROUP_ID , LDH.OFFER_ID , LDH.SOURCE_PROMOTION_ID , CMP.SOURCE_CODE , AL1.MEANING , AL3.MEANING , AL5.MEANING , CUS.PARTY_NAME , CUS.PARTY_TYPE , NULL , NULL , NULL , NULL , NULL , NULL , ASSIGN.SOURCE_FIRST_NAME , ASSIGN.SOURCE_LAST_NAME , ASSIGN.SOURCE_NAME , RNK.MEANING , LDH.LAST_UPDATE_DATE , LDH.ATTRIBUTE1 , LDH.ATTRIBUTE2 , LDH.ATTRIBUTE3 , LDH.ATTRIBUTE4 , LDH.ATTRIBUTE5 , LDH.ATTRIBUTE6 , LDH.ATTRIBUTE7 , LDH.ATTRIBUTE8 , LDH.ATTRIBUTE9 , LDH.ATTRIBUTE10 , LDH.ATTRIBUTE11 , LDH.ATTRIBUTE12 , LDH.ATTRIBUTE13 , LDH.ATTRIBUTE14 , LDH.ATTRIBUTE15 FROM AS_SALES_LEADS LDH , HZ_PARTIES CUS , AS_SALES_LEAD_RANKS_TL RNK , AS_STATUSES_TL AL1 , AS_LOOKUPS AL3 , AS_LOOKUPS CLOSE , OE_LOOKUPS AL5 , AMS_SOURCE_CODES CMP , JTF_RS_RESOURCE_EXTNS ASSIGN WHERE LDH.CUSTOMER_ID = CUS.PARTY_ID AND LDH.LEAD_RANK_ID = RNK.RANK_ID(+) AND RNK.LANGUAGE(+) = USERENV('LANG') AND LDH.STATUS_CODE = AL1.STATUS_CODE(+) AND LDH.SOURCE_PROMOTION_ID = CMP.SOURCE_CODE_ID(+) AND AL1.LANGUAGE(+) = USERENV('LANG') AND LDH.DECISION_TIMEFRAME_CODE = AL3.LOOKUP_CODE(+) AND AL3.LOOKUP_TYPE(+) = 'DECISION_TIMEFRAME' AND LDH.CLOSE_REASON = CLOSE.LOOKUP_CODE(+) AND CLOSE.LOOKUP_TYPE(+) = 'CLOSE_REASON' AND LDH.CHANNEL_CODE = AL5.LOOKUP_CODE(+) AND AL5.LOOKUP_TYPE(+) = 'SALES_CHANNEL' AND LDH.ASSIGN_TO_SALESFORCE_ID = ASSIGN.RESOURCE_ID(+)

View Text - HTML Formatted

SELECT LDH.SALES_LEAD_ID
, LDH.LEAD_NUMBER
, LDH.CUSTOMER_ID
, LDH.ADDRESS_ID
, LDH.STATUS_CODE
, LDH.PARENT_PROJECT
, LDH.DESCRIPTION
, LDH.DESCRIPTION
, LDH.DECISION_TIMEFRAME_CODE
, LDH.LEAD_RANK_CODE
, LDH.CHANNEL_CODE
, LDH.CREATION_DATE
, LDH.CREATED_BY
, CLOSE.MEANING
, LDH.ASSIGN_TO_PERSON_ID
, LDH.BUDGET_AMOUNT
, LDH.BUDGET_STATUS_CODE
, LDH.BUDGET_STATUS_CODE
, LDH.CURRENCY_CODE
, LDH.KEEP_FLAG
, LDH.QUALIFIED_FLAG
, LDH.URGENT_FLAG
, LDH.ACCEPT_FLAG
, LDH.VEHICLE_RESPONSE_CODE
, LDH.DELETED_FLAG
, LDH.SCORECARD_ID
, LDH.ASSIGN_SALES_GROUP_ID
, LDH.OFFER_ID
, LDH.SOURCE_PROMOTION_ID
, CMP.SOURCE_CODE
, AL1.MEANING
, AL3.MEANING
, AL5.MEANING
, CUS.PARTY_NAME
, CUS.PARTY_TYPE
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, ASSIGN.SOURCE_FIRST_NAME
, ASSIGN.SOURCE_LAST_NAME
, ASSIGN.SOURCE_NAME
, RNK.MEANING
, LDH.LAST_UPDATE_DATE
, LDH.ATTRIBUTE1
, LDH.ATTRIBUTE2
, LDH.ATTRIBUTE3
, LDH.ATTRIBUTE4
, LDH.ATTRIBUTE5
, LDH.ATTRIBUTE6
, LDH.ATTRIBUTE7
, LDH.ATTRIBUTE8
, LDH.ATTRIBUTE9
, LDH.ATTRIBUTE10
, LDH.ATTRIBUTE11
, LDH.ATTRIBUTE12
, LDH.ATTRIBUTE13
, LDH.ATTRIBUTE14
, LDH.ATTRIBUTE15
FROM AS_SALES_LEADS LDH
, HZ_PARTIES CUS
, AS_SALES_LEAD_RANKS_TL RNK
, AS_STATUSES_TL AL1
, AS_LOOKUPS AL3
, AS_LOOKUPS CLOSE
, OE_LOOKUPS AL5
, AMS_SOURCE_CODES CMP
, JTF_RS_RESOURCE_EXTNS ASSIGN
WHERE LDH.CUSTOMER_ID = CUS.PARTY_ID
AND LDH.LEAD_RANK_ID = RNK.RANK_ID(+)
AND RNK.LANGUAGE(+) = USERENV('LANG')
AND LDH.STATUS_CODE = AL1.STATUS_CODE(+)
AND LDH.SOURCE_PROMOTION_ID = CMP.SOURCE_CODE_ID(+)
AND AL1.LANGUAGE(+) = USERENV('LANG')
AND LDH.DECISION_TIMEFRAME_CODE = AL3.LOOKUP_CODE(+)
AND AL3.LOOKUP_TYPE(+) = 'DECISION_TIMEFRAME'
AND LDH.CLOSE_REASON = CLOSE.LOOKUP_CODE(+)
AND CLOSE.LOOKUP_TYPE(+) = 'CLOSE_REASON'
AND LDH.CHANNEL_CODE = AL5.LOOKUP_CODE(+)
AND AL5.LOOKUP_TYPE(+) = 'SALES_CHANNEL'
AND LDH.ASSIGN_TO_SALESFORCE_ID = ASSIGN.RESOURCE_ID(+)