Product: | PON - Sourcing |
---|---|
Description: | View to access negotiation style name and description in the session language. |
Implementation/DBA Data: | APPS.PON_NEGOTIATION_STYLES_VL |
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')