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

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 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