VIEW: APPS.MRPFV_PLAN_ORGANIZATIONS

Source

View Text - Preformatted

SELECT PA1.ORGANIZATION_CODE , AL1.NAME , PL.COMPILE_DESIGNATOR , NVL(PA2.ORGANIZATION_CODE, PA1.ORGANIZATION_CODE) , NVL(AL2.NAME, AL1.NAME) , ASS.ASSIGNMENT_SET_NAME , ASS.DESCRIPTION ,'_LA:pl.CURR_OVERWRITE_OPTION:MFG_LOOKUPS:MRP_PLAN_OVERWRITE:MEANING' ,'_LA:pl.CURR_APPEND_PLANNED_ORDERS:MFG_LOOKUPS:SYS_YES_NO:MEANING' ,'_LA:pl.CURR_OPERATION_SCHEDULE_TYPE:MFG_LOOKUPS:MRP_OPERATION:MEANING' ,'_LA:pl.CURR_PART_INCLUDE_TYPE:MFG_LOOKUPS:MRP_SCP_PART_INCLUDE_TYPE:MEANING' ,'_LA:pl.CURR_PLANNING_TIME_FENCE_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING' ,'_LA:pl.CURR_DEMAND_TIME_FENCE_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING' ,'_LA:nvl(plor.NET_WIP, pl.CURR_CONSIDER_WIP):MFG_LOOKUPS:SYS_YES_NO:MEANING' ,'_LA:nvl(plor.NET_PURCHASING, pl.CURR_CONSIDER_PO):MFG_LOOKUPS:SYS_YES_NO:MEANING' ,'_LA:nvl(plor.NET_RESERVATIONS, pl.CURR_CONSIDER_RESERVATIONS):MFG_LOOKUPS:SYS_YES_NO:MEANING' ,'_LA:nvl(plor.PLAN_SAFETY_STOCK, pl.CURR_PLAN_SAFETY_STOCK):MFG_LOOKUPS:SYS_YES_NO:MEANING' ,'_LA:pl.CURR_PLAN_CAPACITY_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING' , NVL(PLOR.BILL_OF_RESOURCES, PL.CURR_BILL_OF_RESOURCES) , NVL(PLOR.SIMULATION_SET, PL.CURR_SIMULATION_SET) , PL.ORGANIZATION_ID , NVL(PLOR.PLANNED_ORGANIZATION, PL.ORGANIZATION_ID) , PL.CURR_ASSIGNMENT_SET_ID , NVL(PLOR.LAST_UPDATE_DATE, PL.LAST_UPDATE_DATE) , NVL(PLOR.LAST_UPDATED_BY, PL.LAST_UPDATED_BY) , NVL(PLOR.CREATION_DATE, PL.CREATION_DATE) , NVL(PLOR.CREATED_BY, PL.CREATED_BY) FROM MTL_PARAMETERS PA1 ,HR_ALL_ORGANIZATION_UNITS AL1 ,MTL_PARAMETERS PA2 ,HR_ALL_ORGANIZATION_UNITS AL2 ,MRP_ASSIGNMENT_SETS ASS ,MRP_PLAN_ORGANIZATIONS PLOR ,MRP_PLANS PL WHERE PLOR.PLAN_LEVEL(+) = 2 AND PLOR.COMPILE_DESIGNATOR(+) = PL.COMPILE_DESIGNATOR AND PLOR.ORGANIZATION_ID(+) = PL.ORGANIZATION_ID AND PL.CURR_ASSIGNMENT_SET_ID = ASS.ASSIGNMENT_SET_ID(+) AND PL.ORGANIZATION_ID = PA1.ORGANIZATION_ID AND PL.ORGANIZATION_ID = AL1.ORGANIZATION_ID AND PLOR.PLANNED_ORGANIZATION = PA2.ORGANIZATION_ID(+) AND PLOR.PLANNED_ORGANIZATION = AL2.ORGANIZATION_ID(+) AND '_SEC:PL.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT PA1.ORGANIZATION_CODE
, AL1.NAME
, PL.COMPILE_DESIGNATOR
, NVL(PA2.ORGANIZATION_CODE
, PA1.ORGANIZATION_CODE)
, NVL(AL2.NAME
, AL1.NAME)
, ASS.ASSIGNMENT_SET_NAME
, ASS.DESCRIPTION
, '_LA:PL.CURR_OVERWRITE_OPTION:MFG_LOOKUPS:MRP_PLAN_OVERWRITE:MEANING'
, '_LA:PL.CURR_APPEND_PLANNED_ORDERS:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:PL.CURR_OPERATION_SCHEDULE_TYPE:MFG_LOOKUPS:MRP_OPERATION:MEANING'
, '_LA:PL.CURR_PART_INCLUDE_TYPE:MFG_LOOKUPS:MRP_SCP_PART_INCLUDE_TYPE:MEANING'
, '_LA:PL.CURR_PLANNING_TIME_FENCE_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:PL.CURR_DEMAND_TIME_FENCE_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:NVL(PLOR.NET_WIP
, PL.CURR_CONSIDER_WIP):MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:NVL(PLOR.NET_PURCHASING
, PL.CURR_CONSIDER_PO):MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:NVL(PLOR.NET_RESERVATIONS
, PL.CURR_CONSIDER_RESERVATIONS):MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:NVL(PLOR.PLAN_SAFETY_STOCK
, PL.CURR_PLAN_SAFETY_STOCK):MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:PL.CURR_PLAN_CAPACITY_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, NVL(PLOR.BILL_OF_RESOURCES
, PL.CURR_BILL_OF_RESOURCES)
, NVL(PLOR.SIMULATION_SET
, PL.CURR_SIMULATION_SET)
, PL.ORGANIZATION_ID
, NVL(PLOR.PLANNED_ORGANIZATION
, PL.ORGANIZATION_ID)
, PL.CURR_ASSIGNMENT_SET_ID
, NVL(PLOR.LAST_UPDATE_DATE
, PL.LAST_UPDATE_DATE)
, NVL(PLOR.LAST_UPDATED_BY
, PL.LAST_UPDATED_BY)
, NVL(PLOR.CREATION_DATE
, PL.CREATION_DATE)
, NVL(PLOR.CREATED_BY
, PL.CREATED_BY)
FROM MTL_PARAMETERS PA1
, HR_ALL_ORGANIZATION_UNITS AL1
, MTL_PARAMETERS PA2
, HR_ALL_ORGANIZATION_UNITS AL2
, MRP_ASSIGNMENT_SETS ASS
, MRP_PLAN_ORGANIZATIONS PLOR
, MRP_PLANS PL
WHERE PLOR.PLAN_LEVEL(+) = 2
AND PLOR.COMPILE_DESIGNATOR(+) = PL.COMPILE_DESIGNATOR
AND PLOR.ORGANIZATION_ID(+) = PL.ORGANIZATION_ID
AND PL.CURR_ASSIGNMENT_SET_ID = ASS.ASSIGNMENT_SET_ID(+)
AND PL.ORGANIZATION_ID = PA1.ORGANIZATION_ID
AND PL.ORGANIZATION_ID = AL1.ORGANIZATION_ID
AND PLOR.PLANNED_ORGANIZATION = PA2.ORGANIZATION_ID(+)
AND PLOR.PLANNED_ORGANIZATION = AL2.ORGANIZATION_ID(+)
AND '_SEC:PL.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY