Oracle eBS經驗分享

Write assign item sql at POST-QUERY trigger( block level).

<example>

select name
into  :CHARGE_SET.FREIGHT_COST_TYPE-- (Non-DB item)
from wsh_freight_cost_types_v
where FREIGHT_COST_TYPE_ID=:CHARGE_SET.FREIGHT_COST_TYPE_ID;

After the assignment sql, we need to change the valiation property to flase.

POST-QUERY trigger( block level).

set_item_property('CHARGE_SET.FREIGHT_COST_TYPE',VALIDATE_FROM_LIST, property_false);

WHEN-NEW-RECORD-INSTANCE(Block Level)

set_item_property('CHARGE_SET.FREIGHT_COST_TYPE',VALIDATE_FROM_LIST, property_true);

Or you will get save message after each execute_query.

FRAME_HORZ_LINE

FRAME_RECT

wms_license_plate_numbers.lpn_context

Code    meaning
1    In Inventory
3    In Receiving
4    Issued out of store
5    Defined but not used
6    Intransit
8    Packing context
11    Picked

Window Style

Most application windows appear inside the MDI window ("Document" style) except dialogs and the Folder tool palette ("Dialog" style).

Size

Guidelines and limits for window size are as follows:

• The maximum window size is 10.3"" (width) x 6.25" (height), to support an 1024x768 screen resolution.

• The minimum size of a window is 2" x 2." (OMS-73016)

• A window may be drawn any size between the maximum and minimum, with the following recommendations (OMS-73017):

  • Make windows only as large as is necessary.

  • Make non-modal windows within a form approximately the same size.

  • Make modal windows smaller than the non-modal windows that invoke them.

• Reference =>http://docs.oracle.com/cd/E18727_01/doc.121/e12900/T458979T458985.htm