DBA Data[Home] [Help]

VIEW: BOM.CST_STANDARD_COSTS#

Source

View Text - Preformatted

select COST_UPDATE_ID COST_UPDATE_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ORGANIZATION_ID ORGANIZATION_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, STANDARD_COST_REVISION_DATE STANDARD_COST_REVISION_DATE, STANDARD_COST STANDARD_COST, INVENTORY_ADJUSTMENT_QUANTITY INVENTORY_ADJUSTMENT_QUANTITY, INVENTORY_ADJUSTMENT_VALUE INVENTORY_ADJUSTMENT_VALUE, INTRANSIT_ADJUSTMENT_QUANTITY INTRANSIT_ADJUSTMENT_QUANTITY, INTRANSIT_ADJUSTMENT_VALUE INTRANSIT_ADJUSTMENT_VALUE, WIP_ADJUSTMENT_QUANTITY WIP_ADJUSTMENT_QUANTITY, WIP_ADJUSTMENT_VALUE WIP_ADJUSTMENT_VALUE, LAST_COST_UPDATE_ID LAST_COST_UPDATE_ID, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE from "BOM"."CST_STANDARD_COSTS"
View Text - HTML Formatted

SELECT COST_UPDATE_ID COST_UPDATE_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ORGANIZATION_ID ORGANIZATION_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, STANDARD_COST_REVISION_DATE STANDARD_COST_REVISION_DATE
, STANDARD_COST STANDARD_COST
, INVENTORY_ADJUSTMENT_QUANTITY INVENTORY_ADJUSTMENT_QUANTITY
, INVENTORY_ADJUSTMENT_VALUE INVENTORY_ADJUSTMENT_VALUE
, INTRANSIT_ADJUSTMENT_QUANTITY INTRANSIT_ADJUSTMENT_QUANTITY
, INTRANSIT_ADJUSTMENT_VALUE INTRANSIT_ADJUSTMENT_VALUE
, WIP_ADJUSTMENT_QUANTITY WIP_ADJUSTMENT_QUANTITY
, WIP_ADJUSTMENT_VALUE WIP_ADJUSTMENT_VALUE
, LAST_COST_UPDATE_ID LAST_COST_UPDATE_ID
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
FROM "BOM"."CST_STANDARD_COSTS"