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.

[Home] [Help]

VIEW: MRP.MRP_PLANS#

Source

View Text - Preformatted


select ORGANIZATION_ID ORGANIZATION_ID, COMPILE_DESIGNATOR COMPILE_DESIGNATOR, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CURR_SCHEDULE_DESIGNATOR CURR_SCHEDULE_DESIGNATOR, CURR_OPERATION_SCHEDULE_TYPE CURR_OPERATION_SCHEDULE_TYPE, CURR_PLAN_TYPE CURR_PLAN_TYPE, CURR_OVERWRITE_OPTION CURR_OVERWRITE_OPTION, CURR_APPEND_PLANNED_ORDERS CURR_APPEND_PLANNED_ORDERS, CURR_SCHEDULE_TYPE CURR_SCHEDULE_TYPE, CURR_CUTOFF_DATE CURR_CUTOFF_DATE, CURR_PART_INCLUDE_TYPE CURR_PART_INCLUDE_TYPE, CURR_PLANNING_TIME_FENCE_FLAG CURR_PLANNING_TIME_FENCE_FLAG, CURR_DEMAND_TIME_FENCE_FLAG CURR_DEMAND_TIME_FENCE_FLAG, CURR_CONSIDER_RESERVATIONS CURR_CONSIDER_RESERVATIONS, CURR_PLAN_SAFETY_STOCK CURR_PLAN_SAFETY_STOCK, CURR_CONSIDER_WIP CURR_CONSIDER_WIP, CURR_CONSIDER_PO CURR_CONSIDER_PO, CURR_SNAPSHOT_LOCK CURR_SNAPSHOT_LOCK, COMPILE_DEFINITION_DATE COMPILE_DEFINITION_DATE, SCHEDULE_DESIGNATOR SCHEDULE_DESIGNATOR, OPERATION_SCHEDULE_TYPE OPERATION_SCHEDULE_TYPE, PLAN_TYPE PLAN_TYPE, OVERWRITE_OPTION OVERWRITE_OPTION, APPEND_PLANNED_ORDERS APPEND_PLANNED_ORDERS, SCHEDULE_TYPE SCHEDULE_TYPE, CUTOFF_DATE CUTOFF_DATE, PART_INCLUDE_TYPE PART_INCLUDE_TYPE, PLANNING_TIME_FENCE_FLAG PLANNING_TIME_FENCE_FLAG, DEMAND_TIME_FENCE_FLAG DEMAND_TIME_FENCE_FLAG, CONSIDER_RESERVATIONS CONSIDER_RESERVATIONS, PLAN_SAFETY_STOCK PLAN_SAFETY_STOCK, CONSIDER_WIP CONSIDER_WIP, CONSIDER_PO CONSIDER_PO, SNAPSHOT_LOCK SNAPSHOT_LOCK, EXPLOSION_START_DATE EXPLOSION_START_DATE, EXPLOSION_COMPLETION_DATE EXPLOSION_COMPLETION_DATE, DATA_START_DATE DATA_START_DATE, DATA_COMPLETION_DATE DATA_COMPLETION_DATE, PLAN_START_DATE PLAN_START_DATE, CRP_PLAN_COMPLETION_DATE CRP_PLAN_COMPLETION_DATE, PLAN_COMPLETION_DATE PLAN_COMPLETION_DATE, CRP_PLAN_START_DATE CRP_PLAN_START_DATE, CURRENT_PLANNER_LEVEL CURRENT_PLANNER_LEVEL, PLANNER_BATCH_NUMBER PLANNER_BATCH_NUMBER, DESCRIPTION DESCRIPTION, UPDATE_BOM UPDATE_BOM, DEMAND_CLASS DEMAND_CLASS, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, CURR_RESCHED_ASSUMPTION CURR_RESCHED_ASSUMPTION, RESCHED_ASSUMPTION RESCHED_ASSUMPTION, CURR_USER_PLAN_START_DATE CURR_USER_PLAN_START_DATE, USER_PLAN_START_DATE USER_PLAN_START_DATE, ONLINE_PLANNER_START_DATE ONLINE_PLANNER_START_DATE, ONLINE_PLANNER_COMPLETION_DATE ONLINE_PLANNER_COMPLETION_DATE, USE_NEW_PLANNER USE_NEW_PLANNER, CURR_FULL_PEGGING CURR_FULL_PEGGING, FULL_PEGGING FULL_PEGGING, ASSIGNMENT_SET_ID ASSIGNMENT_SET_ID, CURR_ASSIGNMENT_SET_ID CURR_ASSIGNMENT_SET_ID, ORGANIZATION_SELECTION ORGANIZATION_SELECTION, CURR_RESERVATION_LEVEL CURR_RESERVATION_LEVEL, CURR_HARD_PEGGING_LEVEL CURR_HARD_PEGGING_LEVEL, RESERVATION_LEVEL RESERVATION_LEVEL, HARD_PEGGING_LEVEL HARD_PEGGING_LEVEL, CURR_PLAN_CAPACITY_FLAG CURR_PLAN_CAPACITY_FLAG, CURR_SIMULATION_SET CURR_SIMULATION_SET, CURR_BILL_OF_RESOURCES CURR_BILL_OF_RESOURCES, PLAN_CAPACITY_FLAG PLAN_CAPACITY_FLAG, SIMULATION_SET SIMULATION_SET, BILL_OF_RESOURCES BILL_OF_RESOURCES, MIN_WF_EXCEPT_ID MIN_WF_EXCEPT_ID, MAX_WF_EXCEPT_ID MAX_WF_EXCEPT_ID from "MRP"."MRP_PLANS"

View Text - HTML Formatted

