SQLDepot

2 queries found for "Business Object Status Language"

Retrieve Business Object Status - Generic

SELECT OB.BUS_OBJ_CD,  OB.BO_STATUS_CD, SL.DESCR
 FROM F1_BUS_OBJ_STATUS OB,
      F1_BUS_OBJ_STATUS_L SL
WHERE OB.BUS_OBJ_CD = :INSERT_BO_TYPE_HERE
AND OB.BUS_OBJ_CD = SL.BUS_OBJ_CD 
AND OB.BO_STATUS_CD = SL.BO_STATUS_CD
AND SL.LANGUAGE_CD = :INSERT_LANGUAGE_HERE
uploaded by Nuno Rodrigues

Activity Type List

SELECT AT.AM_ACTIVITY_TYPE_CD, BOS.DESCR AS STATDESCR
  FROM CI_AM_ACTIVITY_TYPE AT, F1_BUS_OBJ_STATUS_L BOS
 WHERE 
   BOS.BUS_OBJ_CD = AT.BUS_OBJ_CD
   AND BOS.LANGUAGE_CD = :INSERT_LANGUAGE_HERE
   AND BOS.BO_STATUS_CD = AT.BO_STATUS_CD
uploaded by Nuno Rodrigues