VIEW: APPS.MRPFV_MFG_DIST_PLANS

Source

View Text - Preformatted

SELECT PA.ORGANIZATION_CODE , AL.NAME , DE.COMPILE_DESIGNATOR , '_LA:pl.curr_plan_type:MFG_LOOKUPS:MRP_PLAN_TYPE:MEANING' , DE.DESCRIPTION ,LKUP.MEANING , '_LA:de.production:MFG_LOOKUPS:SYS_YES_NO:MEANING' , DE.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_DESIGNATORS:de' , PL.CURR_ASSIGNMENT_SET_ID , DE.ORGANIZATION_ID , DE.LAST_UPDATE_DATE , DE.LAST_UPDATED_BY , DE.CREATION_DATE , DE.CREATED_BY FROM MFG_LOOKUPS LKUP , MTL_PARAMETERS PA ,HR_ALL_ORGANIZATION_UNITS AL ,MRP_DESIGNATORS DE ,MRP_PLANS PL ,MRP_ASSIGNMENT_SETS ASS WHERE DE.ORGANIZATION_ID = PL.ORGANIZATION_ID(+) AND DE.COMPILE_DESIGNATOR = PL.COMPILE_DESIGNATOR(+) AND PL.CURR_ASSIGNMENT_SET_ID = ASS.ASSIGNMENT_SET_ID(+) AND DE.ORGANIZATION_ID = PA.ORGANIZATION_ID AND DE.ORGANIZATION_ID = AL.ORGANIZATION_ID AND LKUP.LOOKUP_CODE = DE.FEEDBACK_FLAG AND LKUP.LOOKUP_TYPE = 'SYS_YES_NO' AND '_SEC:DE.ORGANIZATION_ID' IS NOT NULL UNION SELECT PA.ORGANIZATION_CODE ,AL.NAME ,SC.SCHEDULE_DESIGNATOR ,'_LA:pl.curr_plan_type:MFG_LOOKUPS:MRP_PLAN_TYPE:MEANING' ,SC.DESCRIPTION ,NULL ,'_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.CURR_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

View Text - HTML Formatted

SELECT PA.ORGANIZATION_CODE
, AL.NAME
, DE.COMPILE_DESIGNATOR
, '_LA:PL.CURR_PLAN_TYPE:MFG_LOOKUPS:MRP_PLAN_TYPE:MEANING'
, DE.DESCRIPTION
, LKUP.MEANING
, '_LA:DE.PRODUCTION:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, DE.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_DESIGNATORS:DE'
, PL.CURR_ASSIGNMENT_SET_ID
, DE.ORGANIZATION_ID
, DE.LAST_UPDATE_DATE
, DE.LAST_UPDATED_BY
, DE.CREATION_DATE
, DE.CREATED_BY
FROM MFG_LOOKUPS LKUP
, MTL_PARAMETERS PA
, HR_ALL_ORGANIZATION_UNITS AL
, MRP_DESIGNATORS DE
, MRP_PLANS PL
, MRP_ASSIGNMENT_SETS ASS
WHERE DE.ORGANIZATION_ID = PL.ORGANIZATION_ID(+)
AND DE.COMPILE_DESIGNATOR = PL.COMPILE_DESIGNATOR(+)
AND PL.CURR_ASSIGNMENT_SET_ID = ASS.ASSIGNMENT_SET_ID(+)
AND DE.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND DE.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND LKUP.LOOKUP_CODE = DE.FEEDBACK_FLAG
AND LKUP.LOOKUP_TYPE = 'SYS_YES_NO'
AND '_SEC:DE.ORGANIZATION_ID' IS NOT NULL UNION SELECT PA.ORGANIZATION_CODE
, AL.NAME
, SC.SCHEDULE_DESIGNATOR
, '_LA:PL.CURR_PLAN_TYPE:MFG_LOOKUPS:MRP_PLAN_TYPE:MEANING'
, SC.DESCRIPTION
, NULL
, '_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.CURR_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