eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.AST_LEADS_MV

Source

View Text - Preformatted


SELECT lead_mb.SALES_LEAD_ID, lead_mb.LAST_UPDATE_DATE, lead_mb.LAST_UPDATED_BY, lead_mb.CREATION_DATE, lead_mb.CREATED_BY, lead_mb.LAST_UPDATE_LOGIN, lead_mb.REQUEST_ID, lead_mb.PROGRAM_APPLICATION_ID, lead_mb.PROGRAM_ID, lead_mb.PROGRAM_UPDATE_DATE, lead_mb.LEAD_NUMBER, lead_mb.STATUS_CODE lead_status_code, STATUS_t.MEANING lead_status, lead_mb.OPP_OPEN_STATUS_FLAG, lead_mb.CUSTOMER_ID, lead_mb.ADDRESS_ID, lead_mb.ORIG_SYSTEM_REFERENCE, lead_mb.ASSIGN_TO_PERSON_ID, lead_mb.ASSIGN_TO_SALESFORCE_ID, lead_mb.lead_owner, lead_mb.CHANNEL_CODE, OELKP.MEANING sales_channel, lead_mb.BUDGET_AMOUNT, lead_mb.BUDGET_STATUS_CODE, AS_LOOKUPS2.MEANING BUDGET_STATUS, lead_mb.CURRENCY_CODE, lead_mb.DECISION_TIMEFRAME_CODE, AS_LOOKUPS3.MEANING time_frame, lead_mb.DESCRIPTION, lead_mb.LEAD_RANK_CODE, RANK_t.MEANING rank, lead_mb.SOURCE_PROMOTION_ID, lead_mb.INITIATING_CONTACT_ID, lead_mb.CLOSE_REASON close_reason_code, AS_LOOKUPS4.MEANING close_reason, lead_mb.PARENT_PROJECT, lead_mb.ATTRIBUTE_CATEGORY, lead_mb.ATTRIBUTE1, lead_mb.ATTRIBUTE2, lead_mb.ATTRIBUTE3, lead_mb.ATTRIBUTE4, lead_mb.ATTRIBUTE5, lead_mb.ATTRIBUTE6, lead_mb.ATTRIBUTE7, lead_mb.ATTRIBUTE8, lead_mb.ATTRIBUTE9, lead_mb.ATTRIBUTE10, lead_mb.ATTRIBUTE11, lead_mb.ATTRIBUTE12, lead_mb.ATTRIBUTE13, lead_mb.ATTRIBUTE14, lead_mb.ATTRIBUTE15, lead_mb.ASSIGN_DATE, lead_mb.ACCEPT_FLAG, lead_mb.VEHICLE_RESPONSE_CODE, AS_LOOKUPS5.MEANING vehicle_response_desc, lead_mb.TOTAL_SCORE, lead_mb.SCORECARD_ID, lead_mb.KEEP_FLAG, lead_mb.URGENT_FLAG, lead_mb.IMPORT_FLAG, lead_mb.REJECT_REASON_CODE, lead_mb.LEAD_RANK_ID, lead_mb.DELETED_FLAG, lead_mb.ASSIGN_SALES_GROUP_ID, lead_mb.OFFER_ID, lead_mb.CONTACT_ROLE_CODE, lead_mb.QUALIFIED_FLAG, lead_mb.AUTO_ASSIGNMENT_TYPE, lead_mb.language_code lang FROM (SELECT LEAD.SALES_LEAD_ID, LEAD.LAST_UPDATE_DATE, LEAD.LAST_UPDATED_BY, LEAD.CREATION_DATE, LEAD.CREATED_BY, LEAD.LAST_UPDATE_LOGIN, LEAD.REQUEST_ID, LEAD.PROGRAM_APPLICATION_ID, LEAD.PROGRAM_ID, LEAD.PROGRAM_UPDATE_DATE, LEAD.LEAD_NUMBER, LEAD.STATUS_CODE, STATUS.OPP_OPEN_STATUS_FLAG, LEAD.CUSTOMER_ID, LEAD.ADDRESS_ID, LEAD.ORIG_SYSTEM_REFERENCE, LEAD.ASSIGN_TO_PERSON_ID, LEAD.ASSIGN_TO_SALESFORCE_ID, RES.SOURCE_NAME lead_owner, LEAD.CHANNEL_CODE, LEAD.BUDGET_AMOUNT, LEAD.BUDGET_STATUS_CODE, LEAD.CURRENCY_CODE, LEAD.DECISION_TIMEFRAME_CODE, LEAD.DESCRIPTION, LEAD.LEAD_RANK_CODE, LEAD.SOURCE_PROMOTION_ID, LEAD.INITIATING_CONTACT_ID, LEAD.CLOSE_REASON, LEAD.PARENT_PROJECT, LEAD.ATTRIBUTE_CATEGORY, LEAD.ATTRIBUTE1, LEAD.ATTRIBUTE2, LEAD.ATTRIBUTE3, LEAD.ATTRIBUTE4, LEAD.ATTRIBUTE5, LEAD.ATTRIBUTE6, LEAD.ATTRIBUTE7, LEAD.ATTRIBUTE8, LEAD.ATTRIBUTE9, LEAD.ATTRIBUTE10, LEAD.ATTRIBUTE11, LEAD.ATTRIBUTE12, LEAD.ATTRIBUTE13, LEAD.ATTRIBUTE14, LEAD.ATTRIBUTE15, LEAD.ASSIGN_DATE, LEAD.ACCEPT_FLAG, LEAD.VEHICLE_RESPONSE_CODE, LEAD.TOTAL_SCORE, LEAD.SCORECARD_ID, LEAD.KEEP_FLAG, LEAD.URGENT_FLAG, LEAD.IMPORT_FLAG, LEAD.REJECT_REASON_CODE, LEAD.LEAD_RANK_ID, LEAD.DELETED_FLAG, LEAD.ASSIGN_SALES_GROUP_ID, LEAD.OFFER_ID, LEAD.CONTACT_ROLE_CODE, LEAD.QUALIFIED_FLAG, LEAD.AUTO_ASSIGNMENT_TYPE, fndlang.language_code FROM AS_SALES_LEADS LEAD, AS_STATUSES_b STATUS, JTF_RS_RESOURCE_EXTNS RES, fnd_languages fndlang WHERE fndlang.installed_flag in ('I', 'B') AND LEAD.STATUS_CODE = STATUS.STATUS_CODE AND RES.RESOURCE_ID(+) = LEAD.ASSIGN_TO_SALESFORCE_ID AND RES.CATEGORY(+) = 'EMPLOYEE' AND LEAD.LAST_UPDATE_DATE >= SYSDATE-NVL((select profile_option_value from fnd_profile_option_values where level_id = 10001 and (profile_option_id, application_id) = (select profile_option_id, application_id from fnd_profile_options where profile_option_name = 'AST_MV_NUM_OF_MONTH_DATA')),3)*30 ) LEAD_mb, AS_STATUSES_tL STATUS_t, AS_SALES_LEAD_RANKS_TL RANK_t, FND_LOOKUP_VALUES AS_LOOKUPS2, FND_LOOKUP_VALUES AS_LOOKUPS3, FND_LOOKUP_VALUES AS_LOOKUPS4, FND_LOOKUP_VALUES AS_LOOKUPS5, FND_LOOKUP_VALUES OELKP WHERE LEAD_mb.STATUS_CODE = STATUS_t.STATUS_CODE AND STATUS_t.language = lead_mb.language_code AND LEAD_mb.LEAD_RANK_ID = RANK_t.RANK_ID(+) AND RANK_t.LANGUAGE(+) = lead_mb.language_code AND LEAD_mb.BUDGET_STATUS_CODE = AS_LOOKUPS2.LOOKUP_CODE(+) AND AS_LOOKUPS2.LOOKUP_TYPE(+) = 'BUDGET_STATUS' AND AS_LOOKUPS2.LANGUAGE(+) = lead_mb.language_code AND AS_LOOKUPS2.VIEW_APPLICATION_ID(+) = 279 AND nvl(AS_LOOKUPS2.SECURITY_GROUP_ID, 0) = nvl((select nvl(max(lt.security_group_id), 0) from fnd_lookup_types lt where lt.view_application_id = 279 and lt.lookup_type = 'BUDGET_STATUS' and lt.security_group_id in (0,to_number(decode(substrb(userenv('CLIENT_INFO'),55,1),' ', '0',null, '0', substrb(userenv('CLIENT_INFO'),55,10))))), -99) AND LEAD_mb.DECISION_TIMEFRAME_CODE = AS_LOOKUPS3.LOOKUP_CODE(+) AND AS_LOOKUPS3.LOOKUP_TYPE(+) = 'DECISION_TIMEFRAME' AND AS_LOOKUPS3.LANGUAGE(+) = lead_mb.language_code AND AS_LOOKUPS3.VIEW_APPLICATION_ID(+) = 279 AND nvl(AS_LOOKUPS3.SECURITY_GROUP_ID, 0) = nvl((select nvl(max(lt.security_group_id), 0) from fnd_lookup_types lt where lt.view_application_id = 279 and lt.lookup_type = 'DECISION_TIMEFRAME' and lt.security_group_id in (0,to_number(decode(substrb(userenv('CLIENT_INFO'),55,1),' ', '0',null, '0',substrb(userenv('CLIENT_INFO'),55,10))))), -99) AND LEAD_mb.CLOSE_REASON = AS_LOOKUPS4.LOOKUP_CODE(+) AND AS_LOOKUPS4.LOOKUP_TYPE(+) = 'CLOSE_REASON' AND AS_LOOKUPS4.LANGUAGE(+) = lead_mb.language_code AND AS_LOOKUPS4.VIEW_APPLICATION_ID(+) = 279 AND nvl(AS_LOOKUPS4.SECURITY_GROUP_ID, 0) = nvl((select nvl(max(lt.security_group_id), 0) from fnd_lookup_types lt where lt.view_application_id = 279 and lt.lookup_type = 'CLOSE_REASON' and lt.security_group_id in (0,to_number(decode(substrb(userenv('CLIENT_INFO'),55,1),' ', '0',null, '0',substrb(userenv('CLIENT_INFO'),55,10))))), -99) AND LEAD_mb.CHANNEL_CODE = OELKP.LOOKUP_CODE(+) AND OELKP.LOOKUP_TYPE(+) = 'SALES_CHANNEL' AND OELKP.LANGUAGE(+) = lead_mb.language_code AND OELKP.VIEW_APPLICATION_ID(+) = 660 AND nvl(OELKP.SECURITY_GROUP_ID, 0) = nvl((select nvl(max(lt.security_group_id), 0) from fnd_lookup_types lt where lt.view_application_id = 660 and lt.lookup_type = 'SALES_CHANNEL' and lt.security_group_id in (0,to_number(decode(substrb(userenv('CLIENT_INFO'),55,1),' ', '0',null, '0',substrb(userenv('CLIENT_INFO'),55,10))))), -99) AND AS_LOOKUPS5.LOOKUP_CODE(+) = LEAD_mb.VEHICLE_RESPONSE_CODE AND AS_LOOKUPS5.LOOKUP_TYPE(+) = 'VEHICLE_RESPONSE_CODE' AND AS_LOOKUPS5.LANGUAGE(+) = lead_mb.language_code AND AS_LOOKUPS5.VIEW_APPLICATION_ID(+) = 279 AND nvl(AS_LOOKUPS5.SECURITY_GROUP_ID, 0) = nvl((select nvl(max(lt.security_group_id), 0) from fnd_lookup_types lt where lt.view_application_id = 279 and lt.lookup_type = 'VEHICLE_RESPONSE_CODE' and lt.security_group_id in (0,to_number(decode(substrb(userenv('CLIENT_INFO'),55,1),' ', '0',null, '0',substrb(userenv('CLIENT_INFO'),55,10))))), -99)

