VIEW: APPS.AS_OPPORTUNITY_DETAILS_V

Source

View Text - Preformatted

SELECT OPP.ROWID ROW_ID, OPP.LEAD_ID, OPP.LAST_UPDATE_DATE, OPP.LAST_UPDATED_BY, OPP.CREATION_DATE, OPP.CREATED_BY, OPP.LAST_UPDATE_LOGIN, OPP.REQUEST_ID, OPP.PROGRAM_APPLICATION_ID, OPP.PROGRAM_ID, OPP.PROGRAM_UPDATE_DATE, OPP.LEAD_NUMBER, OPP.STATUS STATUS_CODE, OPP.CUSTOMER_ID, OPP.ADDRESS_ID, OPP.AUTO_ASSIGNMENT_TYPE, OPP.PRM_ASSIGNMENT_TYPE, OPP.DECISION_TIMEFRAME_CODE, OPP.VEHICLE_RESPONSE_CODE, ASL8.MEANING VEHICLE_RESPONSE, OPP.BUDGET_STATUS_CODE, OPP.PRM_IND_CLASSIFICATION_CODE, OPP.PRM_LEAD_TYPE, OPP.CLOSE_COMPETITOR_CODE, OPP.DELETED_FLAG, OPP.CUSTOMER_BUDGET, OPP.ORIGINAL_LEAD_ID, OPP.INCUMBENT_PARTNER_RESOURCE_ID, OPP.INCUMBENT_PARTNER_PARTY_ID, OPP.FOLLOWUP_DATE, OPP.PRM_EXEC_SPONSOR_FLAG, OPP.PRM_PRJ_LEAD_IN_PLACE_FLAG, OPP.SALES_METHODOLOGY_ID, OPP.METHODOLOGY_CODE, NULL METHODOLOGY_NAME, OPP.OFFER_ID, AMS2.NAME OFFER_NAME, AMS2.SOURCE_CODE OFFER_CODE, OPP.LEAD_SOURCE_CODE, OPP.ORIG_SYSTEM_REFERENCE, OPP.SALES_STAGE_ID, OPP.CHANNEL_CODE, OPP.TOTAL_AMOUNT, OPP.CURRENCY_CODE, OPP.DECISION_DATE, OPP.WIN_PROBABILITY, OPP.CLOSE_REASON CLOSE_REASON_CODE, OPP.CLOSE_COMPETITOR, OPP.CLOSE_COMPETITOR_ID, OPP.CLOSE_COMMENT, OPP.DESCRIPTION, OPP.RANK RANK_CODE, OPP.END_USER_CUSTOMER_NAME, OPP.SOURCE_PROMOTION_ID, OPP.END_USER_CUSTOMER_ID, OPP.END_USER_ADDRESS_ID, OPP.ATTRIBUTE_CATEGORY, OPP.ATTRIBUTE1, OPP.ATTRIBUTE2, OPP.ATTRIBUTE3, OPP.ATTRIBUTE4, OPP.ATTRIBUTE5, OPP.ATTRIBUTE6, OPP.ATTRIBUTE7, OPP.ATTRIBUTE8, OPP.ATTRIBUTE9, OPP.ATTRIBUTE10, OPP.ATTRIBUTE11, OPP.ATTRIBUTE12, OPP.ATTRIBUTE13, OPP.ATTRIBUTE14, OPP.ATTRIBUTE15, OPP.PARENT_PROJECT, OPP.NO_OPP_ALLOWED_FLAG, OPP.DELETE_ALLOWED_FLAG, OPP.PRICE_LIST_ID, PARTY.PARTY_NAME CUSTOMER_NAME, PARTY.PERSON_FIRST_NAME, PARTY.PERSON_LAST_NAME, NVL(ORGANIZATION_NAME_PHONETIC,decode(PERSON_LAST_NAME_PHONETIC,Null,Null,PERSON_LAST_NAME_PHONETIC||', ')||PERSON_FIRST_NAME_PHONETIC) CUSTOMER_NAME_PHONETIC, PARTY.PARTY_TYPE, PARTY.CATEGORY_CODE CUSTOMER_CATEGORY_CODE, PARTY.PARTY_NUMBER, PARTY.VALIDATED_FLAG CUSTOMER_STATUS_CODE, AMS1.NAME SOURCE_PROMOTION_NAME, ASOCHANNELS.MEANING CHANNEL, NULL PRICE_LIST_NAME, AMS1.SOURCE_CODE, STGB.MIN_WIN_PROBABILITY, STGB.MAX_WIN_PROBABILITY, STGTL.NAME SALES_STAGE, ASSTATUSES.MEANING STATUS, OPP.FREEZE_FLAG FREEZE_FLAG FROM AS_LEADS_ALL OPP, HZ_PARTIES PARTY, AMS_P_SOURCE_CODES_V AMS1, OE_LOOKUPS ASOCHANNELS, AS_SALES_STAGES_ALL_B STGB, AS_SALES_STAGES_ALL_TL STGTL, AS_STATUSES_TL ASSTATUSES, AS_LOOKUPS ASL8, AMS_P_SOURCE_CODES_V AMS2 WHERE OPP.CUSTOMER_ID = PARTY.PARTY_ID AND OPP.SOURCE_PROMOTION_ID = AMS1.SOURCE_CODE_ID(+) AND OPP.CHANNEL_CODE = ASOCHANNELS.LOOKUP_CODE AND ASOCHANNELS.LOOKUP_TYPE = 'SALES_CHANNEL' AND OPP.VEHICLE_RESPONSE_CODE = ASL8.LOOKUP_CODE (+) AND ASL8.LOOKUP_TYPE (+) = 'VEHICLE_RESPONSE_CODE' 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 = AMS2.SOURCE_CODE_ID(+)

