|
1
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 741474 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 741474 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
2
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 886479 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 886479 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
3
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 317112 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 317112 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
4
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 857930 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 857930 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
5
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 794192 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 794192 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
6
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 725676 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 725676 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
7
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 812953 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 812953 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
8
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 194205 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 194205 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
9
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 151154 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 151154 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
10
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 732447 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 732447 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
11
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 198976 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 198976 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
12
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 205128 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 205128 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
13
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 823547 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 823547 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
14
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 693460 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 693460 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
15
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 693461 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 693461 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
16
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 270966 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 270966 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
17
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 216412 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 216412 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
18
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 738638 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 738638 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
19
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 137031 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 137031 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
20
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 850759 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 850759 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
21
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 123834 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 123834 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
22
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 850992 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 850992 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
23
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 160579 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 160579 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
24
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 738639 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 738639 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
25
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 1001192 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 1001192 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
26
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 423328 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 423328 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
27
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 117983 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 117983 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
28
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 259832 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 259832 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
29
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 1001372 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 1001372 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
30
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 861301 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 861301 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
31
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 604325 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 604325 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
32
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 185815 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 185815 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
33
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 1001223 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 1001223 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
34
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 100140 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 100140 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
35
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 142040 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 142040 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
36
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 1001107 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 1001107 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
37
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 102977 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 102977 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
38
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 699110 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 699110 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
39
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 560953 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 560953 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
40
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 130438 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 130438 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
41
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 145408 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 145408 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
42
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 738637 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 738637 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
43
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 404749 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 404749 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
44
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 802618 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 802618 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
45
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 960244 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 960244 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
46
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 631042 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 631042 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
47
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 179156 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 179156 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
48
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 664496 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 664496 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
49
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 284695 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 284695 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
50
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 100628 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 100628 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
51
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 362210 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 362210 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
52
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 245636 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 245636 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
53
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 249954 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 249954 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
54
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 104009 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 104009 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
55
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 184883 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 184883 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
56
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 718651 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 718651 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
57
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 344374 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 344374 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
58
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 242515 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 242515 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
59
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 684383 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 684383 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
60
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 995718 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 995718 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
61
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 156956 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 156956 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
62
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 473503 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 473503 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
63
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 858846 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 858846 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
64
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 301517 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 301517 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
65
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 647975 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 647975 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
66
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 682145 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 682145 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
67
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 106503 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 106503 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
68
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 754548 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 754548 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
69
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 578836 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 578836 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
70
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 851552 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 851552 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
71
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 176015 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 176015 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
72
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 1001458 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 1001458 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
73
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 145750 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 145750 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
74
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 952668 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 952668 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
75
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 1001460 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 1001460 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
76
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 211970 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 211970 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
77
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 604399 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 604399 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
78
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 739324 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 739324 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
79
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 344353 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 344353 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
80
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 815186 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 815186 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
81
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 852475 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 852475 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
82
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 316214 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 316214 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
83
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 247257 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 247257 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
84
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 331264 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 331264 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
85
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 107742 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 107742 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
86
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 128738 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 128738 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
87
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 198284 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 198284 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
88
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 190599 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 190599 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
89
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 104444 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 104444 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
90
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 105508 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 105508 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
91
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 113460 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 113460 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
92
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 117852 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 117852 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
93
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 128336 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 128336 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
94
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 129423 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 129423 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
95
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 129798 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 129798 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
96
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 134017 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 134017 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
97
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 136598 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 136598 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
98
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 136884 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 136884 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
99
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 146252 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 146252 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
100
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 152356 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 152356 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
101
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 154922 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 154922 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
102
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 155844 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 155844 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
103
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 160145 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 160145 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
104
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 174722 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 174722 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
105
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 176688 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 176688 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
106
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 188300 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 188300 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
107
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 191202 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 191202 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
108
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 195422 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 195422 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
109
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 204903 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 204903 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
110
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 208126 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 208126 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
111
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 209458 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 209458 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
112
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 210758 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 210758 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
113
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 210759 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 210759 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
114
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 211971 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 211971 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
115
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 255001 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 255001 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
116
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 261437 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 261437 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
117
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 270383 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 270383 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
118
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 273157 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 273157 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
119
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 297187 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 297187 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
120
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 301473 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 301473 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
121
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 332764 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 332764 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
122
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 340732 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 340732 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
123
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 344378 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 344378 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
124
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 365917 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 365917 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
125
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 397706 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 397706 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
126
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 456198 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 456198 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
127
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 467054 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 467054 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
128
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 484129 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 484129 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
129
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 520614 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 520614 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
130
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 528117 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 528117 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
131
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 528152 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 528152 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
132
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 530840 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 530840 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
133
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 542529 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 542529 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
134
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 578884 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 578884 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
135
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 600885 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 600885 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
136
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 633937 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 633937 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
137
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 634506 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 634506 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
138
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 641726 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 641726 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
139
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 654185 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 654185 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
140
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 658915 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 658915 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
141
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 659541 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 659541 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
142
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 666671 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 666671 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
143
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 679106 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 679106 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
144
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 684379 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 684379 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
145
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 685781 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 685781 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
146
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 698750 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 698750 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
147
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 698987 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 698987 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
148
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 717688 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 717688 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90009' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
149
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 725669 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 725669 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
150
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 738641 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 738641 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
151
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 749379 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 749379 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
152
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 805467 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 805467 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
153
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 828584 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 828584 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
154
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 852301 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 852301 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
155
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 852946 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 852946 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
156
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 859098 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 859098 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
157
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 860537 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 860537 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
158
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 977968 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 977968 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
159
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 982771 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 982771 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
160
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 1001108 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 1001108 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
161
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 1001451 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 1001451 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
162
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 1001454 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 1001454 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '90011' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
163
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 1001500 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 1001500 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
164
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 796662 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 796662 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
|
165
|
UPDATE US_COMP_PIC ucp JOIN ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 586690 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input ON ucp.COMP_CODE = data_input.comp_code SET ucp.PIC_UNO = data_input.user_no WHERE data_input.user_no IS NOT NULL AND (ucp.PIC_TYPE_CODE = 'PIC01' OR ucp.PIC_TYPE_CODE = 'PIC02'); INSERT INTO US_COMP_PIC (COMP_CODE, PIC_TYPE_CODE, PIC_UNO) SELECT data_input.comp_code, t.pic_type, data_input.user_no FROM ( SELECT (SELECT VENDOR_COMP_CODE FROM VD_VENDOR_HOTEL_MAPPING WHERE HOTEL_CODE = 586690 AND VENDOR_COMP_CODE LIKE '6%' LIMIT 1) AS comp_code, '116771' AS user_no ) AS data_input JOIN (SELECT 'PIC01' AS pic_type UNION ALL SELECT 'PIC02') t WHERE data_input.user_no IS NOT NULL AND NOT EXISTS (SELECT 1 FROM US_COMP_PIC u WHERE u.COMP_CODE = data_input.comp_code AND u.PIC_TYPE_CODE = t.pic_type);
|
