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

Source

View Text - Preformatted


SELECT PLANS.ORGANIZATION_ID , COMPILE_DESIGNATOR , CURR_SCHEDULE_TYPE , PLANS.ORGANIZATION_ID , CURR_SCHEDULE_DESIGNATOR FROM MRP_PLANS PLANS WHERE NVL(PLANS.ORGANIZATION_SELECTION, 1) = 1 UNION ALL SELECT ORGANIZATION_ID, COMPILE_DESIGNATOR, INPUT_TYPE, INPUT_ORGANIZATION_ID, INPUT_NAME FROM MRP_PLAN_SCHEDULES WHERE PLAN_LEVEL = 2 UNION ALL SELECT PLANS1.ORGANIZATION_ID, PLANS1.COMPILE_DESIGNATOR, PLANS2.CURR_SCHEDULE_TYPE, PLANS2.ORGANIZATION_ID, PLANS2.CURR_SCHEDULE_DESIGNATOR FROM MRP_PLANS PLANS1, MRP_PLANS PLANS2 WHERE PLANS1.ORGANIZATION_ID = PLANS2.ORGANIZATION_ID AND PLANS1.CURR_SCHEDULE_DESIGNATOR = PLANS2.COMPILE_DESIGNATOR AND NVL(PLANS1.ORGANIZATION_SELECTION , 1) = 1

View Text - HTML Formatted

SELECT PLANS.ORGANIZATION_ID
, COMPILE_DESIGNATOR
, CURR_SCHEDULE_TYPE
, PLANS.ORGANIZATION_ID
, CURR_SCHEDULE_DESIGNATOR
FROM MRP_PLANS PLANS
WHERE NVL(PLANS.ORGANIZATION_SELECTION
, 1) = 1 UNION ALL SELECT ORGANIZATION_ID
, COMPILE_DESIGNATOR
, INPUT_TYPE
, INPUT_ORGANIZATION_ID
, INPUT_NAME
FROM MRP_PLAN_SCHEDULES
WHERE PLAN_LEVEL = 2 UNION ALL SELECT PLANS1.ORGANIZATION_ID
, PLANS1.COMPILE_DESIGNATOR
, PLANS2.CURR_SCHEDULE_TYPE
, PLANS2.ORGANIZATION_ID
, PLANS2.CURR_SCHEDULE_DESIGNATOR
FROM MRP_PLANS PLANS1
, MRP_PLANS PLANS2
WHERE PLANS1.ORGANIZATION_ID = PLANS2.ORGANIZATION_ID
AND PLANS1.CURR_SCHEDULE_DESIGNATOR = PLANS2.COMPILE_DESIGNATOR
AND NVL(PLANS1.ORGANIZATION_SELECTION
, 1) = 1