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_VOLUME_DETAIL#

Source

View Text - Preformatted


select VOLUME_DETAIL_ID VOLUME_DETAIL_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, OFFER_ID OFFER_ID, QP_LIST_HEADER_ID QP_LIST_HEADER_ID, DISTRIBUTOR_ACCT_ID DISTRIBUTOR_ACCT_ID, CUST_ACCOUNT_ID CUST_ACCOUNT_ID, BILL_TO_SITE_USE_ID BILL_TO_SITE_USE_ID, SHIP_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, VOLUME_TYPE VOLUME_TYPE, UOM_CODE UOM_CODE, CURRENCY_CODE CURRENCY_CODE, VOLUME VOLUME, GROUP_NO GROUP_NO, VOLUME_TRACK_TYPE VOLUME_TRACK_TYPE, ORDER_LINE_ID ORDER_LINE_ID, TRANSACTION_DATE TRANSACTION_DATE, PBH_LINE_ID PBH_LINE_ID, INCLUDE_VOLUME_FLAG INCLUDE_VOLUME_FLAG, SOURCE_CODE SOURCE_CODE from "OZF"."OZF_VOLUME_DETAIL"

View Text - HTML Formatted

SELECT VOLUME_DETAIL_ID VOLUME_DETAIL_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
, OFFER_ID OFFER_ID
, QP_LIST_HEADER_ID QP_LIST_HEADER_ID
, DISTRIBUTOR_ACCT_ID DISTRIBUTOR_ACCT_ID
, CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, BILL_TO_SITE_USE_ID BILL_TO_SITE_USE_ID
, SHIP_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, VOLUME_TYPE VOLUME_TYPE
, UOM_CODE UOM_CODE
, CURRENCY_CODE CURRENCY_CODE
, VOLUME VOLUME
, GROUP_NO GROUP_NO
, VOLUME_TRACK_TYPE VOLUME_TRACK_TYPE
, ORDER_LINE_ID ORDER_LINE_ID
, TRANSACTION_DATE TRANSACTION_DATE
, PBH_LINE_ID PBH_LINE_ID
, INCLUDE_VOLUME_FLAG INCLUDE_VOLUME_FLAG
, SOURCE_CODE SOURCE_CODE
FROM "OZF"."OZF_VOLUME_DETAIL"