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.MSD_DP_USERS_V

Source

View Text - Preformatted


SELECT distinct mdpv.demand_plan_id, mdpv.demand_plan_name, orgs.sr_tp_id, orgs.organization_code, orgs.partner_name, fu.USER_ID, fu.USER_NAME, fr.RESPONSIBILITY_ID, fr.RESPONSIBILITY_KEY, fr.RESPONSIBILITY_NAME, fa.application_ID, fa.application_short_name from fnd_application fa, fnd_user fu, fnd_responsibility_vl fr, fnd_user_resp_groups fur, msc_trading_partners orgs, msd_demand_plans_v mdpv WHERE orgs.sr_tp_id = mdpv.organization_id and orgs.sr_instance_id = mdpv.sr_instance_id and orgs.partner_type = 3 and fu.user_id = fur.user_id and fu.START_DATE <= trunc(sysdate) and nvl(fu.END_DATE, trunc(sysdate)) >= trunc(sysdate) and fa.application_id = fur.responsibility_application_id and fr.responsibility_id = fur.responsibility_id and fur.START_DATE <= trunc(sysdate) and nvl(fur.END_DATE, trunc(sysdate)) >= trunc(sysdate) and fa.application_id = 722 and nvl(mdpv.valid_flag, '1')='0' and fr.application_id = 722 and nvl( mdpv.plan_type , -1) <> 'LIABILITY' union all SELECT distinct mdpv.demand_plan_id, mdpv.demand_plan_name, orgs.sr_tp_id, orgs.organization_code, orgs.partner_name, fu.USER_ID, fu.USER_NAME, fr.RESPONSIBILITY_ID, fr.RESPONSIBILITY_KEY, fr.RESPONSIBILITY_NAME, fa.application_ID, fa.application_short_name from fnd_application fa, fnd_user fu, fnd_responsibility_vl fr, fnd_user_resp_groups fur, msc_trading_partners orgs, msd_demand_plans_v mdpv WHERE orgs.sr_tp_id = mdpv.organization_id and orgs.sr_instance_id = mdpv.sr_instance_id and orgs.partner_type = 3 and fu.user_id = fur.user_id and fu.START_DATE <= trunc(sysdate) and nvl(fu.END_DATE, trunc(sysdate)) >= trunc(sysdate) and fa.application_id = fur.responsibility_application_id and fr.responsibility_id = fur.responsibility_id and fur.START_DATE <= trunc(sysdate) and nvl(fur.END_DATE, trunc(sysdate)) >= trunc(sysdate) and fa.application_id = 724 and nvl(mdpv.valid_flag, '1')='0' and fr.application_id = 724 and mdpv.plan_type = 'LIABILITY' union all SELECT distinct mdpv.demand_plan_id, mdpv.demand_plan_name, orgs.sr_tp_id, orgs.organization_code, orgs.partner_name, fu.USER_ID, fu.USER_NAME, fr.RESPONSIBILITY_ID, fr.RESPONSIBILITY_KEY, fr.RESPONSIBILITY_NAME, fa.application_ID, fa.application_short_name from fnd_application fa, fnd_user fu, fnd_responsibility_vl fr, fnd_user_resp_groups fur, msc_trading_partners orgs, msd_demand_plans_v mdpv WHERE orgs.sr_tp_id = mdpv.organization_id and orgs.sr_instance_id = mdpv.sr_instance_id and orgs.partner_type = 3 and fu.user_id = fur.user_id and fu.START_DATE <= trunc(sysdate) and nvl(fu.END_DATE, trunc(sysdate)) >= trunc(sysdate) and fa.application_id = fur.responsibility_application_id and fr.responsibility_id = fur.responsibility_id and fur.START_DATE <= trunc(sysdate) and nvl(fur.END_DATE, trunc(sysdate)) >= trunc(sysdate) and fa.application_id = 724 and nvl(mdpv.valid_flag, '1')='0' and fr.application_id = 724 and mdpv.plan_type = 'LIABILITY' Union all SELECT distinct mdpv.demand_plan_id, mdpv.demand_plan_name, null,null,null, fu.USER_ID, fu.USER_NAME, fr.RESPONSIBILITY_ID, fr.RESPONSIBILITY_KEY, fr.RESPONSIBILITY_NAME, fa.application_ID, fa.application_short_name from fnd_application fa, fnd_user fu, fnd_responsibility_vl fr, fnd_user_resp_groups fur, msd_demand_plans_v mdpv WHERE fu.user_id = fur.user_id and fu.START_DATE <= trunc(sysdate) and nvl(fu.END_DATE, trunc(sysdate)) >= trunc(sysdate) and fa.application_id = fur.responsibility_application_id and fr.responsibility_id = fur.responsibility_id and fur.START_DATE <= trunc(sysdate) and nvl(fur.END_DATE, trunc(sysdate)) >= trunc(sysdate) and fa.application_id = 724 and nvl(mdpv.valid_flag, '1')='0' and fr.application_id = 724 and mdpv.plan_type = 'LIABILITY' and mdpv.demand_plan_name = FND_MESSAGE.get_string('MSC', 'MSC_COLLAB_LIAB')

