[Home] [Help]
View: AS_SALES_LEAD_UWQ_V
Product: | AS - Sales Foundation |
Description: | This view is used for Universal Work Queue |
Implementation/DBA Data: |
APPS.AS_SALES_LEAD_UWQ_V
|
View Text
SELECT LEAD.SALES_LEAD_ID
, LEAD.DESCRIPTION
, LEAD.CUSTOMER_ID
, PARTY.PARTY_NAME
, LEAD.STATUS_CODE
, STT.MEANING
, LEAD.ASSIGN_TO_SALESFORCE_ID
, LEAD.ASSIGN_SALES_GROUP_ID
, LEAD.BUDGET_AMOUNT
, LEAD.CURRENCY_CODE
, 'LEAD'
, DECODE(RES.CATEGORY
, 'EMPLOYEE'
, 'RS_EMPLOYEE'
, 'PARTNER'
, 'RS_PARTNER'
, NULL)
FROM AS_SALES_LEADS LEAD
, JTF_RS_RESOURCE_EXTNS RES
, HZ_PARTIES PARTY
, AS_STATUSES_B STB
, AS_STATUSES_TL STT
WHERE LEAD.STATUS_CODE = STB.STATUS_CODE
AND STT.STATUS_CODE = STB.STATUS_CODE
AND STT.LANGUAGE = USERENV('LANG')
AND LEAD.CUSTOMER_ID = PARTY.PARTY_ID
AND LEAD.ASSIGN_TO_SALESFORCE_ID = RES.RESOURCE_ID
Columns
Name |
LEAD_ID |
DESCRIPTION |
PARTY_ID |
PARTY_NAME |
STATUS_CODE |
STATUS_MEANING |
RESOURCE_ID |
ASSIGN_SALES_GROUP_ID |
BUDGET_AMOUNT |
CURRENCY_CODE |
OBJECT_CODE |
RESOURCE_TYPE |