View Text - HTML Formatted

SELECT OPP.ROWID ROW_ID
, OPP.LEAD_ID
, OPP.LAST_UPDATE_DATE
, OPP.LAST_UPDATED_BY
, OPP.CREATION_DATE
, OPP.CREATED_BY
, OPP.LAST_UPDATE_LOGIN
, OPP.REQUEST_ID
, OPP.PROGRAM_APPLICATION_ID
, OPP.PROGRAM_ID
, OPP.PROGRAM_UPDATE_DATE
, OPP.LEAD_NUMBER
, OPP.STATUS STATUS_CODE
, OPP.CUSTOMER_ID
, OPP.ADDRESS_ID
, OPP.AUTO_ASSIGNMENT_TYPE
, OPP.PRM_ASSIGNMENT_TYPE
, OPP.DECISION_TIMEFRAME_CODE
, OPP.VEHICLE_RESPONSE_CODE
, ASL8.MEANING VEHICLE_RESPONSE
, OPP.BUDGET_STATUS_CODE
, OPP.PRM_IND_CLASSIFICATION_CODE
, OPP.PRM_LEAD_TYPE
, OPP.CLOSE_COMPETITOR_CODE
, OPP.DELETED_FLAG
, OPP.CUSTOMER_BUDGET
, OPP.ORIGINAL_LEAD_ID
, OPP.INCUMBENT_PARTNER_RESOURCE_ID
, OPP.INCUMBENT_PARTNER_PARTY_ID
, OPP.FOLLOWUP_DATE
, OPP.PRM_EXEC_SPONSOR_FLAG
, OPP.PRM_PRJ_LEAD_IN_PLACE_FLAG
, OPP.SALES_METHODOLOGY_ID
, OPP.METHODOLOGY_CODE
, NULL METHODOLOGY_NAME
, OPP.OFFER_ID
, AMS2.NAME OFFER_NAME
, AMS2.SOURCE_CODE OFFER_CODE
, OPP.LEAD_SOURCE_CODE
, OPP.ORIG_SYSTEM_REFERENCE
, OPP.SALES_STAGE_ID
, OPP.CHANNEL_CODE
, OPP.TOTAL_AMOUNT
, OPP.CURRENCY_CODE
, OPP.DECISION_DATE
, OPP.WIN_PROBABILITY
, OPP.CLOSE_REASON CLOSE_REASON_CODE
, OPP.CLOSE_COMPETITOR
, OPP.CLOSE_COMPETITOR_ID
, OPP.CLOSE_COMMENT
, OPP.DESCRIPTION
, OPP.RANK RANK_CODE
, OPP.END_USER_CUSTOMER_NAME
, OPP.SOURCE_PROMOTION_ID
, OPP.END_USER_CUSTOMER_ID
, OPP.END_USER_ADDRESS_ID
, OPP.ATTRIBUTE_CATEGORY
, OPP.ATTRIBUTE1
, OPP.ATTRIBUTE2
, OPP.ATTRIBUTE3
, OPP.ATTRIBUTE4
, OPP.ATTRIBUTE5
, OPP.ATTRIBUTE6
, OPP.ATTRIBUTE7
, OPP.ATTRIBUTE8
, OPP.ATTRIBUTE9
, OPP.ATTRIBUTE10
, OPP.ATTRIBUTE11
, OPP.ATTRIBUTE12
, OPP.ATTRIBUTE13
, OPP.ATTRIBUTE14
, OPP.ATTRIBUTE15
, OPP.PARENT_PROJECT
, OPP.NO_OPP_ALLOWED_FLAG
, OPP.DELETE_ALLOWED_FLAG
, OPP.PRICE_LIST_ID
, PARTY.PARTY_NAME CUSTOMER_NAME
, PARTY.PERSON_FIRST_NAME
, PARTY.PERSON_LAST_NAME
, NVL(ORGANIZATION_NAME_PHONETIC
, DECODE(PERSON_LAST_NAME_PHONETIC
, NULL
, NULL
, PERSON_LAST_NAME_PHONETIC||'
, ')||PERSON_FIRST_NAME_PHONETIC) CUSTOMER_NAME_PHONETIC
, PARTY.PARTY_TYPE
, PARTY.CATEGORY_CODE CUSTOMER_CATEGORY_CODE
, PARTY.PARTY_NUMBER
, PARTY.VALIDATED_FLAG CUSTOMER_STATUS_CODE
, AMS1.NAME SOURCE_PROMOTION_NAME
, ASOCHANNELS.MEANING CHANNEL
, NULL PRICE_LIST_NAME
, AMS1.SOURCE_CODE
, STGB.MIN_WIN_PROBABILITY
, STGB.MAX_WIN_PROBABILITY
, STGTL.NAME SALES_STAGE
, ASSTATUSES.MEANING STATUS
, OPP.FREEZE_FLAG FREEZE_FLAG
FROM AS_LEADS_ALL OPP
, HZ_PARTIES PARTY
, AMS_P_SOURCE_CODES_V AMS1
, OE_LOOKUPS ASOCHANNELS
, AS_SALES_STAGES_ALL_B STGB
, AS_SALES_STAGES_ALL_TL STGTL
, AS_STATUSES_TL ASSTATUSES
, AS_LOOKUPS ASL8
, AMS_P_SOURCE_CODES_V AMS2
WHERE OPP.CUSTOMER_ID = PARTY.PARTY_ID
AND OPP.SOURCE_PROMOTION_ID = AMS1.SOURCE_CODE_ID(+)
AND OPP.CHANNEL_CODE = ASOCHANNELS.LOOKUP_CODE
AND ASOCHANNELS.LOOKUP_TYPE = 'SALES_CHANNEL'
AND OPP.VEHICLE_RESPONSE_CODE = ASL8.LOOKUP_CODE (+)
AND ASL8.LOOKUP_TYPE (+) = 'VEHICLE_RESPONSE_CODE'
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 = AMS2.SOURCE_CODE_ID(+)