Announcement

Collapse
No announcement yet.

Unreleased / Partially released Order Base Saved Condition

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Unreleased / Partially released Order Base Saved Condition

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

    Thanks,
    Venkat.

  • #2
    Re: Unreleased / Partially released Order Base Saved Condition

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

    Comment


    • #3
      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.

      Comment


      • #4
        Re: Unreleased / Partially released Order Base Saved Condition

        Can anyone help me on this?

        Comment


        • #5
          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

          Comment


          • #6
            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;

            Comment

            Working...
            X