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

Source

View Text - Preformatted


SELECT MPS.ROWID , MPS.PLAN_ID , MPS.SR_INSTANCE_ID , MPS.ORGANIZATION_ID , MPS.INPUT_SCHEDULE_ID , DESIG.DESIGNATOR , MPO.PLAN_LEVEL , NVL(MPO.ORGANIZATION_ID, MPS.ORGANIZATION_ID) , DESIG.DESIGNATOR , MPS.DESIGNATOR_TYPE , MSC_GET_NAME.LOOKUP_MEANING('MSC_DESIGNATOR_TYPE_SHORT', MPS.DESIGNATOR_TYPE) , MPS.LAST_UPDATE_DATE , MPS.LAST_UPDATED_BY , MPS.CREATION_DATE , MPS.CREATED_BY , MPS.LAST_UPDATE_LOGIN , MPS.INPUT_TYPE , MSC_GET_NAME.LOOKUP_MEANING('MSC_DESIGNATOR_TYPE_SHORT', MPS.INPUT_TYPE) , DESIG.DESCRIPTION , MPS.REQUEST_ID , MPS.PROGRAM_APPLICATION_ID , MPS.PROGRAM_ID , MPS.PROGRAM_UPDATE_DATE , MPS.ATTRIBUTE_CATEGORY , MPS.ATTRIBUTE1 , MPS.ATTRIBUTE2 , MPS.ATTRIBUTE3 , MPS.ATTRIBUTE4 , MPS.ATTRIBUTE5 , MPS.ATTRIBUTE6 , MPS.ATTRIBUTE7 , MPS.ATTRIBUTE8 , MPS.ATTRIBUTE9 , MPS.ATTRIBUTE10 , MPS.ATTRIBUTE11 , MPS.ATTRIBUTE12 , MPS.ATTRIBUTE13 , MPS.ATTRIBUTE14 , MPS.ATTRIBUTE15 ,MPS.interplant_demand_flag , MPS.SCENARIO_SET , MPS.PROBABILITY ,MPS.DEMAND_VARIABILITY_TYPE ,MPS.MAPE_VALUE ,decode(desig.designator_type,6, l1.meaning, null) ,decode(desig.designator_type,6, mps.ship_to, -1) ,nvl(include_target_demands,2) ,MPS.INCLUDE_PO ,nvl(MPS.INCLUDE_PLN_ORD,2) FROM MSC_DESIGNATORS DESIG, MSC_PLAN_ORGANIZATIONS MPO, MSC_PLAN_SCHEDULES MPS, fnd_lookups l1 WHERE MPS.INPUT_SCHEDULE_ID = DESIG.DESIGNATOR_ID AND MPS.PLAN_ID = MPO.PLAN_ID AND MPS.ORGANIZATION_ID = MPO.ORGANIZATION_ID AND MPS.SR_INSTANCE_ID = MPO.SR_INSTANCE_ID AND MPS.DESIGNATOR_TYPE <> 7 and L1.LOOKUP_CODE(+) = desig.update_type AND L1.LOOKUP_TYPE(+) = 'MSC_SHIP_TO' AND NVL(MPS.INCLUDE_PLN_ORD ,2) <> 1 UNION SELECT MPS.ROWID , MPS.PLAN_ID , MPS.SR_INSTANCE_ID , MPS.ORGANIZATION_ID , MPS.INPUT_SCHEDULE_ID , SCN.SCENARIO_NAME , MPO.PLAN_LEVEL , NVL(MPO.ORGANIZATION_ID, MPS.ORGANIZATION_ID) , SCN.SCENARIO_NAME , MPS.DESIGNATOR_TYPE , MSC_GET_NAME.LOOKUP_MEANING('MRP_DESIGNATOR_TYPE_SHORT', MPS.DESIGNATOR_TYPE) , MPS.LAST_UPDATE_DATE , MPS.LAST_UPDATED_BY , MPS.CREATION_DATE , MPS.CREATED_BY , MPS.LAST_UPDATE_LOGIN , MPS.INPUT_TYPE , MSC_GET_NAME.LOOKUP_MEANING('MRP_DESIGNATOR_TYPE_SHORT', MPS.INPUT_TYPE) , SCN.DEMAND_PLAN_NAME||':'||SCN.SCENARIO_NAME , MPS.REQUEST_ID , MPS.PROGRAM_APPLICATION_ID , MPS.PROGRAM_ID , MPS.PROGRAM_UPDATE_DATE , MPS.ATTRIBUTE_CATEGORY , MPS.ATTRIBUTE1 , MPS.ATTRIBUTE2 , MPS.ATTRIBUTE3 , MPS.ATTRIBUTE4 , MPS.ATTRIBUTE5 , MPS.ATTRIBUTE6 , MPS.ATTRIBUTE7 , MPS.ATTRIBUTE8 , MPS.ATTRIBUTE9 , MPS.ATTRIBUTE10 , MPS.ATTRIBUTE11 , MPS.ATTRIBUTE12 , MPS.ATTRIBUTE13 , MPS.ATTRIBUTE14 , MPS.ATTRIBUTE15 , MPS.INTERPLANT_DEMAND_FLAG , MPS.SCENARIO_SET , MPS.PROBABILITY ,MPS.DEMAND_VARIABILITY_TYPE ,MPS.MAPE_VALUE , l1.meaning , MPS.SHIP_TO ,nvl(include_target_demands,2) ,MPS.INCLUDE_PO ,nvl(MPS.INCLUDE_PLN_ORD,2) FROM MSD_DP_ASCP_SCENARIOS_V SCN, MSC_PLAN_ORGANIZATIONS MPO, MSC_PLAN_SCHEDULES MPS, fnd_lookups l1 WHERE MPS.INPUT_SCHEDULE_ID = SCN.SCENARIO_ID AND MPS.PLAN_ID = MPO.PLAN_ID AND MPS.ORGANIZATION_ID = MPO.ORGANIZATION_ID AND MPS.SR_INSTANCE_ID = MPO.SR_INSTANCE_ID AND MPS.DESIGNATOR_TYPE = 7 and L1.LOOKUP_CODE(+) = MPS.SHIP_TO AND L1.LOOKUP_TYPE(+) = 'MSC_SHIP_TO' AND NVL(MPS.INCLUDE_PLN_ORD ,2) <> 1 UNION SELECT MPS.ROWID ,MPS.PLAN_ID , MPS.SR_INSTANCE_ID , MPS.ORGANIZATION_ID ,MPS.INPUT_SCHEDULE_ID , SCN.SCENARIO_NAME , -1,-1 , SCN.SCENARIO_NAME , MPS.DESIGNATOR_TYPE ,MSC_GET_NAME.LOOKUP_MEANING( 'MRP_DESIGNATOR_TYPE_SHORT',MPS.DESIGNATOR_TYPE) , MPS.LAST_UPDATE_DATE , MPS.LAST_UPDATED_BY ,MPS.CREATION_DATE , MPS.CREATED_BY , MPS.LAST_UPDATE_LOGIN ,MPS.INPUT_TYPE , MSC_GET_NAME.LOOKUP_MEANING('MRP_DESIGNATOR_TYPE_SHORT', MPS.INPUT_TYPE) , SCN.DEMAND_PLAN_NAME||':'||SCN.SCENARIO_NAME , MPS.REQUEST_ID , MPS.PROGRAM_APPLICATION_ID , MPS.PROGRAM_ID , MPS.PROGRAM_UPDATE_DATE , MPS.ATTRIBUTE_CATEGORY , MPS.ATTRIBUTE1 ,MPS.ATTRIBUTE2 , MPS.ATTRIBUTE3 , MPS.ATTRIBUTE4 , MPS.ATTRIBUTE5 ,MPS.ATTRIBUTE6 , MPS.ATTRIBUTE7 , MPS.ATTRIBUTE8 , MPS.ATTRIBUTE9 ,MPS.ATTRIBUTE10 , MPS.ATTRIBUTE11 , MPS.ATTRIBUTE12 , MPS.ATTRIBUTE13 ,MPS.ATTRIBUTE14 , MPS.ATTRIBUTE15 , MPS.INTERPLANT_DEMAND_FLAG ,MPS.SCENARIO_SET , MPS.PROBABILITY ,MPS.DEMAND_VARIABILITY_TYPE ,MPS.MAPE_VALUE, l1.meaning, MPS.SHIP_TO,nvl(include_target_demands,2) ,MPS.INCLUDE_PO ,nvl(MPS.INCLUDE_PLN_ORD,2) FROM MSD_DP_ASCP_SCENARIOS_V SCN, MSC_PLAN_SCHEDULES MPS, fnd_lookups l1 WHERE MPS.INPUT_SCHEDULE_ID = SCN.SCENARIO_ID AND MPS.ORGANIZATION_ID = -1 AND MPS.DESIGNATOR_TYPE = 7 and L1.LOOKUP_CODE(+) = MPS.SHIP_TO AND L1.LOOKUP_TYPE(+) = 'MSC_SHIP_TO' AND NVL(MPS.INCLUDE_PLN_ORD ,2) <> 1 UNION SELECT MPS.ROWID ,MPS.PLAN_ID , MPS.SR_INSTANCE_ID , MPS.ORGANIZATION_ID ,MPS.INPUT_SCHEDULE_ID , SCN.SCENARIO_NAME , -1,-1 , SCN.SCENARIO_NAME , MPS.DESIGNATOR_TYPE ,MSC_GET_NAME.LOOKUP_MEANING( 'MSC_DESIGNATOR_TYPE_SHORT',MPS.DESIGNATOR_TYPE) , MPS.LAST_UPDATE_DATE , MPS.LAST_UPDATED_BY ,MPS.CREATION_DATE , MPS.CREATED_BY , MPS.LAST_UPDATE_LOGIN ,MPS.INPUT_TYPE , MSC_GET_NAME.LOOKUP_MEANING('MRP_DESIGNATOR_TYPE_SHORT', MPS.INPUT_TYPE) , SCN.DEMAND_PLAN_NAME||':'||SCN.SCENARIO_NAME , MPS.REQUEST_ID , MPS.PROGRAM_APPLICATION_ID , MPS.PROGRAM_ID , MPS.PROGRAM_UPDATE_DATE , MPS.ATTRIBUTE_CATEGORY , MPS.ATTRIBUTE1 ,MPS.ATTRIBUTE2 , MPS.ATTRIBUTE3 , MPS.ATTRIBUTE4 , MPS.ATTRIBUTE5 ,MPS.ATTRIBUTE6 , MPS.ATTRIBUTE7 , MPS.ATTRIBUTE8 , MPS.ATTRIBUTE9 ,MPS.ATTRIBUTE10 , MPS.ATTRIBUTE11 , MPS.ATTRIBUTE12 , MPS.ATTRIBUTE13 ,MPS.ATTRIBUTE14 , MPS.ATTRIBUTE15 , MPS.INTERPLANT_DEMAND_FLAG ,MPS.SCENARIO_SET , MPS.PROBABILITY ,MPS.DEMAND_VARIABILITY_TYPE ,MPS.MAPE_VALUE, l1.meaning, MPS.SHIP_TO,nvl(include_target_demands,2) ,MPS.INCLUDE_PO ,nvl(MPS.INCLUDE_PLN_ORD,2) FROM MSD_DP_ASCP_SCENARIOS_V SCN, MSC_PLAN_SCHEDULES MPS, fnd_lookups l1 WHERE MPS.INPUT_SCHEDULE_ID = SCN.SCENARIO_ID AND MPS.ORGANIZATION_ID = -1 AND MPS.DESIGNATOR_TYPE = 9 and L1.LOOKUP_CODE(+) = MPS.SHIP_TO AND L1.LOOKUP_TYPE(+) = 'MSC_SHIP_TO' AND NVL(MPS.INCLUDE_PLN_ORD ,2) <> 1

