DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.BOM_BILL_OF_MATERIALS_V

Object Details
Object Name: BOM_BILL_OF_MATERIALS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBOM.BOM_BILL_OF_MATERIALS_V
Subobject Name:
Status: VALID

View Type

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.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Record unique identifier
ASSEMBLY_ITEM_ID NUMBER

Inventory item identifier of manufactured assembly
UOM VARCHAR2 (3)
Primary unit of measure code
PICK_COMPONENTS_FLAG VARCHAR2 (1) Yes Flag indicating all shippable components of should be picked
REPLENISH_TO_ORDER_FLAG VARCHAR2 (1) Yes Assemble to Order flag
BOM_ITEM_TYPE NUMBER
Yes Type of item
BASE_ITEM_ID NUMBER

Base item identifier
DESCRIPTION VARCHAR2 (240)
Item description
ITEM_CATALOG_GROUP_ID NUMBER

Item catalog group identifier
ATP_COMPONENTS_FLAG VARCHAR2 (1) Yes Flag indicating whether item may have components requiring ATP check
WIP_SUPPLY_TYPE NUMBER

Source of WIP material supply
ENG_ITEM_FLAG VARCHAR2 (1) Yes Flag indicating engineering item
ORGANIZATION_ID NUMBER
Yes Organization identifier
ALTERNATE_BOM_DESIGNATOR VARCHAR2 (10)
Alternate designator code
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
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
COMMON_ASSEMBLY_ITEM_ID NUMBER

Assembly item identifier of common bill
SPECIFIC_ASSEMBLY_COMMENT VARCHAR2 (240)
Specific bill of material comment
PENDING_FROM_ECN VARCHAR2 (10)
Change notice that created this bill of material
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
ASSEMBLY_TYPE NUMBER
Yes 1=Manufacturing bill 2=Engineering bill
COMMON_BILL_SEQUENCE_ID NUMBER
Yes Identifier of common bill
BILL_SEQUENCE_ID NUMBER
Yes Bill of material unique identifier
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
COMMON_ORGANIZATION_ID NUMBER

Organization identifier of common bill
NEXT_EXPLODE_DATE DATE

Next date when pre-explosion will be refreshed
ITEM_TYPE VARCHAR2 (80)
QuickCode meaning
BOM_ENABLED_FLAG VARCHAR2 (1) Yes Flag indicating item may appear on a BOM
EAM_ITEM_TYPE NUMBER

EAM_ITEM_TYPE_VALUE VARCHAR2 (80)
STRUCTURE_TYPE_ID NUMBER

Structure Type Id
IMPLEMENTATION_DATE DATE

Implementation Date
ENABLE_UNIMPLEMENTED_BOMS VARCHAR2 (1)
Enable Unimplemented Boms
EFFECTIVITY_CONTROL NUMBER

SOURCE_BILL_SEQUENCE_ID NUMBER

Source Bill Sequence Id
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      ASSEMBLY_ITEM_ID
,      UOM
,      PICK_COMPONENTS_FLAG
,      REPLENISH_TO_ORDER_FLAG
,      BOM_ITEM_TYPE
,      BASE_ITEM_ID
,      DESCRIPTION
,      ITEM_CATALOG_GROUP_ID
,      ATP_COMPONENTS_FLAG
,      WIP_SUPPLY_TYPE
,      ENG_ITEM_FLAG
,      ORGANIZATION_ID
,      ALTERNATE_BOM_DESIGNATOR
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      COMMON_ASSEMBLY_ITEM_ID
,      SPECIFIC_ASSEMBLY_COMMENT
,      PENDING_FROM_ECN
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ASSEMBLY_TYPE
,      COMMON_BILL_SEQUENCE_ID
,      BILL_SEQUENCE_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      COMMON_ORGANIZATION_ID
,      NEXT_EXPLODE_DATE
,      ITEM_TYPE
,      BOM_ENABLED_FLAG
,      EAM_ITEM_TYPE
,      EAM_ITEM_TYPE_VALUE
,      STRUCTURE_TYPE_ID
,      IMPLEMENTATION_DATE
,      ENABLE_UNIMPLEMENTED_BOMS
,      EFFECTIVITY_CONTROL
,      SOURCE_BILL_SEQUENCE_ID
FROM APPS.BOM_BILL_OF_MATERIALS_V;

Dependencies

[top of page]

APPS.BOM_BILL_OF_MATERIALS_V references the following:

SchemaAPPS
ViewBOM_BILL_OF_MATERIALS
SynonymBOM_STRUCTURE_TYPES_B
ViewFND_COMMON_LOOKUPS
PL/SQL PackageFND_GLOBAL - show dependent code
ViewMFG_LOOKUPS
SynonymMTL_SYSTEM_ITEMS
SynonymMTL_SYSTEM_ITEMS_TL
APPS.BOM_BILL_OF_MATERIALS_V is referenced by following:

SchemaAPPS
ViewMSD_SR_PF_ALL_V