VIEW: APPS.MSD_OPPORTUNITY_DATA_V

Source

View Text - Preformatted

SELECT org_lvl.level_value inv_org, org_lvl.level_pk inv_org_pk , itm_lvl.level_value item , itm_lvl.level_pk item_pk , cus_lvl.level_value customer, cus_lvl.level_pk customer_pk, chn_lvl.level_value sales_channel, chn_lvl.level_pk sales_channel_pk, rep_lvl.level_value sales_rep, rep_lvl.level_pk sales_rep_pk , geo_lvl.level_value ship_to_loc, geo_lvl.level_pk ship_to_loc_pk , mbd.attribute_28 USER_DEFINED1, null user_defined1_pk, mbd.attribute_32 USER_DEFINED2, null USER_DEFINED2_PK, to_number(mbd.attribute_41) QUANTITY, to_number(mbd.attribute_42) AMOUNT, mbd.attribute_34 time_lvl_id, to_date(mbd.attribute_43, 'YYYY/MM/DD') END_DATE from msd_cs_data mbd, msd_level_values org_lvl, msd_level_values itm_lvl, msd_level_values cus_lvl, msd_level_values chn_lvl, msd_level_values rep_lvl, msd_level_values geo_lvl where mbd.attribute_1 = org_lvl.instance and mbd.attribute_10 = org_lvl.level_id and mbd.attribute_11 = org_lvl.sr_level_pk and mbd.attribute_1 = itm_lvl.instance and mbd.attribute_2 = itm_lvl.level_id and mbd.attribute_3 = itm_lvl.sr_level_pk and mbd.attribute_1 = geo_lvl.instance and mbd.attribute_6 = geo_lvl.level_id and mbd.attribute_7 = geo_lvl.sr_level_pk and mbd.attribute_1 = chn_lvl.instance and mbd.attribute_22 = chn_lvl.level_id and mbd.attribute_23 = chn_lvl.sr_level_pk and mbd.attribute_1 = rep_lvl.instance and mbd.attribute_18 = rep_lvl.level_id and mbd.attribute_19 = rep_lvl.sr_level_pk and mbd.attribute_1 = cus_lvl.instance and mbd.attribute_14 = cus_lvl.level_id and mbd.attribute_15 = cus_lvl.sr_level_pk and mbd.cs_definition_id = (select cs_definition_id from msd_cs_definitions where name = 'MSD_SALES_OPPORTUNITY')

View Text - HTML Formatted

SELECT ORG_LVL.LEVEL_VALUE INV_ORG
, ORG_LVL.LEVEL_PK INV_ORG_PK
, ITM_LVL.LEVEL_VALUE ITEM
, ITM_LVL.LEVEL_PK ITEM_PK
, CUS_LVL.LEVEL_VALUE CUSTOMER
, CUS_LVL.LEVEL_PK CUSTOMER_PK
, CHN_LVL.LEVEL_VALUE SALES_CHANNEL
, CHN_LVL.LEVEL_PK SALES_CHANNEL_PK
, REP_LVL.LEVEL_VALUE SALES_REP
, REP_LVL.LEVEL_PK SALES_REP_PK
, GEO_LVL.LEVEL_VALUE SHIP_TO_LOC
, GEO_LVL.LEVEL_PK SHIP_TO_LOC_PK
, MBD.ATTRIBUTE_28 USER_DEFINED1
, NULL USER_DEFINED1_PK
, MBD.ATTRIBUTE_32 USER_DEFINED2
, NULL USER_DEFINED2_PK
, TO_NUMBER(MBD.ATTRIBUTE_41) QUANTITY
, TO_NUMBER(MBD.ATTRIBUTE_42) AMOUNT
, MBD.ATTRIBUTE_34 TIME_LVL_ID
, TO_DATE(MBD.ATTRIBUTE_43
, 'YYYY/MM/DD') END_DATE
FROM MSD_CS_DATA MBD
, MSD_LEVEL_VALUES ORG_LVL
, MSD_LEVEL_VALUES ITM_LVL
, MSD_LEVEL_VALUES CUS_LVL
, MSD_LEVEL_VALUES CHN_LVL
, MSD_LEVEL_VALUES REP_LVL
, MSD_LEVEL_VALUES GEO_LVL
WHERE MBD.ATTRIBUTE_1 = ORG_LVL.INSTANCE
AND MBD.ATTRIBUTE_10 = ORG_LVL.LEVEL_ID
AND MBD.ATTRIBUTE_11 = ORG_LVL.SR_LEVEL_PK
AND MBD.ATTRIBUTE_1 = ITM_LVL.INSTANCE
AND MBD.ATTRIBUTE_2 = ITM_LVL.LEVEL_ID
AND MBD.ATTRIBUTE_3 = ITM_LVL.SR_LEVEL_PK
AND MBD.ATTRIBUTE_1 = GEO_LVL.INSTANCE
AND MBD.ATTRIBUTE_6 = GEO_LVL.LEVEL_ID
AND MBD.ATTRIBUTE_7 = GEO_LVL.SR_LEVEL_PK
AND MBD.ATTRIBUTE_1 = CHN_LVL.INSTANCE
AND MBD.ATTRIBUTE_22 = CHN_LVL.LEVEL_ID
AND MBD.ATTRIBUTE_23 = CHN_LVL.SR_LEVEL_PK
AND MBD.ATTRIBUTE_1 = REP_LVL.INSTANCE
AND MBD.ATTRIBUTE_18 = REP_LVL.LEVEL_ID
AND MBD.ATTRIBUTE_19 = REP_LVL.SR_LEVEL_PK
AND MBD.ATTRIBUTE_1 = CUS_LVL.INSTANCE
AND MBD.ATTRIBUTE_14 = CUS_LVL.LEVEL_ID
AND MBD.ATTRIBUTE_15 = CUS_LVL.SR_LEVEL_PK
AND MBD.CS_DEFINITION_ID = (SELECT CS_DEFINITION_ID
FROM MSD_CS_DEFINITIONS
WHERE NAME = 'MSD_SALES_OPPORTUNITY')