PJC_LABOR_SCH_KFF_DETAILS_V

Details

• Schema: FUSION

• Object owner: PJC

• Object type: VIEW

Columns

Name
LEGISLATIVE_DATA_GROUP_ID LEGISLATIVE_DATA_GROUP_NAME LEGISLATION_CODE DEFAULT_CURRENCY_CODE COST_ALLOCATION_ID_FLEX_NUM OBJECT_VERSION_NUMBER PAYROLL_COSTING_ALLOC_INST_CODE STRUCTURE_INSTANCE_NUMBER PAYROLL_COSTING_ALLOC_INST_NAME DELIMITER KFF_STRUCTURE_NAME SEGMENT_COUNT SEGMENT_NUMBERS SEGMENT_NAMES

Query

SQL_Statement

SELECT LegislativeDataGroupPEO.LEGISLATIVE_DATA_GROUP_ID, LegislativeDataGroupPEO.NAME LEGISLATIVE_DATA_GROUP_NAME, LegislativeDataGroupPEO.LEGISLATION_CODE, LegislativeDataGroupPEO.DEFAULT_CURRENCY_CODE, LegislativeDataGroupPEO.COST_ALLOCATION_ID_FLEX_NUM, LegislativeDataGroupPEO.OBJECT_VERSION_NUMBER, kff.structure_instance_code PAYROLL_COSTING_ALLOC_INST_CODE, kff.structure_instance_number, kff.NAME PAYROLL_COSTING_ALLOC_INST_NAME, kffstr.DELIMITER, kffstr.name KFF_STRUCTURE_NAME, segments.segment_cnt SEGMENT_COUNT, segments.segment_numbers SEGMENT_NUMBERS, segments.segment_names SEGMENT_NAMES FROM PER_LEGISLATIVE_DATA_GROUPS_VL LegislativeDataGroupPEO INNER JOIN FND_KF_STR_INSTANCES_VL kff ON kff.structure_instance_number = LegislativeDataGroupPEO.cost_allocation_id_flex_num AND kff.key_flexfield_code = 'COST' INNER JOIN FND_KF_STRUCTURES_VL kffstr ON kff.structure_id = kffstr.STRUCTURE_ID INNER JOIN ( SELECT COUNT(*) as segment_cnt, LISTAGG(segment_num , ',') WITHIN GROUP (ORDER BY segment_num) AS segment_numbers, LISTAGG(application_column_name , ',') WITHIN GROUP (ORDER BY segment_num) AS segment_names, id_flex_num FROM FND_ID_FLEX_SEGMENTS WHERE ENABLED_FLAG='Y' GROUP BY id_flex_num )segments ON segments.id_flex_num = LegislativeDataGroupPEO.COST_ALLOCATION_ID_FLEX_NUM