View: PAY_JP_SOE_COSTS_V

Product:	PAY - Payroll
Description:	This view is used for Japanese localization only.
Implementation/DBA Data:	APPS.PAY_JP_SOE_COSTS_V

View Text

SELECT V.ASSIGNMENT_ACTION_ID
, V.INPUT_VALUE_ID
, V.RUN_RESULT_ID
, NVL(PEC.COSTING_DEBIT_OR_CREDIT
, 'D')
, NVL(PETTL.REPORTING_NAME
, PETTL.ELEMENT_NAME) || DECODE(PIVTL.NAME
, HR_GENERAL.PAY_VALUE
, NULL
, '(' || PIVTL.NAME || ')')
, DECODE(V.DR_COUNT
, 1
, 'N'
, 0
, 'N'
, NULL
, 'N'
, 'Y')
, DECODE(V.DR_COUNT
, 1
, V.DR_COST_ALLOCATION_KEYFLEX_ID
, NULL)
, V.DR_VALUE
, DECODE(V.CR_COUNT
, 1
, 'N'
, 0
, 'N'
, NULL
, 'N'
, 'Y')
, DECODE(V.CR_COUNT
, 1
, V.CR_COST_ALLOCATION_KEYFLEX_ID
, NULL)
, V.CR_VALUE
FROM PAY_ELEMENT_TYPES_F_TL PETTL
, PAY_ELEMENT_CLASSIFICATIONS PEC
, PAY_ELEMENT_TYPES_F PET
, PAY_INPUT_VALUES_F_TL PIVTL
, /* RUN PACT */ PAY_PAYROLL_ACTIONS PPA
, /* RUN ASSACT */ PAY_ASSIGNMENT_ACTIONS PAA
, PAY_RUN_RESULTS PRR
, ( SELECT PC.ASSIGNMENT_ACTION_ID
, PC.INPUT_VALUE_ID
, PC.RUN_RESULT_ID
, COUNT(DECODE(PC.DEBIT_OR_CREDIT
, 'D'
, PC.COST_ALLOCATION_KEYFLEX_ID
, NULL)) DR_COUNT
, MAX(DECODE(PC.DEBIT_OR_CREDIT
, 'D'
, PC.COST_ALLOCATION_KEYFLEX_ID
, NULL)) DR_COST_ALLOCATION_KEYFLEX_ID
, NVL(SUM(DECODE(PC.DEBIT_OR_CREDIT
, 'D'
, PC.COSTED_VALUE
, NULL))
, 0) DR_VALUE
, COUNT(DECODE(PC.DEBIT_OR_CREDIT
, 'C'
, PC.COST_ALLOCATION_KEYFLEX_ID
, NULL)) CR_COUNT
, MAX(DECODE(PC.DEBIT_OR_CREDIT
, 'C'
, PC.COST_ALLOCATION_KEYFLEX_ID
, NULL)) CR_COST_ALLOCATION_KEYFLEX_ID
, NVL(SUM(DECODE(PC.DEBIT_OR_CREDIT
, 'C'
, PC.COSTED_VALUE
, NULL))
, 0) CR_VALUE
FROM PAY_COSTS PC GROUP BY PC.ASSIGNMENT_ACTION_ID
, PC.INPUT_VALUE_ID
, PC.RUN_RESULT_ID ) V
WHERE PRR.RUN_RESULT_ID = V.RUN_RESULT_ID
AND PAA.ASSIGNMENT_ACTION_ID = PRR.ASSIGNMENT_ACTION_ID
AND PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID
AND PIVTL.INPUT_VALUE_ID = V.INPUT_VALUE_ID
AND PIVTL.LANGUAGE = USERENV('LANG')
AND PET.ELEMENT_TYPE_ID = PRR.ELEMENT_TYPE_ID
AND PPA.DATE_EARNED BETWEEN PET.EFFECTIVE_START_DATE
AND PET.EFFECTIVE_END_DATE
AND PEC.CLASSIFICATION_ID = PET.CLASSIFICATION_ID
AND PETTL.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND PETTL.LANGUAGE = USERENV('LANG')

Columns