1 Reply Latest reply on Mar 6, 2017 12:36 PM by Srini Chavali-Oracle

    Make Report Of One Table with Different Types & Date Ranges as a row level report

    miro_feps

      Hi ,

       

      i'm having a one table that is having multiple types of payment (base rent , service charge , utility charge ) , each of them could be having a different behavior in inserting the dates on the line level .

       

      Below is sample Of a testing table structure & Its data sample .

       

      CREATE TABLE  XX_TEST_SPLIT

      (

       

        LEASE_ID     NUMBER,

        PAYMENT_TRM_ID NUMBER,

        LOCATION_ID  NUMBER,

        START_DATE   DATE,

        END_DATE     DATE,

        AMOUNT_PAID  NUMBER,

        FREQUENCY    VARCHAR2(250 BYTE),

        LINE_TYPE    VARCHAR2(250 BYTE)

      )

       

      INSERT INTO XX_TEST_SPLIT ( LEASE_ID, PAYMENT_TRM_ID, LOCATION_ID, START_DATE, END_DATE,

      AMOUNT_PAID, FREQUENCY, LINE_TYPE ) VALUES (

      1044, 1260, 1046,  TO_Date( '08/01/2012 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'),  TO_Date( '07/31/2013 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')

      , 1076670, 'YR', 'RENT');

      INSERT INTO XX_TEST_SPLIT ( LEASE_ID, PAYMENT_TRM_ID, LOCATION_ID, START_DATE, END_DATE,

      AMOUNT_PAID, FREQUENCY, LINE_TYPE ) VALUES (

      1044, 1261, 1046,  TO_Date( '08/01/2013 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'),  TO_Date( '07/31/2014 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')

      , 1076670, 'YR', 'RENT');

      INSERT INTO XX_TEST_SPLIT ( LEASE_ID, PAYMENT_TRM_ID, LOCATION_ID, START_DATE, END_DATE,

      AMOUNT_PAID, FREQUENCY, LINE_TYPE ) VALUES (

      1044, 1262, 1046,  TO_Date( '08/01/2014 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'),  TO_Date( '07/31/2015 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')

      , 1076670, 'YR', 'RENT');

      INSERT INTO XX_TEST_SPLIT ( LEASE_ID, PAYMENT_TRM_ID, LOCATION_ID, START_DATE, END_DATE,

      AMOUNT_PAID, FREQUENCY, LINE_TYPE ) VALUES (

      1044, 1263, 1046,  TO_Date( '08/01/2015 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'),  TO_Date( '07/31/2016 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')

      , 1076670, 'YR', 'RENT');

      INSERT INTO XX_TEST_SPLIT ( LEASE_ID, PAYMENT_TRM_ID, LOCATION_ID, START_DATE, END_DATE,

      AMOUNT_PAID, FREQUENCY, LINE_TYPE ) VALUES (

      1044, 1264, 1046,  TO_Date( '08/01/2016 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'),  TO_Date( '07/31/2017 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')

      , 1076670, 'YR', 'RENT');

      INSERT INTO XX_TEST_SPLIT ( LEASE_ID, PAYMENT_TRM_ID, LOCATION_ID, START_DATE, END_DATE,

      AMOUNT_PAID, FREQUENCY, LINE_TYPE ) VALUES (

      1044, 1265, 1046,  TO_Date( '08/01/2012 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'),  TO_Date( '08/01/2012 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')

      , 110000, 'OT', 'SD');

      INSERT INTO XX_TEST_SPLIT ( LEASE_ID, PAYMENT_TRM_ID, LOCATION_ID, START_DATE, END_DATE,

      AMOUNT_PAID, FREQUENCY, LINE_TYPE ) VALUES (

      1044, 1266, 1046,  TO_Date( '08/01/2012 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'),  TO_Date( '07/31/2013 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')

      , 299075, 'YR', 'SERVICE CHARGE');

      INSERT INTO XX_TEST_SPLIT ( LEASE_ID, PAYMENT_TRM_ID, LOCATION_ID, START_DATE, END_DATE,

      AMOUNT_PAID, FREQUENCY, LINE_TYPE ) VALUES (

      1044, 1267, 1046,  TO_Date( '08/01/2013 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'),  TO_Date( '07/31/2014 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')

      , 299075, 'YR', 'SERVICE CHARGE');

      INSERT INTO XX_TEST_SPLIT ( LEASE_ID, PAYMENT_TRM_ID, LOCATION_ID, START_DATE, END_DATE,

      AMOUNT_PAID, FREQUENCY, LINE_TYPE ) VALUES (

      1044, 1268, 1046,  TO_Date( '08/01/2014 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'),  TO_Date( '07/31/2015 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')

      , 299075, 'YR', 'SERVICE CHARGE');

      INSERT INTO XX_TEST_SPLIT ( LEASE_ID, PAYMENT_TRM_ID, LOCATION_ID, START_DATE, END_DATE,

      AMOUNT_PAID, FREQUENCY, LINE_TYPE ) VALUES (

      1044, 1269, 1046,  TO_Date( '08/01/2015 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'),  TO_Date( '07/31/2016 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')

      , 299075, 'YR', 'SERVICE CHARGE');

      INSERT INTO XX_TEST_SPLIT ( LEASE_ID, PAYMENT_TRM_ID, LOCATION_ID, START_DATE, END_DATE,

      AMOUNT_PAID, FREQUENCY, LINE_TYPE ) VALUES (

      1044, 1270, 1046,  TO_Date( '08/01/2016 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'),  TO_Date( '07/31/2017 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')

      , 299075, 'YR', 'SERVICE CHARGE');

      INSERT INTO XX_TEST_SPLIT ( LEASE_ID, PAYMENT_TRM_ID, LOCATION_ID, START_DATE, END_DATE,

      AMOUNT_PAID, FREQUENCY, LINE_TYPE ) VALUES (

      1044, 1271, 1046,  TO_Date( '08/01/2012 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'),  TO_Date( '07/31/2013 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')

      , 179445, 'YR', 'UTILITYC');

      INSERT INTO XX_TEST_SPLIT ( LEASE_ID, PAYMENT_TRM_ID, LOCATION_ID, START_DATE, END_DATE,

      AMOUNT_PAID, FREQUENCY, LINE_TYPE ) VALUES (

      1044, 1272, 1046,  TO_Date( '08/01/2013 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'),  TO_Date( '07/31/2014 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')

      , 179445, 'YR', 'UTILITYC');

      INSERT INTO XX_TEST_SPLIT ( LEASE_ID, PAYMENT_TRM_ID, LOCATION_ID, START_DATE, END_DATE,

      AMOUNT_PAID, FREQUENCY, LINE_TYPE ) VALUES (

      1044, 1273, 1046,  TO_Date( '08/01/2014 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'),  TO_Date( '07/31/2015 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')

      , 179445, 'YR', 'UTILITYC');

      INSERT INTO XX_TEST_SPLIT ( LEASE_ID, PAYMENT_TRM_ID, LOCATION_ID, START_DATE, END_DATE,

      AMOUNT_PAID, FREQUENCY, LINE_TYPE ) VALUES (

      1044, 1274, 1046,  TO_Date( '08/01/2015 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'),  TO_Date( '07/31/2016 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')

      , 179445, 'YR', 'UTILITYC');

      INSERT INTO XX_TEST_SPLIT ( LEASE_ID, PAYMENT_TRM_ID, LOCATION_ID, START_DATE, END_DATE,

      AMOUNT_PAID, FREQUENCY, LINE_TYPE ) VALUES (

      1044, 1275, 1046,  TO_Date( '08/01/2016 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'),  TO_Date( '07/31/2017 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')

      , 179445, 'YR', 'UTILITYC');

      INSERT INTO XX_TEST_SPLIT ( LEASE_ID, PAYMENT_TRM_ID, LOCATION_ID, START_DATE, END_DATE,

      AMOUNT_PAID, FREQUENCY, LINE_TYPE ) VALUES (

      1044, 9001, 1046,  TO_Date( '09/18/2016 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'),  TO_Date( '09/18/2016 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')

      , 50, 'OT', 'JCA');

      INSERT INTO XX_TEST_SPLIT ( LEASE_ID, PAYMENT_TRM_ID, LOCATION_ID, START_DATE, END_DATE,

      AMOUNT_PAID, FREQUENCY, LINE_TYPE ) VALUES (

      1044, 98010, NULL,  TO_Date( '01/04/2017 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'),  TO_Date( '01/04/2017 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')

      , 5000, 'OT', 'BOPCHRG');

      INSERT INTO XX_TEST_SPLIT ( LEASE_ID, PAYMENT_TRM_ID, LOCATION_ID, START_DATE, END_DATE,

      AMOUNT_PAID, FREQUENCY, LINE_TYPE ) VALUES (

      1268, 100, 1126,  TO_Date( '01/01/2017 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'),  TO_Date( '01/01/2017 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')

      , -7380.08, 'OT', 'RENT');

      INSERT INTO XX_TEST_SPLIT ( LEASE_ID, PAYMENT_TRM_ID, LOCATION_ID, START_DATE, END_DATE,

      AMOUNT_PAID, FREQUENCY, LINE_TYPE ) VALUES (

      1268, 101, 1125,  TO_Date( '01/01/2017 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'),  TO_Date( '01/01/2017 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')

      , -7379.01, 'OT', 'RENT');

      INSERT INTO XX_TEST_SPLIT ( LEASE_ID, PAYMENT_TRM_ID, LOCATION_ID, START_DATE, END_DATE,

      AMOUNT_PAID, FREQUENCY, LINE_TYPE ) VALUES (

      1268, 102, 1127,  TO_Date( '01/01/2017 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'),  TO_Date( '01/01/2017 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')

      , -7349.1, 'OT', 'RENT');

      INSERT INTO XX_TEST_SPLIT ( LEASE_ID, PAYMENT_TRM_ID, LOCATION_ID, START_DATE, END_DATE,

      AMOUNT_PAID, FREQUENCY, LINE_TYPE ) VALUES (

      1268, 103, 1126,  TO_Date( '01/01/2017 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'),  TO_Date( '01/01/2017 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')

      , -2043.72, 'OT', 'SERVICE CHARGE');

      INSERT INTO XX_TEST_SPLIT ( LEASE_ID, PAYMENT_TRM_ID, LOCATION_ID, START_DATE, END_DATE,

      AMOUNT_PAID, FREQUENCY, LINE_TYPE ) VALUES (

      1268, 104, 1125,  TO_Date( '01/01/2017 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'),  TO_Date( '01/01/2017 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')

      , -2043.42, 'OT', 'SERVICE CHARGE');

      INSERT INTO XX_TEST_SPLIT ( LEASE_ID, PAYMENT_TRM_ID, LOCATION_ID, START_DATE, END_DATE,

      AMOUNT_PAID, FREQUENCY, LINE_TYPE ) VALUES (

      1268, 105, 1127,  TO_Date( '01/01/2017 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'),  TO_Date( '01/01/2017 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')

      , -2035.13, 'OT', 'SERVICE CHARGE');

      INSERT INTO XX_TEST_SPLIT ( LEASE_ID, PAYMENT_TRM_ID, LOCATION_ID, START_DATE, END_DATE,

      AMOUNT_PAID, FREQUENCY, LINE_TYPE ) VALUES (

      1268, 106, 1125,  TO_Date( '01/01/2016 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'),  TO_Date( '12/31/2016 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')

      , 2693340, 'YR', 'RENT');

      INSERT INTO XX_TEST_SPLIT ( LEASE_ID, PAYMENT_TRM_ID, LOCATION_ID, START_DATE, END_DATE,

      AMOUNT_PAID, FREQUENCY, LINE_TYPE ) VALUES (

      1268, 107, 1126,  TO_Date( '01/01/2016 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'),  TO_Date( '12/31/2016 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')

      , 2693730, 'YR', 'RENT');

      INSERT INTO XX_TEST_SPLIT ( LEASE_ID, PAYMENT_TRM_ID, LOCATION_ID, START_DATE, END_DATE,

      AMOUNT_PAID, FREQUENCY, LINE_TYPE ) VALUES (

      1268, 108, 1127,  TO_Date( '01/01/2016 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'),  TO_Date( '12/31/2016 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')

      , 2682420, 'YR', 'RENT');

      INSERT INTO XX_TEST_SPLIT ( LEASE_ID, PAYMENT_TRM_ID, LOCATION_ID, START_DATE, END_DATE,

      AMOUNT_PAID, FREQUENCY, LINE_TYPE ) VALUES (

      1268, 109, 1125,  TO_Date( '01/01/2016 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'),  TO_Date( '12/31/2016 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')

      , -8069490, 'YR', 'RENTFREE');

      INSERT INTO XX_TEST_SPLIT ( LEASE_ID, PAYMENT_TRM_ID, LOCATION_ID, START_DATE, END_DATE,

      AMOUNT_PAID, FREQUENCY, LINE_TYPE ) VALUES (

      1268, 110, 1125,  TO_Date( '01/01/2016 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'),  TO_Date( '12/31/2016 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')

      , 745848, 'YR', 'SERVICE CHARGE');

      INSERT INTO XX_TEST_SPLIT ( LEASE_ID, PAYMENT_TRM_ID, LOCATION_ID, START_DATE, END_DATE,

      AMOUNT_PAID, FREQUENCY, LINE_TYPE ) VALUES (

      1268, 111, 1126,  TO_Date( '01/01/2016 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'),  TO_Date( '12/31/2016 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')

      , 745956, 'YR', 'SERVICE CHARGE');

      INSERT INTO XX_TEST_SPLIT ( LEASE_ID, PAYMENT_TRM_ID, LOCATION_ID, START_DATE, END_DATE,

      AMOUNT_PAID, FREQUENCY, LINE_TYPE ) VALUES (

      1268, 112, 1127,  TO_Date( '01/01/2016 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'),  TO_Date( '12/31/2016 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')

      , 742824, 'YR', 'SERVICE CHARGE');

      INSERT INTO XX_TEST_SPLIT ( LEASE_ID, PAYMENT_TRM_ID, LOCATION_ID, START_DATE, END_DATE,

      AMOUNT_PAID, FREQUENCY, LINE_TYPE ) VALUES (

      1268, 113, NULL,  TO_Date( '07/02/2016 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'),  TO_Date( '07/02/2016 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')

      , 24874, 'OT', 'UTILITYC');

      INSERT INTO XX_TEST_SPLIT ( LEASE_ID, PAYMENT_TRM_ID, LOCATION_ID, START_DATE, END_DATE,

      AMOUNT_PAID, FREQUENCY, LINE_TYPE ) VALUES (

      1268, 114, NULL,  TO_Date( '07/26/2016 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'),  TO_Date( '07/26/2016 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')

      , 27864, 'OT', 'UTILITYC');

      INSERT INTO XX_TEST_SPLIT ( LEASE_ID, PAYMENT_TRM_ID, LOCATION_ID, START_DATE, END_DATE,

      AMOUNT_PAID, FREQUENCY, LINE_TYPE ) VALUES (

      1268, 115, NULL,  TO_Date( '11/20/2016 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'),  TO_Date( '11/20/2016 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')

      , 15000, 'OT', 'PARKING');

      INSERT INTO XX_TEST_SPLIT ( LEASE_ID, PAYMENT_TRM_ID, LOCATION_ID, START_DATE, END_DATE,

      AMOUNT_PAID, FREQUENCY, LINE_TYPE ) VALUES (

      1268, 116, NULL,  TO_Date( '12/21/2016 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'),  TO_Date( '12/21/2016 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')

      , 9156.79, 'OT', 'ELEC');

      INSERT INTO XX_TEST_SPLIT ( LEASE_ID, PAYMENT_TRM_ID, LOCATION_ID, START_DATE, END_DATE,

      AMOUNT_PAID, FREQUENCY, LINE_TYPE ) VALUES (

      1268, 117, NULL,  TO_Date( '12/21/2016 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'),  TO_Date( '12/21/2016 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')

      , 27764, 'OT', 'EMPOWER');

      INSERT INTO XX_TEST_SPLIT ( LEASE_ID, PAYMENT_TRM_ID, LOCATION_ID, START_DATE, END_DATE,

      AMOUNT_PAID, FREQUENCY, LINE_TYPE ) VALUES (

      1268, 118, NULL,  TO_Date( '12/21/2016 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'),  TO_Date( '12/21/2016 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')

      , 58929, 'OT', 'EMPOWER');

      INSERT INTO XX_TEST_SPLIT ( LEASE_ID, PAYMENT_TRM_ID, LOCATION_ID, START_DATE, END_DATE,

      AMOUNT_PAID, FREQUENCY, LINE_TYPE ) VALUES (

      1268, 119, 1126,  TO_Date( '04/01/2017 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'),  TO_Date( '03/31/2019 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')

      , 5000, 'YR', 'SUBLSFEE');

      INSERT INTO XX_TEST_SPLIT ( LEASE_ID, PAYMENT_TRM_ID, LOCATION_ID, START_DATE, END_DATE,

      AMOUNT_PAID, FREQUENCY, LINE_TYPE ) VALUES (

      1268, 120, 1125,  TO_Date( '01/01/2017 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'),  TO_Date( '12/31/2017 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')

      , 1346670, 'SA', 'RENT');

      INSERT INTO XX_TEST_SPLIT ( LEASE_ID, PAYMENT_TRM_ID, LOCATION_ID, START_DATE, END_DATE,

      AMOUNT_PAID, FREQUENCY, LINE_TYPE ) VALUES (

      1268, 121, 1126,  TO_Date( '01/01/2017 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'),  TO_Date( '12/31/2017 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')

      , 1346865, 'SA', 'RENT');

      INSERT INTO XX_TEST_SPLIT ( LEASE_ID, PAYMENT_TRM_ID, LOCATION_ID, START_DATE, END_DATE,

      AMOUNT_PAID, FREQUENCY, LINE_TYPE ) VALUES (

      1268, 122, 1127,  TO_Date( '01/01/2017 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'),  TO_Date( '12/31/2017 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')

      , 1341210, 'SA', 'RENT');

      INSERT INTO XX_TEST_SPLIT ( LEASE_ID, PAYMENT_TRM_ID, LOCATION_ID, START_DATE, END_DATE,

      AMOUNT_PAID, FREQUENCY, LINE_TYPE ) VALUES (

      1268, 123, 1125,  TO_Date( '01/01/2018 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'),  TO_Date( '12/31/2019 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')

      , 1414003.5, 'SA', 'RENT');

      INSERT INTO XX_TEST_SPLIT ( LEASE_ID, PAYMENT_TRM_ID, LOCATION_ID, START_DATE, END_DATE,

      AMOUNT_PAID, FREQUENCY, LINE_TYPE ) VALUES (

      1268, 124, 1126,  TO_Date( '01/01/2018 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'),  TO_Date( '12/31/2019 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')

      , 1414208.25, 'SA', 'RENT');

      INSERT INTO XX_TEST_SPLIT ( LEASE_ID, PAYMENT_TRM_ID, LOCATION_ID, START_DATE, END_DATE,

      AMOUNT_PAID, FREQUENCY, LINE_TYPE ) VALUES (

      1268, 125, 1127,  TO_Date( '01/01/2018 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'),  TO_Date( '12/31/2019 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')

      , 1408270.5, 'SA', 'RENT');

      INSERT INTO XX_TEST_SPLIT ( LEASE_ID, PAYMENT_TRM_ID, LOCATION_ID, START_DATE, END_DATE,

      AMOUNT_PAID, FREQUENCY, LINE_TYPE ) VALUES (

      1268, 126, 1125,  TO_Date( '01/01/2020 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'),  TO_Date( '12/31/2021 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')

      , 1484755.47, 'SA', 'RENT');

      INSERT INTO XX_TEST_SPLIT ( LEASE_ID, PAYMENT_TRM_ID, LOCATION_ID, START_DATE, END_DATE,

      AMOUNT_PAID, FREQUENCY, LINE_TYPE ) VALUES (

      1268, 127, 1126,  TO_Date( '01/01/2020 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'),  TO_Date( '12/31/2021 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')

      , 1484970.47, 'SA', 'RENT');

      INSERT INTO XX_TEST_SPLIT ( LEASE_ID, PAYMENT_TRM_ID, LOCATION_ID, START_DATE, END_DATE,

      AMOUNT_PAID, FREQUENCY, LINE_TYPE ) VALUES (

      1268, 128, 1127,  TO_Date( '01/01/2020 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'),  TO_Date( '12/31/2021 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')

      , 1478735.61, 'SA', 'RENT');

      INSERT INTO XX_TEST_SPLIT ( LEASE_ID, PAYMENT_TRM_ID, LOCATION_ID, START_DATE, END_DATE,

      AMOUNT_PAID, FREQUENCY, LINE_TYPE ) VALUES (

      1268, 129, 1125,  TO_Date( '01/01/2022 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'),  TO_Date( '12/31/2023 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')

      , 1559029.5, 'SA', 'RENT');

      INSERT INTO XX_TEST_SPLIT ( LEASE_ID, PAYMENT_TRM_ID, LOCATION_ID, START_DATE, END_DATE,

      AMOUNT_PAID, FREQUENCY, LINE_TYPE ) VALUES (

      1268, 130, 1126,  TO_Date( '01/01/2022 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'),  TO_Date( '12/31/2023 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')

      , 1559255.25, 'SA', 'RENT');

      INSERT INTO XX_TEST_SPLIT ( LEASE_ID, PAYMENT_TRM_ID, LOCATION_ID, START_DATE, END_DATE,

      AMOUNT_PAID, FREQUENCY, LINE_TYPE ) VALUES (

      1268, 131, 1127,  TO_Date( '01/01/2022 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'),  TO_Date( '12/31/2023 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')

      , 1552708.5, 'SA', 'RENT');

      INSERT INTO XX_TEST_SPLIT ( LEASE_ID, PAYMENT_TRM_ID, LOCATION_ID, START_DATE, END_DATE,

      AMOUNT_PAID, FREQUENCY, LINE_TYPE ) VALUES (

      1268, 132, 1125,  TO_Date( '01/01/2024 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'),  TO_Date( '12/31/2024 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')

      , 1637032.77, 'SA', 'RENT');

      INSERT INTO XX_TEST_SPLIT ( LEASE_ID, PAYMENT_TRM_ID, LOCATION_ID, START_DATE, END_DATE,

      AMOUNT_PAID, FREQUENCY, LINE_TYPE ) VALUES (

      1268, 133, 1126,  TO_Date( '01/01/2024 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'),  TO_Date( '12/31/2024 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')

      , 1637269.82, 'SA', 'RENT');

      INSERT INTO XX_TEST_SPLIT ( LEASE_ID, PAYMENT_TRM_ID, LOCATION_ID, START_DATE, END_DATE,

      AMOUNT_PAID, FREQUENCY, LINE_TYPE ) VALUES (

      1268, 134, 1127,  TO_Date( '01/01/2024 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'),  TO_Date( '12/31/2024 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')

      , 1630395.51, 'SA', 'RENT');

      INSERT INTO XX_TEST_SPLIT ( LEASE_ID, PAYMENT_TRM_ID, LOCATION_ID, START_DATE, END_DATE,

      AMOUNT_PAID, FREQUENCY, LINE_TYPE ) VALUES (

      1268, 135, 1125,  TO_Date( '01/01/2017 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'),  TO_Date( '12/31/2024 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')

      , 372924, 'SA', 'SERVICE CHARGE');

      INSERT INTO XX_TEST_SPLIT ( LEASE_ID, PAYMENT_TRM_ID, LOCATION_ID, START_DATE, END_DATE,

      AMOUNT_PAID, FREQUENCY, LINE_TYPE ) VALUES (

      1268, 136, 1126,  TO_Date( '01/01/2017 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'),  TO_Date( '12/31/2024 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')

      , 372978, 'SA', 'SERVICE CHARGE');

      INSERT INTO XX_TEST_SPLIT ( LEASE_ID, PAYMENT_TRM_ID, LOCATION_ID, START_DATE, END_DATE,

      AMOUNT_PAID, FREQUENCY, LINE_TYPE ) VALUES (

      1268, 137, 1127,  TO_Date( '01/01/2017 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'),  TO_Date( '12/31/2024 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')

      , 371412, 'SA', 'SERVICE CHARGE');

      INSERT INTO XX_TEST_SPLIT ( LEASE_ID, PAYMENT_TRM_ID, LOCATION_ID, START_DATE, END_DATE,

      AMOUNT_PAID, FREQUENCY, LINE_TYPE ) VALUES (

      1430, 77037, 1120,  TO_Date( '12/01/2016 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'),  TO_Date( '12/01/2016 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')

      , 195, 'OT', 'EJARI');

      INSERT INTO XX_TEST_SPLIT ( LEASE_ID, PAYMENT_TRM_ID, LOCATION_ID, START_DATE, END_DATE,

      AMOUNT_PAID, FREQUENCY, LINE_TYPE ) VALUES (

      1430, 77038, 1120,  TO_Date( '12/01/2016 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'),  TO_Date( '12/01/2016 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')

      , 49400, 'OT', 'SD');

      INSERT INTO XX_TEST_SPLIT ( LEASE_ID, PAYMENT_TRM_ID, LOCATION_ID, START_DATE, END_DATE,

      AMOUNT_PAID, FREQUENCY, LINE_TYPE ) VALUES (

      1430, 79000, 1120,  TO_Date( '12/01/2016 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'),  TO_Date( '12/31/2016 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')

      , 41166.67, 'MON', 'RENT');

      INSERT INTO XX_TEST_SPLIT ( LEASE_ID, PAYMENT_TRM_ID, LOCATION_ID, START_DATE, END_DATE,

      AMOUNT_PAID, FREQUENCY, LINE_TYPE ) VALUES (

      1430, 79001, 1120,  TO_Date( '12/01/2016 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'),  TO_Date( '12/31/2016 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')

      , -41166.67, 'MON', 'RENTFREE');

      INSERT INTO XX_TEST_SPLIT ( LEASE_ID, PAYMENT_TRM_ID, LOCATION_ID, START_DATE, END_DATE,

      AMOUNT_PAID, FREQUENCY, LINE_TYPE ) VALUES (

      1430, 79002, 1120,  TO_Date( '12/01/2016 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'),  TO_Date( '12/31/2016 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')

      , 11400, 'MON', 'SERVICE CHARGE');

      INSERT INTO XX_TEST_SPLIT ( LEASE_ID, PAYMENT_TRM_ID, LOCATION_ID, START_DATE, END_DATE,

      AMOUNT_PAID, FREQUENCY, LINE_TYPE ) VALUES (

      1430, 79003, 1120,  TO_Date( '01/01/2017 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'),  TO_Date( '06/30/2017 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')

      , 247000, 'SA', 'RENT');

      INSERT INTO XX_TEST_SPLIT ( LEASE_ID, PAYMENT_TRM_ID, LOCATION_ID, START_DATE, END_DATE,

      AMOUNT_PAID, FREQUENCY, LINE_TYPE ) VALUES (

      1430, 79004, 1120,  TO_Date( '01/01/2017 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'),  TO_Date( '06/30/2017 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')

      , -247000, 'SA', 'RENTFREE');

      INSERT INTO XX_TEST_SPLIT ( LEASE_ID, PAYMENT_TRM_ID, LOCATION_ID, START_DATE, END_DATE,

      AMOUNT_PAID, FREQUENCY, LINE_TYPE ) VALUES (

      1430, 79005, 1120,  TO_Date( '01/01/2017 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'),  TO_Date( '12/31/2024 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')

      , 68400, 'SA', 'SERVICE CHARGE');

      INSERT INTO XX_TEST_SPLIT ( LEASE_ID, PAYMENT_TRM_ID, LOCATION_ID, START_DATE, END_DATE,

      AMOUNT_PAID, FREQUENCY, LINE_TYPE ) VALUES (

      1430, 79006, 1120,  TO_Date( '07/01/2017 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'),  TO_Date( '07/01/2017 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')

      , 205833.33, 'OT', 'RENT');

      INSERT INTO XX_TEST_SPLIT ( LEASE_ID, PAYMENT_TRM_ID, LOCATION_ID, START_DATE, END_DATE,

      AMOUNT_PAID, FREQUENCY, LINE_TYPE ) VALUES (

      1430, 79007, 1120,  TO_Date( '07/01/2017 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'),  TO_Date( '07/01/2017 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')

      , -205833.33, 'OT', 'RENTFREE');

      INSERT INTO XX_TEST_SPLIT ( LEASE_ID, PAYMENT_TRM_ID, LOCATION_ID, START_DATE, END_DATE,

      AMOUNT_PAID, FREQUENCY, LINE_TYPE ) VALUES (

      1430, 79008, 1120,  TO_Date( '12/01/2017 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'),  TO_Date( '12/31/2017 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')

      , 41166.67, 'MON', 'RENT');

      INSERT INTO XX_TEST_SPLIT ( LEASE_ID, PAYMENT_TRM_ID, LOCATION_ID, START_DATE, END_DATE,

      AMOUNT_PAID, FREQUENCY, LINE_TYPE ) VALUES (

      1430, 79009, 1120,  TO_Date( '01/01/2018 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'),  TO_Date( '12/31/2019 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')

      , 259350, 'SA', 'RENT');

      INSERT INTO XX_TEST_SPLIT ( LEASE_ID, PAYMENT_TRM_ID, LOCATION_ID, START_DATE, END_DATE,

      AMOUNT_PAID, FREQUENCY, LINE_TYPE ) VALUES (

      1430, 79010, 1120,  TO_Date( '01/01/2020 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'),  TO_Date( '12/31/2021 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')

      , 272327, 'SA', 'RENT');

      INSERT INTO XX_TEST_SPLIT ( LEASE_ID, PAYMENT_TRM_ID, LOCATION_ID, START_DATE, END_DATE,

      AMOUNT_PAID, FREQUENCY, LINE_TYPE ) VALUES (

      1430, 79011, 1120,  TO_Date( '01/01/2022 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'),  TO_Date( '12/31/2023 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')

      , 285950, 'SA', 'RENT');

      INSERT INTO XX_TEST_SPLIT ( LEASE_ID, PAYMENT_TRM_ID, LOCATION_ID, START_DATE, END_DATE,

      AMOUNT_PAID, FREQUENCY, LINE_TYPE ) VALUES (

      1430, 79012, 1120,  TO_Date( '01/01/2024 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'),  TO_Date( '12/31/2024 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')

      , 300257, 'SA', 'RENT');

      INSERT INTO XX_TEST_SPLIT ( LEASE_ID, PAYMENT_TRM_ID, LOCATION_ID, START_DATE, END_DATE,

      AMOUNT_PAID, FREQUENCY, LINE_TYPE ) VALUES (

      1430, 118015, 1120,  TO_Date( '01/31/2017 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')

      ,  TO_Date( '01/31/2017 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 11400, 'OT', 'FITOUTREV');

      commit;