機械翻訳について

PON_VALID_NEG_STYLES_V

詳細

• スキーマ: FUSION

• オブジェクト所有者: PON

• オブジェクト・タイプ: VIEW

列

名前
DOCTYPE_CODE STYLE_ID STYLE_NAME

問合せ

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'