You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

INSERT ORDER RELEASE REFNUM AFTER SHIPMENT CREATED

in Transportation Management 9 comments

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'

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!