Details
-
Schema: FUSION
-
Object owner: PAY
-
Object type: VIEW
Columns
| Name |
|---|
|
ACTION_TYPE OBJECT_ACTION_ID AMOUNT CURRENCY_CODE |
Query
| SQL_Statement |
|---|
|
select ACTION_TYPE,OBJECT_ACTION_ID,Amount, CURRENCY_CODE from ( select PAC1.ACTION_TYPE,PPP.PAYROLL_REL_ACTION_ID OBJECT_ACTION_ID, SUM(PPP.BASE_CURRENCY_VALUE) Amount, ldg.DEFAULT_CURRENCY_CODE CURRENCY_CODE from PAY_PRE_PAYMENTS PPP, PAY_PAYROLL_ACTIONS PAC1, PAY_PAYROLL_REL_ACTIONS PAAC1, PER_LEGISLATIVE_DATA_GROUPS_VL ldg where PAC1.PAYROLL_ACTION_ID = PAAC1.PAYROLL_ACTION_ID AND PAAC1.PAYROLL_REL_ACTION_ID = PPP.PAYROLL_REL_ACTION_ID and ldg.legislative_data_group_id = pac1.legislative_data_group_id GROUP BY PAC1.ACTION_TYPE,PPP.PAYROLL_REL_ACTION_ID,ldg.DEFAULT_CURRENCY_CODE union all select PAC1.ACTION_TYPE,PAAC1.PAYROLL_REL_ACTION_ID OBJECT_ACTION_ID, SUM(PPP.value) Amount, OPM.CURRENCY_CODE from PAY_PRE_PAYMENTS PPP, PAY_ORG_PAY_METHODS_F OPM, PAY_PAYROLL_ACTIONS PAC1, PAY_PAYROLL_REL_ACTIONS PAAC1 where PAC1.PAYROLL_ACTION_ID = PAAC1.PAYROLL_ACTION_ID AND PAAC1.PRE_PAYMENT_ID = PPP.PRE_PAYMENT_ID AND OPM.ORG_PAYMENT_METHOD_ID = PPP.ORG_PAYMENT_METHOD_ID AND PAC1.EFFECTIVE_DATE BETWEEN OPM.EFFECTIVE_START_DATE AND OPM.EFFECTIVE_END_DATE GROUP BY PAC1.ACTION_TYPE,PAAC1.PAYROLL_REL_ACTION_ID,OPM.CURRENCY_CODE ) |