查询库存现有量的SQL查询语句

flashbaby

各位今天我在进行库存现有量查询的时候，检查了一下系统所用的查询语句，不太清楚的是条件之中有： WHERE 1 = 0
这样的语句，请问出现这样的条件有什么原因吗？

1. SELECT ORGANIZATION_ID,
   
2. ORGANIZATION_CODE,
   
3. SUBINVENTORY_CODE,
   
4. LOCATOR_ID,
   
5. LOCATOR,
   
6. PROJECT_ID,
   
7. TASK_ID,
   
8. INVENTORY_ITEM_ID,
   
9. ITEM_DESCRIPTION,
   
10. ITEM,
    
11. UOM,
    
12. REVISION,
    
13. ON_HAND,
    
14. UNPACKED,
    
15. PACKED,
    
16. COST_GROUP_ID,
    
17. LPN_ID,
    
18. LPN,
    
19. LOT_NUMBER,
    
20. SERIAL_NUMBER,
    
21. UNIT_NUMBER,
    
22. PLANNING_ORGANIZATION_ID,
    
23. PLANNING_TP_TYPE,
    
24. OWNING_ORGANIZATION_ID,
    
25. OWNING_TP_TYPE,
    
26. SUBINVENTORY_STATUS_ID,
    
27. LPN_CONTEXT,
    
28. ITEM_LOT_CONTROL,
    
29. ITEM_SERIAL_CONTROL
    
30. FROM MTL_ONHAND_DUMMY_V
    
31. WHERE 1 = 0
    
32. UNION ALL
    
33. SELECT organization_id,
    
34. organization_code,
    
35. to_char(null) subinventory_code,
    
36. to_number(null) locator_id,
    
37. to_char(null) locator,
    
38. to_number(null) project_id,
    
39. to_number(null) task_id,
    
40. inventory_item_id,
    
41. item_description,
    
42. item,
    
43. uom,
    
44. to_char(null) revision,
    
45. sum(on_hand) on_hand,
    
46. sum(unpacked) unpacked,
    
47. sum(packed) packed,
    
48. to_number(null) cost_group_id,
    
49. to_number(null) lpn_id,
    
50. to_char(null) lpn,
    
51. to_char(null) lot_number,
    
52. to_char(null) serial_number,
    
53. to_char(null) unit_number,
    
54. planning_organization_id,
    
55. planning_tp_type,
    
56. owning_organization_id,
    
57. owning_tp_type,
    
58. to_number(null) status_id,
    
59. to_number(null) lpn_context,
    
60. item_lot_control,
    
61. item_serial_control
    
62. FROM MTL_ONHAND_TOTAL_MWB_V
    
63. WHERE 1 = 1
    
64. AND inventory_item_id = '966660'
    
65. AND organization_id = '143'
    
66. GROUP BY organization_id,
    
67. organization_code,
    
68. inventory_item_id,
    
69. item_description,
    
70. item,
    
71. uom,
    
72. planning_organization_id,
    
73. planning_tp_type,
    
74. owning_organization_id,
    
75. owning_tp_type,
    
76. item_lot_control,
    
77. item_serial_control
    
78. HAVING 1 = 1
    
79. UNION ALL
    
80. SELECT organization_id,
    
81. organization_code,
    
82. subinventory_code,
    
83. locator_id,
    
84. locator,
    
85. project_id,
    
86. task_id,
    
87. inventory_item_id,
    
88. item_description,
    
89. item,
    
90. uom,
    
91. revision,
    
92. on_hand,
    
93. unpacked,
    
94. packed,
    
95. cost_group_id,
    
96. lpn_id,
    
97. lpn,
    
98. lot_number,
    
99. serial_number,
    
100. unit_number,
     
101. planning_organization_id,
     
102. planning_tp_type,
     
103. owning_organization_id,
     
104. owning_tp_type,
     
105. subinventory_status_id,
     
106. lpn_context,
     
107. item_lot_control,
     
108. item_serial_control
     
109. FROM mtl_onhand_dummy_v
     
110. WHERE 1 = 0
     
111. order by ITEM, ORGANIZATION_ID, SUBINVENTORY_CODE, LOCATOR
     

复制代码

tsai1021

GOOD~~ 推~~

meng_xia_xue

where 1=0 是個羅輯判斷呀，結果是沒有任何記錄。

qishunyong

可以看成是sql语句的开关

fugelong

相当于逻辑判断结果=false

terran_wang

4楼说的没错,就是开关语句,直接加上这句SQL就等于停掉,什么也找不到,我自己的程式有时也会这样做.

tsai1021

good  ~~   ^^

molwang

常见的还有WHERE 1=1 呢，一些程序里查询里为拼接SQL语句用。

xhdxhd

加上where 1=0 或1=1 在写程序的时候方便添加条件。

sysoracle

{:soso_e100:}

纵横四海

参考表　mtl_onhand_quantities

yanwei82123300

GOOD~~ 推~~

EBS_ledger

SELECT msk.concatenated_segments AS 物料编码,
       msk.description AS 物料描述,
       msk.primary_unit_of_measure AS 单位,
       ood.organization_name AS 库存组织,
       msi.secondary_inventory_name AS 子库,
       mlk.concatenated_segments AS 货位,
       moq.lot_number AS 批次,
       SUM(moq.primary_transaction_quantity) AS 数量
  FROM mtl_onhand_quantities_detail moq,
       mtl_system_items_kfv         msk,
       org_organization_definitions ood,
       mtl_secondary_inventories    msi,
       mtl_item_locations_kfv       mlk
WHERE moq.inventory_item_id = msk.inventory_item_id
   AND moq.organization_id = msk.organization_id
   AND moq.organization_id = ood.organization_id
   AND moq.subinventory_code = msi.secondary_inventory_name
   AND msk.serial_number_control_code = 1
   AND moq.locator_id = mlk.inventory_location_id(+)

Star_2122

where 1=1经常用
where 1=0没用过

dohia2010

1=0 false
1=1经常用的 查现有量ONhead就可以吧。。。。

gf_jack

学习中。。。