Product: | AST - TeleSales |
---|---|
Description: | |
Implementation/DBA Data: | APPS.AST_LS_SALES_LEADS_BSC_V |
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(+)