How to restrict to user Batch detail updation.

[MD1]

Hi All,

How to restrict to user Batch detail updation.

Thanks

Danish

[MD1]

help on this

[narayanis]

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

Regards

[MD1]

Sir through transaction notification

[MD1]

---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;