| Custom Code for PO Relases [message #166784] |
Sat, 08 April 2006 07:37 |
sultanmasood
Messages: 11
Registered: March 2006
|
Junior Member |
|
|
Hi,
Trying to copy the value of "Ship-To" in the PO releases form to "Deliver To" in the Distribution Form.
The code is not firing. Any idea.
if (event_name = 'WHEN–NEW–RECORD–INSTANCE')then
if form_name = 'POXPOERL' then
declare
v_loc_code varchar2(100);
begin
if block_name = 'PO_DISTRIBUTIONS' then
v_loc_code:=name_in('PO_SHIPMENTS.SHIP_TO_LOCATION_CODE');
copy(v_loc_code,'PO_DISTRIBUTIONS.DELIVER_TO_LOCATION');
else
null;
end if;
end;
else
null;
end if;
else
null;
end if;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
