eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: OZF.OZF_WORKSHEET_LINES#

Source

View Text - Preformatted


select WORKSHEET_LINE_ID WORKSHEET_LINE_ID, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, WORKSHEET_HEADER_ID WORKSHEET_HEADER_ID, PRODUCT_ATTRIBUTE_CONTEXT PRODUCT_ATTRIBUTE_CONTEXT, PRODUCT_ATTRIBUTE PRODUCT_ATTRIBUTE, PRODUCT_ATTR_VALUE PRODUCT_ATTR_VALUE, PRODUCT_UOM_CODE PRODUCT_UOM_CODE, ARITHMETIC_OPERATOR ARITHMETIC_OPERATOR, OPERAND OPERAND, OTHER_COSTS OTHER_COSTS, FORECASTED_UNITS FORECASTED_UNITS, OFFER_TYPE OFFER_TYPE, LIST_PRICE LIST_PRICE, ITEM_COST ITEM_COST, QUANTITY QUANTITY, SCAN_TYPE SCAN_TYPE, SCAN_VALUE SCAN_VALUE, SCAN_UNIT_FORECAST SCAN_UNIT_FORECAST, DISTRIBUTION_VALUE DISTRIBUTION_VALUE, MIN_ORDER_VALUE MIN_ORDER_VALUE, MAX_ORDER_VALUE MAX_ORDER_VALUE, MAX_UNITS_PER_ORDER MAX_UNITS_PER_ORDER, MAX_ORDERS_PER_CUSTOMER MAX_ORDERS_PER_CUSTOMER, MAX_UNITS_PER_RULE MAX_UNITS_PER_RULE, MAX_COMMITTED_AMT_PER_RULE MAX_COMMITTED_AMT_PER_RULE, PARENT_WORKSHEET_LINE_ID PARENT_WORKSHEET_LINE_ID, RETAIL_UOM_CODE RETAIL_UOM_CODE, DESIRED_RETAIL_PRICE DESIRED_RETAIL_PRICE, RETAILERS_MARGIN RETAILERS_MARGIN, ADJUST_BUDGET ADJUST_BUDGET, UOM_CODE UOM_CODE, EXCLUDE_FLAG EXCLUDE_FLAG, PRODUCT_CONCAT_VALUE PRODUCT_CONCAT_VALUE from "OZF"."OZF_WORKSHEET_LINES"

View Text - HTML Formatted

SELECT WORKSHEET_LINE_ID WORKSHEET_LINE_ID
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, WORKSHEET_HEADER_ID WORKSHEET_HEADER_ID
, PRODUCT_ATTRIBUTE_CONTEXT PRODUCT_ATTRIBUTE_CONTEXT
, PRODUCT_ATTRIBUTE PRODUCT_ATTRIBUTE
, PRODUCT_ATTR_VALUE PRODUCT_ATTR_VALUE
, PRODUCT_UOM_CODE PRODUCT_UOM_CODE
, ARITHMETIC_OPERATOR ARITHMETIC_OPERATOR
, OPERAND OPERAND
, OTHER_COSTS OTHER_COSTS
, FORECASTED_UNITS FORECASTED_UNITS
, OFFER_TYPE OFFER_TYPE
, LIST_PRICE LIST_PRICE
, ITEM_COST ITEM_COST
, QUANTITY QUANTITY
, SCAN_TYPE SCAN_TYPE
, SCAN_VALUE SCAN_VALUE
, SCAN_UNIT_FORECAST SCAN_UNIT_FORECAST
, DISTRIBUTION_VALUE DISTRIBUTION_VALUE
, MIN_ORDER_VALUE MIN_ORDER_VALUE
, MAX_ORDER_VALUE MAX_ORDER_VALUE
, MAX_UNITS_PER_ORDER MAX_UNITS_PER_ORDER
, MAX_ORDERS_PER_CUSTOMER MAX_ORDERS_PER_CUSTOMER
, MAX_UNITS_PER_RULE MAX_UNITS_PER_RULE
, MAX_COMMITTED_AMT_PER_RULE MAX_COMMITTED_AMT_PER_RULE
, PARENT_WORKSHEET_LINE_ID PARENT_WORKSHEET_LINE_ID
, RETAIL_UOM_CODE RETAIL_UOM_CODE
, DESIRED_RETAIL_PRICE DESIRED_RETAIL_PRICE
, RETAILERS_MARGIN RETAILERS_MARGIN
, ADJUST_BUDGET ADJUST_BUDGET
, UOM_CODE UOM_CODE
, EXCLUDE_FLAG EXCLUDE_FLAG
, PRODUCT_CONCAT_VALUE PRODUCT_CONCAT_VALUE
FROM "OZF"."OZF_WORKSHEET_LINES"