[Home] [Help] [Dependency Information]
Object Name: | BOM_IMPL_INQUIRY_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | BOM.BOM_IMPL_INQUIRY_V |
Subobject Name: | |
Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row identifier | |
ORGANIZATION_CODE | VARCHAR2 | (3) | ||
SEQUENCE_ID | NUMBER | Yes | Implosion identifier | |
LOWEST_ITEM_ID | NUMBER | Yes | Identifier of item to implode | |
COMPONENT_ITEM_ID | NUMBER | Yes | Component item identifier | |
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 | (4000) | Parent item | |
PARENT_DESCRIPTION | VARCHAR2 | (4000) | Parent item description | |
PARENT_UOM | VARCHAR2 | (3) | Parent item's unit of measure | |
ITEM_TYPE | VARCHAR2 | (80) | Parent item's user defined item type | |
PARENT_ALTERNATE_DESIGNATOR | VARCHAR2 | (10) | Parent's alternate bom designator | |
COMPONENT_OP_SEQ_NUM | NUMBER | Component's operation sequence number | ||
COMPONENT_REVISION | VARCHAR2 | (3) | Yes | Component's revision |
BASIS_TYPE | VARCHAR2 | (80) | ||
COMPONENT_QUANTITY | NUMBER | Component quantity | ||
PARENT_ENGINEERING_BILL | NUMBER | Flag indicating if parent bill is engineering or manufacturing | ||
CHANGE_NOTICE | VARCHAR2 | (10) | Engineering change order | |
REVISED_ITEM_SEQUENCE_ID | NUMBER | Revised item unique identifier | ||
IMPLEMENTED_FLAG | NUMBER | Indicator if component row is implemented or pending | ||
ITEM_STATUS | VARCHAR2 | (10) | Yes | Component's item status code |
COMPONENT_EFFECTIVE_FROM | VARCHAR2 | (30) | ||
COMPONENT_EFFECTIVE_TO | VARCHAR2 | (30) | ||
EFFECTIVITY_CONTROL | VARCHAR2 | (80) | ||
DISABLED_FLAG | NUMBER | Disabled (Yes/No) | ||
ORG_NAME | VARCHAR2 | (240) | Yes | |
COMPONENT_NAME | VARCHAR2 | (4000) | Component name | |
REVISION_LABEL | VARCHAR2 | (80) | Revision Label | |
PARENT_SORT_CODE | VARCHAR2 | (240) | ||
LIFECYCLE_ID | NUMBER | |||
CURRENT_PHASE_ID | NUMBER | |||
COMPONENT_EFFECTIVE_FROM_DATE | DATE | |||
COMPONENT_EFFECTIVE_TO_DATE | DATE |
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
, REVISION_LABEL
, PARENT_SORT_CODE
, LIFECYCLE_ID
, CURRENT_PHASE_ID
, COMPONENT_EFFECTIVE_FROM_DATE
, COMPONENT_EFFECTIVE_TO_DATE
FROM APPS.BOM_IMPL_INQUIRY_V;
APPS.BOM_IMPL_INQUIRY_V is not referenced by any database object
|
|
|