BBC.SHARED.VARA@SEC_SQLI.LIST-OBJECT-TEMPLATES

Summary

Object type
VARA
Object Folder
PACKAGES/BEST-BLU/BBC.SHARED/SOURCE/LISTING
Title
Returns a list of object templates
Archive Key 1
-
Archive Key 2
-
Created
WRITER/B4A am: 2022-02-28 14:47:17
Last Modified
WRITER/B4A am: 2024-01-09 09:57:40 18 x
Last Used
-

SQL

Statement (MS SQL)
SELECT OVW_VValue AS “Name”, OVW_Value1 AS “Object” FROM OH RIGHT OUTER JOIN OVW ON OH_IdNr = OVW_OH_IdNr WHERE OH_Name = ‘UC_OBJECT_TEMPLATE’ AND OH_Client = ? AND OH_DeleteFlag = 0
Statement (Oracle)
SELECT OVW_VValue AS “Name”, OVW_Value1 AS “Object” FROM OH RIGHT OUTER JOIN OVW ON OH_IdNr = OVW_OH_IdNr WHERE OH_Name = ‘UC_OBJECT_TEMPLATE’ AND OH_Client = ? AND OH_DeleteFlag = 0
Result Format

Bind Parameters

Number Parameter
1 &$CLIENT#

Attributes

Data & Formatting

Data Type
TEXT
Force Upper Case

Script Access

If key not found
INITIAL_VALUES