VIEW: APPS.MSC_PLAN_ORGS_V

Source

View Text - Preformatted

SELECT MPO.ROWID , MPO.PLAN_ID , MPO.SR_INSTANCE_ID , MP.ORGANIZATION_ID , MP.SR_INSTANCE_ID , MP.COMPILE_DESIGNATOR , MPO.ORGANIZATION_ID , nvl(PT.ORGANIZATION_CODE, mpo.organization_code) , nvl(PT.PARTNER_NAME, fnd_message.get_string('MSC', 'MSC_PLAN_ORGS_DELETE_ORG')) , MPO.PLAN_LEVEL , MPO.LAST_UPDATED_BY , MPO.LAST_UPDATE_DATE , MPO.CREATED_BY , MPO.CREATION_DATE , MPO.LAST_UPDATE_LOGIN , MPO.NET_WIP , MPO.NET_RESERVATIONS , MPO.NET_PURCHASING , MPO.PLAN_SAFETY_STOCK , MPO.REQUEST_ID , MPO.PROGRAM_APPLICATION_ID , MPO.PROGRAM_ID , MPO.PROGRAM_UPDATE_DATE , MPO.ATTRIBUTE_CATEGORY , MPO.ATTRIBUTE1 , MPO.ATTRIBUTE2 , MPO.ATTRIBUTE3 , MPO.ATTRIBUTE4 , MPO.ATTRIBUTE5 , MPO.ATTRIBUTE6 , MPO.ATTRIBUTE7 , MPO.ATTRIBUTE8 , MPO.ATTRIBUTE9 , MPO.ATTRIBUTE10 , MPO.ATTRIBUTE11 , MPO.ATTRIBUTE12 , MPO.ATTRIBUTE13 , MPO.ATTRIBUTE14 , MPO.ATTRIBUTE15 , MPO.SIMULATION_SET , MPO.BILL_OF_RESOURCES , MPO.INCLUDE_SALESORDER ,nvl(MPO.NET_ON_HAND,2) , NVL(MPO.CURR_DS_ENABLED_FLAG , 2) , MPO.CURR_FROZEN_HORIZON_DAYS , NVL(MPO.CURR_RESPECT_MAX_ACCEPT_DAYS , 2) , NVL(MPO.CURR_MIN_SUPPLY_LEAD_TIME , 2) ,NVL(MPO.INCLUDE_PRODUCTION_SCHEDULE, 2) ,MPO.PRODUCTION_SCHEDULE_ID ,DECODE(to_char(MPO.PRODUCTION_SCHEDULE_ID), NULL , NULL ,MP1.COMPILE_DESIGNATOR ) ,MPO.FIRM_HORIZON_DAYS ,MPO.FORECAST_CALENDAR FROM MSC_TRADING_PARTNERS PT, MSC_PLANS MP, MSC_PLANS MP1 , MSC_PLAN_ORGANIZATIONS MPO WHERE MPO.PLAN_ID = MP.PLAN_ID AND MPO.SR_INSTANCE_ID = PT.SR_INSTANCE_ID (+) AND MPO.ORGANIZATION_ID = PT.SR_TP_ID (+) AND MP1.PLAN_ID = Decode(MPO.PRODUCTION_SCHEDULE_ID , null , MP.PLAN_ID ,MPO.PRODUCTION_SCHEDULE_ID ) AND PT.partner_type (+) =3

View Text - HTML Formatted

SELECT MPO.ROWID
, MPO.PLAN_ID
, MPO.SR_INSTANCE_ID
, MP.ORGANIZATION_ID
, MP.SR_INSTANCE_ID
, MP.COMPILE_DESIGNATOR
, MPO.ORGANIZATION_ID
, NVL(PT.ORGANIZATION_CODE
, MPO.ORGANIZATION_CODE)
, NVL(PT.PARTNER_NAME
, FND_MESSAGE.GET_STRING('MSC'
, 'MSC_PLAN_ORGS_DELETE_ORG'))
, MPO.PLAN_LEVEL
, MPO.LAST_UPDATED_BY
, MPO.LAST_UPDATE_DATE
, MPO.CREATED_BY
, MPO.CREATION_DATE
, MPO.LAST_UPDATE_LOGIN
, MPO.NET_WIP
, MPO.NET_RESERVATIONS
, MPO.NET_PURCHASING
, MPO.PLAN_SAFETY_STOCK
, MPO.REQUEST_ID
, MPO.PROGRAM_APPLICATION_ID
, MPO.PROGRAM_ID
, MPO.PROGRAM_UPDATE_DATE
, MPO.ATTRIBUTE_CATEGORY
, MPO.ATTRIBUTE1
, MPO.ATTRIBUTE2
, MPO.ATTRIBUTE3
, MPO.ATTRIBUTE4
, MPO.ATTRIBUTE5
, MPO.ATTRIBUTE6
, MPO.ATTRIBUTE7
, MPO.ATTRIBUTE8
, MPO.ATTRIBUTE9
, MPO.ATTRIBUTE10
, MPO.ATTRIBUTE11
, MPO.ATTRIBUTE12
, MPO.ATTRIBUTE13
, MPO.ATTRIBUTE14
, MPO.ATTRIBUTE15
, MPO.SIMULATION_SET
, MPO.BILL_OF_RESOURCES
, MPO.INCLUDE_SALESORDER
, NVL(MPO.NET_ON_HAND
, 2)
, NVL(MPO.CURR_DS_ENABLED_FLAG
, 2)
, MPO.CURR_FROZEN_HORIZON_DAYS
, NVL(MPO.CURR_RESPECT_MAX_ACCEPT_DAYS
, 2)
, NVL(MPO.CURR_MIN_SUPPLY_LEAD_TIME
, 2)
, NVL(MPO.INCLUDE_PRODUCTION_SCHEDULE
, 2)
, MPO.PRODUCTION_SCHEDULE_ID
, DECODE(TO_CHAR(MPO.PRODUCTION_SCHEDULE_ID)
, NULL
, NULL
, MP1.COMPILE_DESIGNATOR )
, MPO.FIRM_HORIZON_DAYS
, MPO.FORECAST_CALENDAR
FROM MSC_TRADING_PARTNERS PT
, MSC_PLANS MP
, MSC_PLANS MP1
, MSC_PLAN_ORGANIZATIONS MPO
WHERE MPO.PLAN_ID = MP.PLAN_ID
AND MPO.SR_INSTANCE_ID = PT.SR_INSTANCE_ID (+)
AND MPO.ORGANIZATION_ID = PT.SR_TP_ID (+)
AND MP1.PLAN_ID = DECODE(MPO.PRODUCTION_SCHEDULE_ID
, NULL
, MP.PLAN_ID
, MPO.PRODUCTION_SCHEDULE_ID )
AND PT.PARTNER_TYPE (+) =3