View: PON_VALID_NEG_STYLES_V

Product:	PON - Sourcing
Description:	This is the view of active negotiation styles which enable line attributes.
Implementation/DBA Data:	APPS.PON_VALID_NEG_STYLES_V

View Text

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'

Columns