[Home] [Help]
| Product: | AS - Sales Foundation |
|---|---|
| Description: | |
| Implementation/DBA Data: | Not implemented in this database |
SELECT '_LA:LL.INTEREST_STATUS_CODE:AS_LOOKUPS:INTEREST_STATUS:MEANING'
, '_LA:LL.STATUS_CODE:AS_LOOKUPS:LEAD_STATUS:MEANING'
, '_LA:LL.CHANNEL_CODE:SO_LOOKUPS:SALES_CHANNEL:MEANING'
, LL.WIN_PROBABILITY
, LL.DECISION_DATE
, LL.TOTAL_AMOUNT
, LL.UOM_CODE
, LL.QUANTITY
, '_LA:LL.QUOTED_LINE_FLAG:AS_LOOKUPS:FLAG:MEANING'
, LL.PRICE
, LL.PRICE_VOLUME_MARGIN
, '_DF:AS:AS_LEAD_LINES:LL' -- RESOLVE FK
, LEAD.LEAD_NUMBER
, LEAD.DESCRIPTION
, INTTYPE.INTEREST_TYPE
, PIC.CODE
, SIC.CODE
, UOM.UNIT_OF_MEASURE
, UOM.UOM_CLASS
, STAGE.NAME
, STAGE.MIN_WIN_PROBABILITY
, STAGE.MAX_WIN_PROBABILITY
, PROB.MEANING
, PARA.ORGANIZATION_CODE
, ORG.NAME -- ID
, LL.LEAD_LINE_ID
, LL.LEAD_ID
, LL.INTEREST_TYPE_ID
, LL.PRIMARY_INTEREST_CODE_ID
, LL.SECONDARY_INTEREST_CODE_ID
, LL.INVENTORY_ITEM_ID
, LL.ORGANIZATION_ID
, LL.SALES_STAGE_ID
, SIC.PF_ITEM_ID
, SIC.PF_ORGANIZATION_ID
, LL.ORG_ID -- WHO
, LL.LAST_UPDATE_DATE
, LL.LAST_UPDATED_BY
, LL.CREATION_DATE
, LL.CREATED_BY
FROM MTL_PARAMETERS PARA
, HR_ALL_ORGANIZATION_UNITS ORG
, MTL_UNITS_OF_MEASURE UOM
, AS_SALES_STAGES_ALL STAGE
, AS_FORECAST_PROB_ALL PROB
, AS_INTEREST_CODES_ALL PIC
, AS_INTEREST_CODES_ALL SIC
, AS_INTEREST_TYPES_ALL INTTYPE
, AS_LEADS_ALL LEAD
, AS_LEAD_LINES_ALL LL
WHERE LL.ORG_ID = PARA.ORGANIZATION_ID (+)
AND LL.ORG_ID = ORG.ORGANIZATION_ID (+) AND LL.UOM_CODE = UOM.UOM_CODE (+) AND LL.SALES_STAGE_ID = STAGE.SALES_STAGE_ID (+)
AND LL.WIN_PROBABILITY = PROB.PROBABILITY_VALUE (+)
AND LL.PRIMARY_INTEREST_CODE_ID = PIC.INTEREST_CODE_ID (+)
AND LL.SECONDARY_INTEREST_CODE_ID = SIC.INTEREST_CODE_ID (+)
AND LL.INTEREST_TYPE_ID = INTTYPE.INTEREST_TYPE_ID (+)
AND LL.LEAD_ID = LEAD.LEAD_ID
AND '_SEC:LL.ORG_ID' IS NOT NULL WITH READ ONLY