VIEW: APPS.POR_NONCAT_TEMPLATES_ALL_VL

Source

View Text - Preformatted

SELECT B.ROWID ROW_ID, B.TEMPLATE_ID, B.ORG_ID, B.ITEM_TYPE, B.DESC_EDITABLE_FLAG, B.CATEGORY_ID, B.CAT_EDITABLE_FLAG, B.RESTRICT_CATEGORY_FLAG, B.COMMODITY_ID, B.QUANTITY, B.UNIT_OF_MEASURE_CODE, B.UOM_EDITABLE_FLAG, B.UNIT_PRICE, B.PRICE_EDITABLE_FLAG, B.AMOUNT, B.AMOUNT_EDITABLE_FLAG, B.CURRENCY_CODE, B.CURRENCY_EDITABLE_FLAG, B.RATE, B.RATE_EDITABLE_FLAG, B.RATE_TYPE, B.RATE_TYPE_EDITABLE_FLAG, B.RATE_DATE, B.RATE_DATE_EDITABLE_FLAG, B.CONTRACT_ID, B.CONTRACT_EDITABLE_FLAG, B.NEW_SUPPLIER_FLAG, B.SUPPLIER_ID, B.SUPPLIER_EDITABLE_FLAG, B.RESTRICT_SUPPLIER_TYPE, B.SUPPLIER_SITE_ID, B.SITE_EDITABLE_FLAG, B.SUPPLIER_CONTACT_ID, B.CONTACT_EDITABLE_FLAG, B.SUPPLIER_CONTACT_PHONE, B.PHONE_EDITABLE_FLAG, B.SUPPLIER_CONTACT_FAX, B.FAX_EDITABLE_FLAG, B.SUPPLIER_CONTACT_EMAIL, B.EMAIL_EDITABLE_FLAG, B.SUPPLIER_ITEM, B.SUPPLIER_ITEM_EDITABLE_FLAG, B.MANUFACTURER, B.MANUFACTURER_EDITABLE_FLAG, B.MANUFACTURER_PART_NUMBER, B.MPN_EDITABLE_FLAG, B.NEGOTIATED_BY_PREPARER_FLAG, B.NEGOTIATED_EDITABLE_FLAG, B.RFQ_REQUIRED_FLAG, B.RFQ_REQ_EDITABLE_FLAG, B.NEW_RESPONSIBILITIES_FLAG, TL.TEMPLATE_NAME, TL.ITEM_DESCRIPTION, TL.IMAGE, TL.KEYWORDS, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.CONTRACT_TYPE, B.COST_CONSTRAINT FROM POR_NONCAT_TEMPLATES_ALL_B B,POR_NONCAT_TEMPLATES_ALL_TL TL WHERE TL.TEMPLATE_ID = B.TEMPLATE_ID AND TL.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.TEMPLATE_ID
, B.ORG_ID
, B.ITEM_TYPE
, B.DESC_EDITABLE_FLAG
, B.CATEGORY_ID
, B.CAT_EDITABLE_FLAG
, B.RESTRICT_CATEGORY_FLAG
, B.COMMODITY_ID
, B.QUANTITY
, B.UNIT_OF_MEASURE_CODE
, B.UOM_EDITABLE_FLAG
, B.UNIT_PRICE
, B.PRICE_EDITABLE_FLAG
, B.AMOUNT
, B.AMOUNT_EDITABLE_FLAG
, B.CURRENCY_CODE
, B.CURRENCY_EDITABLE_FLAG
, B.RATE
, B.RATE_EDITABLE_FLAG
, B.RATE_TYPE
, B.RATE_TYPE_EDITABLE_FLAG
, B.RATE_DATE
, B.RATE_DATE_EDITABLE_FLAG
, B.CONTRACT_ID
, B.CONTRACT_EDITABLE_FLAG
, B.NEW_SUPPLIER_FLAG
, B.SUPPLIER_ID
, B.SUPPLIER_EDITABLE_FLAG
, B.RESTRICT_SUPPLIER_TYPE
, B.SUPPLIER_SITE_ID
, B.SITE_EDITABLE_FLAG
, B.SUPPLIER_CONTACT_ID
, B.CONTACT_EDITABLE_FLAG
, B.SUPPLIER_CONTACT_PHONE
, B.PHONE_EDITABLE_FLAG
, B.SUPPLIER_CONTACT_FAX
, B.FAX_EDITABLE_FLAG
, B.SUPPLIER_CONTACT_EMAIL
, B.EMAIL_EDITABLE_FLAG
, B.SUPPLIER_ITEM
, B.SUPPLIER_ITEM_EDITABLE_FLAG
, B.MANUFACTURER
, B.MANUFACTURER_EDITABLE_FLAG
, B.MANUFACTURER_PART_NUMBER
, B.MPN_EDITABLE_FLAG
, B.NEGOTIATED_BY_PREPARER_FLAG
, B.NEGOTIATED_EDITABLE_FLAG
, B.RFQ_REQUIRED_FLAG
, B.RFQ_REQ_EDITABLE_FLAG
, B.NEW_RESPONSIBILITIES_FLAG
, TL.TEMPLATE_NAME
, TL.ITEM_DESCRIPTION
, TL.IMAGE
, TL.KEYWORDS
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, B.CONTRACT_TYPE
, B.COST_CONSTRAINT
FROM POR_NONCAT_TEMPLATES_ALL_B B
, POR_NONCAT_TEMPLATES_ALL_TL TL
WHERE TL.TEMPLATE_ID = B.TEMPLATE_ID
AND TL.LANGUAGE = USERENV('LANG')