SELECT MLN.TRANSACTION_ID , MLN.LOT_NUMBER , MLN.INVENTORY_ITEM_ID , MLN.ORGANIZATION_ID , MLN.TRANSACTION_DATE , MLN.TRANSACTION_SOURCE_ID , MLN.TRANSACTION_SOURCE_TYPE_ID , MLN.TRANSACTION_SOURCE_NAME , MLN.SERIAL_TRANSACTION_ID , MLN.TRANSACTION_QUANTITY , MLN.PRIMARY_QUANTITY FROM MTL_TRANSACTION_LOT_NUMBERS MLN WHERE '_SEC:MLN.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY
SELECT MLN.TRANSACTION_ID
, MLN.LOT_NUMBER
, MLN.INVENTORY_ITEM_ID
, MLN.ORGANIZATION_ID
, MLN.TRANSACTION_DATE
, MLN.TRANSACTION_SOURCE_ID
, MLN.TRANSACTION_SOURCE_TYPE_ID
, MLN.TRANSACTION_SOURCE_NAME
, MLN.SERIAL_TRANSACTION_ID
, MLN.TRANSACTION_QUANTITY
, MLN.PRIMARY_QUANTITY
FROM MTL_TRANSACTION_LOT_NUMBERS MLN
WHERE '_SEC:MLN.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY
|
|
|