Please wait. This can take some minutes ...
Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $
You can buy this project and download/modify it how often you want.
sql.mysql.FP_DV_TRVL_CO_NM_T.sql Maven / Gradle / Ivy
TRUNCATE TABLE FP_DV_TRVL_CO_NM_T
/
INSERT INTO FP_DV_TRVL_CO_NM_T (DV_EXP_CD,DV_EXP_CO_NM,OBJ_ID,VER_NBR,ROW_ACTV_IND)
VALUES ('A','CONTINENTAL/CONTINENTAL EXPRESS','059C8C53A21EEA14E043814FD881EA14',1.0,'Y')
/
INSERT INTO FP_DV_TRVL_CO_NM_T (DV_EXP_CD,DV_EXP_CO_NM,OBJ_ID,VER_NBR,ROW_ACTV_IND)
VALUES ('A','DELTA','059C8C53A21FEA14E043814FD881EA14',1.0,'Y')
/
INSERT INTO FP_DV_TRVL_CO_NM_T (DV_EXP_CD,DV_EXP_CO_NM,OBJ_ID,VER_NBR,ROW_ACTV_IND)
VALUES ('A','NORTHWEST','059C8C53A220EA14E043814FD881EA14',1.0,'Y')
/
INSERT INTO FP_DV_TRVL_CO_NM_T (DV_EXP_CD,DV_EXP_CO_NM,OBJ_ID,VER_NBR,ROW_ACTV_IND)
VALUES ('A','OTHER','059C8C53A221EA14E043814FD881EA14',1.0,'Y')
/
INSERT INTO FP_DV_TRVL_CO_NM_T (DV_EXP_CD,DV_EXP_CO_NM,OBJ_ID,VER_NBR,ROW_ACTV_IND)
VALUES ('A','SOUTHWEST','059C8C53A222EA14E043814FD881EA14',1.0,'Y')
/
INSERT INTO FP_DV_TRVL_CO_NM_T (DV_EXP_CD,DV_EXP_CO_NM,OBJ_ID,VER_NBR,ROW_ACTV_IND)
VALUES ('A','TRANS WORLD AIRLINES','059C8C53A223EA14E043814FD881EA14',1.0,'Y')
/
INSERT INTO FP_DV_TRVL_CO_NM_T (DV_EXP_CD,DV_EXP_CO_NM,OBJ_ID,VER_NBR,ROW_ACTV_IND)
VALUES ('A','U.S. AIRWAYS','059C8C53A224EA14E043814FD881EA14',1.0,'Y')
/
INSERT INTO FP_DV_TRVL_CO_NM_T (DV_EXP_CD,DV_EXP_CO_NM,OBJ_ID,VER_NBR,ROW_ACTV_IND)
VALUES ('A','UNITED AIRLINES','059C8C53A225EA14E043814FD881EA14',1.0,'Y')
/
INSERT INTO FP_DV_TRVL_CO_NM_T (DV_EXP_CD,DV_EXP_CO_NM,OBJ_ID,VER_NBR,ROW_ACTV_IND)
VALUES ('L','BEST WESTERN','059C8C53A226EA14E043814FD881EA14',1.0,'Y')
/
INSERT INTO FP_DV_TRVL_CO_NM_T (DV_EXP_CD,DV_EXP_CO_NM,OBJ_ID,VER_NBR,ROW_ACTV_IND)
VALUES ('L','CENTURY SUITES','059C8C53A227EA14E043814FD881EA14',1.0,'Y')
/
INSERT INTO FP_DV_TRVL_CO_NM_T (DV_EXP_CD,DV_EXP_CO_NM,OBJ_ID,VER_NBR,ROW_ACTV_IND)
VALUES ('L','COMFORT AND CLARION INNS','059C8C53A228EA14E043814FD881EA14',1.0,'Y')
/
INSERT INTO FP_DV_TRVL_CO_NM_T (DV_EXP_CD,DV_EXP_CO_NM,OBJ_ID,VER_NBR,ROW_ACTV_IND)
VALUES ('L','COURTYARD','059C8C53A229EA14E043814FD881EA14',1.0,'Y')
/
INSERT INTO FP_DV_TRVL_CO_NM_T (DV_EXP_CD,DV_EXP_CO_NM,OBJ_ID,VER_NBR,ROW_ACTV_IND)
VALUES ('L','DAYS INN','059C8C53A22AEA14E043814FD881EA14',1.0,'Y')
/
INSERT INTO FP_DV_TRVL_CO_NM_T (DV_EXP_CD,DV_EXP_CO_NM,OBJ_ID,VER_NBR,ROW_ACTV_IND)
VALUES ('L','FAIRFIELD INN','059C8C53A22BEA14E043814FD881EA14',1.0,'Y')
/
INSERT INTO FP_DV_TRVL_CO_NM_T (DV_EXP_CD,DV_EXP_CO_NM,OBJ_ID,VER_NBR,ROW_ACTV_IND)
VALUES ('L','GRANT STREET INN','059C8C53A22CEA14E043814FD881EA14',1.0,'Y')
/
INSERT INTO FP_DV_TRVL_CO_NM_T (DV_EXP_CD,DV_EXP_CO_NM,OBJ_ID,VER_NBR,ROW_ACTV_IND)
VALUES ('L','HAMPTON INN','059C8C53A22DEA14E043814FD881EA14',1.0,'Y')
/
INSERT INTO FP_DV_TRVL_CO_NM_T (DV_EXP_CD,DV_EXP_CO_NM,OBJ_ID,VER_NBR,ROW_ACTV_IND)
VALUES ('L','HOLIDAY INNS','059C8C53A22EEA14E043814FD881EA14',1.0,'Y')
/
INSERT INTO FP_DV_TRVL_CO_NM_T (DV_EXP_CD,DV_EXP_CO_NM,OBJ_ID,VER_NBR,ROW_ACTV_IND)
VALUES ('L','INDIANA MEMORIAL UNION','059C8C53A22FEA14E043814FD881EA14',1.0,'Y')
/
INSERT INTO FP_DV_TRVL_CO_NM_T (DV_EXP_CD,DV_EXP_CO_NM,OBJ_ID,VER_NBR,ROW_ACTV_IND)
VALUES ('L','OTHER','059C8C53A230EA14E043814FD881EA14',1.0,'Y')
/
INSERT INTO FP_DV_TRVL_CO_NM_T (DV_EXP_CD,DV_EXP_CO_NM,OBJ_ID,VER_NBR,ROW_ACTV_IND)
VALUES ('L','RAMADA INNS','059C8C53A231EA14E043814FD881EA14',1.0,'Y')
/
INSERT INTO FP_DV_TRVL_CO_NM_T (DV_EXP_CD,DV_EXP_CO_NM,OBJ_ID,VER_NBR,ROW_ACTV_IND)
VALUES ('L','TRAVELODGE','059C8C53A232EA14E043814FD881EA14',1.0,'Y')
/
INSERT INTO FP_DV_TRVL_CO_NM_T (DV_EXP_CD,DV_EXP_CO_NM,OBJ_ID,VER_NBR,ROW_ACTV_IND)
VALUES ('L','UNIVERSITY PLACE','059C8C53A233EA14E043814FD881EA14',1.0,'Y')
/
INSERT INTO FP_DV_TRVL_CO_NM_T (DV_EXP_CD,DV_EXP_CO_NM,OBJ_ID,VER_NBR,ROW_ACTV_IND)
VALUES ('M','OTHER','059C8C53A234EA14E043814FD881EA14',1.0,'Y')
/
INSERT INTO FP_DV_TRVL_CO_NM_T (DV_EXP_CD,DV_EXP_CO_NM,OBJ_ID,VER_NBR,ROW_ACTV_IND)
VALUES ('M','RYDER','059C8C53A235EA14E043814FD881EA14',1.0,'Y')
/
INSERT INTO FP_DV_TRVL_CO_NM_T (DV_EXP_CD,DV_EXP_CO_NM,OBJ_ID,VER_NBR,ROW_ACTV_IND)
VALUES ('M','U-HAUL','059C8C53A236EA14E043814FD881EA14',1.0,'Y')
/
INSERT INTO FP_DV_TRVL_CO_NM_T (DV_EXP_CD,DV_EXP_CO_NM,OBJ_ID,VER_NBR,ROW_ACTV_IND)
VALUES ('O','OTHER','059C8C53A237EA14E043814FD881EA14',1.0,'Y')
/
INSERT INTO FP_DV_TRVL_CO_NM_T (DV_EXP_CD,DV_EXP_CO_NM,OBJ_ID,VER_NBR,ROW_ACTV_IND)
VALUES ('PA','CONTINENTAL/CONTINENTAL EXPRESS','059C8C53A238EA14E043814FD881EA14',1.0,'Y')
/
INSERT INTO FP_DV_TRVL_CO_NM_T (DV_EXP_CD,DV_EXP_CO_NM,OBJ_ID,VER_NBR,ROW_ACTV_IND)
VALUES ('PA','DELTA','059C8C53A239EA14E043814FD881EA14',1.0,'Y')
/
INSERT INTO FP_DV_TRVL_CO_NM_T (DV_EXP_CD,DV_EXP_CO_NM,OBJ_ID,VER_NBR,ROW_ACTV_IND)
VALUES ('PA','NORTHWEST','059C8C53A23AEA14E043814FD881EA14',1.0,'Y')
/
INSERT INTO FP_DV_TRVL_CO_NM_T (DV_EXP_CD,DV_EXP_CO_NM,OBJ_ID,VER_NBR,ROW_ACTV_IND)
VALUES ('PA','OTHER','059C8C53A23BEA14E043814FD881EA14',1.0,'Y')
/
INSERT INTO FP_DV_TRVL_CO_NM_T (DV_EXP_CD,DV_EXP_CO_NM,OBJ_ID,VER_NBR,ROW_ACTV_IND)
VALUES ('PA','SOUTHWEST','059C8C53A23CEA14E043814FD881EA14',1.0,'Y')
/
INSERT INTO FP_DV_TRVL_CO_NM_T (DV_EXP_CD,DV_EXP_CO_NM,OBJ_ID,VER_NBR,ROW_ACTV_IND)
VALUES ('PA','TRANS WORLD AIRLINES','059C8C53A23DEA14E043814FD881EA14',1.0,'Y')
/
INSERT INTO FP_DV_TRVL_CO_NM_T (DV_EXP_CD,DV_EXP_CO_NM,OBJ_ID,VER_NBR,ROW_ACTV_IND)
VALUES ('PA','U.S. AIRWAYS','059C8C53A23EEA14E043814FD881EA14',1.0,'Y')
/
INSERT INTO FP_DV_TRVL_CO_NM_T (DV_EXP_CD,DV_EXP_CO_NM,OBJ_ID,VER_NBR,ROW_ACTV_IND)
VALUES ('PA','UNITED AIRLINES','059C8C53A23FEA14E043814FD881EA14',1.0,'Y')
/
INSERT INTO FP_DV_TRVL_CO_NM_T (DV_EXP_CD,DV_EXP_CO_NM,OBJ_ID,VER_NBR,ROW_ACTV_IND)
VALUES ('PC','OTHER','059C8C53A240EA14E043814FD881EA14',1.0,'Y')
/
INSERT INTO FP_DV_TRVL_CO_NM_T (DV_EXP_CD,DV_EXP_CO_NM,OBJ_ID,VER_NBR,ROW_ACTV_IND)
VALUES ('PL','BEST WESTERN','059C8C53A241EA14E043814FD881EA14',1.0,'Y')
/
INSERT INTO FP_DV_TRVL_CO_NM_T (DV_EXP_CD,DV_EXP_CO_NM,OBJ_ID,VER_NBR,ROW_ACTV_IND)
VALUES ('PL','CENTURY SUITES','059C8C53A242EA14E043814FD881EA14',1.0,'Y')
/
INSERT INTO FP_DV_TRVL_CO_NM_T (DV_EXP_CD,DV_EXP_CO_NM,OBJ_ID,VER_NBR,ROW_ACTV_IND)
VALUES ('PL','COMFORT AND CLARION INNS','059C8C53A243EA14E043814FD881EA14',1.0,'Y')
/
INSERT INTO FP_DV_TRVL_CO_NM_T (DV_EXP_CD,DV_EXP_CO_NM,OBJ_ID,VER_NBR,ROW_ACTV_IND)
VALUES ('PL','COURTYARD','059C8C53A244EA14E043814FD881EA14',1.0,'Y')
/
INSERT INTO FP_DV_TRVL_CO_NM_T (DV_EXP_CD,DV_EXP_CO_NM,OBJ_ID,VER_NBR,ROW_ACTV_IND)
VALUES ('PL','DAYS INN','059C8C53A245EA14E043814FD881EA14',1.0,'Y')
/
INSERT INTO FP_DV_TRVL_CO_NM_T (DV_EXP_CD,DV_EXP_CO_NM,OBJ_ID,VER_NBR,ROW_ACTV_IND)
VALUES ('PL','FAIRFIELD INN','059C8C53A246EA14E043814FD881EA14',1.0,'Y')
/
INSERT INTO FP_DV_TRVL_CO_NM_T (DV_EXP_CD,DV_EXP_CO_NM,OBJ_ID,VER_NBR,ROW_ACTV_IND)
VALUES ('PL','GRANT STREET INN','059C8C53A247EA14E043814FD881EA14',1.0,'Y')
/
INSERT INTO FP_DV_TRVL_CO_NM_T (DV_EXP_CD,DV_EXP_CO_NM,OBJ_ID,VER_NBR,ROW_ACTV_IND)
VALUES ('PL','HAMPTON INN','059C8C53A248EA14E043814FD881EA14',1.0,'Y')
/
INSERT INTO FP_DV_TRVL_CO_NM_T (DV_EXP_CD,DV_EXP_CO_NM,OBJ_ID,VER_NBR,ROW_ACTV_IND)
VALUES ('PL','HOLIDAY INNS','059C8C53A249EA14E043814FD881EA14',1.0,'Y')
/
INSERT INTO FP_DV_TRVL_CO_NM_T (DV_EXP_CD,DV_EXP_CO_NM,OBJ_ID,VER_NBR,ROW_ACTV_IND)
VALUES ('PL','INDIANA MEMORIAL UNION','059C8C53A24AEA14E043814FD881EA14',1.0,'Y')
/
INSERT INTO FP_DV_TRVL_CO_NM_T (DV_EXP_CD,DV_EXP_CO_NM,OBJ_ID,VER_NBR,ROW_ACTV_IND)
VALUES ('PL','OTHER','059C8C53A24BEA14E043814FD881EA14',1.0,'Y')
/
INSERT INTO FP_DV_TRVL_CO_NM_T (DV_EXP_CD,DV_EXP_CO_NM,OBJ_ID,VER_NBR,ROW_ACTV_IND)
VALUES ('PL','RAMADA INNS','059C8C53A24CEA14E043814FD881EA14',1.0,'Y')
/
INSERT INTO FP_DV_TRVL_CO_NM_T (DV_EXP_CD,DV_EXP_CO_NM,OBJ_ID,VER_NBR,ROW_ACTV_IND)
VALUES ('PL','TRAVELODGE','059C8C53A24DEA14E043814FD881EA14',1.0,'Y')
/
INSERT INTO FP_DV_TRVL_CO_NM_T (DV_EXP_CD,DV_EXP_CO_NM,OBJ_ID,VER_NBR,ROW_ACTV_IND)
VALUES ('PL','UNIVERSITY PLACE','059C8C53A24EEA14E043814FD881EA14',1.0,'Y')
/
INSERT INTO FP_DV_TRVL_CO_NM_T (DV_EXP_CD,DV_EXP_CO_NM,OBJ_ID,VER_NBR,ROW_ACTV_IND)
VALUES ('PM','OTHER','059C8C53A24FEA14E043814FD881EA14',1.0,'Y')
/
INSERT INTO FP_DV_TRVL_CO_NM_T (DV_EXP_CD,DV_EXP_CO_NM,OBJ_ID,VER_NBR,ROW_ACTV_IND)
VALUES ('PM','RYDER','059C8C53A250EA14E043814FD881EA14',1.0,'Y')
/
INSERT INTO FP_DV_TRVL_CO_NM_T (DV_EXP_CD,DV_EXP_CO_NM,OBJ_ID,VER_NBR,ROW_ACTV_IND)
VALUES ('PM','U-HAUL','059C8C53A251EA14E043814FD881EA14',1.0,'Y')
/
INSERT INTO FP_DV_TRVL_CO_NM_T (DV_EXP_CD,DV_EXP_CO_NM,OBJ_ID,VER_NBR,ROW_ACTV_IND)
VALUES ('PO','PREPAID OTHER','059C8C53A252EA14E043814FD881EA14',1.0,'Y')
/
INSERT INTO FP_DV_TRVL_CO_NM_T (DV_EXP_CD,DV_EXP_CO_NM,OBJ_ID,VER_NBR,ROW_ACTV_IND)
VALUES ('PR','ALAMO','059C8C53A253EA14E043814FD881EA14',1.0,'Y')
/
INSERT INTO FP_DV_TRVL_CO_NM_T (DV_EXP_CD,DV_EXP_CO_NM,OBJ_ID,VER_NBR,ROW_ACTV_IND)
VALUES ('PR','AVIS','059C8C53A254EA14E043814FD881EA14',1.0,'Y')
/
INSERT INTO FP_DV_TRVL_CO_NM_T (DV_EXP_CD,DV_EXP_CO_NM,OBJ_ID,VER_NBR,ROW_ACTV_IND)
VALUES ('PR','BUDGET','059C8C53A255EA14E043814FD881EA14',1.0,'Y')
/
INSERT INTO FP_DV_TRVL_CO_NM_T (DV_EXP_CD,DV_EXP_CO_NM,OBJ_ID,VER_NBR,ROW_ACTV_IND)
VALUES ('PR','HERTZ','059C8C53A256EA14E043814FD881EA14',1.0,'Y')
/
INSERT INTO FP_DV_TRVL_CO_NM_T (DV_EXP_CD,DV_EXP_CO_NM,OBJ_ID,VER_NBR,ROW_ACTV_IND)
VALUES ('PR','NATIONAL','059C8C53A257EA14E043814FD881EA14',1.0,'Y')
/
INSERT INTO FP_DV_TRVL_CO_NM_T (DV_EXP_CD,DV_EXP_CO_NM,OBJ_ID,VER_NBR,ROW_ACTV_IND)
VALUES ('PR','OTHER','059C8C53A258EA14E043814FD881EA14',1.0,'Y')
/
INSERT INTO FP_DV_TRVL_CO_NM_T (DV_EXP_CD,DV_EXP_CO_NM,OBJ_ID,VER_NBR,ROW_ACTV_IND)
VALUES ('PT','BLOOMINGTON SHUTTLE SVC','059C8C53A259EA14E043814FD881EA14',1.0,'Y')
/
INSERT INTO FP_DV_TRVL_CO_NM_T (DV_EXP_CD,DV_EXP_CO_NM,OBJ_ID,VER_NBR,ROW_ACTV_IND)
VALUES ('PT','CLASSIC TOUCH','059C8C53A25AEA14E043814FD881EA14',1.0,'Y')
/
INSERT INTO FP_DV_TRVL_CO_NM_T (DV_EXP_CD,DV_EXP_CO_NM,OBJ_ID,VER_NBR,ROW_ACTV_IND)
VALUES ('PT','OTHER','059C8C53A25BEA14E043814FD881EA14',1.0,'Y')
/
INSERT INTO FP_DV_TRVL_CO_NM_T (DV_EXP_CD,DV_EXP_CO_NM,OBJ_ID,VER_NBR,ROW_ACTV_IND)
VALUES ('PT','YELLOW CAB CO.','059C8C53A25CEA14E043814FD881EA14',1.0,'Y')
/
INSERT INTO FP_DV_TRVL_CO_NM_T (DV_EXP_CD,DV_EXP_CO_NM,OBJ_ID,VER_NBR,ROW_ACTV_IND)
VALUES ('R','ALAMO','059C8C53A25DEA14E043814FD881EA14',1.0,'Y')
/
INSERT INTO FP_DV_TRVL_CO_NM_T (DV_EXP_CD,DV_EXP_CO_NM,OBJ_ID,VER_NBR,ROW_ACTV_IND)
VALUES ('R','AVIS','059C8C53A25EEA14E043814FD881EA14',1.0,'Y')
/
INSERT INTO FP_DV_TRVL_CO_NM_T (DV_EXP_CD,DV_EXP_CO_NM,OBJ_ID,VER_NBR,ROW_ACTV_IND)
VALUES ('R','BUDGET','059C8C53A25FEA14E043814FD881EA14',1.0,'Y')
/
INSERT INTO FP_DV_TRVL_CO_NM_T (DV_EXP_CD,DV_EXP_CO_NM,OBJ_ID,VER_NBR,ROW_ACTV_IND)
VALUES ('R','HERTZ','059C8C53A260EA14E043814FD881EA14',1.0,'Y')
/
INSERT INTO FP_DV_TRVL_CO_NM_T (DV_EXP_CD,DV_EXP_CO_NM,OBJ_ID,VER_NBR,ROW_ACTV_IND)
VALUES ('R','NATIONAL','059C8C53A261EA14E043814FD881EA14',1.0,'Y')
/
INSERT INTO FP_DV_TRVL_CO_NM_T (DV_EXP_CD,DV_EXP_CO_NM,OBJ_ID,VER_NBR,ROW_ACTV_IND)
VALUES ('R','OTHER','059C8C53A262EA14E043814FD881EA14',1.0,'Y')
/
INSERT INTO FP_DV_TRVL_CO_NM_T (DV_EXP_CD,DV_EXP_CO_NM,OBJ_ID,VER_NBR,ROW_ACTV_IND)
VALUES ('T','BLOOMINGTON SHUTTLE SVC','059C8C53A263EA14E043814FD881EA14',1.0,'Y')
/
INSERT INTO FP_DV_TRVL_CO_NM_T (DV_EXP_CD,DV_EXP_CO_NM,OBJ_ID,VER_NBR,ROW_ACTV_IND)
VALUES ('T','CLASSIC TOUCH','059C8C53A264EA14E043814FD881EA14',1.0,'Y')
/
INSERT INTO FP_DV_TRVL_CO_NM_T (DV_EXP_CD,DV_EXP_CO_NM,OBJ_ID,VER_NBR,ROW_ACTV_IND)
VALUES ('T','OTHER','059C8C53A265EA14E043814FD881EA14',1.0,'Y')
/
INSERT INTO FP_DV_TRVL_CO_NM_T (DV_EXP_CD,DV_EXP_CO_NM,OBJ_ID,VER_NBR,ROW_ACTV_IND)
VALUES ('T','YELLOW CAB CO.','059C8C53A266EA14E043814FD881EA14',1.0,'Y')
/