VIEW: APPS.PAY_PAYMENT_TYPES_V

Source

View Text - Preformatted

SELECT PT.ROWID ROW_ID , PT.PAYMENT_TYPE_ID , PT.TERRITORY_CODE , PT.CURRENCY_CODE , PT.CATEGORY , PTTL.PAYMENT_TYPE_NAME , PT.PAYMENT_TYPE_NAME base_payment_type_name , PT.ALLOW_AS_DEFAULT , PTTL.DESCRIPTION , PT.PRE_VALIDATION_REQUIRED , PT.PROCEDURE_NAME , PT.VALIDATION_DAYS , PT.VALIDATION_VALUE , PT.LAST_UPDATE_DATE , PT.LAST_UPDATED_BY , PT.LAST_UPDATE_LOGIN , PT.CREATED_BY , PT.CREATION_DATE , TERR.TERRITORY_SHORT_NAME , CURR.NAME , HR.MEANING D_CATEGORY FROM PAY_PAYMENT_TYPES PT, PAY_PAYMENT_TYPES_TL PTTL, FND_TERRITORIES_VL TERR, FND_CURRENCIES_VL CURR, HR_LOOKUPS HR WHERE PT.payment_type_id = PTTL.payment_type_id AND PTTL.LANGUAGE = userenv('LANG') AND PT.TERRITORY_CODE = TERR.TERRITORY_CODE(+) AND PT.CURRENCY_CODE = CURR.CURRENCY_CODE(+) AND PT.CATEGORY = HR.LOOKUP_CODE AND HR.LOOKUP_TYPE = 'PAYMENT_CATEGORY'

View Text - HTML Formatted

SELECT PT.ROWID ROW_ID
, PT.PAYMENT_TYPE_ID
, PT.TERRITORY_CODE
, PT.CURRENCY_CODE
, PT.CATEGORY
, PTTL.PAYMENT_TYPE_NAME
, PT.PAYMENT_TYPE_NAME BASE_PAYMENT_TYPE_NAME
, PT.ALLOW_AS_DEFAULT
, PTTL.DESCRIPTION
, PT.PRE_VALIDATION_REQUIRED
, PT.PROCEDURE_NAME
, PT.VALIDATION_DAYS
, PT.VALIDATION_VALUE
, PT.LAST_UPDATE_DATE
, PT.LAST_UPDATED_BY
, PT.LAST_UPDATE_LOGIN
, PT.CREATED_BY
, PT.CREATION_DATE
, TERR.TERRITORY_SHORT_NAME
, CURR.NAME
, HR.MEANING D_CATEGORY
FROM PAY_PAYMENT_TYPES PT
, PAY_PAYMENT_TYPES_TL PTTL
, FND_TERRITORIES_VL TERR
, FND_CURRENCIES_VL CURR
, HR_LOOKUPS HR
WHERE PT.PAYMENT_TYPE_ID = PTTL.PAYMENT_TYPE_ID
AND PTTL.LANGUAGE = USERENV('LANG')
AND PT.TERRITORY_CODE = TERR.TERRITORY_CODE(+)
AND PT.CURRENCY_CODE = CURR.CURRENCY_CODE(+)
AND PT.CATEGORY = HR.LOOKUP_CODE
AND HR.LOOKUP_TYPE = 'PAYMENT_CATEGORY'