[Home] [Help] [Dependency Information]
Object Name: | BOM_IMPLOSIONS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | BOM.BOM_IMPLOSIONS_V |
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 |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row identifier | |
ORGANIZATION_CODE | VARCHAR2 | (3) | Organization code | |
SEQUENCE_ID | NUMBER | Yes | Sequence id | |
LOWEST_ITEM_ID | NUMBER | Yes | Identifier of item to implode | |
COMPONENT_ITEM_ID | NUMBER | Yes | Component item id | |
SORT_CODE | VARCHAR2 | (240) | Yes | Sort sequence |
CURRENT_LEVEL | NUMBER | Yes | Implosion level | |
PARENT_ITEM_ID | NUMBER | Assembly item identifier | ||
ORGANIZATION_ID | NUMBER | Organization identifier | ||
PARENT | VARCHAR2 | (40) | Parent item | |
PARENT_DESCRIPTION | VARCHAR2 | (240) | Parent description | |
PARENT_UOM | VARCHAR2 | (3) | Parent unit of measure | |
ITEM_TYPE | VARCHAR2 | (80) | Item type | |
PARENT_ALTERNATE_DESIGNATOR | VARCHAR2 | (10) | Parent alternate BOM designator | |
COMPONENT_OP_SEQ_NUM | NUMBER | Component operation sequence number | ||
COMPONENT_REVISION | VARCHAR2 | (3) | Yes | Component revision |
BASIS_TYPE | VARCHAR2 | (80) | Basis type identifier | |
COMPONENT_QUANTITY | NUMBER | Component quantity | ||
PARENT_ENGINEERING_BILL | NUMBER | Parent engineering bill | ||
CHANGE_NOTICE | VARCHAR2 | (10) | Change notice | |
REVISED_ITEM_SEQUENCE_ID | NUMBER | Revised item sequence identifier | ||
IMPLEMENTED_FLAG | NUMBER | Implemented flag | ||
ITEM_STATUS | VARCHAR2 | (10) | Yes | Item status |
COMPONENT_EFFECTIVE_FROM | VARCHAR2 | (80) | Component effective from | |
COMPONENT_EFFECTIVE_TO | VARCHAR2 | (80) | Component effective to date | |
EFFECTIVITY_CONTROL | VARCHAR2 | (80) | Yes | Effectivity control |
DISABLED_FLAG | NUMBER | DIsabled flag | ||
ORG_NAME | VARCHAR2 | (240) | Yes | Organization name |
COMPONENT_NAME | VARCHAR2 | (40) | Component name | |
COMPONENT_DESCRIPTION | VARCHAR2 | (240) | Component description | |
REVISION_LABEL | VARCHAR2 | (80) | Revision label | |
STRUCTURE_TYPE_NAME | VARCHAR2 | (30) | Structure type name | |
ITEM_CATALOG_GROUP_NAME | VARCHAR2 | (4000) | Item catalog group name | |
CHANGE_ID | NUMBER | Engineering change identifier | ||
PARENT_SORT_CODE | VARCHAR2 | (240) | Sort sequence of parent | |
LIFECYCLE_ID | NUMBER | Lifecycle identifier | ||
CURRENT_PHASE_ID | NUMBER | Current phase identifier | ||
TOP_ITEM_FLAG | VARCHAR2 | (1) | indicating the topmost item in the BOM | |
PK1_VALUE | VARCHAR2 | (50) | Primary key of the object | |
PK2_VALUE | VARCHAR2 | (50) | Primary key of the object | |
OBJ_NAME | VARCHAR2 | (50) | Object name | |
CURRENT_PK1_VALUE | VARCHAR2 | (50) | Primary key | |
CURRENT_PK2_VALUE | VARCHAR2 | (50) | Primary key | |
REVISION_ID | NUMBER | Yes | Revision id | |
GTIN_NUMBER | VARCHAR2 | (255) | Gtin Number | |
GTIN_DESCRIPTION | VARCHAR2 | (240) | Gtin Description | |
TRADE_ITEM_DESCRIPTOR | VARCHAR2 | (150) | Trade Item Descriptor | |
COMPONENT_SEQUENCE_ID | NUMBER | Component Sequence Id | ||
LAST_UPDATE_DATE | DATE | Yes | Standard WHO column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard WHO column | |
CREATION_DATE | DATE | Yes | Standard WHO column | |
CREATED_BY | NUMBER | Standard WHO column | ||
LAST_UPDATE_LOGIN | NUMBER | Standard WHO column | ||
STRUCTURE_TYPE_ID | NUMBER | Structure Type id | ||
STRUCTURE_TYPE_DISP_NAME | VARCHAR2 | (80) | Structure Type Display Name | |
PRIMARY_UOM_DESCRIPTOR | VARCHAR2 | (50) | Primary UOM Description | |
STRUCTURE_NAME | VARCHAR2 | (4000) | Structure nam,e | |
GTIN_PUBLICATION_STATUS | CHAR | (1) | GTIN publication status | |
ACCESS_FLAG | VARCHAR2 | (1) | View Privilege | |
REVISION | VARCHAR2 | (3) | Yes | Revision |
COMP_REVISION_ON_IMPL_DATE | VARCHAR2 | (80) | Component revision on implementation date | |
IS_EXCLUDED_BY_RULE | VARCHAR2 | (1) | Is excluded by rule | |
COMP_REVCODE_ON_IMPL_DATE | VARCHAR2 | (3) | Yes | COmponent revision code in implementation date |
REVISION_CODE | VARCHAR2 | (3) | Revision code |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, ORGANIZATION_CODE
, SEQUENCE_ID
, LOWEST_ITEM_ID
, COMPONENT_ITEM_ID
, SORT_CODE
, CURRENT_LEVEL
, PARENT_ITEM_ID
, ORGANIZATION_ID
, PARENT
, PARENT_DESCRIPTION
, PARENT_UOM
, ITEM_TYPE
, PARENT_ALTERNATE_DESIGNATOR
, COMPONENT_OP_SEQ_NUM
, COMPONENT_REVISION
, BASIS_TYPE
, COMPONENT_QUANTITY
, PARENT_ENGINEERING_BILL
, CHANGE_NOTICE
, REVISED_ITEM_SEQUENCE_ID
, IMPLEMENTED_FLAG
, ITEM_STATUS
, COMPONENT_EFFECTIVE_FROM
, COMPONENT_EFFECTIVE_TO
, EFFECTIVITY_CONTROL
, DISABLED_FLAG
, ORG_NAME
, COMPONENT_NAME
, COMPONENT_DESCRIPTION
, REVISION_LABEL
, STRUCTURE_TYPE_NAME
, ITEM_CATALOG_GROUP_NAME
, CHANGE_ID
, PARENT_SORT_CODE
, LIFECYCLE_ID
, CURRENT_PHASE_ID
, TOP_ITEM_FLAG
, PK1_VALUE
, PK2_VALUE
, OBJ_NAME
, CURRENT_PK1_VALUE
, CURRENT_PK2_VALUE
, REVISION_ID
, GTIN_NUMBER
, GTIN_DESCRIPTION
, TRADE_ITEM_DESCRIPTOR
, COMPONENT_SEQUENCE_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, STRUCTURE_TYPE_ID
, STRUCTURE_TYPE_DISP_NAME
, PRIMARY_UOM_DESCRIPTOR
, STRUCTURE_NAME
, GTIN_PUBLICATION_STATUS
, ACCESS_FLAG
, REVISION
, COMP_REVISION_ON_IMPL_DATE
, IS_EXCLUDED_BY_RULE
, COMP_REVCODE_ON_IMPL_DATE
, REVISION_CODE
FROM APPS.BOM_IMPLOSIONS_V;
|
|
|