DBA Data[Home] [Help]

VIEW: APPS.AST_OPPORTUNITIES_BALI_V

Source

View Text - Preformatted

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 (+)
View Text - HTML Formatted

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 (+)