[Home] [Help]
SELECT LEAD.ROWID , LEAD.SALES_LEAD_ID , ASLC.CONTACT_PARTY_ID , LEAD.LAST_UPDATE_DATE , LEAD.LAST_UPDATED_BY , LEAD.CREATION_DATE , LEAD.CREATED_BY , LEAD.LAST_UPDATE_LOGIN , LEAD.REQUEST_ID , LEAD.PROGRAM_APPLICATION_ID , LEAD.PROGRAM_ID , LEAD.PROGRAM_UPDATE_DATE , LEAD.LEAD_NUMBER , LEAD.STATUS_CODE , STATUS.MEANING , LEAD.STATUS_OPEN_FLAG , LEAD.CUSTOMER_ID , LEAD.ADDRESS_ID , LEAD.ORIG_SYSTEM_REFERENCE , LEAD.ASSIGN_TO_PERSON_ID , LEAD.ASSIGN_TO_SALESFORCE_ID , LEAD.CHANNEL_CODE , OELKP.MEANING , LEAD.BUDGET_AMOUNT , LEAD.BUDGET_STATUS_CODE , AS_LOOKUPS2.MEANING BUDGET_STATUS , LEAD.CURRENCY_CODE , LEAD.DECISION_TIMEFRAME_CODE , AS_LOOKUPS3.MEANING, LEAD.DESCRIPTION , LEAD.LEAD_RANK_CODE, RANK.MEANING, LEAD.SOURCE_PROMOTION_ID , LEAD.INITIATING_CONTACT_ID, LEAD.CLOSE_REASON , AS_LOOKUPS4.MEANING, LEAD.PARENT_PROJECT , LEAD.ATTRIBUTE_CATEGORY, LEAD.ATTRIBUTE1, LEAD.ATTRIBUTE2, LEAD.ATTRIBUTE3, LEAD.ATTRIBUTE4 , LEAD.ATTRIBUTE5, LEAD.ATTRIBUTE6, LEAD.ATTRIBUTE7, LEAD.ATTRIBUTE8, LEAD.ATTRIBUTE9 , LEAD.ATTRIBUTE10, LEAD.ATTRIBUTE11, LEAD.ATTRIBUTE12, LEAD.ATTRIBUTE13, LEAD.ATTRIBUTE14 , LEAD.ATTRIBUTE15, LEAD.ASSIGN_DATE, LEAD.ACCEPT_FLAG , LEAD.VEHICLE_RESPONSE_CODE, AS_LOOKUPS5.MEANING , LEAD.TOTAL_SCORE, LEAD.SCORECARD_ID, LEAD.KEEP_FLAG , LEAD.URGENT_FLAG, LEAD.IMPORT_FLAG, LEAD.REJECT_REASON_CODE , LEAD.LEAD_RANK_ID, LEAD.DELETED_FLAG, LEAD.ASSIGN_SALES_GROUP_ID , LEAD.OFFER_ID, LEAD.CONTACT_ROLE_CODE, LEAD.QUALIFIED_FLAG , LEAD.AUTO_ASSIGNMENT_TYPE FROM AS_SALES_LEADS LEAD , AS_STATUSES_VL STATUS , AS_SALES_LEAD_RANKS_TL RANK , AS_LOOKUPS AS_LOOKUPS2 , AS_LOOKUPS AS_LOOKUPS3 , AS_LOOKUPS AS_LOOKUPS4 , AS_LOOKUPS AS_LOOKUPS5 , OE_LOOKUPS OELKP , AS_SALES_LEAD_CONTACTS ASLC WHERE LEAD.STATUS_CODE = STATUS.STATUS_CODE AND LEAD.LEAD_RANK_ID = RANK.RANK_ID(+) AND RANK.LANGUAGE(+) = USERENV('LANG') AND LEAD.BUDGET_STATUS_CODE = AS_LOOKUPS2.LOOKUP_CODE(+) AND AS_LOOKUPS2.LOOKUP_TYPE(+) = 'BUDGET_STATUS' AND LEAD.DECISION_TIMEFRAME_CODE = AS_LOOKUPS3.LOOKUP_CODE(+) AND AS_LOOKUPS3.LOOKUP_TYPE(+) = 'DECISION_TIMEFRAME' AND LEAD.CLOSE_REASON = AS_LOOKUPS4.LOOKUP_CODE(+) AND AS_LOOKUPS4.LOOKUP_TYPE(+) = 'CLOSE_REASON' AND LEAD.CHANNEL_CODE = OELKP.LOOKUP_CODE(+) AND OELKP.LOOKUP_TYPE(+) = 'SALES_CHANNEL' AND AS_LOOKUPS5.LOOKUP_CODE(+) = LEAD.VEHICLE_RESPONSE_CODE AND AS_LOOKUPS5.LOOKUP_TYPE(+) = 'VEHICLE_RESPONSE_CODE' AND LEAD.SALES_LEAD_ID = ASLC.SALES_LEAD_ID (+)
SELECT LEAD.ROWID
, LEAD.SALES_LEAD_ID
, ASLC.CONTACT_PARTY_ID
, LEAD.LAST_UPDATE_DATE
, LEAD.LAST_UPDATED_BY
, LEAD.CREATION_DATE
, LEAD.CREATED_BY
, LEAD.LAST_UPDATE_LOGIN
, LEAD.REQUEST_ID
, LEAD.PROGRAM_APPLICATION_ID
, LEAD.PROGRAM_ID
, LEAD.PROGRAM_UPDATE_DATE
, LEAD.LEAD_NUMBER
, LEAD.STATUS_CODE
, STATUS.MEANING
, LEAD.STATUS_OPEN_FLAG
, LEAD.CUSTOMER_ID
, LEAD.ADDRESS_ID
, LEAD.ORIG_SYSTEM_REFERENCE
, LEAD.ASSIGN_TO_PERSON_ID
, LEAD.ASSIGN_TO_SALESFORCE_ID
, LEAD.CHANNEL_CODE
, OELKP.MEANING
, LEAD.BUDGET_AMOUNT
, LEAD.BUDGET_STATUS_CODE
, AS_LOOKUPS2.MEANING BUDGET_STATUS
, LEAD.CURRENCY_CODE
, LEAD.DECISION_TIMEFRAME_CODE
, AS_LOOKUPS3.MEANING
, LEAD.DESCRIPTION
, LEAD.LEAD_RANK_CODE
, RANK.MEANING
, LEAD.SOURCE_PROMOTION_ID
, LEAD.INITIATING_CONTACT_ID
, LEAD.CLOSE_REASON
, AS_LOOKUPS4.MEANING
, LEAD.PARENT_PROJECT
, LEAD.ATTRIBUTE_CATEGORY
, LEAD.ATTRIBUTE1
, LEAD.ATTRIBUTE2
, LEAD.ATTRIBUTE3
, LEAD.ATTRIBUTE4
, LEAD.ATTRIBUTE5
, LEAD.ATTRIBUTE6
, LEAD.ATTRIBUTE7
, LEAD.ATTRIBUTE8
, LEAD.ATTRIBUTE9
, LEAD.ATTRIBUTE10
, LEAD.ATTRIBUTE11
, LEAD.ATTRIBUTE12
, LEAD.ATTRIBUTE13
, LEAD.ATTRIBUTE14
, LEAD.ATTRIBUTE15
, LEAD.ASSIGN_DATE
, LEAD.ACCEPT_FLAG
, LEAD.VEHICLE_RESPONSE_CODE
, AS_LOOKUPS5.MEANING
, LEAD.TOTAL_SCORE
, LEAD.SCORECARD_ID
, LEAD.KEEP_FLAG
, LEAD.URGENT_FLAG
, LEAD.IMPORT_FLAG
, LEAD.REJECT_REASON_CODE
, LEAD.LEAD_RANK_ID
, LEAD.DELETED_FLAG
, LEAD.ASSIGN_SALES_GROUP_ID
, LEAD.OFFER_ID
, LEAD.CONTACT_ROLE_CODE
, LEAD.QUALIFIED_FLAG
, LEAD.AUTO_ASSIGNMENT_TYPE
FROM AS_SALES_LEADS LEAD
, AS_STATUSES_VL STATUS
, AS_SALES_LEAD_RANKS_TL RANK
, AS_LOOKUPS AS_LOOKUPS2
, AS_LOOKUPS AS_LOOKUPS3
, AS_LOOKUPS AS_LOOKUPS4
, AS_LOOKUPS AS_LOOKUPS5
, OE_LOOKUPS OELKP
, AS_SALES_LEAD_CONTACTS ASLC
WHERE LEAD.STATUS_CODE = STATUS.STATUS_CODE
AND LEAD.LEAD_RANK_ID = RANK.RANK_ID(+)
AND RANK.LANGUAGE(+) = USERENV('LANG')
AND LEAD.BUDGET_STATUS_CODE = AS_LOOKUPS2.LOOKUP_CODE(+)
AND AS_LOOKUPS2.LOOKUP_TYPE(+) = 'BUDGET_STATUS'
AND LEAD.DECISION_TIMEFRAME_CODE = AS_LOOKUPS3.LOOKUP_CODE(+)
AND AS_LOOKUPS3.LOOKUP_TYPE(+) = 'DECISION_TIMEFRAME'
AND LEAD.CLOSE_REASON = AS_LOOKUPS4.LOOKUP_CODE(+)
AND AS_LOOKUPS4.LOOKUP_TYPE(+) = 'CLOSE_REASON'
AND LEAD.CHANNEL_CODE = OELKP.LOOKUP_CODE(+)
AND OELKP.LOOKUP_TYPE(+) = 'SALES_CHANNEL'
AND AS_LOOKUPS5.LOOKUP_CODE(+) = LEAD.VEHICLE_RESPONSE_CODE
AND AS_LOOKUPS5.LOOKUP_TYPE(+) = 'VEHICLE_RESPONSE_CODE'
AND LEAD.SALES_LEAD_ID = ASLC.SALES_LEAD_ID (+)
|
|
|
|