[Home] [Help]
| Product: | MSD - Demand Planning |
|---|---|
| Description: | This is the Source View for Sales Opportunity. This view would be applied to an Oracle Applications 11i instance from which the Sales Opportunity information is to be retrieved. |
| Implementation/DBA Data: | Not implemented in this database |
SELECT /*AL.LEAD_ID
, ALN.INTEREST_TYPE_ID
, IT.INTEREST_TYPE
, ALN.PRIMARY_INTEREST_CODE_ID
, IC1.CODE
, ALN.SECONDARY_INTEREST_CODE_ID
, IC2.CODE
, ITM.INVENTORY_ITEM_ID
, ITM.CONCATENATED_SEGMENTS
, ORG.ORGANIZATION_ID
, ORG.ORGANIZATION_NAME
, MSD_SR_UTIL.UOM_CONV(ALN.UOM_CODE
, ALN.INVENTORY_ITEM_ID) * ALN.QUANTITY
, ALN.TOTAL_AMOUNT * NVL(MSD_SR_UTIL.CONVERT_GLOBAL_AMT(AL.CURRENCY_CODE
, NVL(ALN.DECISION_DATE
, SYSDATE))
, 1)
, CUS.CUSTOMER_ID
, CUS.CUSTOMER_NAME
, AL.CUSTOMER_ID
, MSD_SR_UTIL.LOCATION (AL.CUSTOMER_ID)
, ALN.CHANNEL_CODE
, ALN.CHANNEL_CODE
, AL.INITIATING_CONTACT_ID
, MSD_SR_UTIL.SREP (AL.INITIATING_CONTACT_ID
, AL.ORG_ID)
, NULL
, NULL
, NULL
, NULL
, ALN.DECISION_DATE
, ALN.WIN_PROBABILITY
, ALN.STATUS_CODE
FROM AS_LEAD_LINES_ALL ALN
, AS_LEADS_ALL AL
, ORG_ORGANIZATION_DEFINITIONS ORG
, MTL_SYSTEM_ITEMS_KFV ITM
, RA_CUSTOMERS CUS
, AS_INTEREST_TYPES IT
, AS_INTEREST_CODES IC1
, AS_INTEREST_CODES IC2*/ NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
FROM DUAL
WHERE /*AL.LEAD_ID = ALN.LEAD_ID
AND AL.CUSTOMER_ID = CUS.CUSTOMER_ID
AND ORG.ORGANIZATION_ID = ALN.ORGANIZATION_ID
AND ITM.ORGANIZATION_ID = ALN.ORGANIZATION_ID
AND ITM.INVENTORY_ITEM_ID = ALN.INVENTORY_ITEM_ID
AND IT.INTEREST_TYPE_ID (+) = ALN.INTEREST_TYPE_ID
AND IC1.INTEREST_CODE_ID (+) = ALN.PRIMARY_INTEREST_CODE_ID
AND IC2.INTEREST_CODE_ID (+) = ALN.SECONDARY_INTEREST_CODE_ID*/ 1 <> 1