SELECT 'REVENUE' , pa_bis_messages.get_message('PA','PA_BIS_AMT_TYPE_LABEL_REV') , pa_bis_messages.get_message('PA','PA_BIS_AMT_TYPE_LABEL_REV') FROM dual UNION SELECT 'COST' , pa_bis_messages.get_message('PA','PA_BIS_AMT_TYPE_LABEL_COST') , pa_bis_messages.get_message('PA','PA_BIS_AMT_TYPE_LABEL_COST') FROM dual
SELECT 'REVENUE'
, PA_BIS_MESSAGES.GET_MESSAGE('PA'
, 'PA_BIS_AMT_TYPE_LABEL_REV')
, PA_BIS_MESSAGES.GET_MESSAGE('PA'
, 'PA_BIS_AMT_TYPE_LABEL_REV')
FROM DUAL UNION SELECT 'COST'
, PA_BIS_MESSAGES.GET_MESSAGE('PA'
, 'PA_BIS_AMT_TYPE_LABEL_COST')
, PA_BIS_MESSAGES.GET_MESSAGE('PA'
, 'PA_BIS_AMT_TYPE_LABEL_COST')
FROM DUAL
|
|
|