[Home] [Help]
| Product: | AS - Sales Foundation |
|---|---|
| Description: | Displays the base information of a lead line |
| Implementation/DBA Data: | Not implemented in this database |
SELECT LL.ROWID
, LL.LEAD_LINE_ID
, LL.LAST_UPDATE_DATE
, LL.LAST_UPDATED_BY
, LL.CREATION_DATE
, LL.CREATED_BY
, LL.LAST_UPDATE_LOGIN
, LL.LEAD_ID
, LL.INTEREST_TYPE_ID
, LL.PRIMARY_INTEREST_CODE_ID
, LL.SECONDARY_INTEREST_CODE_ID
, LL.INVENTORY_ITEM_ID
, LL.ORGANIZATION_ID
, LL.TOTAL_AMOUNT
, LL.SALES_STAGE_ID
, LL.WIN_PROBABILITY
, LL.CHANNEL_CODE
, LL.STATUS_CODE
, LL.DECISION_DATE
, LL.ATTRIBUTE_CATEGORY
, LL.ATTRIBUTE1
, LL.ATTRIBUTE2
, LL.ATTRIBUTE3
, LL.ATTRIBUTE4
, LL.ATTRIBUTE5
, LL.ATTRIBUTE6
, LL.ATTRIBUTE7
, LL.ATTRIBUTE8
, LL.ATTRIBUTE9
, LL.ATTRIBUTE10
, LL.ATTRIBUTE11
, LL.ATTRIBUTE12
, LL.ATTRIBUTE13
, LL.ATTRIBUTE14
, LL.ATTRIBUTE15
, IT.INTEREST_TYPE
, IC1.DESCRIPTION PRIMARY_INTEREST
, IC2.DESCRIPTION SECONDARY_INTEREST
, SO.MEANING CHANNEL
, LU.MEANING STATUS
, LA1.LEAD_ADJUSTMENT_ID
, LA1.LEAD_LINE_ADJUSTMENT_ID
, LA1.ADJUSTED_BY_PERSON_ID
, LA1.TOTAL_AMOUNT
, LA1.WIN_PROBABILITY
, LA1.STATUS_CODE
, LA1.DECISION_DATE
, LA2.LEAD_ADJUSTMENT_ID
, LA2.LEAD_LINE_ADJUSTMENT_ID
, LA2.ADJUSTED_BY_PERSON_ID
, LA2.TOTAL_AMOUNT
, LA2.WIN_PROBABILITY
, LA2.STATUS_CODE
, LA2.DECISION_DATE
FROM AS_INTEREST_TYPES_VL IT
, AS_INTEREST_CODES_VL IC1
, AS_INTEREST_CODES_VL IC2
, SO_LOOKUPS SO
, AS_LOOKUPS LU
, AS_LEAD_LINE_ADJS LA1
, AS_LEAD_LINE_ADJS LA2
, AS_OPPORTUNITY_LINES LL
WHERE LL.INTEREST_TYPE_ID = IT.INTEREST_TYPE_ID(+)
AND LL.PRIMARY_INTEREST_CODE_ID = IC1.INTEREST_CODE_ID(+)
AND LL.SECONDARY_INTEREST_CODE_ID = IC2.INTEREST_CODE_ID(+)
AND LL.CHANNEL_CODE = SO.LOOKUP_CODE(+)
AND SO.LOOKUP_TYPE(+) = 'SALES_CHANNEL'
AND LL.STATUS_CODE = LU.LOOKUP_CODE(+)
AND LU.LOOKUP_TYPE(+) = 'LEAD_STATUS'
AND LA1.ORIGINAL_LEAD_ID = LL.LEAD_ID
AND LA1.ORIGINAL_LEAD_LINE_ID = LL.LEAD_LINE_ID
AND LA2.ORIGINAL_LEAD_ID = LL.LEAD_ID
AND LA2.ORIGINAL_LEAD_LINE_ID = LL.LEAD_LINE_ID