[Home] [Help]
View: AS_OPPORTUNITY_ADJS_V
| Product: | AS - Sales Foundation |
|---|
| Description: | Lead Adjustment view |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT L.ROWID
, L.LEAD_ADJUSTMENT_ID
, L.LAST_UPDATE_DATE
, L.LAST_UPDATED_BY
, L.CREATION_DATE
, L.CREATED_BY
, L.LAST_UPDATE_LOGIN
, L.ORIGINAL_LEAD_ID
, L.ORIGINAL_LEAD_FLAG
, L.WIN_PROBABILITY
, L.STATUS_CODE
, L.DECISION_DATE
, L.TOTAL_AMOUNT
, L.ADJUSTED_BY_PERSON_ID
, L.ADJUSTED_FOR_SALESGROUP_ID
, L.REVIEWED_FLAG
, P.FIRST_NAME || ' ' || P.LAST_NAME
FROM PER_PEOPLE_X P
, AS_LEAD_ADJS L
WHERE L.ADJUSTED_BY_PERSON_ID = P.PERSON_ID
Columns
| Name |
| ROW_ID |
| LEAD_ADJUSTMENT_ID |
| LAST_UPDATE_DATE |
| LAST_UPDATED_BY |
| CREATION_DATE |
| CREATED_BY |
| LAST_UPDATE_LOGIN |
| ORIGINAL_LEAD_ID |
| ORIGINAL_LEAD_FLAG |
| WIN_PROBABILITY |
| STATUS_CODE |
| DECISION_DATE |
| TOTAL_AMOUNT |
| ADJUSTED_BY_PERSON_ID |
| ADJUSTED_FOR_SALESGROUP_ID |
| REVIEWED_FLAG |
| ADJUSTED_BY_NAME |