Unreleased / Partially released Order Base Saved Condition

[vsevs]

Hi,
Can anybody help me in creating a saved condtion for unreleased or partially released order base?

Thanks,
Venkat.

[smpainter]

Re: Unreleased / Partially released Order Base Saved Condition

Would "Select 'Y' from ob_order_base where
IS_FULLY_RELEASED='N' " work?

[vsevs]

Re: Unreleased / Partially released Order Base Saved Condition

Hi,
Thank you for your information. But i could see the flag FULLY_RELEASED is not enabled for order bases which are completely released. Infact, none of my order bases or having the FULLY RELEASED flag enabled though many of the order bases released completely. So in this case if i write a query based on this, it gives all the order bases in the result.

Thanks,
Venkat.

[vsevs]

Re: Unreleased / Partially released Order Base Saved Condition

Can anyone help me on this?

[uppiliyappan]

Re: Unreleased / Partially released Order Base Saved Condition

Hi VSEVS

Just add the below two saved conditions because any one of this is a possible condition for partial release or not released.

Condition 1: SELECT ORDER_BASE_GID FROM OB_SHIP_UNIT OBS WHERE
OBS.SHIP_UNIT_COUNT <> OBS.RELEASED_COUNT;

Condition 2: SELECT ORDER_BASE_GID FROM OB_LINE OBL WHERE OBL.PACKAGED_COUNT <> OBL.RELEASED_COUNT

First one checks if no.of ship units in the order base is equal to released shipunit count. If this is not equal implies it is partially released or not released.

Second one checks if no of total packaged item(line item) is equal to released packaged count. If this is not equal implies it is partially released or not released.

If any one of these two conditions are true then its a partially or not released order base. Hope am clear.

Revert back if any clarification required

[uppiliyappan]

Re: Unreleased / Partially released Order Base Saved Condition

The above will fetch the Order bases which are over release also. To avoid them use the below

a) SELECT ORDER_BASE_GID FROM OB_SHIP_UNIT OBS WHERE
OBS.SHIP_UNIT_COUNT < OBS.RELEASED_COUNT;

b) SELECT ORDER_BASE_GID FROM OB_LINE OBL WHERE
OBL.PACKAGEDCOUNT < OBL.RELEASED_COUNT;