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: CSD.CSD_RETURNS_BI_RCV_TXNS_F#

Source

View Text - Preformatted


select TRANSACTION_ID TRANSACTION_ID, ORDER_HEADER_ID ORDER_HEADER_ID, ORDER_LINE_ID ORDER_LINE_ID, OPERATING_UNIT_ID OPERATING_UNIT_ID, INVENTORY_ORG_ID INVENTORY_ORG_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, RECEIVED_QUANTITY RECEIVED_QUANTITY, PRIMARY_UOM_CODE PRIMARY_UOM_CODE, TRANSACTION_DATE TRANSACTION_DATE, RETURN_STREAM_CODE RETURN_STREAM_CODE, RECEIVED_WEIGHT RECEIVED_WEIGHT, WEIGHT_UOM_CODE WEIGHT_UOM_CODE, RECEIVED_VALUE RECEIVED_VALUE, CURRENCY_CODE CURRENCY_CODE, CATEGORY_ID CATEGORY_ID, CATEGORY_SET_ID CATEGORY_SET_ID, SHIP_GEOGRAPHY_TYPE SHIP_GEOGRAPHY_TYPE, SHIP_GEOGRAPHY_ID SHIP_GEOGRAPHY_ID, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATED_BY LAST_UPDATED_BY, PROGRAM_ID PROGRAM_ID, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, REQUEST_ID REQUEST_ID, CUSTOMER_TYPE CUSTOMER_TYPE, POM_OFFSET POM_OFFSET from "CSD"."CSD_RETURNS_BI_RCV_TXNS_F"

View Text - HTML Formatted

SELECT TRANSACTION_ID TRANSACTION_ID
, ORDER_HEADER_ID ORDER_HEADER_ID
, ORDER_LINE_ID ORDER_LINE_ID
, OPERATING_UNIT_ID OPERATING_UNIT_ID
, INVENTORY_ORG_ID INVENTORY_ORG_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, RECEIVED_QUANTITY RECEIVED_QUANTITY
, PRIMARY_UOM_CODE PRIMARY_UOM_CODE
, TRANSACTION_DATE TRANSACTION_DATE
, RETURN_STREAM_CODE RETURN_STREAM_CODE
, RECEIVED_WEIGHT RECEIVED_WEIGHT
, WEIGHT_UOM_CODE WEIGHT_UOM_CODE
, RECEIVED_VALUE RECEIVED_VALUE
, CURRENCY_CODE CURRENCY_CODE
, CATEGORY_ID CATEGORY_ID
, CATEGORY_SET_ID CATEGORY_SET_ID
, SHIP_GEOGRAPHY_TYPE SHIP_GEOGRAPHY_TYPE
, SHIP_GEOGRAPHY_ID SHIP_GEOGRAPHY_ID
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATED_BY LAST_UPDATED_BY
, PROGRAM_ID PROGRAM_ID
, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, REQUEST_ID REQUEST_ID
, CUSTOMER_TYPE CUSTOMER_TYPE
, POM_OFFSET POM_OFFSET
FROM "CSD"."CSD_RETURNS_BI_RCV_TXNS_F"