VIEW: APPS.MSD_SR_OPPORTUNITY_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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