DBA Data[Home] [Help]

VIEW: BOM.BOM_LOW_LEVEL_CODES#

Source

View Text - Preformatted

select ROLLUP_ID ROLLUP_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, LOW_LEVEL_CODE LOW_LEVEL_CODE, CUMULATIVE_TOTAL_LEAD_TIME CUMULATIVE_TOTAL_LEAD_TIME, CUM_MANUFACTURING_LEAD_TIME CUM_MANUFACTURING_LEAD_TIME, PLANNING_MAKE_BUY_CODE PLANNING_MAKE_BUY_CODE, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE from "BOM"."BOM_LOW_LEVEL_CODES"
View Text - HTML Formatted

SELECT ROLLUP_ID ROLLUP_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, LOW_LEVEL_CODE LOW_LEVEL_CODE
, CUMULATIVE_TOTAL_LEAD_TIME CUMULATIVE_TOTAL_LEAD_TIME
, CUM_MANUFACTURING_LEAD_TIME CUM_MANUFACTURING_LEAD_TIME
, PLANNING_MAKE_BUY_CODE PLANNING_MAKE_BUY_CODE
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
FROM "BOM"."BOM_LOW_LEVEL_CODES"