[Home] [Help]
| Product: | AS - Sales Foundation |
|---|---|
| Description: | |
| Implementation/DBA Data: | Not implemented in this database |
SELECT LL.ROWID LINE_ROWID
, LL.LEAD_LINE_ID
, LL.LAST_UPDATE_DATE
, LL.LAST_UPDATED_BY
, LL.CREATION_DATE
, LL.CREATED_BY
, LL.LAST_UPDATE_LOGIN
, LL.REQUEST_ID
, LL.PROGRAM_APPLICATION_ID
, LL.PROGRAM_ID
, LL.PROGRAM_UPDATE_DATE
, LL.LEAD_ID
, LL.INTEREST_TYPE_ID
, LL.PRIMARY_INTEREST_CODE_ID
, LL.SECONDARY_INTEREST_CODE_ID
, LL.INTEREST_STATUS_CODE
, LL.INVENTORY_ITEM_ID
, LL.ORGANIZATION_ID
, LL.UOM_CODE
, LL.QUANTITY
, LL.TOTAL_AMOUNT
, LL.SALES_STAGE_ID
, LL.WIN_PROBABILITY
, LL.DECISION_DATE
, LL.CHANNEL_CODE
, LL.STATUS_CODE
, LL.QUOTED_LINE_FLAG
, LL.ORIGINAL_LEAD_LINE_ID
, 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
, LL.PRICE
, LL.PRICE_VOLUME_MARGIN
, ADJ.LEAD_LINE_ADJUSTMENT_ID
, ADJ.LAST_UPDATE_DATE
, ADJ.LAST_UPDATED_BY
, ADJ.CREATION_DATE
, ADJ.CREATED_BY
, ADJ.LAST_UPDATE_LOGIN
, ADJ.WIN_PROBABILITY
, ADJ.STATUS_CODE
, ADJ.DECISION_DATE
, ADJ.TOTAL_AMOUNT
, ADJ.COMMIT_FLAG
, ADJ.ADJUSTED_BY_PERSON_ID
, ADJ.HISTORIC_WIN_PROBABILITY
, ADJ.HISTORIC_STATUS_CODE
, ADJ.HISTORIC_SALES_STAGE_ID
, ADJ.HISTORIC_DECISION_DATE
, ADJ.HISTORIC_SHIP_DATE
, ADJ.HISTORIC_TOTAL_AMOUNT
, ADJ.HISTORIC_QUANTITY
, ADJ.HISTORIC_CREDIT_AMOUNT
, ADJ.SALES_STAGE_ID
, ADJ.SHIP_DATE
, ADJ.QUANTITY
, ADJ.UOM_CODE
, ADJ.PRICE_LIST_ID
, ADJ.PRICE
, ADJ.PRICE_VOLUME_MARGIN
, ADJ.ADJUSTED_BY_SALESFORCE_ID
FROM AS_OPPORTUNITY_LINES LL
, AS_LEAD_LINE_ADJS ADJ
WHERE LL.LEAD_LINE_ID = ADJ.ORIGINAL_LEAD_LINE_ID (+)