Archive for the 'Uncategorized' Category

Tip

uc se a budes chytrejsi

LookupValues

escript
  var sStatusCompleted = TheApplication().InvokeMethod("LookupValue", "FS_ORDER_STATUS", "Completed");
searchspec
  [Order Type] <> LookupValue ("FS_ORDER_TYPE", "Bulk Request Template Order")
Field predefault value
  Expr: 'LookupValue("LS_MED_AE_TYPE", "Product Problem Device")'

workflow condition
(ABO Bulk Request Action Set All Must Match (Ignore Case)('[&Action Set Type] = LookupValue('ABO_BR_ACTSET_TYPE','MNP Port In') OR [&Action Set Type] = LookupValue('ABO_BR_ACTSET_TYPE','MNP Port In - PacId per Order')'))

SQL
select * from siebel.s_lst_of_val
	   where type = 'ABO_BR_SUBMIT_STATUS'

Useful selects

Oracle database version: select * from v$version

Oracle characterset: select value from v$nls_parameters where parameter=’NLS_CHARACTERSET’