[Home] [Help] [Dependency Information]
Object Name: | BOM_LOW_LEVEL_CODES |
---|---|
Object Type: | TABLE |
Owner: | BOM |
FND Design Data: | BOM.BOM_LOW_LEVEL_CODES |
Subobject Name: | |
Status: | VALID |
BOM_LOW_LEVEL_CODES stores temporary data for cumulative rollup of
lead times. It also stores the exploded BOM structure for an assembly. The
value of LOW_LEVEL_CODE for an item (INVENTORY_ITEM_ID) determines
which level it is in the BOM structure. The cumulative lead time
(CUMULATIVE_TOTAL_LEAD_TIME), and cumulative manufacturing lead time
(CUM_MANUFACTURING_LEAD_TIME) are calculated for all make-items at
each BOM level.
Tablespace: | APPS_TS_NOLOGGING |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BOM_LOW_LEVEL_CODES_U1 | NORMAL | UNIQUE | APPS_TS_NOLOGGING |
ROLLUP_ID
INVENTORY_ITEM_ID LOW_LEVEL_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROLLUP_ID | NUMBER | Yes | Rollup identifier | |
INVENTORY_ITEM_ID | NUMBER | Yes | Item identifier | |
LOW_LEVEL_CODE | NUMBER | Yes | Low Level Code | |
CUMULATIVE_TOTAL_LEAD_TIME | NUMBER | Cumulative total lead time | ||
CUM_MANUFACTURING_LEAD_TIME | NUMBER | Cumulative manufacturing lead time | ||
PLANNING_MAKE_BUY_CODE | NUMBER | Planning Make buy code | ||
REQUEST_ID | NUMBER | Concurrent Who column | ||
PROGRAM_APPLICATION_ID | NUMBER | Concurrent Who column | ||
PROGRAM_ID | NUMBER | Concurrent Who column | ||
PROGRAM_UPDATE_DATE | DATE | Concurrent Who column |
Cut, paste (and edit) the following text to query this object:
SELECT ROLLUP_ID
, INVENTORY_ITEM_ID
, LOW_LEVEL_CODE
, CUMULATIVE_TOTAL_LEAD_TIME
, CUM_MANUFACTURING_LEAD_TIME
, PLANNING_MAKE_BUY_CODE
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
FROM BOM.BOM_LOW_LEVEL_CODES;
BOM.BOM_LOW_LEVEL_CODES does not reference any database object
BOM.BOM_LOW_LEVEL_CODES is referenced by following:
|
|
|