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.

[Home] [Help]

VIEW: OZF.OZF_SD_RES_PROD_INTF#

Source

View Text - Preformatted


select REQUEST_LINE_ID REQUEST_LINE_ID, PROD_AUTHORIZED_QUANTITY PROD_AUTHORIZED_QUANTITY, DESIGN_WIN_NUMBER DESIGN_WIN_NUMBER, APPROVED_DISCOUNT_VALUE APPROVED_DISCOUNT_VALUE, APPROVED_DISCOUNT_TYPE APPROVED_DISCOUNT_TYPE, APPROVED_DISCOUNT_CURR APPROVED_DISCOUNT_CURR, PROD_UOM PROD_UOM, PROD_REJECTION_CODE PROD_REJECTION_CODE, PROD_TYPE PROD_TYPE, PROD_REQUESTED_QUANTITY PROD_REQUESTED_QUANTITY, REQUEST_NUMBER REQUEST_NUMBER, SUPP_PROD_CODE SUPP_PROD_CODE, PROCESSED_FLAG PROCESSED_FLAG, ERROR_TXT ERROR_TXT, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, RES_PROD_INTF_ID RES_PROD_INTF_ID from "OZF"."OZF_SD_RES_PROD_INTF"

View Text - HTML Formatted

SELECT REQUEST_LINE_ID REQUEST_LINE_ID
, PROD_AUTHORIZED_QUANTITY PROD_AUTHORIZED_QUANTITY
, DESIGN_WIN_NUMBER DESIGN_WIN_NUMBER
, APPROVED_DISCOUNT_VALUE APPROVED_DISCOUNT_VALUE
, APPROVED_DISCOUNT_TYPE APPROVED_DISCOUNT_TYPE
, APPROVED_DISCOUNT_CURR APPROVED_DISCOUNT_CURR
, PROD_UOM PROD_UOM
, PROD_REJECTION_CODE PROD_REJECTION_CODE
, PROD_TYPE PROD_TYPE
, PROD_REQUESTED_QUANTITY PROD_REQUESTED_QUANTITY
, REQUEST_NUMBER REQUEST_NUMBER
, SUPP_PROD_CODE SUPP_PROD_CODE
, PROCESSED_FLAG PROCESSED_FLAG
, ERROR_TXT ERROR_TXT
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, RES_PROD_INTF_ID RES_PROD_INTF_ID
FROM "OZF"."OZF_SD_RES_PROD_INTF"