DBA Data[Home] [Help]

VIEW: APPS.PON_NEGOTIATION_STYLES_VL

Source

View Text - Preformatted

SELECT B. STYLE_ID, STATUS, T.STYLE_NAME, T.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, B.CREATION_DATE, B.CREATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_LOGIN , QTY_PRICE_TIERS_ENABLED_FLAG, supp_reg_qual_flag, supp_eval_flag, hide_terms_flag, hide_abstract_forms_flag, hide_attachments_flag, internal_eval_flag, hdr_supp_attr_enabled_flag, intgr_hdr_attr_flag, intgr_hdr_attach_flag, line_supp_attr_enabled_flag, item_supp_attr_enabled_flag, intgr_cat_line_attr_flag, intgr_item_line_attr_flag, intgr_cat_line_asl_flag FROM PON_NEGOTIATION_STYLES B,PON_NEGOTIATION_STYLES_TL T WHERE B.STYLE_ID = T.STYLE_ID AND T.LANGUAGE = USERENV('LANG')
View Text - HTML Formatted

SELECT B. STYLE_ID
, STATUS
, T.STYLE_NAME
, T.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
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, QTY_PRICE_TIERS_ENABLED_FLAG
, SUPP_REG_QUAL_FLAG
, SUPP_EVAL_FLAG
, HIDE_TERMS_FLAG
, HIDE_ABSTRACT_FORMS_FLAG
, HIDE_ATTACHMENTS_FLAG
, INTERNAL_EVAL_FLAG
, HDR_SUPP_ATTR_ENABLED_FLAG
, INTGR_HDR_ATTR_FLAG
, INTGR_HDR_ATTACH_FLAG
, LINE_SUPP_ATTR_ENABLED_FLAG
, ITEM_SUPP_ATTR_ENABLED_FLAG
, INTGR_CAT_LINE_ATTR_FLAG
, INTGR_ITEM_LINE_ATTR_FLAG
, INTGR_CAT_LINE_ASL_FLAG
FROM PON_NEGOTIATION_STYLES B
, PON_NEGOTIATION_STYLES_TL T
WHERE B.STYLE_ID = T.STYLE_ID
AND T.LANGUAGE = USERENV('LANG')