POR_SMART_FORMS_ALL_VL

Details

• Schema: FUSION

• Object owner: POR

• Object type: VIEW

Columns

Name

SMART_FORM_ID PRC_BU_ID SMART_FORM_NAME DESCRIPTION KEYWORDS IMAGE LINE_TYPE_ID ITEM_DESCRIPTION ITEM_DESC_EDITABLE_FLAG BROWSING_CATEGORY_ID BROWSING_CATEGORY_ID_LIST CATEGORY_ID CATEGORY_EDITABLE_FLAG CURRENCY_CODE CURRENCY_EDITABLE_FLAG QUANTITY UOM_CODE UOM_EDITABLE_FLAG UNIT_PRICE UNIT_PRICE_EDITABLE_FLAG AMOUNT AMOUNT_EDITABLE_FLAG NEGOTIATION_REQUIRED_FLAG NEGOTIATION_REQ_EDITABLE_FLAG NEGOTIATED_FLAG NEGOTIATED_EDITABLE_FLAG AGREEMENT_ID AGREEMENT_EDITABLE_FLAG SUPPLIER_ID SUPPLIER_EDITABLE_FLAG SUPPLIER_SITE_ID SITE_EDITABLE_FLAG SUPPLIER_CONTACT_ID CONTACT_EDITABLE_FLAG SUPPLIER_CONTACT_PHONE PHONE_EDITABLE_FLAG SUPPLIER_CONTACT_FAX FAX_EDITABLE_FLAG SUPPLIER_CONTACT_EMAIL EMAIL_EDITABLE_FLAG SUPPLIER_ITEM_NUMBER SUPPLIER_ITEM_EDITABLE_FLAG MANUFACTURER MANUFACTURER_EDITABLE_FLAG MANUFACTURER_PART_NUMBER MPN_EDITABLE_FLAG CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT B.SMART_FORM_ID, B.PRC_BU_ID, TL.SMART_FORM_NAME, TL.DESCRIPTION, TL.KEYWORDS, B.IMAGE, B.LINE_TYPE_ID, TL.ITEM_DESCRIPTION, B.ITEM_DESC_EDITABLE_FLAG, B.BROWSING_CATEGORY_ID, B.BROWSING_CATEGORY_ID_LIST, B.CATEGORY_ID, B.CATEGORY_EDITABLE_FLAG, B.CURRENCY_CODE, B.CURRENCY_EDITABLE_FLAG, B.QUANTITY, B.UOM_CODE, B.UOM_EDITABLE_FLAG, B.UNIT_PRICE, B.UNIT_PRICE_EDITABLE_FLAG, B.AMOUNT, B.AMOUNT_EDITABLE_FLAG, B.NEGOTIATION_REQUIRED_FLAG, B.NEGOTIATION_REQ_EDITABLE_FLAG, B.NEGOTIATED_FLAG, B.NEGOTIATED_EDITABLE_FLAG, B.AGREEMENT_ID, B.AGREEMENT_EDITABLE_FLAG, B.SUPPLIER_ID, B.SUPPLIER_EDITABLE_FLAG, 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_NUMBER, B.SUPPLIER_ITEM_EDITABLE_FLAG, TL.MANUFACTURER, B.MANUFACTURER_EDITABLE_FLAG, B.MANUFACTURER_PART_NUMBER, B.MPN_EDITABLE_FLAG, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.OBJECT_VERSION_NUMBER FROM POR_SMART_FORMS_ALL_B B, POR_SMART_FORMS_ALL_TL TL WHERE TL.SMART_FORM_ID = B.SMART_FORM_ID AND TL.LANGUAGE = USERENV('LANG')