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

Source

View Text - Preformatted


SELECT PA.ORGANIZATION_CODE , AL.NAME , PL.COMPILE_DESIGNATOR , PL.CURR_SCHEDULE_DESIGNATOR , LKUP.MEANING , PA.ORGANIZATION_CODE , AL.NAME , PL.ORGANIZATION_ID , PL.ORGANIZATION_ID , PL.LAST_UPDATE_DATE , PL.LAST_UPDATED_BY , PL.CREATION_DATE , PL.CREATED_BY FROM MFG_LOOKUPS LKUP ,MTL_PARAMETERS PA ,HR_ALL_ORGANIZATION_UNITS AL ,MRP_PLANS PL WHERE NVL(PL.ORGANIZATION_SELECTION,1) = 1 AND PL.ORGANIZATION_ID = PA.ORGANIZATION_ID AND PL.ORGANIZATION_ID = AL.ORGANIZATION_ID AND LKUP.LOOKUP_CODE = PL.CURR_SCHEDULE_TYPE AND LKUP.LOOKUP_TYPE = 'MRP_SCHEDULE_TYPE' AND '_SEC:pl.ORGANIZATION_ID' IS NOT NULL UNION ALL SELECT PA.ORGANIZATION_CODE ,AL1.NAME ,PLSC.COMPILE_DESIGNATOR ,PLSC.INPUT_NAME ,LKUP.MEANING ,PA2.ORGANIZATION_CODE ,AL2.NAME ,PLSC.ORGANIZATION_ID ,PLSC.INPUT_ORGANIZATION_ID ,PLSC.LAST_UPDATE_DATE ,PLSC.LAST_UPDATED_BY ,PLSC.CREATION_DATE ,PLSC.CREATED_BY FROM MFG_LOOKUPS LKUP ,MTL_PARAMETERS PA ,MTL_PARAMETERS PA2 ,HR_ALL_ORGANIZATION_UNITS AL1 ,HR_ALL_ORGANIZATION_UNITS AL2 ,MRP_PLAN_SCHEDULES PLSC WHERE PLSC.PLAN_LEVEL = 2 AND PLSC.ORGANIZATION_ID = PA.ORGANIZATION_ID AND PLSC.ORGANIZATION_ID = AL1.ORGANIZATION_ID AND PLSC.INPUT_ORGANIZATION_ID = PA2.ORGANIZATION_ID AND PLSC.INPUT_ORGANIZATION_ID = AL2.ORGANIZATION_ID AND LKUP.LOOKUP_CODE = PLSC.INPUT_TYPE AND LKUP.LOOKUP_TYPE = 'MRP_SCHEDULE_TYPE' AND '_SEC:plsc.ORGANIZATION_ID' IS NOT NULL UNION ALL SELECT PA1.ORGANIZATION_CODE ,AL1.NAME ,PLAN1.COMPILE_DESIGNATOR ,PLAN2.CURR_SCHEDULE_DESIGNATOR ,LKUP.MEANING ,PA2.ORGANIZATION_CODE ,AL2.NAME ,PLAN1.ORGANIZATION_ID ,PLAN2.ORGANIZATION_ID ,PLAN1.LAST_UPDATE_DATE ,PLAN1.LAST_UPDATED_BY ,PLAN1.CREATION_DATE ,PLAN1.CREATED_BY FROM MFG_LOOKUPS LKUP ,MTL_PARAMETERS PA1 ,MTL_PARAMETERS PA2 ,HR_ALL_ORGANIZATION_UNITS AL1 ,HR_ALL_ORGANIZATION_UNITS AL2 ,MRP_PLANS PLAN1 ,MRP_PLANS PLAN2 WHERE PLAN1.ORGANIZATION_ID = PLAN2.ORGANIZATION_ID AND PLAN1.CURR_SCHEDULE_DESIGNATOR = PLAN2.COMPILE_DESIGNATOR AND NVL(PLAN1.ORGANIZATION_SELECTION,1) = 1 AND PLAN1.ORGANIZATION_ID = PA1.ORGANIZATION_ID AND PLAN1.ORGANIZATION_ID = AL1.ORGANIZATION_ID AND PLAN2.ORGANIZATION_ID = PA2.ORGANIZATION_ID AND PLAN2.ORGANIZATION_ID = AL2.ORGANIZATION_ID AND LKUP.LOOKUP_CODE = PLAN2.CURR_SCHEDULE_TYPE AND LKUP.LOOKUP_TYPE = 'MRP_SCHEDULE_TYPE' AND '_SEC:plan1.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT PA.ORGANIZATION_CODE
, AL.NAME
, PL.COMPILE_DESIGNATOR
, PL.CURR_SCHEDULE_DESIGNATOR
, LKUP.MEANING
, PA.ORGANIZATION_CODE
, AL.NAME
, PL.ORGANIZATION_ID
, PL.ORGANIZATION_ID
, PL.LAST_UPDATE_DATE
, PL.LAST_UPDATED_BY
, PL.CREATION_DATE
, PL.CREATED_BY
FROM MFG_LOOKUPS LKUP
, MTL_PARAMETERS PA
, HR_ALL_ORGANIZATION_UNITS AL
, MRP_PLANS PL
WHERE NVL(PL.ORGANIZATION_SELECTION
, 1) = 1
AND PL.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND PL.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND LKUP.LOOKUP_CODE = PL.CURR_SCHEDULE_TYPE
AND LKUP.LOOKUP_TYPE = 'MRP_SCHEDULE_TYPE'
AND '_SEC:PL.ORGANIZATION_ID' IS NOT NULL UNION ALL SELECT PA.ORGANIZATION_CODE
, AL1.NAME
, PLSC.COMPILE_DESIGNATOR
, PLSC.INPUT_NAME
, LKUP.MEANING
, PA2.ORGANIZATION_CODE
, AL2.NAME
, PLSC.ORGANIZATION_ID
, PLSC.INPUT_ORGANIZATION_ID
, PLSC.LAST_UPDATE_DATE
, PLSC.LAST_UPDATED_BY
, PLSC.CREATION_DATE
, PLSC.CREATED_BY
FROM MFG_LOOKUPS LKUP
, MTL_PARAMETERS PA
, MTL_PARAMETERS PA2
, HR_ALL_ORGANIZATION_UNITS AL1
, HR_ALL_ORGANIZATION_UNITS AL2
, MRP_PLAN_SCHEDULES PLSC
WHERE PLSC.PLAN_LEVEL = 2
AND PLSC.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND PLSC.ORGANIZATION_ID = AL1.ORGANIZATION_ID
AND PLSC.INPUT_ORGANIZATION_ID = PA2.ORGANIZATION_ID
AND PLSC.INPUT_ORGANIZATION_ID = AL2.ORGANIZATION_ID
AND LKUP.LOOKUP_CODE = PLSC.INPUT_TYPE
AND LKUP.LOOKUP_TYPE = 'MRP_SCHEDULE_TYPE'
AND '_SEC:PLSC.ORGANIZATION_ID' IS NOT NULL UNION ALL SELECT PA1.ORGANIZATION_CODE
, AL1.NAME
, PLAN1.COMPILE_DESIGNATOR
, PLAN2.CURR_SCHEDULE_DESIGNATOR
, LKUP.MEANING
, PA2.ORGANIZATION_CODE
, AL2.NAME
, PLAN1.ORGANIZATION_ID
, PLAN2.ORGANIZATION_ID
, PLAN1.LAST_UPDATE_DATE
, PLAN1.LAST_UPDATED_BY
, PLAN1.CREATION_DATE
, PLAN1.CREATED_BY
FROM MFG_LOOKUPS LKUP
, MTL_PARAMETERS PA1
, MTL_PARAMETERS PA2
, HR_ALL_ORGANIZATION_UNITS AL1
, HR_ALL_ORGANIZATION_UNITS AL2
, MRP_PLANS PLAN1
, MRP_PLANS PLAN2
WHERE PLAN1.ORGANIZATION_ID = PLAN2.ORGANIZATION_ID
AND PLAN1.CURR_SCHEDULE_DESIGNATOR = PLAN2.COMPILE_DESIGNATOR
AND NVL(PLAN1.ORGANIZATION_SELECTION
, 1) = 1
AND PLAN1.ORGANIZATION_ID = PA1.ORGANIZATION_ID
AND PLAN1.ORGANIZATION_ID = AL1.ORGANIZATION_ID
AND PLAN2.ORGANIZATION_ID = PA2.ORGANIZATION_ID
AND PLAN2.ORGANIZATION_ID = AL2.ORGANIZATION_ID
AND LKUP.LOOKUP_CODE = PLAN2.CURR_SCHEDULE_TYPE
AND LKUP.LOOKUP_TYPE = 'MRP_SCHEDULE_TYPE'
AND '_SEC:PLAN1.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY