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