[Home] [Help]
View: PAY_GB_ELEMENT_VALUES_V
View Text
SELECT PET.ELEMENT_TYPE_ID
, PIV.INPUT_VALUE_ID
, PRV.RESULT_VALUE
, PAC.LOCKING_ACTION_ID
FROM PAY_ELEMENT_TYPES_F PET
, PAY_INPUT_VALUES_F PIV
, PAY_RUN_RESULT_VALUES PRV
, PAY_RUN_RESULTS PRR
, PAY_ACTION_INTERLOCKS PAC
WHERE PRR.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND PRR.STATUS IN ('P'
, 'PA')
AND PIV.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND PRV.INPUT_VALUE_ID = PIV.INPUT_VALUE_ID
AND PRV.RUN_RESULT_ID = PRR.RUN_RESULT_ID
AND PAC.LOCKED_ACTION_ID = PRR.ASSIGNMENT_ACTION_ID
Columns
Name |
ELEMENT_TYPE_ID |
INPUT_VALUE_ID |
RESULT_VALUE |
ASSIGNMENT_ACTION_ID |