Skip to Content

How to restrict to user Batch detail updation.

Hi All,

How to restrict to user Batch detail updation.

Thanks

Danish

cbgl5.png (188.6 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Oct 07, 2017 at 08:57 AM

    there is an authorization --> Batch Details. Set it to "No Authorization"

    Regards

    Add comment
    10|10000 characters needed characters exceeded

    • ---Ist
      IF :object_type = '10000044' THEN
      Declare temp_var_0 integer;
      SELECT
      (SELECT Count (*)
      FROM OBTN T0
      WHERE T0."AbsEntry" <> :list_of_cols_val_tab_del AND T0."LotNumber" =
      (SELECT TOP 1 "LotNumber"
      FROM OBTN
      WHERE "AbsEntry" = :list_of_cols_val_tab_del )) INTO temp_var_0 FROM DUMMY;
      IF :temp_var_0 > 0 THEN
      SELECT 1, 'Duplicate AR Not Allowed!' INTO error, error_message FROM DUMMY;
      END IF;
      END IF;

      ----IInd
      IF :Object_Type = '10000044' THEN
      Declare temp_VVvar_0 integer;
      SELECT
      (SELECT "AbsEntry"
      FROM OBTN B
      WHERE ("LotNumber" <>
      (SELECT "LotNumber"
      FROM ABTN C
      WHERE ("LogInstanc" =
      (SELECT COUNT("LogInstanc") AS "Expr1"
      FROM ABTN A
      WHERE ("AbsEntry" = C."AbsEntry"))) AND ("AbsEntry" = B."AbsEntry"))) AND ("AbsEntry" = :list_of_cols_val_tab_del)) INTO temp_VVvar_0 FROM DUMMY;
      IF :temp_VVvar_0 > 0 THEN
      error := 406;
      error_message := 'U R Not Auth. to change ';
      END IF;
      END IF;