SELECT 'Full Import on Terminal' move_code, eqpa_container_type, Count(eqpa_container) cont, SUM(Nvl(Decode(eqpa_container_size, '20', 1, '40', 2), 0)) teus FROM mtu_2009.id_equipment_all_moves WHERE eqpa_company = 'MTU' AND eqpa_move_date BETWEEN '01-JAN-2009' AND '23-SEP-2012' AND eqpa_move_code = 'DSFULL' AND ( eqpa_company, eqpa_container, eqpa_serial_no ) IN (SELECT a.eqpa_company, a.eqpa_container, Max(a.eqpa_serial_no) FROM mtu_2009.iv_equipment_all_moves_gv a, mtu_2009.id_equipment_control WHERE a.eqpa_company = 'MTU' AND a.eqpa_company = eqip_company AND a.eqpa_container = eqpa_container AND a.eqpa_container_type = eqpa_container_type AND a.eqpa_move_date <= SYSDATE AND eqpa_soc = 'L' GROUP BY a.eqpa_company, a.eqpa_container) GROUP BY eqpa_container_type CREATE TABLE id_equipment_all_moves ( eqpa_company VARCHAR2(10) NOT NULL, eqpa_container VARCHAR2(15) NOT NULL, eqpa_serial_no NUMBER NOT NULL, eqpa_move_date DATE NOT NULL, eqpa_move_code VARCHAR2(10) NOT NULL, eqpa_service_type VARCHAR2(10) NOT NULL, eqpa_container_service_type VARCHAR2(10), eqpa_container_type VARCHAR2(10) NOT NULL, eqpa_container_size VARCHAR2(2) NOT NULL, eqpa_container_storage VARCHAR2(10) NOT NULL, eqpa_mode VARCHAR2(1) DEFAULT 'S' NOT NULL, eqpa_current_location VARCHAR2(5) NOT NULL, eqpa_current_status VARCHAR2(1) DEFAULT 'C' NOT NULL, eqpa_gross_weight NUMBER DEFAULT 0 NOT NULL, eqpa_tare_weight NUMBER DEFAULT 0 NOT NULL, eqpa_net_weight NUMBER DEFAULT 0 NOT NULL, eqpa_cargo_weight NUMBER DEFAULT 0 NOT NULL, eqpa_days NUMBER DEFAULT 0 NOT NULL, eqpa_created_by VARCHAR2(10) NOT NULL, eqpa_created_on DATE DEFAULT sysdate NOT NULL, eqpa_modified_by VARCHAR2(10), eqpa_modified_on DATE, eqpa_line VARCHAR2(10), eqpa_vessel VARCHAR2(10), eqpa_voyage VARCHAR2(10), eqpa_port VARCHAR2(5), eqpa_mother_line VARCHAR2(10), eqpa_mother_vessel VARCHAR2(10), eqpa_mother_voyage VARCHAR2(10), eqpa_mother_port VARCHAR2(5), eqpa_origin_port VARCHAR2(5), eqpa_origin_name VARCHAR2(50), eqpa_from_port VARCHAR2(5), eqpa_to_port VARCHAR2(5), eqpa_final_port VARCHAR2(5), eqpa_final_name VARCHAR2(50), eqpa_truck_number VARCHAR2(25), eqpa_transporter VARCHAR2(50), eqpa_customer VARCHAR2(10), eqpa_seal_number VARCHAR2(25), eqpa_bill_no VARCHAR2(50), eqpa_bl_number VARCHAR2(25), eqpa_do_number VARCHAR2(25), eqpa_remarks VARCHAR2(240), eqpa_out_gauge VARCHAR2(1) DEFAULT 'N', eqpa_out_height NUMBER, eqpa_out_width NUMBER, eqpa_out_length NUMBER, eqpa_reefer_status VARCHAR2(1) DEFAULT 'N', eqpa_min_temprature NUMBER, eqpa_max_temprature NUMBER, eqpa_imco_status VARCHAR2(1) DEFAULT 'N', eqpa_imco_unno VARCHAR2(10), eqpa_imco_class VARCHAR2(10), eqpa_imco_page VARCHAR2(10), eqpa_imco_flash VARCHAR2(10), eqpa_food_status VARCHAR2(1) DEFAULT 'N', eqpa_food_description VARCHAR2(240), eqpa_booking_type VARCHAR2(10), eqpa_booking_number VARCHAR2(25), eqpa_job_type VARCHAR2(10), eqpa_job_number VARCHAR2(25), eqpa_job_basis VARCHAR2(50), eqpa_amount NUMBER DEFAULT 0, eqpa_train_number VARCHAR2(25), eqpa_train_reference VARCHAR2(50), eqpa_account_status VARCHAR2(1) DEFAULT 'X', eqpa_booking_status VARCHAR2(1) DEFAULT 'X', eqpa_billing_status VARCHAR2(1) DEFAULT 'X', eqpa_flex_1 VARCHAR2(240), eqpa_flex_2 VARCHAR2(240), eqpa_flex_3 VARCHAR2(240), eqpa_flex_4 VARCHAR2(240), eqpa_flex_5 VARCHAR2(240) DEFAULT 'N', eqpa_entry_type VARCHAR2(1) DEFAULT 'D' NOT NULL, eqpa_stowage VARCHAR2(10), eqpa_commodity VARCHAR2(10), eqpa_sequence NUMBER, eqpa_soc VARCHAR2(1) DEFAULT 'L', eqpa_voyage_service VARCHAR2(10), eqpa_tsp_port_1 VARCHAR2(5), eqpa_tsp_port_2 VARCHAR2(5), eqpa_tsp_port_3 VARCHAR2(5), eqpa_lease_number VARCHAR2(25), eqpa_lease_type VARCHAR2(10), eqpa_out_width_left NUMBER, eqpa_out_width_right NUMBER, eqpa_out_length_fore NUMBER, eqpa_out_length_back NUMBER, eqpa_ccm_gen_status VARCHAR2(1) DEFAULT 'N' NOT NULL, eqpa_ccm_file_name VARCHAR2(50), eqpa_ccm_on DATE, eqpa_tsp_status VARCHAR2(1) DEFAULT 'N', eqpa_batch VARCHAR2(25), eqpa_filter_0 VARCHAR2(240), eqpa_filter_1 VARCHAR2(240), eqpa_filter_2 VARCHAR2(240), eqpa_filter_3 VARCHAR2(240), eqpa_filter_4 VARCHAR2(240), eqpa_filter_5 VARCHAR2(240), eqpa_filter_6 VARCHAR2(240), eqpa_filter_7 VARCHAR2(240), eqpa_filter_8 VARCHAR2(240), eqpa_filter_9 VARCHAR2(240), eqpa_commission_status VARCHAR2(1) DEFAULT 'N', eqpa_slot_operator VARCHAR2(10), eqpa_terminal VARCHAR2(10), eqpa_haulage VARCHAR2(1), eqpa_from_sub_location VARCHAR2(10), eqpa_to_sub_location VARCHAR2(10), eqpa_barge_voyage VARCHAR2(10), eqpa_barge_name VARCHAR2(100), eqpa_current_loc_depot VARCHAR2(10), eqpa_quality_status VARCHAR2(1), eqpa_dest_location VARCHAR2(10), eqpa_dest_depot VARCHAR2(10), eqpa_demage_reason VARCHAR2(2000), eqpa_demage_remarks VARCHAR2(2000), eqpa_repair_reference VARCHAR2(240), eqpa_invoice_to VARCHAR2(10), eqpa_tsp_port_4 VARCHAR2(10), eqpa_tsp_port_5 VARCHAR2(10), eqpa_reefer_temp_basis VARCHAR2(1), eqpa_orgin_depot VARCHAR2(10), eqpa_orgin_location VARCHAR2(10), eqpa_origin_loc_name VARCHAR2(100), eqpa_orgin_zip VARCHAR2(50), eqpa_dest_loc_name VARCHAR2(100), eqpa_dest_loc_zip VARCHAR2(50), eqpa_feeder_voyage VARCHAR2(10), eqpa_feeder_vessel VARCHAR2(10), eqpa_dest_terminal VARCHAR2(10), eqpa_scac_code VARCHAR2(10), eqpa_pre_booking_number VARCHAR2(25), eqpa_lod_dis_lot_number NUMBER, eqpa_line_reference VARCHAR2(240), eqpa_other_reference VARCHAR2(240), eqpa_contract_no VARCHAR2(240), eqpa_dest_type VARCHAR2(1), eqpa_to_loc VARCHAR2(5), eqpa_to_loc_name VARCHAR2(75), eqpa_program_id VARCHAR2(50), eqpa_seal_type_1 VARCHAR2(1) DEFAULT 'N', eqpa_seal_type_2 VARCHAR2(1) DEFAULT 'N', eqpa_seal_type_3 VARCHAR2(1) DEFAULT 'N', eqpa_seal_number_2 VARCHAR2(25), eqpa_seal_number_3 VARCHAR2(25), eqpa_flex_6 VARCHAR2(240), eqpa_flex_7 VARCHAR2(240), eqpa_flex_8 VARCHAR2(240), eqpa_flex_9 VARCHAR2(240), eqpa_flex_10 VARCHAR2(240), eqpa_iso_code VARCHAR2(10), eqpa_pay_load NUMBER, eqpa_local_gen_status VARCHAR2(1), eqpa_local_file_on DATE, eqpa_local_file_name VARCHAR2(50), eqpa_cont_dep_doc_type VARCHAR2(10), eqpa_cont_dep_doc_number VARCHAR2(50), eqpa_seal_type VARCHAR2(1), eqpa_open_bal_remarks VARCHAR2(2000), eqpa_tsp_comm VARCHAR2(1) ) -- Indexes for ID_EQUIPMENT_ALL_MOVES ----------------- INDEX ------------------ CREATE INDEX cont_edi_idx ON id_equipment_all_moves (eqpa_company, eqpa_line, eqpa_ccm_gen_status) PCTFREE 10 INITRANS 2 MAXTRANS 255 / CREATE INDEX eqpa_bill_idx ON id_equipment_all_moves (eqpa_company, eqpa_bill_no, eqpa_move_code) PCTFREE 10 INITRANS 2 MAXTRANS 255 / CREATE INDEX eqpa_cont_status ON id_equipment_all_moves (eqpa_company, eqpa_container, eqpa_current_status) PCTFREE 10 INITRANS 2 MAXTRANS 255 / CREATE INDEX eqpa_created_date_key ON id_equipment_all_moves (eqpa_company, eqpa_created_on) PCTFREE 10 INITRANS 2 MAXTRANS 255 / CREATE INDEX eqpa_current_cont_move_dt ON id_equipment_all_moves (eqpa_company, eqpa_current_status, eqpa_container, eqpa_move_date, eqpa_move_code, eqpa_current_location) PCTFREE 10 INITRANS 2 MAXTRANS 255 / CREATE INDEX eqpa_current_status ON id_equipment_all_moves (eqpa_company, eqpa_current_status) PCTFREE 10 INITRANS 2 MAXTRANS 255 / CREATE INDEX eqpa_line_key ON id_equipment_all_moves (eqpa_company, eqpa_line, eqpa_vessel, eqpa_voyage, eqpa_port) PCTFREE 10 INITRANS 2 MAXTRANS 255 / CREATE INDEX eqpa_move_date_idx ON id_equipment_all_moves (eqpa_company, eqpa_move_date) PCTFREE 10 INITRANS 2 MAXTRANS 255 / CREATE INDEX equipment_all_moves_ind ON id_equipment_all_moves (eqpa_company, eqpa_customer) PCTFREE 10 INITRANS 2 MAXTRANS 255 / CREATE UNIQUE INDEX equipment_unique_key ON id_equipment_all_moves (eqpa_company, eqpa_container, eqpa_move_date, eqpa_move_code) PCTFREE 10 INITRANS 2 MAXTRANS 255 / CREATE INDEX euipment_all_moves_ind ON id_equipment_all_moves (eqpa_container_type) PCTFREE 10 INITRANS 2 MAXTRANS 255 / CREATE INDEX euipment_all_moves_ind2 ON id_equipment_all_moves (eqpa_container_service_type) PCTFREE 10 INITRANS 2 MAXTRANS 255 / CREATE INDEX euipment_all_moves_ind3 ON id_equipment_all_moves (eqpa_line) PCTFREE 10 INITRANS 2 MAXTRANS 255 / CREATE INDEX euipment_all_moves_ind4 ON id_equipment_all_moves (eqpa_vessel) PCTFREE 10 INITRANS 2 MAXTRANS 255 / CREATE INDEX euipment_all_moves_ind5 ON id_equipment_all_moves (eqpa_move_code) PCTFREE 10 INITRANS 2 MAXTRANS 255 / CREATE INDEX fsa_eqc_dem_idx ON id_equipment_all_moves (eqpa_company, eqpa_line, eqpa_current_location, eqpa_move_code, eqpa_move_date, eqpa_bl_number) PCTFREE 10 INITRANS 2 MAXTRANS 255 / ----------------------------------------------------------------------- CREATE OR REPLACE VIEW iv_equipment_all_moves_gv ( eqpa_company, eqpa_container, eqpa_serial_no, eqpa_move_date, eqpa_move_code, eqpa_service_type, eqpa_container_service_type, eqpa_container_type, eqpa_container_size, eqpa_container_storage, eqpa_mode, eqpa_current_location, eqpa_current_status, eqpa_gross_weight, eqpa_tare_weight, eqpa_net_weight, eqpa_cargo_weight, eqpa_days, eqpa_created_by, eqpa_created_on, eqpa_modified_by, eqpa_modified_on, eqpa_line, eqpa_vessel, eqpa_voyage, eqpa_port, eqpa_mother_line, eqpa_mother_vessel, eqpa_mother_voyage, eqpa_mother_port, eqpa_origin_port, eqpa_origin_name, eqpa_from_port, eqpa_to_port, eqpa_final_port, eqpa_final_name, eqpa_truck_number, eqpa_transporter, eqpa_customer, eqpa_seal_number, eqpa_bill_no, eqpa_bl_number, eqpa_do_number, eqpa_remarks, eqpa_out_gauge, eqpa_out_height, eqpa_out_width, eqpa_out_length, eqpa_reefer_status, eqpa_min_temprature, eqpa_max_temprature, eqpa_imco_status, eqpa_imco_unno, eqpa_imco_class, eqpa_imco_page, eqpa_imco_flash, eqpa_food_status, eqpa_food_description, eqpa_booking_type, eqpa_booking_number, eqpa_job_type, eqpa_job_number, eqpa_job_basis, eqpa_amount, eqpa_train_number, eqpa_train_reference, eqpa_account_status, eqpa_booking_status, eqpa_billing_status, eqpa_flex_1, eqpa_flex_2, eqpa_flex_3, eqpa_flex_4, eqpa_flex_5, eqpa_entry_type, eqpa_stowage, eqpa_commodity, eqpa_sequence, eqpa_soc, eqpa_voyage_service, eqpa_tsp_port_1, eqpa_tsp_port_2, eqpa_tsp_port_3, eqpa_lease_number, eqpa_lease_type, eqpa_out_width_left, eqpa_out_width_right, eqpa_out_length_fore, eqpa_out_length_back, eqpa_ccm_gen_status, eqpa_ccm_file_name, eqpa_ccm_on, eqpa_tsp_status, eqpa_batch, eqpa_filter_0, eqpa_filter_1, eqpa_filter_2, eqpa_filter_3, eqpa_filter_4, eqpa_filter_5, eqpa_filter_6, eqpa_filter_7, eqpa_filter_8, eqpa_filter_9, eqpa_commission_status, eqpa_slot_operator, eqpa_terminal, eqpa_haulage, eqpa_from_sub_location, eqpa_to_sub_location, eqpa_barge_voyage, eqpa_barge_name, eqpa_current_loc_depot, eqpa_quality_status, eqpa_dest_location, eqpa_dest_depot, eqpa_demage_reason, eqpa_demage_remarks, eqpa_repair_reference, eqpa_invoice_to, eqpa_tsp_port_4, eqpa_tsp_port_5, eqpa_reefer_temp_basis, eqpa_orgin_depot, eqpa_orgin_location, eqpa_origin_loc_name, eqpa_orgin_zip, eqpa_dest_loc_name, eqpa_dest_loc_zip, eqpa_feeder_voyage, eqpa_feeder_vessel, eqpa_dest_terminal, eqpa_scac_code, eqpa_pre_booking_number, eqpa_lod_dis_lot_number, eqpa_line_reference, eqpa_other_reference, eqpa_contract_no, eqpa_dest_type, eqpa_to_loc, eqpa_to_loc_name, eqpa_program_id, eqpa_seal_type_1, eqpa_seal_type_2, eqpa_seal_type_3, eqpa_seal_number_2, eqpa_seal_number_3, eqpa_flex_6, eqpa_flex_7, eqpa_flex_8, eqpa_flex_9, eqpa_flex_10, eqpa_local_gen_status, eqpa_local_file_name, eqpa_local_file_on, eqpa_iso_code, eqpa_pay_load, eqpa_cont_dep_doc_type, eqpa_cont_dep_doc_number) AS SELECT "EQPA_COMPANY", "EQPA_CONTAINER", "EQPA_SERIAL_NO", "EQPA_MOVE_DATE", "EQPA_MOVE_CODE", "EQPA_SERVICE_TYPE", "EQPA_CONTAINER_SERVICE_TYPE", "EQPA_CONTAINER_TYPE", "EQPA_CONTAINER_SIZE", "EQPA_CONTAINER_STORAGE", "EQPA_MODE", "EQPA_CURRENT_LOCATION", "EQPA_CURRENT_STATUS", "EQPA_GROSS_WEIGHT", "EQPA_TARE_WEIGHT", "EQPA_NET_WEIGHT", "EQPA_CARGO_WEIGHT", "EQPA_DAYS", "EQPA_CREATED_BY", "EQPA_CREATED_ON", "EQPA_MODIFIED_BY", "EQPA_MODIFIED_ON", "EQPA_LINE", "EQPA_VESSEL", "EQPA_VOYAGE", "EQPA_PORT", "EQPA_MOTHER_LINE", "EQPA_MOTHER_VESSEL", "EQPA_MOTHER_VOYAGE", "EQPA_MOTHER_PORT", "EQPA_ORIGIN_PORT", "EQPA_ORIGIN_NAME", "EQPA_FROM_PORT", "EQPA_TO_PORT", "EQPA_FINAL_PORT", "EQPA_FINAL_NAME", "EQPA_TRUCK_NUMBER", "EQPA_TRANSPORTER", "EQPA_CUSTOMER", "EQPA_SEAL_NUMBER", "EQPA_BILL_NO", "EQPA_BL_NUMBER", "EQPA_DO_NUMBER", "EQPA_REMARKS", "EQPA_OUT_GAUGE", "EQPA_OUT_HEIGHT", "EQPA_OUT_WIDTH", "EQPA_OUT_LENGTH", "EQPA_REEFER_STATUS", "EQPA_MIN_TEMPRATURE", "EQPA_MAX_TEMPRATURE", "EQPA_IMCO_STATUS", "EQPA_IMCO_UNNO", "EQPA_IMCO_CLASS", "EQPA_IMCO_PAGE", "EQPA_IMCO_FLASH", "EQPA_FOOD_STATUS", "EQPA_FOOD_DESCRIPTION", "EQPA_BOOKING_TYPE", "EQPA_BOOKING_NUMBER", "EQPA_JOB_TYPE", "EQPA_JOB_NUMBER", "EQPA_JOB_BASIS", "EQPA_AMOUNT", "EQPA_TRAIN_NUMBER", "EQPA_TRAIN_REFERENCE", "EQPA_ACCOUNT_STATUS", "EQPA_BOOKING_STATUS", "EQPA_BILLING_STATUS", "EQPA_FLEX_1", "EQPA_FLEX_2", "EQPA_FLEX_3", "EQPA_FLEX_4", "EQPA_FLEX_5", "EQPA_ENTRY_TYPE", "EQPA_STOWAGE", "EQPA_COMMODITY", "EQPA_SEQUENCE", "EQPA_SOC", "EQPA_VOYAGE_SERVICE", "EQPA_TSP_PORT_1", "EQPA_TSP_PORT_2", "EQPA_TSP_PORT_3", "EQPA_LEASE_NUMBER", "EQPA_LEASE_TYPE", "EQPA_OUT_WIDTH_LEFT", "EQPA_OUT_WIDTH_RIGHT", "EQPA_OUT_LENGTH_FORE", "EQPA_OUT_LENGTH_BACK", "EQPA_CCM_GEN_STATUS", "EQPA_CCM_FILE_NAME", "EQPA_CCM_ON", "EQPA_TSP_STATUS", "EQPA_BATCH", "EQPA_FILTER_0", "EQPA_FILTER_1", "EQPA_FILTER_2", "EQPA_FILTER_3", "EQPA_FILTER_4", "EQPA_FILTER_5", "EQPA_FILTER_6", "EQPA_FILTER_7", "EQPA_FILTER_8", "EQPA_FILTER_9", "EQPA_COMMISSION_STATUS", "EQPA_SLOT_OPERATOR", "EQPA_TERMINAL", "EQPA_HAULAGE", "EQPA_FROM_SUB_LOCATION", "EQPA_TO_SUB_LOCATION", "EQPA_BARGE_VOYAGE", "EQPA_BARGE_NAME", "EQPA_CURRENT_LOC_DEPOT", "EQPA_QUALITY_STATUS", "EQPA_DEST_LOCATION", "EQPA_DEST_DEPOT", "EQPA_DEMAGE_REASON", "EQPA_DEMAGE_REMARKS", "EQPA_REPAIR_REFERENCE", "EQPA_INVOICE_TO", "EQPA_TSP_PORT_4", "EQPA_TSP_PORT_5", "EQPA_REEFER_TEMP_BASIS", "EQPA_ORGIN_DEPOT", "EQPA_ORGIN_LOCATION", "EQPA_ORIGIN_LOC_NAME", "EQPA_ORGIN_ZIP", "EQPA_DEST_LOC_NAME", "EQPA_DEST_LOC_ZIP", "EQPA_FEEDER_VOYAGE", "EQPA_FEEDER_VESSEL", "EQPA_DEST_TERMINAL", "EQPA_SCAC_CODE", "EQPA_PRE_BOOKING_NUMBER", "EQPA_LOD_DIS_LOT_NUMBER", "EQPA_LINE_REFERENCE", "EQPA_OTHER_REFERENCE", "EQPA_CONTRACT_NO", "EQPA_DEST_TYPE", "EQPA_TO_LOC", "EQPA_TO_LOC_NAME", "EQPA_PROGRAM_ID", "EQPA_SEAL_TYPE_1", "EQPA_SEAL_TYPE_2", "EQPA_SEAL_TYPE_3", "EQPA_SEAL_NUMBER_2", "EQPA_SEAL_NUMBER_3", "EQPA_FLEX_6", "EQPA_FLEX_7", "EQPA_FLEX_8", "EQPA_FLEX_9", "EQPA_FLEX_10", "EQPA_LOCAL_GEN_STATUS", "EQPA_LOCAL_FILE_NAME", "EQPA_LOCAL_FILE_ON", "EQPA_ISO_CODE", "EQPA_PAY_LOAD", "EQPA_CONT_DEP_DOC_TYPE", "EQPA_CONT_DEP_DOC_NUMBER" FROM id_equipment_all_moves CREATE TABLE id_equipment_control ( eqip_company VARCHAR2(10) NOT NULL, eqip_full_in VARCHAR2(10) NOT NULL, eqip_full_tsp_in VARCHAR2(10) NOT NULL, eqip_empty_in VARCHAR2(10) NOT NULL, eqip_empty_tsp_in VARCHAR2(10) NOT NULL, eqip_full_out VARCHAR2(10) NOT NULL, eqip_full_tsp_out VARCHAR2(10) NOT NULL, eqip_empty_out VARCHAR2(10) NOT NULL, eqip_empty_tsp_out VARCHAR2(10) NOT NULL, eqip_depot_in VARCHAR2(10) NOT NULL, eqip_depot_out VARCHAR2(10) NOT NULL, eqip_lease_in VARCHAR2(10), eqip_lease_out VARCHAR2(10), eqip_damage_in VARCHAR2(10), eqip_damage_out VARCHAR2(10), eqip_return_empty VARCHAR2(10) NOT NULL, eqip_return_full VARCHAR2(10), eqip_expense_build VARCHAR2(1) DEFAULT 'N' NOT NULL, eqip_sold VARCHAR2(10), eqip_redelivery VARCHAR2(10), eqip_depot_empty_in VARCHAR2(10), eqip_depot_empty_out VARCHAR2(10), eqip_van VARCHAR2(10), eqip_dvan VARCHAR2(10), eqip_sublease_in VARCHAR2(10), eqip_sublease_out VARCHAR2(10), eqip_icd_arrival VARCHAR2(10), eqip_to_repair VARCHAR2(10), eqip_from_repair VARCHAR2(10), eqip_purchase VARCHAR2(10), eqip_filter_0 VARCHAR2(240), eqip_filter_1 VARCHAR2(240), eqip_filter_2 VARCHAR2(240), eqip_filter_3 VARCHAR2(240), eqip_filter_4 VARCHAR2(240), eqip_filter_5 VARCHAR2(240), eqip_filter_6 VARCHAR2(240), eqip_filter_7 VARCHAR2(240), eqip_filter_8 VARCHAR2(240), eqip_filter_9 VARCHAR2(240), eqip_delv VARCHAR2(10), eqip_full_o_truck VARCHAR2(10), eqip_full_i_truck VARCHAR2(10), eqip_full_o_rail VARCHAR2(10), eqip_full_i_rail VARCHAR2(10), eqip_mty_o_truck VARCHAR2(10), eqip_mty_i_truck VARCHAR2(10), eqip_mty_o_rail VARCHAR2(10), eqip_mty_i_rail VARCHAR2(10), eqip_xstuff VARCHAR2(10), eqip_mty_gate_out_soc VARCHAR2(10), eqip_dock_destuff VARCHAR2(10), eqip_dock_stuff VARCHAR2(10), eqip_fact_destuff VARCHAR2(10), eqip_fact_stuff VARCHAR2(10), eqip_rep_ret_mty VARCHAR2(10), eqip_sub_out_full VARCHAR2(10), eqip_sub_out_mty VARCHAR2(10), eqip_sub_in_full VARCHAR2(10), eqip_sub_in_mty VARCHAR2(10), eqip_repair_out_full VARCHAR2(10), eqip_repair_out_mty VARCHAR2(10), eqip_repair_ret_full VARCHAR2(10), eqip_damage_full VARCHAR2(10), eqip_damage_mty VARCHAR2(10), eqip_repair_ret_mty VARCHAR2(10), eqip_exp_dtfi VARCHAR2(10), eqip_exp_dtfo VARCHAR2(10), eqip_imp_dtfi VARCHAR2(10), eqip_imp_dtfo VARCHAR2(10), eqip_reserved_full VARCHAR2(10), eqip_rew_out VARCHAR2(10), eqip_redirect_delivery VARCHAR2(10), eqip_redirect_pickup VARCHAR2(10), eqip_reserved_mty VARCHAR2(10), eqip_sold_full VARCHAR2(10), eqip_exp_out_truck VARCHAR2(10), eqip_exp_in_truck VARCHAR2(10), eqip_exp_out_rail VARCHAR2(10), eqip_exp_in_rail VARCHAR2(10), eqip_imp_out_truck VARCHAR2(10), eqip_imp_in_truck VARCHAR2(10), eqip_imp_out_rail VARCHAR2(10), eqip_imp_in_rail VARCHAR2(10), eqip_rew_in VARCHAR2(10), eqip_ldfbg VARCHAR2(10), eqip_ldmbg VARCHAR2(10), eqip_dsfbg VARCHAR2(10), eqip_dsmbg VARCHAR2(10), eqip_ucacgo VARCHAR2(10), eqip_lost_full VARCHAR2(10), eqip_lost_mty VARCHAR2(10), eqip_from_cfs_mty VARCHAR2(10), eqip_to_cfs_mty VARCHAR2(10), eqip_from_cfs_full VARCHAR2(10), eqip_to_cfs_full VARCHAR2(10) )