View Text - HTML Formatted

SELECT DISTINCT MDPV.DEMAND_PLAN_ID
, MDPV.DEMAND_PLAN_NAME
, ORGS.SR_TP_ID
, ORGS.ORGANIZATION_CODE
, ORGS.PARTNER_NAME
, FU.USER_ID
, FU.USER_NAME
, FR.RESPONSIBILITY_ID
, FR.RESPONSIBILITY_KEY
, FR.RESPONSIBILITY_NAME
, FA.APPLICATION_ID
, FA.APPLICATION_SHORT_NAME
FROM FND_APPLICATION FA
, FND_USER FU
, FND_RESPONSIBILITY_VL FR
, FND_USER_RESP_GROUPS FUR
, MSC_TRADING_PARTNERS ORGS
, MSD_DEMAND_PLANS_V MDPV
WHERE ORGS.SR_TP_ID = MDPV.ORGANIZATION_ID
AND ORGS.SR_INSTANCE_ID = MDPV.SR_INSTANCE_ID
AND ORGS.PARTNER_TYPE = 3
AND FU.USER_ID = FUR.USER_ID
AND FU.START_DATE <= TRUNC(SYSDATE)
AND NVL(FU.END_DATE
, TRUNC(SYSDATE)) >= TRUNC(SYSDATE)
AND FA.APPLICATION_ID = FUR.RESPONSIBILITY_APPLICATION_ID
AND FR.RESPONSIBILITY_ID = FUR.RESPONSIBILITY_ID
AND FUR.START_DATE <= TRUNC(SYSDATE)
AND NVL(FUR.END_DATE
, TRUNC(SYSDATE)) >= TRUNC(SYSDATE)
AND FA.APPLICATION_ID = 722
AND NVL(MDPV.VALID_FLAG
, '1')='0'
AND FR.APPLICATION_ID = 722
AND NVL( MDPV.PLAN_TYPE
, -1) <> 'LIABILITY' UNION ALL SELECT DISTINCT MDPV.DEMAND_PLAN_ID
, MDPV.DEMAND_PLAN_NAME
, ORGS.SR_TP_ID
, ORGS.ORGANIZATION_CODE
, ORGS.PARTNER_NAME
, FU.USER_ID
, FU.USER_NAME
, FR.RESPONSIBILITY_ID
, FR.RESPONSIBILITY_KEY
, FR.RESPONSIBILITY_NAME
, FA.APPLICATION_ID
, FA.APPLICATION_SHORT_NAME
FROM FND_APPLICATION FA
, FND_USER FU
, FND_RESPONSIBILITY_VL FR
, FND_USER_RESP_GROUPS FUR
, MSC_TRADING_PARTNERS ORGS
, MSD_DEMAND_PLANS_V MDPV
WHERE ORGS.SR_TP_ID = MDPV.ORGANIZATION_ID
AND ORGS.SR_INSTANCE_ID = MDPV.SR_INSTANCE_ID
AND ORGS.PARTNER_TYPE = 3
AND FU.USER_ID = FUR.USER_ID
AND FU.START_DATE <= TRUNC(SYSDATE)
AND NVL(FU.END_DATE
, TRUNC(SYSDATE)) >= TRUNC(SYSDATE)
AND FA.APPLICATION_ID = FUR.RESPONSIBILITY_APPLICATION_ID
AND FR.RESPONSIBILITY_ID = FUR.RESPONSIBILITY_ID
AND FUR.START_DATE <= TRUNC(SYSDATE)
AND NVL(FUR.END_DATE
, TRUNC(SYSDATE)) >= TRUNC(SYSDATE)
AND FA.APPLICATION_ID = 724
AND NVL(MDPV.VALID_FLAG
, '1')='0'
AND FR.APPLICATION_ID = 724
AND MDPV.PLAN_TYPE = 'LIABILITY' UNION ALL SELECT DISTINCT MDPV.DEMAND_PLAN_ID
, MDPV.DEMAND_PLAN_NAME
, ORGS.SR_TP_ID
, ORGS.ORGANIZATION_CODE
, ORGS.PARTNER_NAME
, FU.USER_ID
, FU.USER_NAME
, FR.RESPONSIBILITY_ID
, FR.RESPONSIBILITY_KEY
, FR.RESPONSIBILITY_NAME
, FA.APPLICATION_ID
, FA.APPLICATION_SHORT_NAME
FROM FND_APPLICATION FA
, FND_USER FU
, FND_RESPONSIBILITY_VL FR
, FND_USER_RESP_GROUPS FUR
, MSC_TRADING_PARTNERS ORGS
, MSD_DEMAND_PLANS_V MDPV
WHERE ORGS.SR_TP_ID = MDPV.ORGANIZATION_ID
AND ORGS.SR_INSTANCE_ID = MDPV.SR_INSTANCE_ID
AND ORGS.PARTNER_TYPE = 3
AND FU.USER_ID = FUR.USER_ID
AND FU.START_DATE <= TRUNC(SYSDATE)
AND NVL(FU.END_DATE
, TRUNC(SYSDATE)) >= TRUNC(SYSDATE)
AND FA.APPLICATION_ID = FUR.RESPONSIBILITY_APPLICATION_ID
AND FR.RESPONSIBILITY_ID = FUR.RESPONSIBILITY_ID
AND FUR.START_DATE <= TRUNC(SYSDATE)
AND NVL(FUR.END_DATE
, TRUNC(SYSDATE)) >= TRUNC(SYSDATE)
AND FA.APPLICATION_ID = 724
AND NVL(MDPV.VALID_FLAG
, '1')='0'
AND FR.APPLICATION_ID = 724
AND MDPV.PLAN_TYPE = 'LIABILITY' UNION ALL SELECT DISTINCT MDPV.DEMAND_PLAN_ID
, MDPV.DEMAND_PLAN_NAME
, NULL
, NULL
, NULL
, FU.USER_ID
, FU.USER_NAME
, FR.RESPONSIBILITY_ID
, FR.RESPONSIBILITY_KEY
, FR.RESPONSIBILITY_NAME
, FA.APPLICATION_ID
, FA.APPLICATION_SHORT_NAME
FROM FND_APPLICATION FA
, FND_USER FU
, FND_RESPONSIBILITY_VL FR
, FND_USER_RESP_GROUPS FUR
, MSD_DEMAND_PLANS_V MDPV
WHERE FU.USER_ID = FUR.USER_ID
AND FU.START_DATE <= TRUNC(SYSDATE)
AND NVL(FU.END_DATE
, TRUNC(SYSDATE)) >= TRUNC(SYSDATE)
AND FA.APPLICATION_ID = FUR.RESPONSIBILITY_APPLICATION_ID
AND FR.RESPONSIBILITY_ID = FUR.RESPONSIBILITY_ID
AND FUR.START_DATE <= TRUNC(SYSDATE)
AND NVL(FUR.END_DATE
, TRUNC(SYSDATE)) >= TRUNC(SYSDATE)
AND FA.APPLICATION_ID = 724
AND NVL(MDPV.VALID_FLAG
, '1')='0'
AND FR.APPLICATION_ID = 724
AND MDPV.PLAN_TYPE = 'LIABILITY'
AND MDPV.DEMAND_PLAN_NAME = FND_MESSAGE.GET_STRING('MSC'
, 'MSC_COLLAB_LIAB')