ECC Property Manager, Normalized Data for Property Manager Leases, SQL1

Description
Columns: Account Expense, Accrued Liability, Adjustment, Currency Code, Ecc Spec Id, Lease Id, Normalization Cash, Schedule Date, Total Cash, Period ...
Imported from ECC
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