SELECT uommaster.UM_CODE, /*regular attributes*/ uommaster.UM_DESC, uommaster.STD_FACTOR, uommaster.RND_FACTOR, uommaster.REF_UM, uommaster.UM_TYPE, /*ID*/ uommaster.CREATED_BY, /*WHO*/ uommaster.CREATION_DATE, uommaster.LAST_UPDATE_DATE, uommaster.LAST_UPDATED_BY FROM sy_uoms_mst uommaster WHERE uommaster.delete_mark = 0 with read only
SELECT UOMMASTER.UM_CODE
, /*REGULAR ATTRIBUTES*/ UOMMASTER.UM_DESC
, UOMMASTER.STD_FACTOR
, UOMMASTER.RND_FACTOR
, UOMMASTER.REF_UM
, UOMMASTER.UM_TYPE
, /*ID*/ UOMMASTER.CREATED_BY
, /*WHO*/ UOMMASTER.CREATION_DATE
, UOMMASTER.LAST_UPDATE_DATE
, UOMMASTER.LAST_UPDATED_BY
FROM SY_UOMS_MST UOMMASTER
WHERE UOMMASTER.DELETE_MARK = 0 WITH READ ONLY
|
|
|