[Home] [Help]
[Dependency Information]
| Object Name: | BOMBV_BILL_OF_MATERIALS |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | BOM.BOMBV_BILL_OF_MATERIALS
|
| Subobject Name: | |
| Status: | VALID |
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.
| 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 |
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;
APPS
BOM_BILL_OF_MATERIALS
FND_GLOBAL
- show dependent code
HR_ALL_ORGANIZATION_UNITS
MTL_PARAMETERS
MTL_SYSTEM_ITEMS
APPS.BOMBV_BILL_OF_MATERIALS is not referenced by any database object
|
|
|
|