VIEW: APPS.PON_VALID_NEG_STYLES_V

Source

View Text - Preformatted

SELECT adt.internal_name as doctype_code, nsb.style_id, nst.style_name FROM PON_NEGOTIATION_STYLES NSB,PON_NEGOTIATION_STYLES_TL NST,PON_DOCTYPE_STYLES DS,PON_AUC_DOCTYPES ADT WHERE nsb.style_id = nst.style_id and nst.language = userenv('LANG') and nsb.style_id = ds.style_id and ds.enabled_flag = 'Y' and ds.doctype_id = adt.doctype_id and nsb.status = 'ACTIVE' and nsb.line_attribute_enabled_flag = 'Y'

View Text - HTML Formatted

SELECT ADT.INTERNAL_NAME AS DOCTYPE_CODE
, NSB.STYLE_ID
, NST.STYLE_NAME
FROM PON_NEGOTIATION_STYLES NSB
, PON_NEGOTIATION_STYLES_TL NST
, PON_DOCTYPE_STYLES DS
, PON_AUC_DOCTYPES ADT
WHERE NSB.STYLE_ID = NST.STYLE_ID
AND NST.LANGUAGE = USERENV('LANG')
AND NSB.STYLE_ID = DS.STYLE_ID
AND DS.ENABLED_FLAG = 'Y'
AND DS.DOCTYPE_ID = ADT.DOCTYPE_ID
AND NSB.STATUS = 'ACTIVE'
AND NSB.LINE_ATTRIBUTE_ENABLED_FLAG = 'Y'