1. Tables and Views for Project Management
  2. PJC_XLA_PAYROLL_KEYFLEX_V

PJC_XLA_PAYROLL_KEYFLEX_V

Details

  • Schema: FUSION

  • Object owner: PJC

  • Object type: VIEW

Columns

Name

COST_ALLOCATION_KEYFLEX_ID

COST_ALLOCATION_SEGMENT1

COST_ALLOCATION_SEGMENT2

COST_ALLOCATION_SEGMENT3

COST_ALLOCATION_SEGMENT4

COST_ALLOCATION_SEGMENT5

COST_ALLOCATION_SEGMENT6

COST_ALLOCATION_SEGMENT7

COST_ALLOCATION_SEGMENT8

COST_ALLOCATION_SEGMENT9

COST_ALLOCATION_SEGMENT10

COST_ALLOCATION_SEGMENT11

COST_ALLOCATION_SEGMENT12

COST_ALLOCATION_SEGMENT13

COST_ALLOCATION_SEGMENT14

COST_ALLOCATION_SEGMENT15

COST_ALLOCATION_SEGMENT16

COST_ALLOCATION_SEGMENT17

COST_ALLOCATION_SEGMENT18

COST_ALLOCATION_SEGMENT19

COST_ALLOCATION_SEGMENT20

COST_ALLOCATION_SEGMENT21

COST_ALLOCATION_SEGMENT22

COST_ALLOCATION_SEGMENT23

COST_ALLOCATION_SEGMENT24

COST_ALLOCATION_SEGMENT25

COST_ALLOCATION_SEGMENT26

COST_ALLOCATION_SEGMENT27

COST_ALLOCATION_SEGMENT28

COST_ALLOCATION_SEGMENT29

COST_ALLOCATION_SEGMENT30

Query

SQL_Statement

SELECT COST_ALLOCATION_KEYFLEX_ID,

SEGMENT1 COST_ALLOCATION_SEGMENT1,

SEGMENT2 COST_ALLOCATION_SEGMENT2,

SEGMENT3 COST_ALLOCATION_SEGMENT3,

SEGMENT4 COST_ALLOCATION_SEGMENT4,

SEGMENT5 COST_ALLOCATION_SEGMENT5,

SEGMENT6 COST_ALLOCATION_SEGMENT6,

SEGMENT7 COST_ALLOCATION_SEGMENT7,

SEGMENT8 COST_ALLOCATION_SEGMENT8,

SEGMENT9 COST_ALLOCATION_SEGMENT9,

SEGMENT10 COST_ALLOCATION_SEGMENT10,

SEGMENT11 COST_ALLOCATION_SEGMENT11,

SEGMENT12 COST_ALLOCATION_SEGMENT12,

SEGMENT13 COST_ALLOCATION_SEGMENT13,

SEGMENT14 COST_ALLOCATION_SEGMENT14,

SEGMENT15 COST_ALLOCATION_SEGMENT15,

SEGMENT16 COST_ALLOCATION_SEGMENT16,

SEGMENT17 COST_ALLOCATION_SEGMENT17,

SEGMENT18 COST_ALLOCATION_SEGMENT18,

SEGMENT19 COST_ALLOCATION_SEGMENT19,

SEGMENT20 COST_ALLOCATION_SEGMENT20,

SEGMENT21 COST_ALLOCATION_SEGMENT21,

SEGMENT22 COST_ALLOCATION_SEGMENT22,

SEGMENT23 COST_ALLOCATION_SEGMENT23,

SEGMENT24 COST_ALLOCATION_SEGMENT24,

SEGMENT25 COST_ALLOCATION_SEGMENT25,

SEGMENT26 COST_ALLOCATION_SEGMENT26,

SEGMENT27 COST_ALLOCATION_SEGMENT27,

SEGMENT28 COST_ALLOCATION_SEGMENT28,

SEGMENT29 COST_ALLOCATION_SEGMENT29,

SEGMENT30 COST_ALLOCATION_SEGMENT30

FROM PAY_COST_ALLOCATION_KEYFLEX