View: AMS_DS_SALES_LEADS_V

Product:	AMS - Marketing
Description:
Implementation/DBA Data:	APPS.AMS_DS_SALES_LEADS_V

View Text

SELECT LEAD.SALES_LEAD_ID
, LEAD.CREATION_DATE
, LEAD.LAST_UPDATE_DATE
, LEAD.LEAD_NUMBER
, LEAD.STATUS_CODE
, AS_LOOKUPS1.MEANING LEAD_STATUS
, LEAD.CUSTOMER_ID
, LEAD.ADDRESS_ID
, LEAD.ASSIGN_TO_PERSON_ID
, LEAD.ASSIGN_TO_SALESFORCE_ID
, LEAD.ORIG_SYSTEM_REFERENCE
, LEAD.CHANNEL_CODE
, ASO_CHANNEL.SALES_CHANNEL
, LEAD.BUDGET_AMOUNT
, LEAD.BUDGET_STATUS_CODE
, AS_LOOKUPS2.MEANING BUDGET_STATUS
, LEAD.CURRENCY_CODE
, LEAD.DECISION_TIMEFRAME_CODE
, AS_LOOKUPS3.MEANING TIME_FRAME
, LEAD.DESCRIPTION
, LEAD.LEAD_RANK_CODE
, RANK.MEANING RANK
, LEAD.SOURCE_PROMOTION_ID
, CAMP.NAME SOURCE_PROMOTION_NAME
, CAMP.SOURCE_CODE SOURCE_PROMOTION_CODE
, LEAD.CLOSE_REASON
, LEAD.ACCEPT_FLAG
, LEAD.VEHICLE_RESPONSE_CODE
, LEAD.URGENT_FLAG
, LEAD.LEAD_RANK_ID
, LEAD.ASSIGN_SALES_GROUP_ID
, LEAD.CONTACT_ROLE_CODE
, LEAD.QUALIFIED_FLAG
, LEAD.PRIMARY_CONTACT_PARTY_ID
, LEAD.PRIMARY_CNT_PERSON_PARTY_ID
, LEAD.PRIMARY_CONTACT_PHONE_ID
, AS_LOOKUPS4.MEANING DECLINE_REASON
, AS_LOOKUPS5.MEANING VEH_RESP_CODE_MEANING
, AS_LOOKUPS4.MEANING GROUP_NAME
, RES.SOURCE_NAME RESOURCE_NAME
, 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
, LL.CATEGORY_ID
, LL.INVENTORY_ITEM_ID
, LL.ORGANIZATION_ID
, LL.UOM_CODE
, LL.QUANTITY
, DENORM.CATEGORY_DESC
, MTLUOM.UNIT_OF_MEASURE_TL
, MTLSI.CONCATENATED_SEGMENTS
, MTLSI.DESCRIPTION ITEM_DESCRIPTION
, DENORM.CONCAT_CAT_PARENTAGE
, LL.CATEGORY_SET_ID
, LL.ATTRIBUTE_CATEGORY LINE_ATTRIBUTE_CATEGORY
, LL.ATTRIBUTE1 LINE_ATTRIBUTE1
, LL.ATTRIBUTE2 LINE_ATTRIBUTE2
, LL.ATTRIBUTE2 LINE_ATTRIBUTE3
, LL.ATTRIBUTE2 LINE_ATTRIBUTE4
, LL.ATTRIBUTE2 LINE_ATTRIBUTE5
, LL.ATTRIBUTE2 LINE_ATTRIBUTE6
, LL.ATTRIBUTE2 LINE_ATTRIBUTE7
, LL.ATTRIBUTE2 LINE_ATTRIBUTE8
, LL.ATTRIBUTE2 LINE_ATTRIBUTE9
, LL.ATTRIBUTE2 LINE_ATTRIBUTE10
, LL.ATTRIBUTE11 LINE_ATTRIBUTE11
, LL.ATTRIBUTE12 LINE_ATTRIBUTE12
, LL.ATTRIBUTE13 LINE_ATTRIBUTE13
, LL.ATTRIBUTE14 LINE_ATTRIBUTE14
, LL.ATTRIBUTE15 LINE_ATTRIBUTE15
FROM AS_SALES_LEADS LEAD
, AMS_P_SOURCE_CODES_V CAMP
, AMS_P_SOURCE_CODES_V OFR
, AS_STATUSES_TL AS_LOOKUPS1
, AS_SALES_LEAD_RANKS_TL RANK
, AS_LOOKUPS AS_LOOKUPS2
, AS_LOOKUPS AS_LOOKUPS3
, AS_LOOKUPS AS_LOOKUPS4
, HZ_PARTIES CONTACT
, ASO_I_SALES_CHANNELS_V ASO_CHANNEL
, JTF_RS_RESOURCE_EXTNS RES
, AS_STATUSES_B STATUS
, AS_LOOKUPS AS_LOOKUPS5
, AS_SALES_LEAD_LINES LL
, MTL_SYSTEM_ITEMS_VL MTLSI
, MTL_UNITS_OF_MEASURE MTLUOM
, ENI_PROD_DEN_HRCHY_PARENTS_V DENORM
WHERE LEAD.STATUS_CODE = AS_LOOKUPS1.STATUS_CODE
AND AS_LOOKUPS1.LANGUAGE = USERENV('LANG')
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.REJECT_REASON_CODE = AS_LOOKUPS4.LOOKUP_CODE(+)
AND AS_LOOKUPS4.LOOKUP_TYPE(+) = 'REJECT_REASON_CODE'
AND LEAD.CHANNEL_CODE = ASO_CHANNEL.SALES_CHANNEL_CODE(+)
AND LEAD.SOURCE_PROMOTION_ID = CAMP.SOURCE_CODE_ID(+)
AND LEAD.OFFER_ID = OFR.SOURCE_CODE_ID(+)
AND LEAD.PRIMARY_CNT_PERSON_PARTY_ID = CONTACT.PARTY_ID(+)
AND RES.RESOURCE_ID(+) = LEAD.ASSIGN_TO_SALESFORCE_ID
AND LEAD.STATUS_CODE = STATUS.STATUS_CODE
AND LEAD.VEHICLE_RESPONSE_CODE = AS_LOOKUPS5.LOOKUP_CODE(+)
AND AS_LOOKUPS5.LOOKUP_TYPE(+) = 'VEHICLE_RESPONSE_CODE'
AND LL.SALES_LEAD_ID = LEAD.SALES_LEAD_ID
AND LL.INVENTORY_ITEM_ID = MTLSI.INVENTORY_ITEM_ID(+)
AND LL.ORGANIZATION_ID = MTLSI.ORGANIZATION_ID(+)
AND LL.UOM_CODE = MTLUOM.UOM_CODE(+)
AND MTLUOM.LANGUAGE(+) = USERENV('LANG')
AND LL.CATEGORY_ID = DENORM.CATEGORY_ID

Columns