VIEW: APPS.PAY_COSTS_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')