Labels

[ALRT] (3) [AR] (2) [BOM] (3) [GL] (2) [GTM] (1) [INV] (18) [MRP] (1) [OM] (27) [PO] (58) [QP] (3) [SYS] (39) [WIP] (4) AGIS (1) OM (1)

Friday, December 24, 2010

[SYS] Form Personalizations - Setting Property Value by Calling a SQL Query

Can be done.

Enter the value as below:
=(SELECT AGENT_ID FROM PO_HEADERS_ALL WHERE SEGMENT1=:RCV_TRANSACTION.PO_NUMBER)

:RCV_TRANSACTION.PO_NUMBER is a Target Object ("Item" Type) name, which you can refer after you clicked on "Insert Item Value..." button. It can also be found under Target ObjectLOV with Object Type "Item".

No comments:

Post a Comment