VIEW: APPS.FEM_MP_PROCESS_OPTIONS_V

Source

View Text - Preformatted

SELECT t.process_engine_cd, o.step_name, NVL(o.object_id,0) AS object_id, o.num_of_processes, DECODE(o.data_slice_type_code,'3',0,o.process_data_slices_cd) AS process_data_slices_cd, o.process_partition_cd, o.commit_frequency, o.array_size_rows FROM fem_object_types t, fem_mp_process_options o WHERE t.object_type_code = o.object_type_code AND t.process_engine_cd IS NOT NULL

View Text - HTML Formatted

SELECT T.PROCESS_ENGINE_CD
, O.STEP_NAME
, NVL(O.OBJECT_ID
, 0) AS OBJECT_ID
, O.NUM_OF_PROCESSES
, DECODE(O.DATA_SLICE_TYPE_CODE
, '3'
, 0
, O.PROCESS_DATA_SLICES_CD) AS PROCESS_DATA_SLICES_CD
, O.PROCESS_PARTITION_CD
, O.COMMIT_FREQUENCY
, O.ARRAY_SIZE_ROWS
FROM FEM_OBJECT_TYPES T
, FEM_MP_PROCESS_OPTIONS O
WHERE T.OBJECT_TYPE_CODE = O.OBJECT_TYPE_CODE
AND T.PROCESS_ENGINE_CD IS NOT NULL