VIEW: CSD.CSD_RETURNS_BI_MTL_TXNS_F#

Source

View Text - Preformatted

select TRANSACTION_ID TRANSACTION_ID, OPERATING_UNIT_ID OPERATING_UNIT_ID, INVENTORY_ORG_ID INVENTORY_ORG_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, TRANSACTED_QTY TRANSACTED_QTY, PRIMARY_UOM_CODE PRIMARY_UOM_CODE, TRANSACTION_DATE TRANSACTION_DATE, REASON_ID REASON_ID, MTL_DISPOSITION_CODE MTL_DISPOSITION_CODE, TRANSACTED_WEIGHT TRANSACTED_WEIGHT, WEIGHT_UOM_CODE WEIGHT_UOM_CODE, CATEGORY_ID CATEGORY_ID, CATEGORY_SET_ID CATEGORY_SET_ID, INV_GEOGRAPHY_TYPE INV_GEOGRAPHY_TYPE, INV_GEOGRAPHY_ID INV_GEOGRAPHY_ID, 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, RECOVERY_VALUE RECOVERY_VALUE, PROCESSING_COST PROCESSING_COST, CURRENCY_CODE CURRENCY_CODE from "CSD"."CSD_RETURNS_BI_MTL_TXNS_F"

View Text - HTML Formatted

SELECT TRANSACTION_ID TRANSACTION_ID
, OPERATING_UNIT_ID OPERATING_UNIT_ID
, INVENTORY_ORG_ID INVENTORY_ORG_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, TRANSACTED_QTY TRANSACTED_QTY
, PRIMARY_UOM_CODE PRIMARY_UOM_CODE
, TRANSACTION_DATE TRANSACTION_DATE
, REASON_ID REASON_ID
, MTL_DISPOSITION_CODE MTL_DISPOSITION_CODE
, TRANSACTED_WEIGHT TRANSACTED_WEIGHT
, WEIGHT_UOM_CODE WEIGHT_UOM_CODE
, CATEGORY_ID CATEGORY_ID
, CATEGORY_SET_ID CATEGORY_SET_ID
, INV_GEOGRAPHY_TYPE INV_GEOGRAPHY_TYPE
, INV_GEOGRAPHY_ID INV_GEOGRAPHY_ID
, 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
, RECOVERY_VALUE RECOVERY_VALUE
, PROCESSING_COST PROCESSING_COST
, CURRENCY_CODE CURRENCY_CODE
FROM "CSD"."CSD_RETURNS_BI_MTL_TXNS_F"