View: PAY_COSTS_V

Product:	PAY - Payroll
Description:	Used to support user interface
Implementation/DBA Data:	APPS.PAY_COSTS_V

View Text

SELECT COS.COST_ALLOCATION_KEYFLEX_ID
, COS.ASSIGNMENT_ACTION_ID
, COS.RUN_RESULT_ID
, COS.INPUT_VALUE_ID
, COS.DISTRIBUTED_RUN_RESULT_ID
, COS.BALANCE_OR_COST
, DECODE(COS.DISTRIBUTED_INPUT_VALUE_ID
, NULL
, ELETL.ELEMENT_NAME
, DIS_ELETL.ELEMENT_NAME)
, INVTL.NAME
, INV.UOM
, HR_GENERAL.DECODE_LOOKUP('UNITS'
, INV.UOM) UNITS
, CAK.CONCATENATED_SEGMENTS
, ELE.OUTPUT_CURRENCY_CODE
, COS.COSTED_VALUE
, HR_CHKFMT.CHANGEFORMAT(COS.COSTED_VALUE
, INV.UOM
, ELE.OUTPUT_CURRENCY_CODE) D_COSTED_VALUE
, HR_GENERAL.DECODE_LOOKUP('DEBIT_CREDIT'
, COS.DEBIT_OR_CREDIT) DEBIT_OR_CREDIT
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, DECODE(COS.DISTRIBUTED_INPUT_VALUE_ID
, NULL
, 'N'
, 'Y')) DISTRIBUTED
, ELE.EFFECTIVE_START_DATE ELE_EFFECTIVE_START_DATE
, ELE.EFFECTIVE_END_DATE ELE_EFFECTIVE_END_DATE
, INV.EFFECTIVE_START_DATE INV_EFFECTIVE_START_DATE
, INV.EFFECTIVE_END_DATE INV_EFFECTIVE_END_DATE
, DECODE(COS.DISTRIBUTED_INPUT_VALUE_ID
, NULL
, NULL
, DECODE(ELE.ELEMENT_TYPE_ID
, DIS_ELE.ELEMENT_TYPE_ID
, NULL
, ELETL.ELEMENT_NAME))
FROM PAY_COSTS COS
, PAY_ASSIGNMENT_ACTIONS PAA
, PAY_PAYROLL_ACTIONS PPA
, PAY_ELEMENT_TYPES_F ELE
, PAY_ELEMENT_TYPES_F_TL ELETL
, PAY_INPUT_VALUES_F INV
, PAY_INPUT_VALUES_F_TL INVTL
, PAY_ELEMENT_TYPES_F DIS_ELE
, PAY_ELEMENT_TYPES_F_TL DIS_ELETL
, PAY_INPUT_VALUES_F DIS_INV
, PAY_COST_ALLOCATION_KEYFLEX CAK
WHERE INV.INPUT_VALUE_ID = INVTL.INPUT_VALUE_ID
AND INVTL.LANGUAGE = USERENV('LANG')
AND ELE.ELEMENT_TYPE_ID = ELETL.ELEMENT_TYPE_ID
AND ELETL.LANGUAGE = USERENV('LANG')
AND INV.INPUT_VALUE_ID = COS.INPUT_VALUE_ID
AND ELE.ELEMENT_TYPE_ID = INV.ELEMENT_TYPE_ID
AND PPA.EFFECTIVE_DATE BETWEEN INV.EFFECTIVE_START_DATE
AND INV.EFFECTIVE_END_DATE
AND PPA.EFFECTIVE_DATE BETWEEN ELE.EFFECTIVE_START_DATE
AND ELE.EFFECTIVE_END_DATE
AND COS.ASSIGNMENT_ACTION_ID = PAA.ASSIGNMENT_ACTION_ID
AND PAA.PAYROLL_ACTION_ID = PPA.PAYROLL_ACTION_ID
AND CAK.COST_ALLOCATION_KEYFLEX_ID = COS.COST_ALLOCATION_KEYFLEX_ID
AND DECODE(COS.DISTRIBUTED_INPUT_VALUE_ID
, NULL
, COS.INPUT_VALUE_ID
, COS.DISTRIBUTED_INPUT_VALUE_ID) = DIS_INV.INPUT_VALUE_ID
AND DIS_INV.ELEMENT_TYPE_ID = DIS_ELE.ELEMENT_TYPE_ID
AND DIS_ELE.ELEMENT_TYPE_ID = DIS_ELETL.ELEMENT_TYPE_ID
AND PPA.EFFECTIVE_DATE BETWEEN DIS_INV.EFFECTIVE_START_DATE
AND DIS_INV.EFFECTIVE_END_DATE
AND PPA.EFFECTIVE_DATE BETWEEN DIS_ELE.EFFECTIVE_START_DATE
AND DIS_ELE.EFFECTIVE_END_DATE
AND DIS_ELETL.LANGUAGE = USERENV('LANG')

Columns