[Home] [Help] [Dependency Information]
Object Name: | BOM_IMPLOSION_VIEW |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | BOM.BOM_IMPLOSION_VIEW |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SEQUENCE_ID | NUMBER | (22) | Yes | Implosion identifier |
LOWEST_ITEM_ID | NUMBER | Yes | Identifier of item imploded | |
SORT_CODE | VARCHAR2 | (2000) | Yes | Sort sequence |
CURRENT_LEVEL | NUMBER | Yes | Level of implosion | |
PARENT_ITEM_ID | NUMBER | Identifier of parent item | ||
ORGANIZATION_ID | NUMBER | Organization identifier | ||
PARENT | VARCHAR2 | (40) | Concatenated item flex segments of parent item | |
PARENT_DESCRIPTION | VARCHAR2 | (240) | Description of parent item | |
PARENT_UOM | VARCHAR2 | (3) | Unit of measure of parent item | |
PARENT_ALTERNATE_DESIGNATOR | VARCHAR2 | (10) | Alternate bom designator of assembly | |
PARENT_ENGINEERING_BILL | NUMBER | Indicates if parent is an engineering or manufacturing bill | ||
COMPONENT_OP_SEQ_NUM | NUMBER | Operation sequence number at which component is used in bill | ||
COMPONENT_EFFECTIVE_DATE | DATE | Date on which component is effective in bill | ||
COMPONENT_DISABLE_DATE | DATE | Date on which component is disabled in bill | ||
BASIS_TYPE | VARCHAR2 | (80) | ||
COMPONENT_QUANTITY | NUMBER | Quantity of component used in bill | ||
CHANGE_NOTICE | VARCHAR2 | (10) | Engineering change order number | |
REVISED_ITEM_SEQUENCE_ID | NUMBER | Status of parent item on an ECO | ||
ITEM_TYPE | VARCHAR2 | (30) | User defined item type | |
DISPLAY_PLAN_LEVEL | VARCHAR2 | (4000) | Formatted plan level for reporting | |
IMPLEMENTED_FLAG | NUMBER | Implemented (yes or no) |
Cut, paste (and edit) the following text to query this object:
SELECT SEQUENCE_ID
, LOWEST_ITEM_ID
, SORT_CODE
, CURRENT_LEVEL
, PARENT_ITEM_ID
, ORGANIZATION_ID
, PARENT
, PARENT_DESCRIPTION
, PARENT_UOM
, PARENT_ALTERNATE_DESIGNATOR
, PARENT_ENGINEERING_BILL
, COMPONENT_OP_SEQ_NUM
, COMPONENT_EFFECTIVE_DATE
, COMPONENT_DISABLE_DATE
, BASIS_TYPE
, COMPONENT_QUANTITY
, CHANGE_NOTICE
, REVISED_ITEM_SEQUENCE_ID
, ITEM_TYPE
, DISPLAY_PLAN_LEVEL
, IMPLEMENTED_FLAG
FROM APPS.BOM_IMPLOSION_VIEW;
APPS.BOM_IMPLOSION_VIEW is not referenced by any database object
|
|
|