DBA Data[Home] [Help]

VIEW: APPS.BSC_D_BSC_PER_CAL1_PER4_V

Source

View Text - Preformatted

SELECT DISTINCT  DECODE( TO_CHAR(ID) , TO_CHAR(0) , TO_CHAR(-99999999) , TO_CHAR(ID)) , TO_CHAR(ID) , VALUE FROM BSC_P_BSC_PER_CAL1_PER4_V
View Text - HTML Formatted

SELECT DISTINCT DECODE( TO_CHAR(ID)
, TO_CHAR(0)
, TO_CHAR(-99999999)
, TO_CHAR(ID))
, TO_CHAR(ID)
, VALUE
FROM BSC_P_BSC_PER_CAL1_PER4_V