View: MRPFV_MPS_PLANS

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

View Text

SELECT PA.ORGANIZATION_CODE
, AL.NAME
, SC.SCHEDULE_DESIGNATOR
, SC.DESCRIPTION
, '_LA:SC.MPS_RELIEF:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:SC.PRODUCTION:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, SC.DISABLE_DATE
, ASS.ASSIGNMENT_SET_NAME
, ASS.DESCRIPTION
, '_LA:PL.CURR_SNAPSHOT_LOCK:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:PL.CURR_FULL_PEGGING:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:PL.CURR_RESERVATION_LEVEL:MFG_LOOKUPS:MRP_RESERVATION_LEVEL:MEANING'
, '_LA:PL.CURR_HARD_PEGGING_LEVEL:MFG_LOOKUPS:MRP_HARD_PEGGING_LEVEL:MEANING'
, PL.CURR_CUTOFF_DATE
, '_DF:MRP:MRP_SCHEDULE_DESIGNATORS:SC'
, PL.CURR_ASSIGNMENT_SET_ID
, SC.ORGANIZATION_ID
, SC.LAST_UPDATE_DATE
, SC.LAST_UPDATED_BY
, SC.CREATION_DATE
, SC.CREATED_BY
FROM MTL_PARAMETERS PA
, HR_ALL_ORGANIZATION_UNITS AL
, MRP_ASSIGNMENT_SETS ASS
, MRP_PLANS PL
, MRP_SCHEDULE_DESIGNATORS SC
WHERE SC.ORGANIZATION_ID = PL.ORGANIZATION_ID(+)
AND SC.SCHEDULE_DESIGNATOR = PL.COMPILE_DESIGNATOR(+)
AND SC.SCHEDULE_TYPE = 2
AND PL.ASSIGNMENT_SET_ID = ASS.ASSIGNMENT_SET_ID(+)
AND SC.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND SC.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND '_SEC:SC.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns