INSERT ALL
INTO NDS_APPLICATION (ID, "NAME", APPID, CREATED, CREATEDBY) VALUES (400, 'CDSN3-DEV0', 'CDSN3-DEV0', CURRENT_TIMESTAMP, 'admin')
INTO NDS_APPLICATION (ID, "NAME", APPID, CREATED, CREATEDBY) VALUES (401, 'CDSN3-DEV1', 'CDSN3-DEV1', CURRENT_TIMESTAMP, 'admin')
INTO NDS_APPLICATION (ID, "NAME", APPID, CREATED, CREATEDBY) VALUES (402, 'CDSN3-DEV2', 'CDSN3-DEV2', CURRENT_TIMESTAMP, 'admin')
INTO NDS_APPLICATION (ID, "NAME", APPID, CREATED, CREATEDBY) VALUES (403, 'CDSN3-DEV3', 'CDSN3-DEV3', CURRENT_TIMESTAMP, 'admin')
INTO NDS_APPLICATION (ID, "NAME", APPID, CREATED, CREATEDBY) VALUES (404, 'CDSN3-DEV4', 'CDSN3-DEV4', CURRENT_TIMESTAMP, 'admin')
INTO NDS_APPLICATION (ID, "NAME", APPID, CREATED, CREATEDBY) VALUES (405, 'CDSN3-DEV5', 'CDSN3-DEV5', CURRENT_TIMESTAMP, 'admin')
INTO NDS_APPLICATION (ID, "NAME", APPID, CREATED, CREATEDBY) VALUES (406, 'CDSN3-DEV6', 'CDSN3-DEV6', CURRENT_TIMESTAMP, 'admin')
INTO NDS_APPLICATION (ID, "NAME", APPID, CREATED, CREATEDBY) VALUES (407, 'CDSN3-DEV7', 'CDSN3-DEV7', CURRENT_TIMESTAMP, 'admin')
INTO NDS_APPLICATION (ID, "NAME", APPID, CREATED, CREATEDBY) VALUES (408, 'CDSN3-DEV8', 'CDSN3-DEV8', CURRENT_TIMESTAMP, 'admin')
INTO NDS_APPLICATION (ID, "NAME", APPID, CREATED, CREATEDBY) VALUES (409, 'CDSN3-DEV9', 'CDSN3-DEV9', CURRENT_TIMESTAMP, 'admin')
SELECT * FROM dual;

INSERT ALL
INTO NDS_INFRAENDPOINT (ID, SERVICEENDPOINT_ID, DESCRIPTION, SERVICESTATE_ID, PROTOCOL, SERVERADDRESS, PORT, SERVICEPATH, CREATED, CREATEDBY)
    VALUES (530, 7, 'CDSN3-DEV0 - CDS Java SOAP', 1, 'http', 'IP         ', 8201, 'cds-wsclient/cds-service', CURRENT_TIMESTAMP, 'admin')
INTO NDS_INFRAENDPOINT (ID, SERVICEENDPOINT_ID, DESCRIPTION, SERVICESTATE_ID, PROTOCOL, SERVERADDRESS, PORT, SERVICEPATH, CREATED, CREATEDBY)
    VALUES (531, 7, 'CDSN3-DEV1 - CDS Java SOAP', 1, 'http', 'IP         ', 8206, 'cds-wsclient/cds-service', CURRENT_TIMESTAMP, 'admin')
INTO NDS_INFRAENDPOINT (ID, SERVICEENDPOINT_ID, DESCRIPTION, SERVICESTATE_ID, PROTOCOL, SERVERADDRESS, PORT, SERVICEPATH, CREATED, CREATEDBY)
    VALUES (532, 7, 'CDSN3-DEV2 - CDS Java SOAP', 1, 'http', 'IP         ', 8211, 'cds-wsclient/cds-service', CURRENT_TIMESTAMP, 'admin')
INTO NDS_INFRAENDPOINT (ID, SERVICEENDPOINT_ID, DESCRIPTION, SERVICESTATE_ID, PROTOCOL, SERVERADDRESS, PORT, SERVICEPATH, CREATED, CREATEDBY)
    VALUES (533, 7, 'CDSN3-DEV3 - CDS Java SOAP', 1, 'http', 'IP         ', 8216, 'cds-wsclient/cds-service', CURRENT_TIMESTAMP, 'admin')
INTO NDS_INFRAENDPOINT (ID, SERVICEENDPOINT_ID, DESCRIPTION, SERVICESTATE_ID, PROTOCOL, SERVERADDRESS, PORT, SERVICEPATH, CREATED, CREATEDBY)
    VALUES (534, 7, 'CDSN3-DEV4 - CDS Java SOAP', 1, 'http', 'IP         ', 8201, 'cds-wsclient/cds-service', CURRENT_TIMESTAMP, 'admin')
INTO NDS_INFRAENDPOINT (ID, SERVICEENDPOINT_ID, DESCRIPTION, SERVICESTATE_ID, PROTOCOL, SERVERADDRESS, PORT, SERVICEPATH, CREATED, CREATEDBY)
    VALUES (535, 7, 'CDSN3-DEV5 - CDS Java SOAP', 1, 'http', 'IP         ', 8206, 'cds-wsclient/cds-service', CURRENT_TIMESTAMP, 'admin')
INTO NDS_INFRAENDPOINT (ID, SERVICEENDPOINT_ID, DESCRIPTION, SERVICESTATE_ID, PROTOCOL, SERVERADDRESS, PORT, SERVICEPATH, CREATED, CREATEDBY)
    VALUES (536, 7, 'CDSN3-DEV6 - CDS Java SOAP', 1, 'http', 'IP         ', 8211, 'cds-wsclient/cds-service', CURRENT_TIMESTAMP, 'admin')
INTO NDS_INFRAENDPOINT (ID, SERVICEENDPOINT_ID, DESCRIPTION, SERVICESTATE_ID, PROTOCOL, SERVERADDRESS, PORT, SERVICEPATH, CREATED, CREATEDBY)
    VALUES (537, 7, 'CDSN3-DEV7 - CDS Java SOAP', 1, 'http', 'IP         ', 8216, 'cds-wsclient/cds-service', CURRENT_TIMESTAMP, 'admin')
INTO NDS_INFRAENDPOINT (ID, SERVICEENDPOINT_ID, DESCRIPTION, SERVICESTATE_ID, PROTOCOL, SERVERADDRESS, PORT, SERVICEPATH, CREATED, CREATEDBY)
    VALUES (538, 7, 'CDSN3-DEV8 - CDS Java SOAP', 1, 'http', 'IP         ', 8201, 'cds-wsclient/cds-service', CURRENT_TIMESTAMP, 'admin')
INTO NDS_INFRAENDPOINT (ID, SERVICEENDPOINT_ID, DESCRIPTION, SERVICESTATE_ID, PROTOCOL, SERVERADDRESS, PORT, SERVICEPATH, CREATED, CREATEDBY)
    VALUES (539, 7, 'CDSN3-DEV9 - CDS Java SOAP', 1, 'http', 'IP         ', 8206, 'cds-wsclient/cds-service', CURRENT_TIMESTAMP, 'admin')
SELECT * FROM dual;

INSERT ALL
INTO NDS_SITEAPPDEPLOYMENT (ID, SITE_ID, APPLICATION_ID, INFRAENDPOINT_ID, PRIORITY, CREATED, CREATEDBY) VALUES (600, 2, 400, 530, 1, CURRENT_TIMESTAMP, 'admin')
INTO NDS_SITEAPPDEPLOYMENT (ID, SITE_ID, APPLICATION_ID, INFRAENDPOINT_ID, PRIORITY, CREATED, CREATEDBY) VALUES (601, 2, 401, 531, 1, CURRENT_TIMESTAMP, 'admin')
INTO NDS_SITEAPPDEPLOYMENT (ID, SITE_ID, APPLICATION_ID, INFRAENDPOINT_ID, PRIORITY, CREATED, CREATEDBY) VALUES (602, 2, 402, 532, 1, CURRENT_TIMESTAMP, 'admin')
INTO NDS_SITEAPPDEPLOYMENT (ID, SITE_ID, APPLICATION_ID, INFRAENDPOINT_ID, PRIORITY, CREATED, CREATEDBY) VALUES (603, 2, 403, 533, 1, CURRENT_TIMESTAMP, 'admin')
INTO NDS_SITEAPPDEPLOYMENT (ID, SITE_ID, APPLICATION_ID, INFRAENDPOINT_ID, PRIORITY, CREATED, CREATEDBY) VALUES (604, 2, 404, 534, 1, CURRENT_TIMESTAMP, 'admin')
INTO NDS_SITEAPPDEPLOYMENT (ID, SITE_ID, APPLICATION_ID, INFRAENDPOINT_ID, PRIORITY, CREATED, CREATEDBY) VALUES (605, 2, 405, 535, 1, CURRENT_TIMESTAMP, 'admin')
INTO NDS_SITEAPPDEPLOYMENT (ID, SITE_ID, APPLICATION_ID, INFRAENDPOINT_ID, PRIORITY, CREATED, CREATEDBY) VALUES (606, 2, 406, 536, 1, CURRENT_TIMESTAMP, 'admin')
INTO NDS_SITEAPPDEPLOYMENT (ID, SITE_ID, APPLICATION_ID, INFRAENDPOINT_ID, PRIORITY, CREATED, CREATEDBY) VALUES (607, 2, 407, 537, 1, CURRENT_TIMESTAMP, 'admin')
INTO NDS_SITEAPPDEPLOYMENT (ID, SITE_ID, APPLICATION_ID, INFRAENDPOINT_ID, PRIORITY, CREATED, CREATEDBY) VALUES (608, 2, 408, 538, 1, CURRENT_TIMESTAMP, 'admin')
INTO NDS_SITEAPPDEPLOYMENT (ID, SITE_ID, APPLICATION_ID, INFRAENDPOINT_ID, PRIORITY, CREATED, CREATEDBY) VALUES (609, 2, 409, 539, 1, CURRENT_TIMESTAMP, 'admin')
SELECT * FROM dual;


INSERT ALL
INTO NDS_INFRAENDPOINT (ID, SERVICEENDPOINT_ID, DESCRIPTION, SERVICESTATE_ID, PROTOCOL, SERVERADDRESS, PORT, CREATED, CREATEDBY)
    VALUES (540, 6, 'CDSN3-DEV0 - CDS Remote EJB', 1, 't3', 'IP         ', 8201, CURRENT_TIMESTAMP, 'admin')
INTO NDS_INFRAENDPOINT (ID, SERVICEENDPOINT_ID, DESCRIPTION, SERVICESTATE_ID, PROTOCOL, SERVERADDRESS, PORT, CREATED, CREATEDBY)
    VALUES (541, 6, 'CDSN3-DEV1 - CDS Remote EJB', 1, 't3', 'IP         ', 8206, CURRENT_TIMESTAMP, 'admin')
INTO NDS_INFRAENDPOINT (ID, SERVICEENDPOINT_ID, DESCRIPTION, SERVICESTATE_ID, PROTOCOL, SERVERADDRESS, PORT, CREATED, CREATEDBY)
    VALUES (542, 6, 'CDSN3-DEV2 - CDS Remote EJB', 1, 't3', 'IP         ', 8211, CURRENT_TIMESTAMP, 'admin')
INTO NDS_INFRAENDPOINT (ID, SERVICEENDPOINT_ID, DESCRIPTION, SERVICESTATE_ID, PROTOCOL, SERVERADDRESS, PORT, CREATED, CREATEDBY)
    VALUES (543, 6, 'CDSN3-DEV3 - CDS Remote EJB', 1, 't3', 'IP         ', 8216, CURRENT_TIMESTAMP, 'admin')
INTO NDS_INFRAENDPOINT (ID, SERVICEENDPOINT_ID, DESCRIPTION, SERVICESTATE_ID, PROTOCOL, SERVERADDRESS, PORT, CREATED, CREATEDBY)
    VALUES (544, 6, 'CDSN3-DEV4 - CDS Remote EJB', 1, 't3', 'IP         ', 8201, CURRENT_TIMESTAMP, 'admin')
INTO NDS_INFRAENDPOINT (ID, SERVICEENDPOINT_ID, DESCRIPTION, SERVICESTATE_ID, PROTOCOL, SERVERADDRESS, PORT, CREATED, CREATEDBY)
    VALUES (545, 6, 'CDSN3-DEV5 - CDS Remote EJB', 1, 't3', 'IP         ', 8206, CURRENT_TIMESTAMP, 'admin')
INTO NDS_INFRAENDPOINT (ID, SERVICEENDPOINT_ID, DESCRIPTION, SERVICESTATE_ID, PROTOCOL, SERVERADDRESS, PORT, CREATED, CREATEDBY)
    VALUES (546, 6, 'CDSN3-DEV6 - CDS Remote EJB', 1, 't3', 'IP         ', 8211, CURRENT_TIMESTAMP, 'admin')
INTO NDS_INFRAENDPOINT (ID, SERVICEENDPOINT_ID, DESCRIPTION, SERVICESTATE_ID, PROTOCOL, SERVERADDRESS, PORT, CREATED, CREATEDBY)
    VALUES (547, 6, 'CDSN3-DEV7 - CDS Remote EJB', 1, 't3', 'IP         ', 8216, CURRENT_TIMESTAMP, 'admin')
INTO NDS_INFRAENDPOINT (ID, SERVICEENDPOINT_ID, DESCRIPTION, SERVICESTATE_ID, PROTOCOL, SERVERADDRESS, PORT, CREATED, CREATEDBY)
    VALUES (548, 6, 'CDSN3-DEV8 - CDS Remote EJB', 1, 't3', 'IP         ', 8201, CURRENT_TIMESTAMP, 'admin')
INTO NDS_INFRAENDPOINT (ID, SERVICEENDPOINT_ID, DESCRIPTION, SERVICESTATE_ID, PROTOCOL, SERVERADDRESS, PORT, CREATED, CREATEDBY)
    VALUES (549, 6, 'CDSN3-DEV9 - CDS Remote EJB', 1, 't3', 'IP         ', 8206, CURRENT_TIMESTAMP, 'admin')
SELECT * FROM dual;

INSERT ALL
INTO NDS_SITEAPPDEPLOYMENT (ID, SITE_ID, APPLICATION_ID, INFRAENDPOINT_ID, PRIORITY, CREATED, CREATEDBY) VALUES (610, 2, 400, 540, 1, CURRENT_TIMESTAMP, 'admin')
INTO NDS_SITEAPPDEPLOYMENT (ID, SITE_ID, APPLICATION_ID, INFRAENDPOINT_ID, PRIORITY, CREATED, CREATEDBY) VALUES (611, 2, 401, 541, 1, CURRENT_TIMESTAMP, 'admin')
INTO NDS_SITEAPPDEPLOYMENT (ID, SITE_ID, APPLICATION_ID, INFRAENDPOINT_ID, PRIORITY, CREATED, CREATEDBY) VALUES (612, 2, 402, 542, 1, CURRENT_TIMESTAMP, 'admin')
INTO NDS_SITEAPPDEPLOYMENT (ID, SITE_ID, APPLICATION_ID, INFRAENDPOINT_ID, PRIORITY, CREATED, CREATEDBY) VALUES (613, 2, 403, 543, 1, CURRENT_TIMESTAMP, 'admin')
INTO NDS_SITEAPPDEPLOYMENT (ID, SITE_ID, APPLICATION_ID, INFRAENDPOINT_ID, PRIORITY, CREATED, CREATEDBY) VALUES (614, 2, 404, 544, 1, CURRENT_TIMESTAMP, 'admin')
INTO NDS_SITEAPPDEPLOYMENT (ID, SITE_ID, APPLICATION_ID, INFRAENDPOINT_ID, PRIORITY, CREATED, CREATEDBY) VALUES (615, 2, 405, 545, 1, CURRENT_TIMESTAMP, 'admin')
INTO NDS_SITEAPPDEPLOYMENT (ID, SITE_ID, APPLICATION_ID, INFRAENDPOINT_ID, PRIORITY, CREATED, CREATEDBY) VALUES (616, 2, 406, 546, 1, CURRENT_TIMESTAMP, 'admin')
INTO NDS_SITEAPPDEPLOYMENT (ID, SITE_ID, APPLICATION_ID, INFRAENDPOINT_ID, PRIORITY, CREATED, CREATEDBY) VALUES (617, 2, 407, 547, 1, CURRENT_TIMESTAMP, 'admin')
INTO NDS_SITEAPPDEPLOYMENT (ID, SITE_ID, APPLICATION_ID, INFRAENDPOINT_ID, PRIORITY, CREATED, CREATEDBY) VALUES (618, 2, 408, 548, 1, CURRENT_TIMESTAMP, 'admin')
INTO NDS_SITEAPPDEPLOYMENT (ID, SITE_ID, APPLICATION_ID, INFRAENDPOINT_ID, PRIORITY, CREATED, CREATEDBY) VALUES (619, 2, 409, 549, 1, CURRENT_TIMESTAMP, 'admin')
SELECT * FROM dual;


COMMIT;