View Text - HTML Formatted

SELECT LEAD_MB.SALES_LEAD_ID
, LEAD_MB.LAST_UPDATE_DATE
, LEAD_MB.LAST_UPDATED_BY
, LEAD_MB.CREATION_DATE
, LEAD_MB.CREATED_BY
, LEAD_MB.LAST_UPDATE_LOGIN
, LEAD_MB.REQUEST_ID
, LEAD_MB.PROGRAM_APPLICATION_ID
, LEAD_MB.PROGRAM_ID
, LEAD_MB.PROGRAM_UPDATE_DATE
, LEAD_MB.LEAD_NUMBER
, LEAD_MB.STATUS_CODE LEAD_STATUS_CODE
, STATUS_T.MEANING LEAD_STATUS
, LEAD_MB.OPP_OPEN_STATUS_FLAG
, LEAD_MB.CUSTOMER_ID
, LEAD_MB.ADDRESS_ID
, LEAD_MB.ORIG_SYSTEM_REFERENCE
, LEAD_MB.ASSIGN_TO_PERSON_ID
, LEAD_MB.ASSIGN_TO_SALESFORCE_ID
, LEAD_MB.LEAD_OWNER
, LEAD_MB.CHANNEL_CODE
, OELKP.MEANING SALES_CHANNEL
, LEAD_MB.BUDGET_AMOUNT
, LEAD_MB.BUDGET_STATUS_CODE
, AS_LOOKUPS2.MEANING BUDGET_STATUS
, LEAD_MB.CURRENCY_CODE
, LEAD_MB.DECISION_TIMEFRAME_CODE
, AS_LOOKUPS3.MEANING TIME_FRAME
, LEAD_MB.DESCRIPTION
, LEAD_MB.LEAD_RANK_CODE
, RANK_T.MEANING RANK
, LEAD_MB.SOURCE_PROMOTION_ID
, LEAD_MB.INITIATING_CONTACT_ID
, LEAD_MB.CLOSE_REASON CLOSE_REASON_CODE
, AS_LOOKUPS4.MEANING CLOSE_REASON
, LEAD_MB.PARENT_PROJECT
, LEAD_MB.ATTRIBUTE_CATEGORY
, LEAD_MB.ATTRIBUTE1
, LEAD_MB.ATTRIBUTE2
, LEAD_MB.ATTRIBUTE3
, LEAD_MB.ATTRIBUTE4
, LEAD_MB.ATTRIBUTE5
, LEAD_MB.ATTRIBUTE6
, LEAD_MB.ATTRIBUTE7
, LEAD_MB.ATTRIBUTE8
, LEAD_MB.ATTRIBUTE9
, LEAD_MB.ATTRIBUTE10
, LEAD_MB.ATTRIBUTE11
, LEAD_MB.ATTRIBUTE12
, LEAD_MB.ATTRIBUTE13
, LEAD_MB.ATTRIBUTE14
, LEAD_MB.ATTRIBUTE15
, LEAD_MB.ASSIGN_DATE
, LEAD_MB.ACCEPT_FLAG
, LEAD_MB.VEHICLE_RESPONSE_CODE
, AS_LOOKUPS5.MEANING VEHICLE_RESPONSE_DESC
, LEAD_MB.TOTAL_SCORE
, LEAD_MB.SCORECARD_ID
, LEAD_MB.KEEP_FLAG
, LEAD_MB.URGENT_FLAG
, LEAD_MB.IMPORT_FLAG
, LEAD_MB.REJECT_REASON_CODE
, LEAD_MB.LEAD_RANK_ID
, LEAD_MB.DELETED_FLAG
, LEAD_MB.ASSIGN_SALES_GROUP_ID
, LEAD_MB.OFFER_ID
, LEAD_MB.CONTACT_ROLE_CODE
, LEAD_MB.QUALIFIED_FLAG
, LEAD_MB.AUTO_ASSIGNMENT_TYPE
, LEAD_MB.LANGUAGE_CODE LANG
FROM (SELECT LEAD.SALES_LEAD_ID
, LEAD.LAST_UPDATE_DATE
, LEAD.LAST_UPDATED_BY
, LEAD.CREATION_DATE
, LEAD.CREATED_BY
, LEAD.LAST_UPDATE_LOGIN
, LEAD.REQUEST_ID
, LEAD.PROGRAM_APPLICATION_ID
, LEAD.PROGRAM_ID
, LEAD.PROGRAM_UPDATE_DATE
, LEAD.LEAD_NUMBER
, LEAD.STATUS_CODE
, STATUS.OPP_OPEN_STATUS_FLAG
, LEAD.CUSTOMER_ID
, LEAD.ADDRESS_ID
, LEAD.ORIG_SYSTEM_REFERENCE
, LEAD.ASSIGN_TO_PERSON_ID
, LEAD.ASSIGN_TO_SALESFORCE_ID
, RES.SOURCE_NAME LEAD_OWNER
, LEAD.CHANNEL_CODE
, LEAD.BUDGET_AMOUNT
, LEAD.BUDGET_STATUS_CODE
, LEAD.CURRENCY_CODE
, LEAD.DECISION_TIMEFRAME_CODE
, LEAD.DESCRIPTION
, LEAD.LEAD_RANK_CODE
, LEAD.SOURCE_PROMOTION_ID
, LEAD.INITIATING_CONTACT_ID
, LEAD.CLOSE_REASON
, LEAD.PARENT_PROJECT
, LEAD.ATTRIBUTE_CATEGORY
, LEAD.ATTRIBUTE1
, LEAD.ATTRIBUTE2
, LEAD.ATTRIBUTE3
, LEAD.ATTRIBUTE4
, LEAD.ATTRIBUTE5
, LEAD.ATTRIBUTE6
, LEAD.ATTRIBUTE7
, LEAD.ATTRIBUTE8
, LEAD.ATTRIBUTE9
, LEAD.ATTRIBUTE10
, LEAD.ATTRIBUTE11
, LEAD.ATTRIBUTE12
, LEAD.ATTRIBUTE13
, LEAD.ATTRIBUTE14
, LEAD.ATTRIBUTE15
, LEAD.ASSIGN_DATE
, LEAD.ACCEPT_FLAG
, LEAD.VEHICLE_RESPONSE_CODE
, LEAD.TOTAL_SCORE
, LEAD.SCORECARD_ID
, LEAD.KEEP_FLAG
, LEAD.URGENT_FLAG
, LEAD.IMPORT_FLAG
, LEAD.REJECT_REASON_CODE
, LEAD.LEAD_RANK_ID
, LEAD.DELETED_FLAG
, LEAD.ASSIGN_SALES_GROUP_ID
, LEAD.OFFER_ID
, LEAD.CONTACT_ROLE_CODE
, LEAD.QUALIFIED_FLAG
, LEAD.AUTO_ASSIGNMENT_TYPE
, FNDLANG.LANGUAGE_CODE
FROM AS_SALES_LEADS LEAD
, AS_STATUSES_B STATUS
, JTF_RS_RESOURCE_EXTNS RES
, FND_LANGUAGES FNDLANG
WHERE FNDLANG.INSTALLED_FLAG IN ('I'
, 'B')
AND LEAD.STATUS_CODE = STATUS.STATUS_CODE
AND RES.RESOURCE_ID(+) = LEAD.ASSIGN_TO_SALESFORCE_ID
AND RES.CATEGORY(+) = 'EMPLOYEE'
AND LEAD.LAST_UPDATE_DATE >= SYSDATE-NVL((SELECT PROFILE_OPTION_VALUE
FROM FND_PROFILE_OPTION_VALUES
WHERE LEVEL_ID = 10001
AND (PROFILE_OPTION_ID
, APPLICATION_ID) = (SELECT PROFILE_OPTION_ID
, APPLICATION_ID
FROM FND_PROFILE_OPTIONS
WHERE PROFILE_OPTION_NAME = 'AST_MV_NUM_OF_MONTH_DATA'))
, 3)*30 ) LEAD_MB
, AS_STATUSES_TL STATUS_T
, AS_SALES_LEAD_RANKS_TL RANK_T
, FND_LOOKUP_VALUES AS_LOOKUPS2
, FND_LOOKUP_VALUES AS_LOOKUPS3
, FND_LOOKUP_VALUES AS_LOOKUPS4
, FND_LOOKUP_VALUES AS_LOOKUPS5
, FND_LOOKUP_VALUES OELKP
WHERE LEAD_MB.STATUS_CODE = STATUS_T.STATUS_CODE
AND STATUS_T.LANGUAGE = LEAD_MB.LANGUAGE_CODE
AND LEAD_MB.LEAD_RANK_ID = RANK_T.RANK_ID(+)
AND RANK_T.LANGUAGE(+) = LEAD_MB.LANGUAGE_CODE
AND LEAD_MB.BUDGET_STATUS_CODE = AS_LOOKUPS2.LOOKUP_CODE(+)
AND AS_LOOKUPS2.LOOKUP_TYPE(+) = 'BUDGET_STATUS'
AND AS_LOOKUPS2.LANGUAGE(+) = LEAD_MB.LANGUAGE_CODE
AND AS_LOOKUPS2.VIEW_APPLICATION_ID(+) = 279
AND NVL(AS_LOOKUPS2.SECURITY_GROUP_ID
, 0) = NVL((SELECT NVL(MAX(LT.SECURITY_GROUP_ID)
, 0)
FROM FND_LOOKUP_TYPES LT
WHERE LT.VIEW_APPLICATION_ID = 279
AND LT.LOOKUP_TYPE = 'BUDGET_STATUS'
AND LT.SECURITY_GROUP_ID IN (0
, TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 55
, 1)
, ' '
, '0'
, NULL
, '0'
, SUBSTRB(USERENV('CLIENT_INFO')
, 55
, 10)))))
, -99)
AND LEAD_MB.DECISION_TIMEFRAME_CODE = AS_LOOKUPS3.LOOKUP_CODE(+)
AND AS_LOOKUPS3.LOOKUP_TYPE(+) = 'DECISION_TIMEFRAME'
AND AS_LOOKUPS3.LANGUAGE(+) = LEAD_MB.LANGUAGE_CODE
AND AS_LOOKUPS3.VIEW_APPLICATION_ID(+) = 279
AND NVL(AS_LOOKUPS3.SECURITY_GROUP_ID
, 0) = NVL((SELECT NVL(MAX(LT.SECURITY_GROUP_ID)
, 0)
FROM FND_LOOKUP_TYPES LT
WHERE LT.VIEW_APPLICATION_ID = 279
AND LT.LOOKUP_TYPE = 'DECISION_TIMEFRAME'
AND LT.SECURITY_GROUP_ID IN (0
, TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 55
, 1)
, ' '
, '0'
, NULL
, '0'
, SUBSTRB(USERENV('CLIENT_INFO')
, 55
, 10)))))
, -99)
AND LEAD_MB.CLOSE_REASON = AS_LOOKUPS4.LOOKUP_CODE(+)
AND AS_LOOKUPS4.LOOKUP_TYPE(+) = 'CLOSE_REASON'
AND AS_LOOKUPS4.LANGUAGE(+) = LEAD_MB.LANGUAGE_CODE
AND AS_LOOKUPS4.VIEW_APPLICATION_ID(+) = 279
AND NVL(AS_LOOKUPS4.SECURITY_GROUP_ID
, 0) = NVL((SELECT NVL(MAX(LT.SECURITY_GROUP_ID)
, 0)
FROM FND_LOOKUP_TYPES LT
WHERE LT.VIEW_APPLICATION_ID = 279
AND LT.LOOKUP_TYPE = 'CLOSE_REASON'
AND LT.SECURITY_GROUP_ID IN (0
, TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 55
, 1)
, ' '
, '0'
, NULL
, '0'
, SUBSTRB(USERENV('CLIENT_INFO')
, 55
, 10)))))
, -99)
AND LEAD_MB.CHANNEL_CODE = OELKP.LOOKUP_CODE(+)
AND OELKP.LOOKUP_TYPE(+) = 'SALES_CHANNEL'
AND OELKP.LANGUAGE(+) = LEAD_MB.LANGUAGE_CODE
AND OELKP.VIEW_APPLICATION_ID(+) = 660
AND NVL(OELKP.SECURITY_GROUP_ID
, 0) = NVL((SELECT NVL(MAX(LT.SECURITY_GROUP_ID)
, 0)
FROM FND_LOOKUP_TYPES LT
WHERE LT.VIEW_APPLICATION_ID = 660
AND LT.LOOKUP_TYPE = 'SALES_CHANNEL'
AND LT.SECURITY_GROUP_ID IN (0
, TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 55
, 1)
, ' '
, '0'
, NULL
, '0'
, SUBSTRB(USERENV('CLIENT_INFO')
, 55
, 10)))))
, -99)
AND AS_LOOKUPS5.LOOKUP_CODE(+) = LEAD_MB.VEHICLE_RESPONSE_CODE
AND AS_LOOKUPS5.LOOKUP_TYPE(+) = 'VEHICLE_RESPONSE_CODE'
AND AS_LOOKUPS5.LANGUAGE(+) = LEAD_MB.LANGUAGE_CODE
AND AS_LOOKUPS5.VIEW_APPLICATION_ID(+) = 279
AND NVL(AS_LOOKUPS5.SECURITY_GROUP_ID
, 0) = NVL((SELECT NVL(MAX(LT.SECURITY_GROUP_ID)
, 0)
FROM FND_LOOKUP_TYPES LT
WHERE LT.VIEW_APPLICATION_ID = 279
AND LT.LOOKUP_TYPE = 'VEHICLE_RESPONSE_CODE'
AND LT.SECURITY_GROUP_ID IN (0
, TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 55
, 1)
, ' '
, '0'
, NULL
, '0'
, SUBSTRB(USERENV('CLIENT_INFO')
, 55
, 10)))))
, -99)