PON_NEGOTIATION_STYLES

Details

Schema: FUSION
Object owner: PON
Object type: VIEW

Columns

Name
STYLE_ID STATUS STYLE_NAME DESCRIPTION SYSTEM_FLAG LINE_ATTRIBUTE_ENABLED_FLAG LINE_MAS_ENABLED_FLAG PRICE_ELEMENT_ENABLED_FLAG RFI_LINE_ENABLED_FLAG LOT_ENABLED_FLAG GROUP_ENABLED_FLAG LARGE_NEG_ENABLED_FLAG HDR_ATTRIBUTE_ENABLED_FLAG NEG_TEAM_ENABLED_FLAG PROXY_BIDDING_ENABLED_FLAG POWER_BIDDING_ENABLED_FLAG AUTO_EXTEND_ENABLED_FLAG TEAM_SCORING_ENABLED_FLAG QTY_PRICE_TIERS_ENABLED_FLAG COVER_PAGE_ENABLED_FLAG TWOSTAGE_EVAL_ENABLED_FLAG GENERAL_INTRO_ENABLED_FLAG TERMS_INSTR_ENABLED_FLAG STAG_CLOSE_ENABLED_FLAG ABSTRACT_ENABLED_FLAG REQMNTS_INSTR_ENABLED_FLAG LINES_INSTR_ENABLED_FLAG CONTERMS_ENABLED_FLAG CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER STYLE_CODE ALTERNATE_LINES_ENABLED_FLAG PROJECTS_ENABLED_FLAG LINE_DEFAULTS_ENABLED_FLAG RESP_SPSHET_ENABLED_FLAG RESP_XML_SPSHET_ENABLED_FLAG RESP_LINES_SPSHET_ENABLED_FLAG RESP_REQT_SPSHET_ENABLED_FLAG INTERNAL_CF_ENABLED_FLAG OVERALL_RESP_RANK_ENABLED_FLAG INTERNAL_CF_LINES_ENABLED_FLAG INTERNAL_CF_SUM_ENABLED_FLAG PREBID_ENABLED_FLAG LINE_DECREMENT_ENABLED_FLAG SPLIT_NEG_PDF_ENABLED_FLAG NOTIFY_CONTACTS_ENABLED_FLAG COVER_TEXT_GEN_AI_ENABLED_FLAG

Name

STYLE_ID

STATUS

STYLE_NAME

DESCRIPTION

SYSTEM_FLAG

LINE_ATTRIBUTE_ENABLED_FLAG

LINE_MAS_ENABLED_FLAG

PRICE_ELEMENT_ENABLED_FLAG

RFI_LINE_ENABLED_FLAG

LOT_ENABLED_FLAG

GROUP_ENABLED_FLAG

LARGE_NEG_ENABLED_FLAG

HDR_ATTRIBUTE_ENABLED_FLAG

NEG_TEAM_ENABLED_FLAG

PROXY_BIDDING_ENABLED_FLAG

POWER_BIDDING_ENABLED_FLAG

AUTO_EXTEND_ENABLED_FLAG

TEAM_SCORING_ENABLED_FLAG

QTY_PRICE_TIERS_ENABLED_FLAG

COVER_PAGE_ENABLED_FLAG

TWOSTAGE_EVAL_ENABLED_FLAG

GENERAL_INTRO_ENABLED_FLAG

TERMS_INSTR_ENABLED_FLAG

STAG_CLOSE_ENABLED_FLAG

ABSTRACT_ENABLED_FLAG

REQMNTS_INSTR_ENABLED_FLAG

LINES_INSTR_ENABLED_FLAG

CONTERMS_ENABLED_FLAG

CREATION_DATE

CREATED_BY

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

STYLE_CODE

ALTERNATE_LINES_ENABLED_FLAG

PROJECTS_ENABLED_FLAG

LINE_DEFAULTS_ENABLED_FLAG

RESP_SPSHET_ENABLED_FLAG

RESP_XML_SPSHET_ENABLED_FLAG

RESP_LINES_SPSHET_ENABLED_FLAG

RESP_REQT_SPSHET_ENABLED_FLAG

INTERNAL_CF_ENABLED_FLAG

OVERALL_RESP_RANK_ENABLED_FLAG

INTERNAL_CF_LINES_ENABLED_FLAG

INTERNAL_CF_SUM_ENABLED_FLAG

PREBID_ENABLED_FLAG

LINE_DECREMENT_ENABLED_FLAG

SPLIT_NEG_PDF_ENABLED_FLAG

NOTIFY_CONTACTS_ENABLED_FLAG

COVER_TEXT_GEN_AI_ENABLED_FLAG

Query

