View: ASBV_SALES_OPPORTUNITY_LINES

View Text

SELECT '_LA:LINE.INTEREST_STATUS_CODE:AS_LOOKUPS:INTEREST_STATUS:MEANING'
, '_LA:LINE.STATUS_CODE:AS_LOOKUPS:LEAD_STATUS:MEANING'
, '_LA:LINE.CHANNEL_CODE:SO_LOOKUPS:SALES_CHANNEL:MEANING'
, LINE.WIN_PROBABILITY
, LINE.DECISION_DATE
, LINE.TOTAL_AMOUNT
, LINE.UOM_CODE
, LINE.QUANTITY
, '_LA:LINE.QUOTED_LINE_FLAG:AS_LOOKUPS:FLAG:MEANING'
, LINE.PRICE
, LINE.PRICE_VOLUME_MARGIN
, '_DF:AS:AS_LEAD_LINES:LINE' -- ID
, LINE.LEAD_LINE_ID
, LINE.LEAD_ID
, LINE.INTEREST_TYPE_ID
, LINE.PRIMARY_INTEREST_CODE_ID
, LINE.SECONDARY_INTEREST_CODE_ID
, LINE.INVENTORY_ITEM_ID
, LINE.ORGANIZATION_ID
, LINE.SALES_STAGE_ID
, LINE.ORG_ID -- WHO
, LINE.LAST_UPDATE_DATE
, LINE.LAST_UPDATED_BY
, LINE.CREATION_DATE
, LINE.CREATED_BY
FROM AS_LEAD_LINES_ALL LINE
WHERE '_SEC:LINE.ORG_ID' IS NOT NULL WITH READ ONLY

Columns