VIEW: APPS.MRPFV_PLAN_SIMULATION_SETS

Source

View Text - Preformatted

SELECT PA.ORGANIZATION_CODE ORGANIZATION_CODE , AL.NAME ORGANIZATION_NAME , SI.SIMULATION_SET SIMULATION_SET_CODE , SI.DESCRIPTION DESCRIPTION , LKUP.MEANING , '_DF:CRP:CRP_SIMULATION_SETS:si' , SI.ORGANIZATION_ID , SI.LAST_UPDATE_DATE , SI.LAST_UPDATED_BY , SI.CREATION_DATE , SI.CREATED_BY FROM MFG_LOOKUPS LKUP , MTL_PARAMETERS PA ,HR_ALL_ORGANIZATION_UNITS AL ,CRP_SIMULATION_SETS SI WHERE SI.ORGANIZATION_ID = PA.ORGANIZATION_ID AND SI.ORGANIZATION_ID = AL.ORGANIZATION_ID AND LKUP.LOOKUP_CODE(+) = SI.USE_IN_WIP_FLAG AND LKUP.LOOKUP_TYPE(+) = 'SYS_YES_NO' AND '_SEC:SI.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT PA.ORGANIZATION_CODE ORGANIZATION_CODE
, AL.NAME ORGANIZATION_NAME
, SI.SIMULATION_SET SIMULATION_SET_CODE
, SI.DESCRIPTION DESCRIPTION
, LKUP.MEANING
, '_DF:CRP:CRP_SIMULATION_SETS:SI'
, SI.ORGANIZATION_ID
, SI.LAST_UPDATE_DATE
, SI.LAST_UPDATED_BY
, SI.CREATION_DATE
, SI.CREATED_BY
FROM MFG_LOOKUPS LKUP
, MTL_PARAMETERS PA
, HR_ALL_ORGANIZATION_UNITS AL
, CRP_SIMULATION_SETS SI
WHERE SI.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND SI.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND LKUP.LOOKUP_CODE(+) = SI.USE_IN_WIP_FLAG
AND LKUP.LOOKUP_TYPE(+) = 'SYS_YES_NO'
AND '_SEC:SI.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY