Product: | PAY - Payroll |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PAY_PDT_BATCH_LINES_V3 |
SELECT /* MAP VALUE_1..VALUE_15 TO SPECIFIC COLUMNS DEPENDENT ON THE INPUT ** VALUE NAME. SELECT FURTHER NULL COLUMNS SO THAT THE VIEW DEFINITION MATCHES ** THE OLD TABLE DEFINITION OF PAY_PDT_BATCH_LINES. */ BATCH_ID
, BATCH_LINE_ID LINE_ID
, ASSIGNMENT_NUMBER
, NULL ADJUSTMENT_TYPE_CODE
, DECODE( 'AMOUNT'
, NAME_1
, VALUE_1
, NAME_2
, VALUE_2
, NAME_3
, VALUE_3
, NAME_4
, VALUE_4
, NAME_5
, VALUE_5
, NAME_6
, VALUE_6
, NAME_7
, VALUE_7
, NAME_8
, VALUE_8
, NAME_9
, VALUE_9
, NAME_10
, VALUE_10
, NAME_11
, VALUE_11
, NAME_12
, VALUE_12
, NAME_13
, VALUE_13
, NAME_14
, VALUE_14
, NAME_15
, VALUE_15
, NULL ) AMT_AMOUNT
, DECODE( 'PERCENTAGE'
, NAME_1
, VALUE_1
, NAME_2
, VALUE_2
, NAME_3
, VALUE_3
, NAME_4
, VALUE_4
, NAME_5
, VALUE_5
, NAME_6
, VALUE_6
, NAME_7
, VALUE_7
, NAME_8
, VALUE_8
, NAME_9
, VALUE_9
, NAME_10
, VALUE_10
, NAME_11
, VALUE_11
, NAME_12
, VALUE_12
, NAME_13
, VALUE_13
, NAME_14
, VALUE_14
, NAME_15
, VALUE_15
, NULL ) AMT_PERCENTAGE
, DECODE( 'NET AMOUNT'
, NAME_1
, VALUE_1
, NAME_2
, VALUE_2
, NAME_3
, VALUE_3
, NAME_4
, VALUE_4
, NAME_5
, VALUE_5
, NAME_6
, VALUE_6
, NAME_7
, VALUE_7
, NAME_8
, VALUE_8
, NAME_9
, VALUE_9
, NAME_10
, VALUE_10
, NAME_11
, VALUE_11
, NAME_12
, VALUE_12
, NAME_13
, VALUE_13
, NAME_14
, VALUE_14
, NAME_15
, VALUE_15
, NULL ) AMT_NET_AMOUNT
, DECODE( 'PAY VALUE'
, NAME_1
, VALUE_1
, NAME_2
, VALUE_2
, NAME_3
, VALUE_3
, NAME_4
, VALUE_4
, NAME_5
, VALUE_5
, NAME_6
, VALUE_6
, NAME_7
, VALUE_7
, NAME_8
, VALUE_8
, NAME_9
, VALUE_9
, NAME_10
, VALUE_10
, NAME_11
, VALUE_11
, NAME_12
, VALUE_12
, NAME_13
, VALUE_13
, NAME_14
, VALUE_14
, NAME_15
, VALUE_15
, NULL ) AMT_PAY_VALUE
, DECODE( 'REPLACE AMT'
, NAME_1
, VALUE_1
, NAME_2
, VALUE_2
, NAME_3
, VALUE_3
, NAME_4
, VALUE_4
, NAME_5
, VALUE_5
, NAME_6
, VALUE_6
, NAME_7
, VALUE_7
, NAME_8
, VALUE_8
, NAME_9
, VALUE_9
, NAME_10
, VALUE_10
, NAME_11
, VALUE_11
, NAME_12
, VALUE_12
, NAME_13
, VALUE_13
, NAME_14
, VALUE_14
, NAME_15
, VALUE_15
, NULL ) AMT_REPLACE_AMT
, DECODE( 'ADDL AMT'
, NAME_1
, VALUE_1
, NAME_2
, VALUE_2
, NAME_3
, VALUE_3
, NAME_4
, VALUE_4
, NAME_5
, VALUE_5
, NAME_6
, VALUE_6
, NAME_7
, VALUE_7
, NAME_8
, VALUE_8
, NAME_9
, VALUE_9
, NAME_10
, VALUE_10
, NAME_11
, VALUE_11
, NAME_12
, VALUE_12
, NAME_13
, VALUE_13
, NAME_14
, VALUE_14
, NAME_15
, VALUE_15
, NULL ) AMT_ADDL_AMT
, NULL APPLY_THIS_PERIOD
, NULL COST_CENTER_CODE
, ELEMENT_NAME
, EFFECTIVE_DATE FROM_DATE
, DECODE( 'RATE'
, NAME_1
, VALUE_1
, NAME_2
, VALUE_2
, NAME_3
, VALUE_3
, NAME_4
, VALUE_4
, NAME_5
, VALUE_5
, NAME_6
, VALUE_6
, NAME_7
, VALUE_7
, NAME_8
, VALUE_8
, NAME_9
, VALUE_9
, NAME_10
, VALUE_10
, NAME_11
, VALUE_11
, NAME_12
, VALUE_12
, NAME_13
, VALUE_13
, NAME_14
, VALUE_14
, NAME_15
, VALUE_15
, NULL ) HOURLY_RATE
, DECODE( 'HOURS'
, NAME_1
, VALUE_1
, NAME_2
, VALUE_2
, NAME_3
, VALUE_3
, NAME_4
, VALUE_4
, NAME_5
, VALUE_5
, NAME_6
, VALUE_6
, NAME_7
, VALUE_7
, NAME_8
, VALUE_8
, NAME_9
, VALUE_9
, NAME_10
, VALUE_10
, NAME_11
, VALUE_11
, NAME_12
, VALUE_12
, NAME_13
, VALUE_13
, NAME_14
, VALUE_14
, NAME_15
, VALUE_15
, NULL ) HOURS_WORKED
, DECODE( 'TOWARDS OWED'
, NAME_1
, VALUE_1
, NAME_2
, VALUE_2
, NAME_3
, VALUE_3
, NAME_4
, VALUE_4
, NAME_5
, VALUE_5
, NAME_6
, VALUE_6
, NAME_7
, VALUE_7
, NAME_8
, VALUE_8
, NAME_9
, VALUE_9
, NAME_10
, VALUE_10
, NAME_11
, VALUE_11
, NAME_12
, VALUE_12
, NAME_13
, VALUE_13
, NAME_14
, VALUE_14
, NAME_15
, VALUE_15
, NULL ) INC_ASC_BALANCE
, NULL LABOR_DIST_CODE
, BATCH_LINE_STATUS LINE_STATUS
, NULL LOCALITY_WORKED
, TO_NUMBER( NULL ) NEW_SALARY
, TO_DATE( NULL ) PAY_EFFECTIVE_DATE
, TO_NUMBER( NULL ) PCNT_INCREASE
, DECODE( 'RATE CODE'
, NAME_1
, VALUE_1
, NAME_2
, VALUE_2
, NAME_3
, VALUE_3
, NAME_4
, VALUE_4
, NAME_5
, VALUE_5
, NAME_6
, VALUE_6
, NAME_7
, VALUE_7
, NAME_8
, VALUE_8
, NAME_9
, VALUE_9
, NAME_10
, VALUE_10
, NAME_11
, VALUE_11
, NAME_12
, VALUE_12
, NAME_13
, VALUE_13
, NAME_14
, VALUE_14
, NAME_15
, VALUE_15
, NULL ) RATE_CODE
, DECODE( 'MULTIPLE'
, NAME_1
, VALUE_1
, NAME_2
, VALUE_2
, NAME_3
, VALUE_3
, NAME_4
, VALUE_4
, NAME_5
, VALUE_5
, NAME_6
, VALUE_6
, NAME_7
, VALUE_7
, NAME_8
, VALUE_8
, NAME_9
, VALUE_9
, NAME_10
, VALUE_10
, NAME_11
, VALUE_11
, NAME_12
, VALUE_12
, NAME_13
, VALUE_13
, NAME_14
, VALUE_14
, NAME_15
, VALUE_15
, NULL ) RATE_MULTIPLE
, NULL RATING_CODE
, DECODE( 'SEPARATE CHECK'
, NAME_1
, VALUE_1
, NAME_2
, VALUE_2
, NAME_3
, VALUE_3
, NAME_4
, VALUE_4
, NAME_5
, VALUE_5
, NAME_6
, VALUE_6
, NAME_7
, VALUE_7
, NAME_8
, VALUE_8
, NAME_9
, VALUE_9
, NAME_10
, VALUE_10
, NAME_11
, VALUE_11
, NAME_12
, VALUE_12
, NAME_13
, VALUE_13
, NAME_14
, VALUE_14
, NAME_15
, VALUE_15
, NULL ) SEPARATE_CHECK_FLAG
, DECODE( 'SHIFT'
, NAME_1
, VALUE_1
, NAME_2
, VALUE_2
, NAME_3
, VALUE_3
, NAME_4
, VALUE_4
, NAME_5
, VALUE_5
, NAME_6
, VALUE_6
, NAME_7
, VALUE_7
, NAME_8
, VALUE_8
, NAME_9
, VALUE_9
, NAME_10
, VALUE_10
, NAME_11
, VALUE_11
, NAME_12
, VALUE_12
, NAME_13
, VALUE_13
, NAME_14
, VALUE_14
, NAME_15
, VALUE_15
, NULL ) SHIFT_TYPE
, DECODE( 'JURISDICTION'
, NAME_1
, VALUE_1
, NAME_2
, VALUE_2
, NAME_3
, VALUE_3
, NAME_4
, VALUE_4
, NAME_5
, VALUE_5
, NAME_6
, VALUE_6
, NAME_7
, VALUE_7
, NAME_8
, VALUE_8
, NAME_9
, VALUE_9
, NAME_10
, VALUE_10
, NAME_11
, VALUE_11
, NAME_12
, VALUE_12
, NAME_13
, VALUE_13
, NAME_14
, VALUE_14
, NAME_15
, VALUE_15
, NULL ) STATE_WORKED
, DECODE( 'TAX SEPARATELY'
, NAME_1
, VALUE_1
, NAME_2
, VALUE_2
, NAME_3
, VALUE_3
, NAME_4
, VALUE_4
, NAME_5
, VALUE_5
, NAME_6
, VALUE_6
, NAME_7
, VALUE_7
, NAME_8
, VALUE_8
, NAME_9
, VALUE_9
, NAME_10
, VALUE_10
, NAME_11
, VALUE_11
, NAME_12
, VALUE_12
, NAME_13
, VALUE_13
, NAME_14
, VALUE_14
, NAME_15
, VALUE_15
, NULL ) TAX_SEPARATELY_FLAG
, TO_DATE( NULL ) TO_DATE
, DECODE( 'DEDUCTION PROCESSING'
, NAME_1
, VALUE_1
, NAME_2
, VALUE_2
, NAME_3
, VALUE_3
, NAME_4
, VALUE_4
, NAME_5
, VALUE_5
, NAME_6
, VALUE_6
, NAME_7
, VALUE_7
, NAME_8
, VALUE_8
, NAME_9
, VALUE_9
, NAME_10
, VALUE_10
, NAME_11
, VALUE_11
, NAME_12
, VALUE_12
, NAME_13
, VALUE_13
, NAME_14
, VALUE_14
, NAME_15
, VALUE_15
, NULL ) VOL_DED_PROC_OVD
, COST_ALLOCATION_KEYFLEX_ID
, CONCATENATED_SEGMENTS
, SEGMENT1
, SEGMENT2
, SEGMENT3
, SEGMENT4
, SEGMENT5
, SEGMENT6
, SEGMENT7
, SEGMENT8
, SEGMENT9
, SEGMENT10
, SEGMENT11
, SEGMENT12
, SEGMENT13
, SEGMENT14
, SEGMENT15
, SEGMENT16
, SEGMENT17
, SEGMENT18
, SEGMENT19
, SEGMENT20
, SEGMENT21
, SEGMENT22
, SEGMENT23
, SEGMENT24
, SEGMENT25
, SEGMENT26
, SEGMENT27
, SEGMENT28
, SEGMENT29
, SEGMENT30
FROM PAY_PDT_BATCH_LINES_V2