View: MRPFV_PLAN_SCHEDULES

Product:	MRP - Master Scheduling/MRP
Description:	- Retrofitted
Implementation/DBA Data:	APPS.MRPFV_PLAN_SCHEDULES

View Text

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

Columns