DBA Data[Home] [Help]

VIEW: CSD.CSD_RETURNS_BI_SHP_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, SHIPPED_QUANTITY SHIPPED_QUANTITY, PRIMARY_UOM_CODE PRIMARY_UOM_CODE, TRANSACTION_DATE TRANSACTION_DATE, SHIPPED_WEIGHT SHIPPED_WEIGHT, WEIGHT_UOM_CODE WEIGHT_UOM_CODE, CATEGORY_ID CATEGORY_ID, CATEGORY_SET_ID CATEGORY_SET_ID, SHIP_GEOGRAPHY_TYPE SHIP_GEOGRAPHY_TYPE, SHIP_GEOGRAPHY_ID SHIP_GEOGRAPHY_ID, CUSTOMER_TYPE CUSTOMER_TYPE, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PROGRAM_ID PROGRAM_ID, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, REQUEST_ID REQUEST_ID from "CSD"."CSD_RETURNS_BI_SHP_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
, SHIPPED_QUANTITY SHIPPED_QUANTITY
, PRIMARY_UOM_CODE PRIMARY_UOM_CODE
, TRANSACTION_DATE TRANSACTION_DATE
, SHIPPED_WEIGHT SHIPPED_WEIGHT
, WEIGHT_UOM_CODE WEIGHT_UOM_CODE
, CATEGORY_ID CATEGORY_ID
, CATEGORY_SET_ID CATEGORY_SET_ID
, SHIP_GEOGRAPHY_TYPE SHIP_GEOGRAPHY_TYPE
, SHIP_GEOGRAPHY_ID SHIP_GEOGRAPHY_ID
, CUSTOMER_TYPE CUSTOMER_TYPE
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PROGRAM_ID PROGRAM_ID
, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, REQUEST_ID REQUEST_ID
FROM "CSD"."CSD_RETURNS_BI_SHP_TXNS_F"