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

VIEW: APPS.BOM_BILL_OF_MATERIALS_ERV

Object Details
Object Name: BOM_BILL_OF_MATERIALS_ERV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBOM.BOM_BILL_OF_MATERIALS_ERV
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)
Row identifier
ASSEMBLY_ITEM_ID NUMBER

Inventory item identifier of manufactured assembly
UOM VARCHAR2 (3)
Unit of measure
PICK_COMPONENTS_FLAG VARCHAR2 (1) Yes Pick components flag
REPLENISH_TO_ORDER_FLAG VARCHAR2 (1) Yes Replenish to order
BOM_ITEM_TYPE NUMBER
Yes BOM item type
BASE_ITEM_ID NUMBER

Base item identifier
ASSEMBLY_ITEM_NO VARCHAR2 (40)
Item number of manufactured assembly
ASSEMBLY_ITEM_DESCRIPTION VARCHAR2 (240)
Item description of manufactured assembly
ASSEMBLY_ITEM_REVISION VARCHAR2 (3)
Item revision of manufactured assembly
ITEM_CATALOG_GROUP_ID NUMBER

Item catalog group identifier
ITEM_CATALOG_GROUP VARCHAR2 (4000)
Item catalog group
ATP_COMPONENTS_FLAG VARCHAR2 (1) Yes ATP component flag
WIP_SUPPLY_TYPE NUMBER

Work in process supply type
ENG_ITEM_FLAG VARCHAR2 (1) Yes Engineering item flag
ORGANIZATION_ID NUMBER
Yes Organization identifier
ORGANIZATION_CODE VARCHAR2 (3)
Organization code
ORGANIZATION_NAME VARCHAR2 (240) Yes Organization name
ALTERNATE_BOM_DESIGNATOR VARCHAR2 (10)
Alternate BOM designator
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
COMMON_ASSEMBLY_ITEM_NO VARCHAR2 (40)
Assembly item number of common bill
COMMON_ASSEMBLY_DESCRIPTION VARCHAR2 (240)
Assembly item description of common bill
SPECIFIC_ASSEMBLY_COMMENT VARCHAR2 (240)
Comment on specific assembly
PENDING_FROM_ECN VARCHAR2 (10)
Pending from ECN
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 Assembly type
COMMON_BILL_SEQUENCE_ID NUMBER
Yes Sequence id for common bill
BILL_SEQUENCE_ID NUMBER
Yes Bill sequence id
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 for common bill
COMMON_ORGANIZATION_CODE VARCHAR2 (3)
organization code for common bill
COMMON_ORGANIZATION_NAME VARCHAR2 (240)
Organization name for common bill
NEXT_EXPLODE_DATE DATE

Next bill explosion date
ITEM_TYPE VARCHAR2 (80)
Item type
BOM_ENABLED_FLAG VARCHAR2 (1) Yes BOM enabled flag
EAM_ITEM_TYPE NUMBER

EAM item type
EAM_ITEM_TYPE_VALUE VARCHAR2 (80)
EAM item type value
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
,      ASSEMBLY_ITEM_NO
,      ASSEMBLY_ITEM_DESCRIPTION
,      ASSEMBLY_ITEM_REVISION
,      ITEM_CATALOG_GROUP_ID
,      ITEM_CATALOG_GROUP
,      ATP_COMPONENTS_FLAG
,      WIP_SUPPLY_TYPE
,      ENG_ITEM_FLAG
,      ORGANIZATION_ID
,      ORGANIZATION_CODE
,      ORGANIZATION_NAME
,      ALTERNATE_BOM_DESIGNATOR
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      COMMON_ASSEMBLY_ITEM_ID
,      COMMON_ASSEMBLY_ITEM_NO
,      COMMON_ASSEMBLY_DESCRIPTION
,      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
,      COMMON_ORGANIZATION_CODE
,      COMMON_ORGANIZATION_NAME
,      NEXT_EXPLODE_DATE
,      ITEM_TYPE
,      BOM_ENABLED_FLAG
,      EAM_ITEM_TYPE
,      EAM_ITEM_TYPE_VALUE
FROM APPS.BOM_BILL_OF_MATERIALS_ERV;

Dependencies

[top of page]

APPS.BOM_BILL_OF_MATERIALS_ERV references the following:

SchemaAPPS
ViewBOM_BILL_OF_MATERIALS
ViewFND_COMMON_LOOKUPS
PL/SQL PackageFND_FLEX_SERVER - show dependent code
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymHR_ALL_ORGANIZATION_UNITS_TL
ViewMFG_LOOKUPS
SynonymMTL_ITEM_CATALOG_GROUPS
SynonymMTL_ITEM_REVISIONS
SynonymMTL_PARAMETERS
ViewMTL_SYSTEM_ITEMS_VL

APPS.BOM_BILL_OF_MATERIALS_ERV is not referenced by any database object