SELECT ORGANIZATION_ID ORGANIZATION_ID
, COMPILE_DESIGNATOR COMPILE_DESIGNATOR
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CURR_SCHEDULE_DESIGNATOR CURR_SCHEDULE_DESIGNATOR
, CURR_OPERATION_SCHEDULE_TYPE CURR_OPERATION_SCHEDULE_TYPE
, CURR_PLAN_TYPE CURR_PLAN_TYPE
, CURR_OVERWRITE_OPTION CURR_OVERWRITE_OPTION
, CURR_APPEND_PLANNED_ORDERS CURR_APPEND_PLANNED_ORDERS
, CURR_SCHEDULE_TYPE CURR_SCHEDULE_TYPE
, CURR_CUTOFF_DATE CURR_CUTOFF_DATE
, CURR_PART_INCLUDE_TYPE CURR_PART_INCLUDE_TYPE
, CURR_PLANNING_TIME_FENCE_FLAG CURR_PLANNING_TIME_FENCE_FLAG
, CURR_DEMAND_TIME_FENCE_FLAG CURR_DEMAND_TIME_FENCE_FLAG
, CURR_CONSIDER_RESERVATIONS CURR_CONSIDER_RESERVATIONS
, CURR_PLAN_SAFETY_STOCK CURR_PLAN_SAFETY_STOCK
, CURR_CONSIDER_WIP CURR_CONSIDER_WIP
, CURR_CONSIDER_PO CURR_CONSIDER_PO
, CURR_SNAPSHOT_LOCK CURR_SNAPSHOT_LOCK
, COMPILE_DEFINITION_DATE COMPILE_DEFINITION_DATE
, SCHEDULE_DESIGNATOR SCHEDULE_DESIGNATOR
, OPERATION_SCHEDULE_TYPE OPERATION_SCHEDULE_TYPE
, PLAN_TYPE PLAN_TYPE
, OVERWRITE_OPTION OVERWRITE_OPTION
, APPEND_PLANNED_ORDERS APPEND_PLANNED_ORDERS
, SCHEDULE_TYPE SCHEDULE_TYPE
, CUTOFF_DATE CUTOFF_DATE
, PART_INCLUDE_TYPE PART_INCLUDE_TYPE
, PLANNING_TIME_FENCE_FLAG PLANNING_TIME_FENCE_FLAG
, DEMAND_TIME_FENCE_FLAG DEMAND_TIME_FENCE_FLAG
, CONSIDER_RESERVATIONS CONSIDER_RESERVATIONS
, PLAN_SAFETY_STOCK PLAN_SAFETY_STOCK
, CONSIDER_WIP CONSIDER_WIP
, CONSIDER_PO CONSIDER_PO
, SNAPSHOT_LOCK SNAPSHOT_LOCK
, EXPLOSION_START_DATE EXPLOSION_START_DATE
, EXPLOSION_COMPLETION_DATE EXPLOSION_COMPLETION_DATE
, DATA_START_DATE DATA_START_DATE
, DATA_COMPLETION_DATE DATA_COMPLETION_DATE
, PLAN_START_DATE PLAN_START_DATE
, CRP_PLAN_COMPLETION_DATE CRP_PLAN_COMPLETION_DATE
, PLAN_COMPLETION_DATE PLAN_COMPLETION_DATE
, CRP_PLAN_START_DATE CRP_PLAN_START_DATE
, CURRENT_PLANNER_LEVEL CURRENT_PLANNER_LEVEL
, PLANNER_BATCH_NUMBER PLANNER_BATCH_NUMBER
, DESCRIPTION DESCRIPTION
, UPDATE_BOM UPDATE_BOM
, DEMAND_CLASS DEMAND_CLASS
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, CURR_RESCHED_ASSUMPTION CURR_RESCHED_ASSUMPTION
, RESCHED_ASSUMPTION RESCHED_ASSUMPTION
, CURR_USER_PLAN_START_DATE CURR_USER_PLAN_START_DATE
, USER_PLAN_START_DATE USER_PLAN_START_DATE
, ONLINE_PLANNER_START_DATE ONLINE_PLANNER_START_DATE
, ONLINE_PLANNER_COMPLETION_DATE ONLINE_PLANNER_COMPLETION_DATE
, USE_NEW_PLANNER USE_NEW_PLANNER
, CURR_FULL_PEGGING CURR_FULL_PEGGING
, FULL_PEGGING FULL_PEGGING
, ASSIGNMENT_SET_ID ASSIGNMENT_SET_ID
, CURR_ASSIGNMENT_SET_ID CURR_ASSIGNMENT_SET_ID
, ORGANIZATION_SELECTION ORGANIZATION_SELECTION
, CURR_RESERVATION_LEVEL CURR_RESERVATION_LEVEL
, CURR_HARD_PEGGING_LEVEL CURR_HARD_PEGGING_LEVEL
, RESERVATION_LEVEL RESERVATION_LEVEL
, HARD_PEGGING_LEVEL HARD_PEGGING_LEVEL
, CURR_PLAN_CAPACITY_FLAG CURR_PLAN_CAPACITY_FLAG
, CURR_SIMULATION_SET CURR_SIMULATION_SET
, CURR_BILL_OF_RESOURCES CURR_BILL_OF_RESOURCES
, PLAN_CAPACITY_FLAG PLAN_CAPACITY_FLAG
, SIMULATION_SET SIMULATION_SET
, BILL_OF_RESOURCES BILL_OF_RESOURCES
, MIN_WF_EXCEPT_ID MIN_WF_EXCEPT_ID
, MAX_WF_EXCEPT_ID MAX_WF_EXCEPT_ID
FROM "MRP"."MRP_PLANS"