[Home] [Help]
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
Name |
DOCTYPE_CODE |
STYLE_ID |
STYLE_NAME |