SQL_Statement
SELECT B.STYLE_ID, B.STATUS, T.STYLE_NAME, T.DESCRIPTION, B.SYSTEM_FLAG, B.LINE_ATTRIBUTE_ENABLED_FLAG, B.LINE_MAS_ENABLED_FLAG, B.PRICE_ELEMENT_ENABLED_FLAG, B.RFI_LINE_ENABLED_FLAG, B.LOT_ENABLED_FLAG, B.GROUP_ENABLED_FLAG, B.LARGE_NEG_ENABLED_FLAG, B.HDR_ATTRIBUTE_ENABLED_FLAG, B.NEG_TEAM_ENABLED_FLAG, B.PROXY_BIDDING_ENABLED_FLAG, B.POWER_BIDDING_ENABLED_FLAG, B.AUTO_EXTEND_ENABLED_FLAG, B.TEAM_SCORING_ENABLED_FLAG, B.QTY_PRICE_TIERS_ENABLED_FLAG, B.COVER_PAGE_ENABLED_FLAG, B.TWOSTAGE_EVAL_ENABLED_FLAG, B.GENERAL_INTRO_ENABLED_FLAG, B.TERMS_INSTR_ENABLED_FLAG, B.STAG_CLOSE_ENABLED_FLAG, B.ABSTRACT_ENABLED_FLAG, B.REQMNTS_INSTR_ENABLED_FLAG, B.LINES_INSTR_ENABLED_FLAG, B.CONTERMS_ENABLED_FLAG, B.CREATION_DATE, B.CREATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_LOGIN, B.OBJECT_VERSION_NUMBER, B.STYLE_CODE, B.ALTERNATE_LINES_ENABLED_FLAG, B.PROJECTS_ENABLED_FLAG, B.LINE_DEFAULTS_ENABLED_FLAG, B.RESP_SPSHET_ENABLED_FLAG, B.RESP_XML_SPSHET_ENABLED_FLAG, B.RESP_LINES_SPSHET_ENABLED_FLAG, B.RESP_REQT_SPSHET_ENABLED_FLAG, B.INTERNAL_CF_ENABLED_FLAG, B.OVERALL_RESP_RANK_ENABLED_FLAG, B.INTERNAL_CF_LINES_ENABLED_FLAG, B.INTERNAL_CF_SUM_ENABLED_FLAG, B.PREBID_ENABLED_FLAG, B.LINE_DECREMENT_ENABLED_FLAG, B.SPLIT_NEG_PDF_ENABLED_FLAG, B.NOTIFY_CONTACTS_ENABLED_FLAG, B.COVER_TEXT_GEN_AI_ENABLED_FLAG FROM PON_NEGOTIATION_STYLES_B B, PON_NEGOTIATION_STYLES_TL T WHERE B.STYLE_ID = T.STYLE_ID AND T.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

B.STYLE_ID,

B.STATUS,

T.STYLE_NAME,

T.DESCRIPTION,

B.SYSTEM_FLAG,

B.LINE_ATTRIBUTE_ENABLED_FLAG,

B.LINE_MAS_ENABLED_FLAG,

B.PRICE_ELEMENT_ENABLED_FLAG,

B.RFI_LINE_ENABLED_FLAG,

B.LOT_ENABLED_FLAG,

B.GROUP_ENABLED_FLAG,

B.LARGE_NEG_ENABLED_FLAG,

B.HDR_ATTRIBUTE_ENABLED_FLAG,

B.NEG_TEAM_ENABLED_FLAG,

B.PROXY_BIDDING_ENABLED_FLAG,

B.POWER_BIDDING_ENABLED_FLAG,

B.AUTO_EXTEND_ENABLED_FLAG,

B.TEAM_SCORING_ENABLED_FLAG,

B.QTY_PRICE_TIERS_ENABLED_FLAG,

B.COVER_PAGE_ENABLED_FLAG,

B.TWOSTAGE_EVAL_ENABLED_FLAG,

B.GENERAL_INTRO_ENABLED_FLAG,

B.TERMS_INSTR_ENABLED_FLAG,

B.STAG_CLOSE_ENABLED_FLAG,

B.ABSTRACT_ENABLED_FLAG,

B.REQMNTS_INSTR_ENABLED_FLAG,

B.LINES_INSTR_ENABLED_FLAG,

B.CONTERMS_ENABLED_FLAG,

B.CREATION_DATE,

B.CREATED_BY,

B.LAST_UPDATE_DATE,

B.LAST_UPDATED_BY,

B.LAST_UPDATE_LOGIN,

B.OBJECT_VERSION_NUMBER,

B.STYLE_CODE,

B.ALTERNATE_LINES_ENABLED_FLAG,

B.PROJECTS_ENABLED_FLAG,

B.LINE_DEFAULTS_ENABLED_FLAG,

B.RESP_SPSHET_ENABLED_FLAG,

B.RESP_XML_SPSHET_ENABLED_FLAG,

B.RESP_LINES_SPSHET_ENABLED_FLAG,

B.RESP_REQT_SPSHET_ENABLED_FLAG,

B.INTERNAL_CF_ENABLED_FLAG,

B.OVERALL_RESP_RANK_ENABLED_FLAG,

B.INTERNAL_CF_LINES_ENABLED_FLAG,

B.INTERNAL_CF_SUM_ENABLED_FLAG,

B.PREBID_ENABLED_FLAG,

B.LINE_DECREMENT_ENABLED_FLAG,

B.SPLIT_NEG_PDF_ENABLED_FLAG,

B.NOTIFY_CONTACTS_ENABLED_FLAG,

B.COVER_TEXT_GEN_AI_ENABLED_FLAG

FROM

PON_NEGOTIATION_STYLES_B B,

PON_NEGOTIATION_STYLES_TL T

WHERE

B.STYLE_ID = T.STYLE_ID AND T.LANGUAGE = USERENV('LANG')