VIEW: APPS.POA_NEG_DOCTYPES_V

Source

View Text - Preformatted

SELECT d.doctype_id id, dtl.name value, d.internal_name internal_name from pon_auc_doctypes d, pon_auc_doctypes_tl dtl WHERE d.transaction_type = 'REVERSE' and d.doctype_id = dtl.doctype_id and d.internal_name in ('BUYER_AUCTION', 'REQUEST_FOR_QUOTE', 'REQUEST_FOR_INFORMATION') and dtl.language = userenv('LANG')

View Text - HTML Formatted

SELECT D.DOCTYPE_ID ID
, DTL.NAME VALUE
, D.INTERNAL_NAME INTERNAL_NAME
FROM PON_AUC_DOCTYPES D
, PON_AUC_DOCTYPES_TL DTL
WHERE D.TRANSACTION_TYPE = 'REVERSE'
AND D.DOCTYPE_ID = DTL.DOCTYPE_ID
AND D.INTERNAL_NAME IN ('BUYER_AUCTION'
, 'REQUEST_FOR_QUOTE'
, 'REQUEST_FOR_INFORMATION')
AND DTL.LANGUAGE = USERENV('LANG')