[Home] [Help]
View: OKX_OPP_LINES_V
View Text
SELECT ASL.LEAD_LINE_ID ID1
, '#' ID2
, ASL.LEAD_ID OPP_HEADER_ID
, ASL.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ASL.ORGANIZATION_ID ORGANIZATION_ID
, ASL.UOM_CODE UOM_CODE
, ASL.QUANTITY QUANTITY
, ASL.TOTAL_AMOUNT TOTAL_AMOUNT
, ASL.SALES_STAGE_ID SALES_STAGE_ID
, ASL.WIN_PROBABILITY WIN_PROBABILITY
, ASL.STATUS_CODE STATUS_CODE
, ASL.DECISION_DATE DECISION_DATE
, ASL.ORG_ID ORG_ID
FROM AS_LEAD_LINES_ALL ASL
Columns
Name |
ID1 |
ID2 |
OPP_HEADER_ID |
INVENTORY_ITEM_ID |
ORGANIZATION_ID |
UOM_CODE |
QUANTITY |
TOTAL_AMOUNT |
SALES_STAGE_ID |
WIN_PROBABILITY |
STATUS_CODE |
DECISION_DATE |
ORG_ID |