"APPS"."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 "INV"."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;