VIEW: APPS.PAY_XLA_COSTS_V

Source

View Text - Preformatted

SELECT PXE.EVENT_ID, PC.COST_ID, TGL_AA.ASSIGNMENT_ACTION_ID, COST_AA.ASSIGNMENT_ACTION_ID, RUN_AA.ASSIGNMENT_ACTION_ID, PC.COSTED_VALUE, PC.DEBIT_OR_CREDIT, DECODE(IV.UOM, 'M', ET.OUTPUT_CURRENCY_CODE, 'STAT'), ETTL.ELEMENT_NAME, KEY.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_ASSIGNMENT_ACTIONS TGL_AA, PAY_ACTION_INTERLOCKS COST_LOCK, PAY_ASSIGNMENT_ACTIONS COST_AA, PAY_PAYROLL_ACTIONS COST_PA, PAY_ACTION_CLASSIFICATIONS COST_CLA, PAY_ACTION_INTERLOCKS RUN_LOCK, PAY_ASSIGNMENT_ACTIONS RUN_AA, PAY_PAYROLL_ACTIONS RUN_PA, PAY_ACTION_CLASSIFICATIONS RUN_CLA, PAY_ASSIGNMENT_ACTIONS RUN_AA2, PAY_COSTS PC, PAY_RUN_RESULTS RR, PAY_INPUT_VALUES_F IV, PAY_ELEMENT_TYPES_F ET, PAY_ELEMENT_TYPES_F_TL ETTL, PAY_COST_ALLOCATION_KEYFLEX KEY WHERE TGL_AA.ASSIGNMENT_ACTION_ID = PXE.ASSIGNMENT_ACTION_ID AND COST_LOCK.LOCKING_ACTION_ID = TGL_AA.ASSIGNMENT_ACTION_ID AND COST_AA.ASSIGNMENT_ACTION_ID = COST_LOCK.LOCKED_ACTION_ID AND COST_PA.PAYROLL_ACTION_ID = COST_AA.PAYROLL_ACTION_ID AND COST_PA.ACTION_TYPE = COST_CLA.ACTION_TYPE AND COST_CLA.CLASSIFICATION_NAME = 'TRANSGL' AND RUN_LOCK.LOCKING_ACTION_ID = TGL_AA.ASSIGNMENT_ACTION_ID AND RUN_AA.ASSIGNMENT_ACTION_ID = RUN_LOCK.LOCKED_ACTION_ID AND RUN_PA.PAYROLL_ACTION_ID = RUN_AA.PAYROLL_ACTION_ID AND RUN_PA.ACTION_TYPE = RUN_CLA.ACTION_TYPE AND RUN_CLA.CLASSIFICATION_NAME = 'COSTED' AND RUN_AA2.PAYROLL_ACTION_ID = RUN_PA.PAYROLL_ACTION_ID AND RUN_AA2.ASSIGNMENT_ID = RUN_AA.ASSIGNMENT_ID AND PC.ASSIGNMENT_ACTION_ID = COST_AA.ASSIGNMENT_ACTION_ID AND PC.TRANSFER_TO_GL_FLAG = 'Y' AND RR.RUN_RESULT_ID = PC.RUN_RESULT_ID AND RR.ASSIGNMENT_ACTION_ID = RUN_AA2.ASSIGNMENT_ACTION_ID AND IV.INPUT_VALUE_ID = PC.INPUT_VALUE_ID AND RUN_PA.DATE_EARNED BETWEEN IV.EFFECTIVE_START_DATE AND IV.EFFECTIVE_END_DATE AND ET.ELEMENT_TYPE_ID = RR.ELEMENT_TYPE_ID AND RUN_PA.DATE_EARNED BETWEEN ET.EFFECTIVE_START_DATE AND ET.EFFECTIVE_END_DATE AND ETTL.ELEMENT_TYPE_ID = ET.ELEMENT_TYPE_ID AND ETTL.LANGUAGE (+) = USERENV('LANG') AND PC.COST_ALLOCATION_KEYFLEX_ID = KEY.COST_ALLOCATION_KEYFLEX_ID

View Text - HTML Formatted

