[Home] [Help]
[Dependency Information]
Object Name: | BOMBV_BILL_OF_MATERIALS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ![]() |
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.BOMBV_BILL_OF_MATERIALS is not referenced by any database object
|
|
|