POXPOEPO - PO_LINES: system item LOV / system item

[mohammedahmed1966]

Hi All,

To elaborate, I am trying to do some customizatiosn on form POXPOEPO. block PO_LINES and item is po_lines_item_number which is beside field 'Type' (line_type). when the three dots are pressed then a window appears to input 'enter reduction criteria for long list' when the percentage is pressed 'System Items' find window appears listing all the items defined. what i want the this window to display only those items for which item_type = 'Assets' on MTL_system_items and 'user item type' on 'master item' definition window tab 'main'.

What is the way to achieve this.

i did like this but it is not working:

procedure event(event_name varchar2) is
form_name varchar2(30) := name_in('system.current_form');
block_name varchar2(30) := name_in('system.cursor_block');
item_name varchar2(60) := name_in('system.cursor_item');
begin
FND_MESSAGE.SET_STRING('form name='||form_name||' Block='||block_name||' item='||item_name);
fnd_message.show;
if (event_name = 'WHEN-NEW-FORM-INSTANCE') then
if (form_name='POXPOEPO') then
if (block_name='PO_LINES') then
fnd_key_flex.update_definition(
BLOCK=>'PO_LINES',
FIELD=>'PO_LINES.ITEM_NUMBER',
WHERE_CLAUSE=>'item_type = "Consums"'
);
end if;
end if;
else
null;
end if;
end event;

any guidance in this regard is appreciated.

PS: nav: purchasing super user->purchase orders->purchase orders