SELECT PXE.EVENT_ID
, PC.COST_ID
, TGL_AA.ASSIGNMENT_ACTION_ID
, COST_AA.ASSIGNMENT_ACTION_ID
, RUN_AA.ASSIGNMENT_ACTION_ID
, PC.COSTED_VALUE
, PC.DEBIT_OR_CREDIT
, DECODE(IV.UOM
, 'M'
, ET.OUTPUT_CURRENCY_CODE
, 'STAT')
, ETTL.ELEMENT_NAME
, KEY.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_ASSIGNMENT_ACTIONS TGL_AA
, PAY_ACTION_INTERLOCKS COST_LOCK
, PAY_ASSIGNMENT_ACTIONS COST_AA
, PAY_PAYROLL_ACTIONS COST_PA
, PAY_ACTION_CLASSIFICATIONS COST_CLA
, PAY_ACTION_INTERLOCKS RUN_LOCK
, PAY_ASSIGNMENT_ACTIONS RUN_AA
, PAY_PAYROLL_ACTIONS RUN_PA
, PAY_ACTION_CLASSIFICATIONS RUN_CLA
, PAY_ASSIGNMENT_ACTIONS RUN_AA2
, PAY_COSTS PC
, PAY_RUN_RESULTS RR
, PAY_INPUT_VALUES_F IV
, PAY_ELEMENT_TYPES_F ET
, PAY_ELEMENT_TYPES_F_TL ETTL
, PAY_COST_ALLOCATION_KEYFLEX KEY
WHERE TGL_AA.ASSIGNMENT_ACTION_ID = PXE.ASSIGNMENT_ACTION_ID
AND COST_LOCK.LOCKING_ACTION_ID = TGL_AA.ASSIGNMENT_ACTION_ID
AND COST_AA.ASSIGNMENT_ACTION_ID = COST_LOCK.LOCKED_ACTION_ID
AND COST_PA.PAYROLL_ACTION_ID = COST_AA.PAYROLL_ACTION_ID
AND COST_PA.ACTION_TYPE = COST_CLA.ACTION_TYPE
AND COST_CLA.CLASSIFICATION_NAME = 'TRANSGL'
AND RUN_LOCK.LOCKING_ACTION_ID = TGL_AA.ASSIGNMENT_ACTION_ID
AND RUN_AA.ASSIGNMENT_ACTION_ID = RUN_LOCK.LOCKED_ACTION_ID
AND RUN_PA.PAYROLL_ACTION_ID = RUN_AA.PAYROLL_ACTION_ID
AND RUN_PA.ACTION_TYPE = RUN_CLA.ACTION_TYPE
AND RUN_CLA.CLASSIFICATION_NAME = 'COSTED'
AND RUN_AA2.PAYROLL_ACTION_ID = RUN_PA.PAYROLL_ACTION_ID
AND RUN_AA2.ASSIGNMENT_ID = RUN_AA.ASSIGNMENT_ID
AND PC.ASSIGNMENT_ACTION_ID = COST_AA.ASSIGNMENT_ACTION_ID
AND PC.TRANSFER_TO_GL_FLAG = 'Y'
AND RR.RUN_RESULT_ID = PC.RUN_RESULT_ID
AND RR.ASSIGNMENT_ACTION_ID = RUN_AA2.ASSIGNMENT_ACTION_ID
AND IV.INPUT_VALUE_ID = PC.INPUT_VALUE_ID
AND RUN_PA.DATE_EARNED BETWEEN IV.EFFECTIVE_START_DATE
AND IV.EFFECTIVE_END_DATE
AND ET.ELEMENT_TYPE_ID = RR.ELEMENT_TYPE_ID
AND RUN_PA.DATE_EARNED BETWEEN ET.EFFECTIVE_START_DATE
AND ET.EFFECTIVE_END_DATE
AND ETTL.ELEMENT_TYPE_ID = ET.ELEMENT_TYPE_ID
AND ETTL.LANGUAGE (+) = USERENV('LANG')
AND PC.COST_ALLOCATION_KEYFLEX_ID = KEY.COST_ALLOCATION_KEYFLEX_ID