[Home] [Help]
View: BIC_OPTY_DETAIL_V
| Product: | BIC - Customer Intelligence(Obsolete) |
|---|
| Description: | |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT ASLL.LEAD_ID
, ASLL.INVENTORY_ITEM_ID
, ASLL.CREATION_DATE
, ASLL.DECISION_DATE
, ASLL.STATUS_CODE
, ASLL.UOM_CODE
, ASLL.ORG_ID
, ASLL.QUANTITY
, ASLL.PRICE
, ASLL.TOTAL_AMOUNT
, ASLL.WIN_PROBABILITY
, ASLL.QUOTED_LINE_FLAG
, MT.DESCRIPTION
FROM AS_LEAD_LINES_ALL ASLL
, MTL_SYSTEM_ITEMS MT
WHERE ASLL.INVENTORY_ITEM_ID = MT.INVENTORY_ITEM_ID (+)
AND ASLL.ORG_ID = MT.ORGANIZATION_ID(+)
Columns
| Name |
| LEAD_ID |
| INVENTORY_ITEM_ID |
| CREATION_DATE |
| DECISION_DATE |
| STATUS_CODE |
| UOM_CODE |
| ORG_ID |
| QUANTITY |
| PRICE |
| TOTAL_AMOUNT |
| WIN_PROBABILITY |
| QUOTED_LINE_FLAG |
| DESCRIPTION |