PON_VALID_NEG_STYLES

Details

Schema: FUSION
Object owner: PON
Object type: VIEW

Columns

Name
DOCTYPE_CODE STYLE_ID STYLE_NAME

Name

DOCTYPE_CODE

STYLE_ID

STYLE_NAME

Query

SQL_Statement
SELECT adt.internal_name as doctype_code, nsb.style_id, nst.style_name FROM PON_NEGOTIATION_STYLES_B NSB,PON_NEGOTIATION_STYLES_TL NST,PON_DOCTYPE_STYLES_B DS,PON_AUC_DOCTYPES_B 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'

SQL_Statement

SELECT adt.internal_name as doctype_code, nsb.style_id, nst.style_name FROM PON_NEGOTIATION_STYLES_B NSB,PON_NEGOTIATION_STYLES_TL NST,PON_DOCTYPE_STYLES_B DS,PON_AUC_DOCTYPES_B 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'