DBA Data[Home] [Help]

VIEW: GMD.GMD_LCF_EXTERNAL_COST#

Source

View Text - Preformatted

select INVENTORY_ITEM_ID INVENTORY_ITEM_ID, COST_ORGANIZATION_ID COST_ORGANIZATION_ID, LAB_ORGANIZATION_ID LAB_ORGANIZATION_ID, QUANTITY QUANTITY, LOT_NUMBER LOT_NUMBER, UOM UOM, UNIT_COST UNIT_COST, FROM_DATE FROM_DATE, TO_DATE TO_DATE, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATE_DATE LAST_UPDATE_DATE from "GMD"."GMD_LCF_EXTERNAL_COST"
View Text - HTML Formatted

SELECT INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, COST_ORGANIZATION_ID COST_ORGANIZATION_ID
, LAB_ORGANIZATION_ID LAB_ORGANIZATION_ID
, QUANTITY QUANTITY
, LOT_NUMBER LOT_NUMBER
, UOM UOM
, UNIT_COST UNIT_COST
, FROM_DATE FROM_DATE
, TO_DATE TO_DATE
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM "GMD"."GMD_LCF_EXTERNAL_COST"