API tools faq
paste
Advertisement
mhamdani049

Test

mhamdani049
Jul 1st, 2020
1,165
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 12.99 KB | None | 0 0
raw download clone embed print report
  1. USE SPEX_DB;
  2.  
  3. -- Add bucket transfer
  4. INSERT INTO SPEX_DB.spex.TB_M_BUCKET_TRANSFER (BT_NO, ZONE_CD, DEST_CD, TRANSP_CD, SOURCE, TARGET, STATUS, CREATED_BY, CREATED_DT, CHANGED_BY, CHANGED_DT) VALUES ('REBI-M-0106200001', 'M', NULL, NULL, 'Reserve', 'Binning', '0', 'AMANAH.Yusup', '2020-06-01 00:00:00.000', 'AMANAH.Yusup', '2020-06-01 00:00:00.000');
  5. INSERT INTO SPEX_DB.spex.TB_M_BUCKET_TRANSFER (BT_NO, ZONE_CD, DEST_CD, TRANSP_CD, SOURCE, TARGET, STATUS, CREATED_BY, CREATED_DT, CHANGED_BY, CHANGED_DT) VALUES ('REBI-M-0106200002', 'M', NULL, NULL, 'Reserve', 'Binning', '0', 'AMANAH.Yusup', '2020-06-01 00:00:00.000', 'AMANAH.Yusup', '2020-06-01 00:00:00.000');
  6. INSERT INTO SPEX_DB.spex.TB_M_BUCKET_TRANSFER (BT_NO, ZONE_CD, DEST_CD, TRANSP_CD, SOURCE, TARGET, STATUS, CREATED_BY, CREATED_DT, CHANGED_BY, CHANGED_DT) VALUES ('REBI-M-0106200003', 'M', NULL, NULL, 'Reserve', 'Binning', '0', 'AMANAH.Yusup', '2020-06-01 00:00:00.000', 'AMANAH.Yusup', '2020-06-01 00:00:00.000');
  7. INSERT INTO SPEX_DB.spex.TB_M_BUCKET_TRANSFER (BT_NO, ZONE_CD, DEST_CD, TRANSP_CD, SOURCE, TARGET, STATUS, CREATED_BY, CREATED_DT, CHANGED_BY, CHANGED_DT) VALUES ('REBI-M-0106200004', 'M', NULL, NULL, 'Reserve', 'Binning', '0', 'AMANAH.Yusup', '2020-06-01 00:00:00.000', 'AMANAH.Yusup', '2020-06-01 00:00:00.000');
  8. INSERT INTO SPEX_DB.spex.TB_M_BUCKET_TRANSFER (BT_NO, ZONE_CD, DEST_CD, TRANSP_CD, SOURCE, TARGET, STATUS, CREATED_BY, CREATED_DT, CHANGED_BY, CHANGED_DT) VALUES ('REBI-M-0106200005', 'M', NULL, NULL, 'Reserve', 'Binning', '0', 'AMANAH.Yusup', '2020-06-01 00:00:00.000', 'AMANAH.Yusup', '2020-06-01 00:00:00.000');
  9. INSERT INTO SPEX_DB.spex.TB_M_BUCKET_TRANSFER (BT_NO, ZONE_CD, DEST_CD, TRANSP_CD, SOURCE, TARGET, STATUS, CREATED_BY, CREATED_DT, CHANGED_BY, CHANGED_DT) VALUES ('REBI-M-0106200006', 'M', NULL, NULL, 'Reserve', 'Binning', '0', 'AMANAH.Yusup', '2020-06-01 00:00:00.000', 'AMANAH.Yusup', '2020-06-01 00:00:00.000');
  10. INSERT INTO SPEX_DB.spex.TB_M_BUCKET_TRANSFER (BT_NO, ZONE_CD, DEST_CD, TRANSP_CD, SOURCE, TARGET, STATUS, CREATED_BY, CREATED_DT, CHANGED_BY, CHANGED_DT) VALUES ('REBI-M-0106200007', 'M', NULL, NULL, 'Reserve', 'Binning', '0', 'AMANAH.Yusup', '2020-06-01 00:00:00.000', 'AMANAH.Yusup', '2020-06-01 00:00:00.000');
  11. INSERT INTO SPEX_DB.spex.TB_M_BUCKET_TRANSFER (BT_NO, ZONE_CD, DEST_CD, TRANSP_CD, SOURCE, TARGET, STATUS, CREATED_BY, CREATED_DT, CHANGED_BY, CHANGED_DT) VALUES ('REBI-M-0106200008', 'M', NULL, NULL, 'Reserve', 'Binning', '0', 'AMANAH.Yusup', '2020-06-01 00:00:00.000', 'AMANAH.Yusup', '2020-06-01 00:00:00.000');
  12. INSERT INTO SPEX_DB.spex.TB_M_BUCKET_TRANSFER (BT_NO, ZONE_CD, DEST_CD, TRANSP_CD, SOURCE, TARGET, STATUS, CREATED_BY, CREATED_DT, CHANGED_BY, CHANGED_DT) VALUES ('REBI-M-0106200009', 'M', NULL, NULL, 'Reserve', 'Binning', '0', 'AMANAH.Yusup', '2020-06-01 00:00:00.000', 'AMANAH.Yusup', '2020-06-01 00:00:00.000');
  13. INSERT INTO SPEX_DB.spex.TB_M_BUCKET_TRANSFER (BT_NO, ZONE_CD, DEST_CD, TRANSP_CD, SOURCE, TARGET, STATUS, CREATED_BY, CREATED_DT, CHANGED_BY, CHANGED_DT) VALUES ('REBI-M-0106200010', 'M', NULL, NULL, 'Reserve', 'Binning', '0', 'AMANAH.Yusup', '2020-06-01 00:00:00.000', 'AMANAH.Yusup', '2020-06-01 00:00:00.000');
  14. INSERT INTO SPEX_DB.spex.TB_M_BUCKET_TRANSFER (BT_NO, ZONE_CD, DEST_CD, TRANSP_CD, SOURCE, TARGET, STATUS, CREATED_BY, CREATED_DT, CHANGED_BY, CHANGED_DT) VALUES ('REBI-M-0106200011', 'M', NULL, NULL, 'Reserve', 'Binning', '0', 'AMANAH.Yusup', '2020-06-01 00:00:00.000', 'AMANAH.Yusup', '2020-06-01 00:00:00.000');
  15. INSERT INTO SPEX_DB.spex.TB_M_BUCKET_TRANSFER (BT_NO, ZONE_CD, DEST_CD, TRANSP_CD, SOURCE, TARGET, STATUS, CREATED_BY, CREATED_DT, CHANGED_BY, CHANGED_DT) VALUES ('REBI-M-0106200012', 'M', NULL, NULL, 'Reserve', 'Binning', '0', 'AMANAH.Yusup', '2020-06-01 00:00:00.000', 'AMANAH.Yusup', '2020-06-01 00:00:00.000');
  16. INSERT INTO SPEX_DB.spex.TB_M_BUCKET_TRANSFER (BT_NO, ZONE_CD, DEST_CD, TRANSP_CD, SOURCE, TARGET, STATUS, CREATED_BY, CREATED_DT, CHANGED_BY, CHANGED_DT) VALUES ('REBI-M-0106200013', 'M', NULL, NULL, 'Reserve', 'Binning', '0', 'AMANAH.Yusup', '2020-06-01 00:00:00.000', 'AMANAH.Yusup', '2020-06-01 00:00:00.000');
  17. INSERT INTO SPEX_DB.spex.TB_M_BUCKET_TRANSFER (BT_NO, ZONE_CD, DEST_CD, TRANSP_CD, SOURCE, TARGET, STATUS, CREATED_BY, CREATED_DT, CHANGED_BY, CHANGED_DT) VALUES ('REBI-M-0106200014', 'M', NULL, NULL, 'Reserve', 'Binning', '0', 'AMANAH.Yusup', '2020-06-01 00:00:00.000', 'AMANAH.Yusup', '2020-06-01 00:00:00.000');
  18. INSERT INTO SPEX_DB.spex.TB_M_BUCKET_TRANSFER (BT_NO, ZONE_CD, DEST_CD, TRANSP_CD, SOURCE, TARGET, STATUS, CREATED_BY, CREATED_DT, CHANGED_BY, CHANGED_DT) VALUES ('REBI-M-0106200015', 'M', NULL, NULL, 'Reserve', 'Binning', '0', 'AMANAH.Yusup', '2020-06-01 00:00:00.000', 'AMANAH.Yusup', '2020-06-01 00:00:00.000');
  19. INSERT INTO SPEX_DB.spex.TB_M_BUCKET_TRANSFER (BT_NO, ZONE_CD, DEST_CD, TRANSP_CD, SOURCE, TARGET, STATUS, CREATED_BY, CREATED_DT, CHANGED_BY, CHANGED_DT) VALUES ('REBI-M-0106200016', 'M', NULL, NULL, 'Reserve', 'Binning', '0', 'AMANAH.Yusup', '2020-06-01 00:00:00.000', 'AMANAH.Yusup', '2020-06-01 00:00:00.000');
  20. INSERT INTO SPEX_DB.spex.TB_M_BUCKET_TRANSFER (BT_NO, ZONE_CD, DEST_CD, TRANSP_CD, SOURCE, TARGET, STATUS, CREATED_BY, CREATED_DT, CHANGED_BY, CHANGED_DT) VALUES ('REBI-M-0106200017', 'M', NULL, NULL, 'Reserve', 'Binning', '0', 'AMANAH.Yusup', '2020-06-01 00:00:00.000', 'AMANAH.Yusup', '2020-06-01 00:00:00.000');
  21. INSERT INTO SPEX_DB.spex.TB_M_BUCKET_TRANSFER (BT_NO, ZONE_CD, DEST_CD, TRANSP_CD, SOURCE, TARGET, STATUS, CREATED_BY, CREATED_DT, CHANGED_BY, CHANGED_DT) VALUES ('REBI-M-0106200018', 'M', NULL, NULL, 'Reserve', 'Binning', '0', 'AMANAH.Yusup', '2020-06-01 00:00:00.000', 'AMANAH.Yusup', '2020-06-01 00:00:00.000');
  22. INSERT INTO SPEX_DB.spex.TB_M_BUCKET_TRANSFER (BT_NO, ZONE_CD, DEST_CD, TRANSP_CD, SOURCE, TARGET, STATUS, CREATED_BY, CREATED_DT, CHANGED_BY, CHANGED_DT) VALUES ('REBI-M-0106200019', 'M', NULL, NULL, 'Reserve', 'Binning', '0', 'AMANAH.Yusup', '2020-06-01 00:00:00.000', 'AMANAH.Yusup', '2020-06-01 00:00:00.000');
  23. INSERT INTO SPEX_DB.spex.TB_M_BUCKET_TRANSFER (BT_NO, ZONE_CD, DEST_CD, TRANSP_CD, SOURCE, TARGET, STATUS, CREATED_BY, CREATED_DT, CHANGED_BY, CHANGED_DT) VALUES ('REBI-M-0106200020', 'M', NULL, NULL, 'Reserve', 'Binning', '0', 'AMANAH.Yusup', '2020-06-01 00:00:00.000', 'AMANAH.Yusup', '2020-06-01 00:00:00.000');
  24. INSERT INTO SPEX_DB.spex.TB_M_BUCKET_TRANSFER (BT_NO, ZONE_CD, DEST_CD, TRANSP_CD, SOURCE, TARGET, STATUS, CREATED_BY, CREATED_DT, CHANGED_BY, CHANGED_DT) VALUES ('REBI-M-0106200021', 'M', NULL, NULL, 'Reserve', 'Binning', '0', 'AMANAH.Yusup', '2020-06-01 00:00:00.000', 'AMANAH.Yusup', '2020-06-01 00:00:00.000');
  25. INSERT INTO SPEX_DB.spex.TB_M_BUCKET_TRANSFER (BT_NO, ZONE_CD, DEST_CD, TRANSP_CD, SOURCE, TARGET, STATUS, CREATED_BY, CREATED_DT, CHANGED_BY, CHANGED_DT) VALUES ('REBI-M-0106200022', 'M', NULL, NULL, 'Reserve', 'Binning', '0', 'AMANAH.Yusup', '2020-06-01 00:00:00.000', 'AMANAH.Yusup', '2020-06-01 00:00:00.000');
  26. INSERT INTO SPEX_DB.spex.TB_M_BUCKET_TRANSFER (BT_NO, ZONE_CD, DEST_CD, TRANSP_CD, SOURCE, TARGET, STATUS, CREATED_BY, CREATED_DT, CHANGED_BY, CHANGED_DT) VALUES ('REBI-M-0106200023', 'M', NULL, NULL, 'Reserve', 'Binning', '0', 'AMANAH.Yusup', '2020-06-01 00:00:00.000', 'AMANAH.Yusup', '2020-06-01 00:00:00.000');
  27. INSERT INTO SPEX_DB.spex.TB_M_BUCKET_TRANSFER (BT_NO, ZONE_CD, DEST_CD, TRANSP_CD, SOURCE, TARGET, STATUS, CREATED_BY, CREATED_DT, CHANGED_BY, CHANGED_DT) VALUES ('REBI-M-0106200024', 'M', NULL, NULL, 'Reserve', 'Binning', '0', 'AMANAH.Yusup', '2020-06-01 00:00:00.000', 'AMANAH.Yusup', '2020-06-01 00:00:00.000');
  28. INSERT INTO SPEX_DB.spex.TB_M_BUCKET_TRANSFER (BT_NO, ZONE_CD, DEST_CD, TRANSP_CD, SOURCE, TARGET, STATUS, CREATED_BY, CREATED_DT, CHANGED_BY, CHANGED_DT) VALUES ('REBI-M-0106200025', 'M', NULL, NULL, 'Reserve', 'Binning', '0', 'AMANAH.Yusup', '2020-06-01 00:00:00.000', 'AMANAH.Yusup', '2020-06-01 00:00:00.000');
  29. INSERT INTO SPEX_DB.spex.TB_M_BUCKET_TRANSFER (BT_NO, ZONE_CD, DEST_CD, TRANSP_CD, SOURCE, TARGET, STATUS, CREATED_BY, CREATED_DT, CHANGED_BY, CHANGED_DT) VALUES ('REBI-N-0106200001', 'N', NULL, NULL, 'Reserve', 'Binning', '0', 'AMANAH.Yusup', '2020-06-01 00:00:00.000', 'AMANAH.Yusup', '2020-06-01 00:00:00.000');
  30. INSERT INTO SPEX_DB.spex.TB_M_BUCKET_TRANSFER (BT_NO, ZONE_CD, DEST_CD, TRANSP_CD, SOURCE, TARGET, STATUS, CREATED_BY, CREATED_DT, CHANGED_BY, CHANGED_DT) VALUES ('REBI-N-0106200002', 'N', NULL, NULL, 'Reserve', 'Binning', '0', 'AMANAH.Yusup', '2020-06-01 00:00:00.000', 'AMANAH.Yusup', '2020-06-01 00:00:00.000');
  31. INSERT INTO SPEX_DB.spex.TB_M_BUCKET_TRANSFER (BT_NO, ZONE_CD, DEST_CD, TRANSP_CD, SOURCE, TARGET, STATUS, CREATED_BY, CREATED_DT, CHANGED_BY, CHANGED_DT) VALUES ('REBI-N-0106200003', 'N', NULL, NULL, 'Reserve', 'Binning', '0', 'AMANAH.Yusup', '2020-06-01 00:00:00.000', 'AMANAH.Yusup', '2020-06-01 00:00:00.000');
  32. INSERT INTO SPEX_DB.spex.TB_M_BUCKET_TRANSFER (BT_NO, ZONE_CD, DEST_CD, TRANSP_CD, SOURCE, TARGET, STATUS, CREATED_BY, CREATED_DT, CHANGED_BY, CHANGED_DT) VALUES ('REBI-N-0106200004', 'N', NULL, NULL, 'Reserve', 'Binning', '0', 'AMANAH.Yusup', '2020-06-01 00:00:00.000', 'AMANAH.Yusup', '2020-06-01 00:00:00.000');
  33. INSERT INTO SPEX_DB.spex.TB_M_BUCKET_TRANSFER (BT_NO, ZONE_CD, DEST_CD, TRANSP_CD, SOURCE, TARGET, STATUS, CREATED_BY, CREATED_DT, CHANGED_BY, CHANGED_DT) VALUES ('REBI-N-0106200005', 'N', NULL, NULL, 'Reserve', 'Binning', '0', 'AMANAH.Yusup', '2020-06-01 00:00:00.000', 'AMANAH.Yusup', '2020-06-01 00:00:00.000');
  34. INSERT INTO SPEX_DB.spex.TB_M_BUCKET_TRANSFER (BT_NO, ZONE_CD, DEST_CD, TRANSP_CD, SOURCE, TARGET, STATUS, CREATED_BY, CREATED_DT, CHANGED_BY, CHANGED_DT) VALUES ('REBI-S-0106200001', 'S', NULL, NULL, 'Reserve', 'Binning', '0', 'AMANAH.Yusup', '2020-06-01 00:00:00.000', 'AMANAH.Yusup', '2020-06-01 00:00:00.000');
  35. INSERT INTO SPEX_DB.spex.TB_M_BUCKET_TRANSFER (BT_NO, ZONE_CD, DEST_CD, TRANSP_CD, SOURCE, TARGET, STATUS, CREATED_BY, CREATED_DT, CHANGED_BY, CHANGED_DT) VALUES ('REBI-S-0106200002', 'S', NULL, NULL, 'Reserve', 'Binning', '0', 'AMANAH.Yusup', '2020-06-01 00:00:00.000', 'AMANAH.Yusup', '2020-06-01 00:00:00.000');
  36. INSERT INTO SPEX_DB.spex.TB_M_BUCKET_TRANSFER (BT_NO, ZONE_CD, DEST_CD, TRANSP_CD, SOURCE, TARGET, STATUS, CREATED_BY, CREATED_DT, CHANGED_BY, CHANGED_DT) VALUES ('REBI-S-0106200003', 'S', NULL, NULL, 'Reserve', 'Binning', '0', 'AMANAH.Yusup', '2020-06-01 00:00:00.000', 'AMANAH.Yusup', '2020-06-01 00:00:00.000');
  37. INSERT INTO SPEX_DB.spex.TB_M_BUCKET_TRANSFER (BT_NO, ZONE_CD, DEST_CD, TRANSP_CD, SOURCE, TARGET, STATUS, CREATED_BY, CREATED_DT, CHANGED_BY, CHANGED_DT) VALUES ('REBI-S-0106200004', 'S', NULL, NULL, 'Reserve', 'Binning', '0', 'AMANAH.Yusup', '2020-06-01 00:00:00.000', 'AMANAH.Yusup', '2020-06-01 00:00:00.000');
  38. INSERT INTO SPEX_DB.spex.TB_M_BUCKET_TRANSFER (BT_NO, ZONE_CD, DEST_CD, TRANSP_CD, SOURCE, TARGET, STATUS, CREATED_BY, CREATED_DT, CHANGED_BY, CHANGED_DT) VALUES ('REBI-S-0106200005', 'S', NULL, NULL, 'Reserve', 'Binning', '0', 'AMANAH.Yusup', '2020-06-01 00:00:00.000', 'AMANAH.Yusup', '2020-06-01 00:00:00.000');
  39. INSERT INTO SPEX_DB.spex.TB_M_BUCKET_TRANSFER (BT_NO, ZONE_CD, DEST_CD, TRANSP_CD, SOURCE, TARGET, STATUS, CREATED_BY, CREATED_DT, CHANGED_BY, CHANGED_DT) VALUES ('REBI-Y-0106200001', 'Y', NULL, NULL, 'Reserve', 'Binning', '0', 'AMANAH.Yusup', '2020-06-01 00:00:00.000', 'AMANAH.Yusup', '2020-06-01 00:00:00.000');
  40. INSERT INTO SPEX_DB.spex.TB_M_BUCKET_TRANSFER (BT_NO, ZONE_CD, DEST_CD, TRANSP_CD, SOURCE, TARGET, STATUS, CREATED_BY, CREATED_DT, CHANGED_BY, CHANGED_DT) VALUES ('REBI-Y-0106200002', 'Y', NULL, NULL, 'Reserve', 'Binning', '0', 'AMANAH.Yusup', '2020-06-01 00:00:00.000', 'AMANAH.Yusup', '2020-06-01 00:00:00.000');
  41. SELECT * FROM SPEX_DB.spex.TB_M_BUCKET_TRANSFER WHERE SOURCE = 'Reserve' AND TARGET = 'Binning'
  42.  
  43.  
  44. SELECT * FROM dbo.TB_R_REFILL WHERE PART_NO='21672BZ020B2' AND BT_NO='REBI-M-0106200001' AND (CREATED_BY='AMANAH.Yusup' OR CHANGED_BY='AMANAH.Yusup');
  45. SELECT * FROM spex.TB_R_PART_STOCK_INFO WHERE PART_NO='21672BZ020B2' AND CHANGED_BY='AMANAH.Yusup';
  46. SELECT * FROM spex.TB_R_BINNING WHERE PART_NO='21672BZ020B2' AND RACK_ADDRESS='M-UHTAR-002' AND LEFT([RACK_ADDRESS], 1)='M'
  47. SELECT * FROM spex.TB_T_BUCKET_TRANSFER WHERE BT_NO='REBI-M-0106200001'
  48. SELECT * FROM spex.TB_R_REPORT_PROBLEM WHERE PART_NO='21672BZ020B2' AND TYPE_PROBLEM=2
  49. SELECT * FROM spex.TB_R_BUCKET_TRANSFER_H WHERE BT_NO='REBI-M-0106200001' AND OPEN_BY='AMANAH.Yusup' AND CLOSE_BY IS NULL AND CLOSE_DT IS NULL
  50. SELECT * FROM spex.TB_R_BUCKET_TRANSFER_D WHERE TRANSFER_NO=(SELECT TB_R_BUCKET_TRANSFER_H.TRANSFER_NO FROM spex.TB_R_BUCKET_TRANSFER_H WHERE BT_NO='REBI-M-0106200001' AND OPEN_BY='AMANAH.Yusup' AND CLOSE_BY IS NULL AND CLOSE_DT IS NULL) AND PART_NO='21672BZ020B2'
  51. SELECT * FROM spex.TB_R_STOCK_CARD WHERE PART_NO='21672BZ020B2' AND FLAG='0'
  52.  
  53. -- SOH=1094, SOR=1075, SONDR=20
  54. SELECT * FROM dbo.TB_R_REFILL WHERE PART_NO='48510bzd00' AND BT_NO='REBI-N-0106200001' AND (CREATED_BY='AMANAH.Yusup' OR CHANGED_BY='AMANAH.Yusup');
  55. SELECT * FROM spex.TB_R_PART_STOCK_INFO WHERE PART_NO='48510bzd00' --AND CHANGED_BY='AMANAH.Yusup';
  56. SELECT * FROM spex.TB_R_BINNING WHERE PART_NO='48510bzd00' --AND RACK_ADDRESS='N-UNDUTANTUNDUH-001' AND LEFT([RACK_ADDRESS], 1)='N'
  57. SELECT * FROM spex.TB_T_BUCKET_TRANSFER WHERE BT_NO='REBI-N-0106200001'
  58. SELECT * FROM spex.TB_R_REPORT_PROBLEM WHERE PART_NO='48510bzd00' AND TYPE_PROBLEM=2
  59. SELECT * FROM spex.TB_R_BUCKET_TRANSFER_H WHERE BT_NO='REBI-N-0106200001' AND OPEN_BY='AMANAH.Yusup'
  60. SELECT * FROM spex.TB_R_BUCKET_TRANSFER_D WHERE TRANSFER_NO=(SELECT TB_R_BUCKET_TRANSFER_H.TRANSFER_NO FROM spex.TB_R_BUCKET_TRANSFER_H WHERE BT_NO='REBI-N-0106200001' AND OPEN_BY='AMANAH.Yusup') AND PART_NO='48510bzd00'
  61. SELECT * FROM spex.TB_R_STOCK_CARD WHERE PART_NO='48510bzd00' AND FLAG='0' AND CHANGED_BY='AMANAH.Yusup'
  62.  
  63.  
  64. SELECT * FROM spex.TB_R_PART_STOCK_INFO WHERE PART_NO='16572BZ270' AND CHANGED_BY='AMANAH.Yusup';
  65. SELECT * FROM spex.TB_R_BINNING WHERE PART_NO='16572BZ270' AND RACK_ADDRESS='M-UTAN-001' AND LEFT([RACK_ADDRESS], 1)='M'
  66. SELECT A.QTY, END_STOCK
  67. FROM spex.TB_R_STOCK_CARD A
  68.     JOIN spex.TB_R_PART_STOCK_INFO B ON A.PART_NO = B.PART_NO
  69.     WHERE A.PART_NO='16572BZ270'
  70.     AND CONVERT ( DATE, [DATE] ) = CONVERT ( DATE, CURRENT_TIMESTAMP )
  71.     AND A.FLAG='0'
  72.  
  73.  
  74. SELECT * FROM spex.TB_R_BUCKET_TRANSFER_H ORDER BY CREATED_DT DESC
  75.  
  76. SELECT * FROM spex.TB_M_RESERVE_NON_DIRECT
  77. SELECT * FROM spex.TB_R_BUCKET_TRANSFER_H WHERE TRANSFER_NO = 'TR2020041300001'
  78. SELECT * FROM spex.TB_R_BUCKET_TRANSFER_D WHERE TRANSFER_NO = 'TR2020041300001'
  79.  
  80. SELECT x.* FROM (
  81.     SELECT a.ZONE_CD AS ZONE, 0 AS STATUS FROM spex.TB_M_ZONE a WHERE a.ZONE_CD NOT IN (
  82.         SELECT a.ZONE_CD
  83.         FROM spex.TB_M_ZONE a
  84.             LEFT JOIN spex.TB_M_PART_STOCK b
  85.                 ON a.ZONE_CD = LEFT(b.RACK_ADDRESS_CD, 1)
  86.             INNER JOIN spex.TB_M_RESERVE_NON_DIRECT c ON b.PART_NO = c.PART_NO
  87.     )
  88.     UNION
  89.     SELECT a.ZONE_CD, 1 AS STATUS
  90.     FROM spex.TB_M_ZONE a
  91.         LEFT JOIN spex.TB_M_PART_STOCK b
  92.             ON a.ZONE_CD = LEFT(b.RACK_ADDRESS_CD, 1)
  93.         INNER JOIN spex.TB_M_RESERVE_NON_DIRECT c ON b.PART_NO = c.PART_NO
  94. ) x ORDER BY x.ZONE ASC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!