DBA Data[Home] [Help]

VIEW: APPS.PAY_NZ_SOE_RUN_ELEMENTS_V

Source

View Text - Preformatted

SELECT "ELEMENT_REPORTING_NAME","CLASSIFICATION_NAME","PAYMENT","PROCESSING_PRIORITY","ASSIGNMENT_ACTION_ID","ASSIGNMENT_ID" FROM pay_nz_soe_run_elements_v1 UNION ALL SELECT "ELEMENT_REPORTING_NAME","CLASSIFICATION_NAME","PAYMENT","PROCESSING_PRIORITY","ASSIGNMENT_ACTION_ID","ASSIGNMENT_ID" FROM pay_nz_soe_run_elements_v2
View Text - HTML Formatted

SELECT "ELEMENT_REPORTING_NAME"
, "CLASSIFICATION_NAME"
, "PAYMENT"
, "PROCESSING_PRIORITY"
, "ASSIGNMENT_ACTION_ID"
, "ASSIGNMENT_ID"
FROM PAY_NZ_SOE_RUN_ELEMENTS_V1 UNION ALL SELECT "ELEMENT_REPORTING_NAME"
, "CLASSIFICATION_NAME"
, "PAYMENT"
, "PROCESSING_PRIORITY"
, "ASSIGNMENT_ACTION_ID"
, "ASSIGNMENT_ID"
FROM PAY_NZ_SOE_RUN_ELEMENTS_V2