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