[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 |