View: MSD_DP_USERS_V

Product:	MSD - Demand Planning
Description:	This view Specifies the various Users who have access to the Demand Plan.
Implementation/DBA Data:	APPS.MSD_DP_USERS_V

View Text

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'

Columns