SELECT /* REGULAR ATTRIBUTES */ LO.MEANING , VA.ORGANIZATION_ID , VA.RECORD_CREATOR , VA.STEP_MEANING , /* RESOLVED FOREIGN KEYS */ PA.ORGANIZATION_CODE , AL.NAME , /* WHO */ VA.CREATION_DATE , VA.CREATED_BY , VA.LAST_UPDATE_DATE , VA.LAST_UPDATED_BY FROM MFG_LOOKUPS LO , WIP_PARAMETERS WPA , HR_ALL_ORGANIZATION_UNITS AL , MTL_PARAMETERS PA , WIP_VALID_INTRAOPERATION_STEPS VA WHERE VA.ORGANIZATION_ID = PA.ORGANIZATION_ID AND VA.ORGANIZATION_ID = AL.ORGANIZATION_ID AND VA.ORGANIZATION_ID = WPA.ORGANIZATION_ID AND LO.LOOKUP_CODE = VA.STEP_LOOKUP_TYPE AND LO.LOOKUP_TYPE = 'WIP_INTRAOPERATION_STEP' AND '_SEC:VA.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY