Product: | AST - TeleSales |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT LDH.SALES_LEAD_ID
, CUS.PARTY_NAME
, LDH.LEAD_NUMBER
, LDH.CUSTOMER_ID
, LDH.ADDRESS_ID
, LDH.STATUS_CODE
, AL1.MEANING STATUS
, LDH.PARENT_PROJECT
, LDH.DESCRIPTION
, LDH.DECISION_TIMEFRAME_CODE
, AL3.MEANING
, LDH.LEAD_RANK_CODE
, RNK.MEANING
, LDH.CHANNEL_CODE
, LDH.CREATION_DATE
, LDH.CREATED_BY
, LDH.CLOSE_REASON
, LDH.ASSIGN_TO_PERSON_ID
, PER.SOURCE_NAME
, LDH.BUDGET_AMOUNT
, LDH.BUDGET_STATUS_CODE
, LDH.BUDGET_STATUS_CODE
, LDH.CURRENCY_CODE
, LDH.KEEP_FLAG
, LDH.URGENT_FLAG
, LDH.VEHICLE_RESPONSE_CODE
, LDH.DELETED_FLAG
, LDH.SCORECARD_ID
, LDH.ASSIGN_SALES_GROUP_ID
, LDH.OFFER_ID
, LDC.LEAD_CONTACT_ID
, LDC.FIRST_NAME
, LDC.LAST_NAME
, LDC.FIRST_NAME||' '||LDC.LAST_NAME
, LDC.CONTACT_ROLE_CODE
, LDC.CONTACT_ID
FROM AS_SALES_LEADS LDH
, HZ_PARTIES CUS
, AS_SALES_LEAD_CONTACTS_V LDC
, AS_SALES_LEAD_RANKS_TL RNK
, AS_STATUSES_TL AL1
, AS_LOOKUPS AL3
, JTF_RS_RESOURCE_EXTNS PER
WHERE LDC.SALES_LEAD_ID (+) = LDH.SALES_LEAD_ID
AND LDH.CUSTOMER_ID = CUS.PARTY_ID
AND LDC.PRIMARY_CONTACT_FLAG (+) = 'Y'
AND RNK.RANK_ID(+) = LDH.LEAD_RANK_ID
AND RNK.LANGUAGE(+) = USERENV('LANG')
AND PER.SOURCE_ID(+) = LDH.ASSIGN_TO_PERSON_ID
AND AL1.STATUS_CODE = LDH.STATUS_CODE
AND AL1.LANGUAGE = USERENV('LANG')
AND AL3.LOOKUP_CODE(+) = LDH.DECISION_TIMEFRAME_CODE
AND AL3.LOOKUP_TYPE(+) = 'DECISION_TIMEFRAME'