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


VIEW: APPS.BOMBV_BILL_OF_MATERIALS

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

View Type

A Business Intelligence System view


This shows the product assembly structure. This structure classifies Bills of Material as manufacturing or engineering and reveals how lower level item
components are assembled into product configurations in a hierarchical
structure.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ALTERNATE_BOM_CODE VARCHAR2 (10)

ORGANIZATION_CODE VARCHAR2 (3)

ORGANIZATION_NAME VARCHAR2 (240) Yes
_KF:BILL_ITEM_NAME CHAR (15)

DESCRIPTION VARCHAR2 (240)

PENDING_FROM_ECO VARCHAR2 (10)

_LA:MANUFACTURING_BILL_FLAG CHAR (57)

ASSEMBLY_ITEM_ID NUMBER


ORGANIZATION_ID NUMBER
Yes
BILL_SEQUENCE_ID NUMBER
Yes
COMMON_ASSEMBLY_ITEM_ID NUMBER


COMMON_BILL_SEQUENCE_ID NUMBER
Yes
COMMON_ORGANIZATION_ID NUMBER


UPDATED_ON DATE
Yes
UPDATED_BY NUMBER
Yes
CREATED_ON DATE
Yes
CREATED_BY NUMBER
Yes
Query Text

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


SELECT ALTERNATE_BOM_CODE
,      ORGANIZATION_CODE
,      ORGANIZATION_NAME
,      _KF:BILL_ITEM_NAME
,      DESCRIPTION
,      PENDING_FROM_ECO
,      _LA:MANUFACTURING_BILL_FLAG
,      ASSEMBLY_ITEM_ID
,      ORGANIZATION_ID
,      BILL_SEQUENCE_ID
,      COMMON_ASSEMBLY_ITEM_ID
,      COMMON_BILL_SEQUENCE_ID
,      COMMON_ORGANIZATION_ID
,      UPDATED_ON
,      UPDATED_BY
,      CREATED_ON
,      CREATED_BY
FROM APPS.BOMBV_BILL_OF_MATERIALS;

Dependencies

[top of page]

APPS.BOMBV_BILL_OF_MATERIALS references the following:

SchemaAPPS
ViewBOM_BILL_OF_MATERIALS
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymHR_ALL_ORGANIZATION_UNITS
SynonymMTL_PARAMETERS
SynonymMTL_SYSTEM_ITEMS

APPS.BOMBV_BILL_OF_MATERIALS is not referenced by any database object