TRIGGER: APPS.MTL_SERIAL_NUMBERS_AIU

Source

Description

MTL_SERIAL_NUMBERS_AIU
/* $Header: invmsntr.sql 115.0 2002/01/14 10:26:23 pkm ship     $ */

BEFORE   INSERT
      OR UPDATE OF status_id
      ON MTL_SERIAL_NUMBERS
FOR EACH ROW

Type

BEFORE EACH ROW

Event

INSERT OR UPDATE

Column

When

new.status_id is NULL

Referencing

REFERENCING NEW AS NEW OLD AS OLD

Body

BEGIN
   :new.status_id := inv_globals.g_material_status_active;
END MTL_SERIAL_NUMBERS_AIU;