VIEW: APPS.PAY_PDT_BATCH_LINES_V3

Source

View Text - Preformatted

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

View Text - HTML Formatted

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