SELECT pptT.PAYMENT_TYPE_NAME ,ppt.PAYMENT_TYPE_ID ,pptT.PAYMENT_TYPE_NAME order_by FROM pay_payment_types ppt ,pay_payment_types_tl pptT WHERE ppt.payment_type_id = pptT.payment_type_id and pptT.language = userenv('LANG') UNION ALL SELECT null ,-1 ,' ' order_by FROM dual WITH READ ONLY
SELECT PPTT.PAYMENT_TYPE_NAME
, PPT.PAYMENT_TYPE_ID
, PPTT.PAYMENT_TYPE_NAME ORDER_BY
FROM PAY_PAYMENT_TYPES PPT
, PAY_PAYMENT_TYPES_TL PPTT
WHERE PPT.PAYMENT_TYPE_ID = PPTT.PAYMENT_TYPE_ID
AND PPTT.LANGUAGE = USERENV('LANG') UNION ALL SELECT NULL
, -1
, ' ' ORDER_BY
FROM DUAL WITH READ ONLY
|
|
|