View Text - HTML Formatted

SELECT MPS.ROWID
, MPS.PLAN_ID
, MPS.SR_INSTANCE_ID
, MPS.ORGANIZATION_ID
, MPS.INPUT_SCHEDULE_ID
, DESIG.DESIGNATOR
, MPO.PLAN_LEVEL
, NVL(MPO.ORGANIZATION_ID
, MPS.ORGANIZATION_ID)
, DESIG.DESIGNATOR
, MPS.DESIGNATOR_TYPE
, MSC_GET_NAME.LOOKUP_MEANING('MSC_DESIGNATOR_TYPE_SHORT'
, MPS.DESIGNATOR_TYPE)
, MPS.LAST_UPDATE_DATE
, MPS.LAST_UPDATED_BY
, MPS.CREATION_DATE
, MPS.CREATED_BY
, MPS.LAST_UPDATE_LOGIN
, MPS.INPUT_TYPE
, MSC_GET_NAME.LOOKUP_MEANING('MSC_DESIGNATOR_TYPE_SHORT'
, MPS.INPUT_TYPE)
, DESIG.DESCRIPTION
, MPS.REQUEST_ID
, MPS.PROGRAM_APPLICATION_ID
, MPS.PROGRAM_ID
, MPS.PROGRAM_UPDATE_DATE
, MPS.ATTRIBUTE_CATEGORY
, MPS.ATTRIBUTE1
, MPS.ATTRIBUTE2
, MPS.ATTRIBUTE3
, MPS.ATTRIBUTE4
, MPS.ATTRIBUTE5
, MPS.ATTRIBUTE6
, MPS.ATTRIBUTE7
, MPS.ATTRIBUTE8
, MPS.ATTRIBUTE9
, MPS.ATTRIBUTE10
, MPS.ATTRIBUTE11
, MPS.ATTRIBUTE12
, MPS.ATTRIBUTE13
, MPS.ATTRIBUTE14
, MPS.ATTRIBUTE15
, MPS.INTERPLANT_DEMAND_FLAG
, MPS.SCENARIO_SET
, MPS.PROBABILITY
, MPS.DEMAND_VARIABILITY_TYPE
, MPS.MAPE_VALUE
, DECODE(DESIG.DESIGNATOR_TYPE
, 6
, L1.MEANING
, NULL)
, DECODE(DESIG.DESIGNATOR_TYPE
, 6
, MPS.SHIP_TO
, -1)
, NVL(INCLUDE_TARGET_DEMANDS
, 2)
, MPS.INCLUDE_PO
, NVL(MPS.INCLUDE_PLN_ORD
, 2)
FROM MSC_DESIGNATORS DESIG
, MSC_PLAN_ORGANIZATIONS MPO
, MSC_PLAN_SCHEDULES MPS
, FND_LOOKUPS L1
WHERE MPS.INPUT_SCHEDULE_ID = DESIG.DESIGNATOR_ID
AND MPS.PLAN_ID = MPO.PLAN_ID
AND MPS.ORGANIZATION_ID = MPO.ORGANIZATION_ID
AND MPS.SR_INSTANCE_ID = MPO.SR_INSTANCE_ID
AND MPS.DESIGNATOR_TYPE <> 7
AND L1.LOOKUP_CODE(+) = DESIG.UPDATE_TYPE
AND L1.LOOKUP_TYPE(+) = 'MSC_SHIP_TO'
AND NVL(MPS.INCLUDE_PLN_ORD
, 2) <> 1 UNION SELECT MPS.ROWID
, MPS.PLAN_ID
, MPS.SR_INSTANCE_ID
, MPS.ORGANIZATION_ID
, MPS.INPUT_SCHEDULE_ID
, SCN.SCENARIO_NAME
, MPO.PLAN_LEVEL
, NVL(MPO.ORGANIZATION_ID
, MPS.ORGANIZATION_ID)
, SCN.SCENARIO_NAME
, MPS.DESIGNATOR_TYPE
, MSC_GET_NAME.LOOKUP_MEANING('MRP_DESIGNATOR_TYPE_SHORT'
, MPS.DESIGNATOR_TYPE)
, MPS.LAST_UPDATE_DATE
, MPS.LAST_UPDATED_BY
, MPS.CREATION_DATE
, MPS.CREATED_BY
, MPS.LAST_UPDATE_LOGIN
, MPS.INPUT_TYPE
, MSC_GET_NAME.LOOKUP_MEANING('MRP_DESIGNATOR_TYPE_SHORT'
, MPS.INPUT_TYPE)
, SCN.DEMAND_PLAN_NAME||':'||SCN.SCENARIO_NAME
, MPS.REQUEST_ID
, MPS.PROGRAM_APPLICATION_ID
, MPS.PROGRAM_ID
, MPS.PROGRAM_UPDATE_DATE
, MPS.ATTRIBUTE_CATEGORY
, MPS.ATTRIBUTE1
, MPS.ATTRIBUTE2
, MPS.ATTRIBUTE3
, MPS.ATTRIBUTE4
, MPS.ATTRIBUTE5
, MPS.ATTRIBUTE6
, MPS.ATTRIBUTE7
, MPS.ATTRIBUTE8
, MPS.ATTRIBUTE9
, MPS.ATTRIBUTE10
, MPS.ATTRIBUTE11
, MPS.ATTRIBUTE12
, MPS.ATTRIBUTE13
, MPS.ATTRIBUTE14
, MPS.ATTRIBUTE15
, MPS.INTERPLANT_DEMAND_FLAG
, MPS.SCENARIO_SET
, MPS.PROBABILITY
, MPS.DEMAND_VARIABILITY_TYPE
, MPS.MAPE_VALUE
, L1.MEANING
, MPS.SHIP_TO
, NVL(INCLUDE_TARGET_DEMANDS
, 2)
, MPS.INCLUDE_PO
, NVL(MPS.INCLUDE_PLN_ORD
, 2)
FROM MSD_DP_ASCP_SCENARIOS_V SCN
, MSC_PLAN_ORGANIZATIONS MPO
, MSC_PLAN_SCHEDULES MPS
, FND_LOOKUPS L1
WHERE MPS.INPUT_SCHEDULE_ID = SCN.SCENARIO_ID
AND MPS.PLAN_ID = MPO.PLAN_ID
AND MPS.ORGANIZATION_ID = MPO.ORGANIZATION_ID
AND MPS.SR_INSTANCE_ID = MPO.SR_INSTANCE_ID
AND MPS.DESIGNATOR_TYPE = 7
AND L1.LOOKUP_CODE(+) = MPS.SHIP_TO
AND L1.LOOKUP_TYPE(+) = 'MSC_SHIP_TO'
AND NVL(MPS.INCLUDE_PLN_ORD
, 2) <> 1 UNION SELECT MPS.ROWID
, MPS.PLAN_ID
, MPS.SR_INSTANCE_ID
, MPS.ORGANIZATION_ID
, MPS.INPUT_SCHEDULE_ID
, SCN.SCENARIO_NAME
, -1
, -1
, SCN.SCENARIO_NAME
, MPS.DESIGNATOR_TYPE
, MSC_GET_NAME.LOOKUP_MEANING( 'MRP_DESIGNATOR_TYPE_SHORT'
, MPS.DESIGNATOR_TYPE)
, MPS.LAST_UPDATE_DATE
, MPS.LAST_UPDATED_BY
, MPS.CREATION_DATE
, MPS.CREATED_BY
, MPS.LAST_UPDATE_LOGIN
, MPS.INPUT_TYPE
, MSC_GET_NAME.LOOKUP_MEANING('MRP_DESIGNATOR_TYPE_SHORT'
, MPS.INPUT_TYPE)
, SCN.DEMAND_PLAN_NAME||':'||SCN.SCENARIO_NAME
, MPS.REQUEST_ID
, MPS.PROGRAM_APPLICATION_ID
, MPS.PROGRAM_ID
, MPS.PROGRAM_UPDATE_DATE
, MPS.ATTRIBUTE_CATEGORY
, MPS.ATTRIBUTE1
, MPS.ATTRIBUTE2
, MPS.ATTRIBUTE3
, MPS.ATTRIBUTE4
, MPS.ATTRIBUTE5
, MPS.ATTRIBUTE6
, MPS.ATTRIBUTE7
, MPS.ATTRIBUTE8
, MPS.ATTRIBUTE9
, MPS.ATTRIBUTE10
, MPS.ATTRIBUTE11
, MPS.ATTRIBUTE12
, MPS.ATTRIBUTE13
, MPS.ATTRIBUTE14
, MPS.ATTRIBUTE15
, MPS.INTERPLANT_DEMAND_FLAG
, MPS.SCENARIO_SET
, MPS.PROBABILITY
, MPS.DEMAND_VARIABILITY_TYPE
, MPS.MAPE_VALUE
, L1.MEANING
, MPS.SHIP_TO
, NVL(INCLUDE_TARGET_DEMANDS
, 2)
, MPS.INCLUDE_PO
, NVL(MPS.INCLUDE_PLN_ORD
, 2)
FROM MSD_DP_ASCP_SCENARIOS_V SCN
, MSC_PLAN_SCHEDULES MPS
, FND_LOOKUPS L1
WHERE MPS.INPUT_SCHEDULE_ID = SCN.SCENARIO_ID
AND MPS.ORGANIZATION_ID = -1
AND MPS.DESIGNATOR_TYPE = 7
AND L1.LOOKUP_CODE(+) = MPS.SHIP_TO
AND L1.LOOKUP_TYPE(+) = 'MSC_SHIP_TO'
AND NVL(MPS.INCLUDE_PLN_ORD
, 2) <> 1 UNION SELECT MPS.ROWID
, MPS.PLAN_ID
, MPS.SR_INSTANCE_ID
, MPS.ORGANIZATION_ID
, MPS.INPUT_SCHEDULE_ID
, SCN.SCENARIO_NAME
, -1
, -1
, SCN.SCENARIO_NAME
, MPS.DESIGNATOR_TYPE
, MSC_GET_NAME.LOOKUP_MEANING( 'MSC_DESIGNATOR_TYPE_SHORT'
, MPS.DESIGNATOR_TYPE)
, MPS.LAST_UPDATE_DATE
, MPS.LAST_UPDATED_BY
, MPS.CREATION_DATE
, MPS.CREATED_BY
, MPS.LAST_UPDATE_LOGIN
, MPS.INPUT_TYPE
, MSC_GET_NAME.LOOKUP_MEANING('MRP_DESIGNATOR_TYPE_SHORT'
, MPS.INPUT_TYPE)
, SCN.DEMAND_PLAN_NAME||':'||SCN.SCENARIO_NAME
, MPS.REQUEST_ID
, MPS.PROGRAM_APPLICATION_ID
, MPS.PROGRAM_ID
, MPS.PROGRAM_UPDATE_DATE
, MPS.ATTRIBUTE_CATEGORY
, MPS.ATTRIBUTE1
, MPS.ATTRIBUTE2
, MPS.ATTRIBUTE3
, MPS.ATTRIBUTE4
, MPS.ATTRIBUTE5
, MPS.ATTRIBUTE6
, MPS.ATTRIBUTE7
, MPS.ATTRIBUTE8
, MPS.ATTRIBUTE9
, MPS.ATTRIBUTE10
, MPS.ATTRIBUTE11
, MPS.ATTRIBUTE12
, MPS.ATTRIBUTE13
, MPS.ATTRIBUTE14
, MPS.ATTRIBUTE15
, MPS.INTERPLANT_DEMAND_FLAG
, MPS.SCENARIO_SET
, MPS.PROBABILITY
, MPS.DEMAND_VARIABILITY_TYPE
, MPS.MAPE_VALUE
, L1.MEANING
, MPS.SHIP_TO
, NVL(INCLUDE_TARGET_DEMANDS
, 2)
, MPS.INCLUDE_PO
, NVL(MPS.INCLUDE_PLN_ORD
, 2)
FROM MSD_DP_ASCP_SCENARIOS_V SCN
, MSC_PLAN_SCHEDULES MPS
, FND_LOOKUPS L1
WHERE MPS.INPUT_SCHEDULE_ID = SCN.SCENARIO_ID
AND MPS.ORGANIZATION_ID = -1
AND MPS.DESIGNATOR_TYPE = 9
AND L1.LOOKUP_CODE(+) = MPS.SHIP_TO
AND L1.LOOKUP_TYPE(+) = 'MSC_SHIP_TO'
AND NVL(MPS.INCLUDE_PLN_ORD
, 2) <> 1