VIEW: APPS.PAYBV_PAYMENT_TYPE_V

Source

View Text - Preformatted

SELECT hr_bis.bis_decode_lookup('PAYMENT_CATEGORY',PT.CATEGORY) CATEGORY_M , TL.PAYMENT_TYPE_NAME , TL.DESCRIPTION , PT.ALLOW_AS_DEFAULT , PT.PRE_VALIDATION_REQUIRED , PT.PROCEDURE_NAME , PT.VALIDATION_DAYS , PT.VALIDATION_VALUE , PT.RECONCILIATION_FUNCTION , PT.CATEGORY , PT.PAYMENT_TYPE_ID , PT.TERRITORY_CODE , PT.CURRENCY_CODE , PT.LAST_UPDATE_DATE , PT.LAST_UPDATED_BY , PT.LAST_UPDATE_LOGIN , PT.CREATED_BY , PT.CREATION_DATE FROM PAY_PAYMENT_TYPES PT , PAY_PAYMENT_TYPES_TL TL WHERE PT.PAYMENT_TYPE_ID = TL.PAYMENT_TYPE_ID AND TL.LANGUAGE = userenv('LANG') WITH READ ONLY

View Text - HTML Formatted

SELECT HR_BIS.BIS_DECODE_LOOKUP('PAYMENT_CATEGORY'
, PT.CATEGORY) CATEGORY_M
, TL.PAYMENT_TYPE_NAME
, TL.DESCRIPTION
, PT.ALLOW_AS_DEFAULT
, PT.PRE_VALIDATION_REQUIRED
, PT.PROCEDURE_NAME
, PT.VALIDATION_DAYS
, PT.VALIDATION_VALUE
, PT.RECONCILIATION_FUNCTION
, PT.CATEGORY
, PT.PAYMENT_TYPE_ID
, PT.TERRITORY_CODE
, PT.CURRENCY_CODE
, PT.LAST_UPDATE_DATE
, PT.LAST_UPDATED_BY
, PT.LAST_UPDATE_LOGIN
, PT.CREATED_BY
, PT.CREATION_DATE
FROM PAY_PAYMENT_TYPES PT
, PAY_PAYMENT_TYPES_TL TL
WHERE PT.PAYMENT_TYPE_ID = TL.PAYMENT_TYPE_ID
AND TL.LANGUAGE = USERENV('LANG') WITH READ ONLY