PAY_TASK_PARAMETERS_O

Details

Schema: FUSION
Object owner: PAY
Object type: VIEW

Columns

Name
TASK_PARAMETER_ID BASE_TASK_PARAMETER_ID BASE_TASK_ACTION_ID BASE_TASK_PARAMETER_NAME MODULE_ID OBJECT_VERSION_NUMBER DISPLAY_FLAG PARAM_DISP_TYPE PARAM_USAGE_TYPE PARAM_SEQUENCE PARAM_LOOKUP PARAM_VALUE_SET DEFAULT_TYPE DEFAULT_VAL LEGISLATIVE_DATA_GROUP_ID LEGISLATION_CODE DATA_TYPE DATA_DOMAIN NAMESPACE REPETITIVE_FLAG PARAMETER_TYPE ELEMENT_NAME PARENT_TASK_PARAM_ID DRIVING_LABEL_METHOD LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN CREATED_BY CREATION_DATE PARAM_LEVEL PARAMETER_NAME DESCRIPTION

Name

TASK_PARAMETER_ID

BASE_TASK_PARAMETER_ID

BASE_TASK_ACTION_ID

BASE_TASK_PARAMETER_NAME

MODULE_ID

OBJECT_VERSION_NUMBER

DISPLAY_FLAG

PARAM_DISP_TYPE

PARAM_USAGE_TYPE

PARAM_SEQUENCE

PARAM_LOOKUP

PARAM_VALUE_SET

DEFAULT_TYPE

DEFAULT_VAL

LEGISLATIVE_DATA_GROUP_ID

LEGISLATION_CODE

DATA_TYPE

DATA_DOMAIN

NAMESPACE

REPETITIVE_FLAG

PARAMETER_TYPE

ELEMENT_NAME

PARENT_TASK_PARAM_ID

DRIVING_LABEL_METHOD

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

CREATED_BY

CREATION_DATE

PARAM_LEVEL

PARAMETER_NAME

DESCRIPTION

Query

SQL_Statement
SELECT b.task_parameter_id, b.base_task_parameter_id, b.base_task_action_id, b.base_task_parameter_name, b.module_id, b.object_version_number, b.display_flag, b.param_disp_type, b.param_usage_type, b.param_sequence, b.param_lookup, b.param_value_set, b.default_type, b.default_val, ldg.legislative_data_group_id, ldg.legislation_code, b.data_type, b.data_domain, b.namespace, b.repetitive_flag, b.parameter_type, b.element_name, b.parent_task_param_id, b.driving_label_method, b.last_update_date, b.last_updated_by, b.last_update_login, b.created_by, b.creation_date, b.param_level, tl.parameter_name , tl.description FROM pay_task_parameters b, pay_task_parameters_tl tl, per_legislative_data_groups ldg WHERE b.task_parameter_id = tl.task_parameter_id AND USERENV('LANG') =tl.language AND ( (b.legislative_data_group_id IS NOT NULL AND b.legislation_code IS NULL AND b.legislative_data_group_id =ldg.legislative_data_group_id) OR (b.legislation_code IS NOT NULL AND b.legislative_data_group_id IS NULL AND b.legislation_code =ldg.legislation_code AND ( NOT EXISTS ( SELECT null FROM pay_task_parameters c1 WHERE b.base_task_parameter_id = c1.base_task_parameter_id AND (c1.legislative_data_group_id IS NOT NULL AND c1.legislation_code IS NULL AND c1.legislative_data_group_id =ldg.legislative_data_group_id ) ))) OR ( b.legislative_data_group_id IS NULL AND b.legislation_code IS NULL AND ( NOT EXISTS ( SELECT null FROM pay_task_parameters c2 WHERE b.base_task_parameter_id = c2.base_task_parameter_id AND ( ( c2.legislative_data_group_id IS NOT NULL AND c2.legislation_code IS NULL AND c2.legislative_data_group_id =ldg.legislative_data_group_id ) OR ( c2.legislation_code IS NOT NULL AND c2.legislative_data_group_id IS NULL AND c2.legislation_code =ldg.legislation_code ) ) ) ) ))

SQL_Statement

SELECT b.task_parameter_id,

b.base_task_parameter_id,

b.base_task_action_id,

b.base_task_parameter_name,

b.module_id,

b.object_version_number,

b.display_flag,

b.param_disp_type,

b.param_usage_type,

b.param_sequence,

b.param_lookup,

b.param_value_set,

b.default_type,

b.default_val,

ldg.legislative_data_group_id,

ldg.legislation_code,

b.data_type,

b.data_domain,

b.namespace,

b.repetitive_flag,

b.parameter_type,

b.element_name,

b.parent_task_param_id,

b.driving_label_method,

b.last_update_date,

b.last_updated_by,

b.last_update_login,

b.created_by,

b.creation_date,

b.param_level,

tl.parameter_name ,

tl.description

FROM pay_task_parameters b,

pay_task_parameters_tl tl,

per_legislative_data_groups ldg

WHERE b.task_parameter_id = tl.task_parameter_id

AND USERENV('LANG') =tl.language

AND (

(b.legislative_data_group_id IS NOT NULL

AND b.legislation_code IS NULL

AND b.legislative_data_group_id =ldg.legislative_data_group_id)

OR

(b.legislation_code IS NOT NULL

AND b.legislative_data_group_id IS NULL

AND b.legislation_code =ldg.legislation_code

AND ( NOT EXISTS

(

SELECT null

FROM pay_task_parameters c1

WHERE b.base_task_parameter_id = c1.base_task_parameter_id

AND (c1.legislative_data_group_id IS NOT NULL

AND c1.legislation_code IS NULL

AND c1.legislative_data_group_id =ldg.legislative_data_group_id )

)))

OR ( b.legislative_data_group_id IS NULL

AND b.legislation_code IS NULL

AND ( NOT EXISTS

(

SELECT null

FROM pay_task_parameters c2

WHERE b.base_task_parameter_id = c2.base_task_parameter_id

AND (

( c2.legislative_data_group_id IS NOT NULL

AND c2.legislation_code IS NULL

AND c2.legislative_data_group_id =ldg.legislative_data_group_id )

OR

( c2.legislation_code IS NOT NULL

AND c2.legislative_data_group_id IS NULL

AND c2.legislation_code =ldg.legislation_code ) )

) ) ))