1. Tables and Views for HCM
  2. PAY_XLA_PAYMENT_COSTS_V

PAY_XLA_PAYMENT_COSTS_V

Details

  • Schema: FUSION

  • Object owner: PAY

  • Object type: VIEW

Columns

Name

EVENT_ID

LINE_NUMBER

PAYROLL_REL_ACTION_ID

COST_ACTION_ID

COSTED_VALUE

DEBIT_OR_CREDIT

CURRENCY_CODE

ACCOUNT_TYPE

ACCOUNTING_DATE

PAYROLL_NAME

COST_ALLOCATION_KEYFLEX_ID

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

Query

SQL_Statement

SELECT PXE.EVENT_ID, PPC.PAYMENT_COST_ID LINE_NUMBER, TGL_RA.PAYROLL_REL_ACTION_ID,

PPC.PAYROLL_REL_ACTION_ID COST_ACTION_ID, PPC.VALUE COSTED_VALUE,

decode(nvl(PXE.REVERSAL_FLAG, 'N'), 'N', PPC.DEBIT_OR_CREDIT, decode(PPC.DEBIT_OR_CREDIT, 'C', 'D', 'C')) DEBIT_OR_CREDIT,

PPC.CURRENCY_CODE, PPC.ACCOUNT_TYPE, PXE.ACCOUNTING_DATE, PAY.PAYROLL_NAME, PPC.COST_ALLOCATION_KEYFLEX_ID,

KEY.SEGMENT1, KEY.SEGMENT2, KEY.SEGMENT3, KEY.SEGMENT4, KEY.SEGMENT5,

KEY.SEGMENT6, KEY.SEGMENT7, KEY.SEGMENT8, KEY.SEGMENT9, KEY.SEGMENT10, KEY.SEGMENT11, KEY.SEGMENT12,

KEY.SEGMENT13, KEY.SEGMENT14, KEY.SEGMENT15, KEY.SEGMENT16, KEY.SEGMENT17, KEY.SEGMENT18,

KEY.SEGMENT19, KEY.SEGMENT20, KEY.SEGMENT21, KEY.SEGMENT22, KEY.SEGMENT23, KEY.SEGMENT24,

KEY.SEGMENT25, KEY.SEGMENT26, KEY.SEGMENT27, KEY.SEGMENT28, KEY.SEGMENT29, KEY.SEGMENT30

FROM PAY_XLA_EVENTS PXE,

PAY_PAYROLL_REL_ACTIONS TGL_RA,

PAY_PAYROLL_ACTIONS TGL_PA,

PAY_ACTION_INTERLOCKS COST_LOCK,

PAY_PAYROLL_REL_ACTIONS COST_RA,

PAY_PAYROLL_ACTIONS COST_PA,

PAY_PAYMENT_COSTS PPC,

PAY_ALL_PAYROLLS_F PAY,

PAY_COST_ALLOCATION_KEYFLEX KEY

WHERE TGL_RA.PAYROLL_REL_ACTION_ID = PXE.PAYROLL_REL_ACTION_ID

AND TGL_PA.PAYROLL_ACTION_ID = TGL_RA.PAYROLL_ACTION_ID

AND COST_LOCK.LOCKING_ACTION_ID = TGL_RA.PAYROLL_REL_ACTION_ID

AND COST_RA.PAYROLL_REL_ACTION_ID = COST_LOCK.LOCKED_ACTION_ID

AND COST_PA.PAYROLL_ACTION_ID = COST_RA.PAYROLL_ACTION_ID

AND COST_PA.ACTION_TYPE = 'CP'

AND PPC.PAYROLL_REL_ACTION_ID = COST_RA.PAYROLL_REL_ACTION_ID

AND DECODE(PXE.REVERSAL_FLAG, 'Y', PXE.ACCOUNTING_DATE, nvl(TGL_PA.OVERRIDE_DATE, PPC.ACCOUNTING_DATE)) = PXE.ACCOUNTING_DATE

AND PAY.PAYROLL_ID = PXE.PAYROLL_ID

AND COST_PA.EFFECTIVE_DATE BETWEEN PAY.EFFECTIVE_START_DATE AND PAY.EFFECTIVE_END_DATE

AND KEY.COST_ALLOCATION_KEYFLEX_ID = PPC.COST_ALLOCATION_KEYFLEX_ID

AND PPC.PAYROLL_ID = PXE.PAYROLL_ID

AND PPC.TRANSFER_TO_GL_FLAG = 'Y'