INSERT ORDER RELEASE REFNUM AFTER SHIPMENT CREATED
HI, WE TRY TO CREATE ORDER RELEASE REFNUM AFTER SHIPMENT CREATED USING DSU BUT SOMEHOW IT DIDNT WORK
INSERT INTO ORDER_RELEASE_REFNUM ( ORDER_RELEASE_GID, ORDER_RELEASE_REFNUM_QUAL_GID, ORDER_RELEASE_REFNUM_VALUE, DOMAIN_NAME ) SELECT ORR.ORDER_RELEASE_GID ORDER_RELEASE_GID, 'PL.TIER' ORDER_RELEASE_REFNUM_QUAL_GID, CASE WHEN NVL(SHP.TOTAL_VOLUME, 0) BETWEEN 1 AND 1000 THEN 'TIER 1'WHEN NVL(SHP.TOTAL_VOLUME, 0) BETWEEN 1001 AND 2500 THEN 'TIER 2' WHEN NVL(SHP.TOTAL_VOLUME, 0) BETWEEN 2501 AND 4000 THEN 'TIER 3'WHEN NVL(SHP.TOTAL_VOLUME, 0) BETWEEN 4001 AND 8000 THEN 'TIER 4' WHEN NVL(SHP.TOTAL_VOLUME, 0) BETWEEN 8001 AND 12000 THEN 'TIER 5' WHEN NVL(SHP.TOTAL_VOLUME, 0) BETWEEN 12001 AND 16000 THEN 'TIER 6' WHEN NVL(SHP.TOTAL_VOLUME, 0) > 16001 THEN 'TIER 7'