Product: | AST - TeleSales |
---|---|
Description: | |
Implementation/DBA Data: | APPS.AST_OPPORTUNITIES_BALI_V |
SELECT OPP.ROWID ROW_ID
, OPP.LEAD_ID
, OPP.CREATION_DATE
, OPP.LEAD_NUMBER
, OPP.STATUS
, OPP.CUSTOMER_ID
, OPP.DECISION_TIMEFRAME_CODE
, OPP.BUDGET_STATUS_CODE
, OPP.CUSTOMER_BUDGET
, OPP.OFFER_ID
, OFR.OFFER_CODE
, OPP.SALES_STAGE_ID
, OPP.CHANNEL_CODE
, OPP.TOTAL_AMOUNT
, OPP.CURRENCY_CODE
, OPP.DECISION_DATE
, OPP.WIN_PROBABILITY
, OPP.DESCRIPTION
, OPP.SOURCE_PROMOTION_ID
, OPP.PARENT_PROJECT
, AMSS.SOURCE_CODE
, ASOCHANNELS.MEANING
, STGB.MIN_WIN_PROBABILITY
, STGB.MAX_WIN_PROBABILITY
, STGTL.NAME
, ASSTATUSES.MEANING
FROM AS_LEADS_ALL OPP
, AMS_SOURCE_CODES AMSS
, OE_LOOKUPS ASOCHANNELS
, AS_SALES_STAGES_ALL_B STGB
, AS_SALES_STAGES_ALL_TL STGTL
, AS_STATUSES_TL ASSTATUSES
, AMS_ACT_OFFERS OFR
WHERE OPP.SOURCE_PROMOTION_ID = AMSS.SOURCE_CODE_ID(+)
AND OPP.CHANNEL_CODE = ASOCHANNELS.LOOKUP_CODE(+)
AND ASOCHANNELS.LOOKUP_TYPE(+) = 'SALES_CHANNEL'
AND OPP.SALES_STAGE_ID = STGB.SALES_STAGE_ID(+)
AND STGB.SALES_STAGE_ID = STGTL.SALES_STAGE_ID (+)
AND STGTL.LANGUAGE(+) = USERENV('LANG')
AND OPP.STATUS = ASSTATUSES.STATUS_CODE
AND ASSTATUSES.LANGUAGE = USERENV('LANG')
AND OPP.OFFER_ID = OFR.ACTIVITY_OFFER_ID (+)