[Home] [Help]
View: ASF_LEAD_SHARE_OPPORTUNITIES_V
Product: | ASF - Sales Online |
Description: | This view tracks and reports the number incomming and outgoing opportunities |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT CUST.PARTY_NAME
, LEAD.TOTAL_AMOUNT
, LEAD.DESCRIPTION
, LEAD.STATUS
, LEAD.LEAD_ID
, CUST.PARTY_ID
, TQ.SOURCE_LEAD_ID
, TQ.DESTINATION_LEAD_ID
, TQ.SOURCE_PARTNER_ID
, TQ.DESTINATION_PARTNER_ID
, TQ.TRANSACTION_STATUS
, TQ.CREATE_TIMESTAMP
, PARTNER.PARTNER_NAME
FROM HZ_PARTIES CUST
, AS_LEADS_ALL LEAD
, AS_TRANSFER_QUES TQ
, ASF_PARTNER_PROFILE_V PARTNER
WHERE CUST.PARTY_ID = LEAD.CUSTOMER_ID
AND LEAD.LEAD_ID = TQ.DESTINATION_LEAD_ID
AND TQ.SOURCE_PARTNER_ID = PARTNER.PARTNER_ID
AND UPPER(TQ.TRANSACTION_STATUS) IN ('I'
, 'C')
Columns
Name |
PARTY_NAME |
TOTAL_AMOUNT |
DESCRIPTION |
STATUS |
LEAD_ID |
PARTY_ID |
SOURCE_LEAD_ID |
DESTINATION_LEAD_ID |
SOURCE_PARTNER_ID |
DESTINATION_PARTNER_ID |
TRANSACTION_STATUS |
CREATE_TIMESTAMP |
PARTNER_NAME |