VIEW: CSM.CSM_MTL_MATERIAL_TXNS_INQ#

Source

View Text - Preformatted

select CLID$$CS CLID$$CS, TRANSACTION_ID TRANSACTION_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, REVISION REVISION, ORGANIZATION_ID ORGANIZATION_ID, SUBINVENTORY_CODE SUBINVENTORY_CODE, LOCATOR_ID LOCATOR_ID, TRANSACTION_TYPE_ID TRANSACTION_TYPE_ID, TRANSACTION_ACTION_ID TRANSACTION_ACTION_ID, TRANSACTION_SOURCE_TYPE_ID TRANSACTION_SOURCE_TYPE_ID, TRANSACTION_QUANTITY TRANSACTION_QUANTITY, TRANSACTION_UOM TRANSACTION_UOM, PRIMARY_QUANTITY PRIMARY_QUANTITY, TRANSACTION_DATE TRANSACTION_DATE, TRANSACTION_REFERENCE TRANSACTION_REFERENCE, REASON_ID REASON_ID, TRANSFER_ORGANIZATION_ID TRANSFER_ORGANIZATION_ID, TRANSFER_SUBINVENTORY TRANSFER_SUBINVENTORY, TRANSFER_LOCATOR_ID TRANSFER_LOCATOR_ID, DMLTYPE$$ DMLTYPE$$, SEQNO$$ SEQNO$$, TRANID$$ TRANID$$, VERSION$$ VERSION$$ from "CSM"."CSM_MTL_MATERIAL_TXNS_INQ"

View Text - HTML Formatted

SELECT CLID$$CS CLID$$CS
, TRANSACTION_ID TRANSACTION_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, REVISION REVISION
, ORGANIZATION_ID ORGANIZATION_ID
, SUBINVENTORY_CODE SUBINVENTORY_CODE
, LOCATOR_ID LOCATOR_ID
, TRANSACTION_TYPE_ID TRANSACTION_TYPE_ID
, TRANSACTION_ACTION_ID TRANSACTION_ACTION_ID
, TRANSACTION_SOURCE_TYPE_ID TRANSACTION_SOURCE_TYPE_ID
, TRANSACTION_QUANTITY TRANSACTION_QUANTITY
, TRANSACTION_UOM TRANSACTION_UOM
, PRIMARY_QUANTITY PRIMARY_QUANTITY
, TRANSACTION_DATE TRANSACTION_DATE
, TRANSACTION_REFERENCE TRANSACTION_REFERENCE
, REASON_ID REASON_ID
, TRANSFER_ORGANIZATION_ID TRANSFER_ORGANIZATION_ID
, TRANSFER_SUBINVENTORY TRANSFER_SUBINVENTORY
, TRANSFER_LOCATOR_ID TRANSFER_LOCATOR_ID
, DMLTYPE$$ DMLTYPE$$
, SEQNO$$ SEQNO$$
, TRANID$$ TRANID$$
, VERSION$$ VERSION$$
FROM "CSM"."CSM_MTL_MATERIAL_TXNS_INQ"