Fonction DECODE ne fonctionne pas
Bonjour,
La fonction DECODE de mon code ne fonctionne pas.
voici ce que j'ai écrit (sans la fonction decode, ça me rapporte les bonnes valeurs) :
Code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
| SELECT DISTINCT
ooh.order_number "N° commande"
, ool.ordered_item "article"
, msn.current_subinventory_code "stock"
, DECODE(mil.segment1,RC,'Reception',TR,'Triage') "poste de travail"
FROM oe_order_headers_all ooh
LEFT JOIN oe_order_lines_all ool ON ooh.header_id = ool.header_id
INNER JOIN mtl_serial_numbers msn ON msn.serial_number = to_char(ooh.order_number)
LEFT OUTER JOIN mtl_item_locations mil ON mil.inventory_location_id = msn.current_locator_id
WHERE ooh.order_type_id = 3435
AND ooh.org_id = 119
AND ooh.flow_status_code IN ('BOOKED','ENTERED')
AND msn.current_subinventory_code IN ('PRODUCTION','LOGISTIQUE')
AND (ool.creation_date) >= to_date ('25/10/2010', 'DD/MM/YYYY'); |
code qui fonctionne :
Code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
| SELECT DISTINCT
ooh.order_number "N° commande"
, ool.ordered_item "article"
, msn.current_subinventory_code "stock"
, mil.segment1 "poste de travail"
FROM oe_order_headers_all ooh
LEFT JOIN oe_order_lines_all ool ON ooh.header_id = ool.header_id
INNER JOIN mtl_serial_numbers msn ON msn.serial_number = to_char(ooh.order_number)
LEFT OUTER JOIN mtl_item_locations mil ON mil.inventory_location_id = msn.current_locator_id
WHERE ooh.order_type_id = 3435
AND ooh.org_id = 119
AND ooh.flow_status_code IN ('BOOKED','ENTERED')
AND msn.current_subinventory_code IN ('PRODUCTION','LOGISTIQUE')
AND (ool.creation_date) >= to_date ('25/10/2010', 'DD/MM/YYYY') |
Pouvez-vous m'aider?
Merci,
Douchka
