ECC Property Manager, Normalized Data for Property Manager Leases

select
x.*
from
(
SELECT
ACCOUNT_EXPENSE,
ABS(ACCRUED_LIABILITY) ACCRUED_LIABILITY,
ABS(ADJUSTMENT) ADJUSTMENT,
CURRENCY_CODE,
ECC_SPEC_ID,
LEASE_ID,
NORMALIZATION_CASH,
SCHEDULE_DATE,
TOTAL_CASH,
TO_CHAR(SCHEDULE_DATE,'MON-YY') PERIOD,
to_char(SCHEDULE_DATE,'YYYY-MM') rep_period,
PROCESSING_STATUS_FLAG,
ORG_ID
FROM PN_ECC_NORMALIZE_V
) x
where
2=2

select x.* from ( SELECT ACCOUNT_EXPENSE, ABS(ACCRUED_LIABILITY) ACCRUED_LIABILITY, ABS(ADJUSTMENT) ADJUSTMENT, CURRENCY_CODE, ECC_SPEC_ID, LEASE_ID, NORMALIZATION_CASH, SCHEDULE_DATE, TOTAL_CASH, TO_CHAR(SCHEDULE_DATE,'MON-YY') PERIOD, to_char(SCHEDULE_DATE,'YYYY-MM') rep_period, PROCESSING_STATUS_FLAG, ORG_ID FROM PN_ECC_NORMALIZE_V ) x where 2=2