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

VIEW: APPS.OKX_BILL_OF_MATERIALS_V

Object Details
Object Name: OKX_BILL_OF_MATERIALS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKX.OKX_BILL_OF_MATERIALS_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
ID1 NUMBER
Yes Bill of material unique identifier
ID2 CHAR (1)
(Multi-part) Primary Key
COMMON_BILL_SEQUENCE_ID NUMBER
Yes Identifier of common bill
ASSEMBLY_ITEM_ID NUMBER

Inventory item identifier of manufactured assembly
ORGANIZATION_ID NUMBER
Yes Organization identifier
ASSEMBLY_TYPE NUMBER
Yes 1=Manufacturing bill 2=Engineering bill
ALTERNATE_BOM_DESIGNATOR VARCHAR2 (10)
Alternate designator code
NAME VARCHAR2 (10)
Alternate BOM designator
STATUS CHAR (1)
Status
DESCRIPTION VARCHAR2 (240)
Specific assembly component - description
START_DATE_ACTIVE DATE

Date record becomes active
END_DATE_ACTIVE VARCHAR2 (0)
Date record becomes inactive
Query Text

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


SELECT ID1
,      ID2
,      COMMON_BILL_SEQUENCE_ID
,      ASSEMBLY_ITEM_ID
,      ORGANIZATION_ID
,      ASSEMBLY_TYPE
,      ALTERNATE_BOM_DESIGNATOR
,      NAME
,      STATUS
,      DESCRIPTION
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
FROM APPS.OKX_BILL_OF_MATERIALS_V;

Dependencies

[top of page]

APPS.OKX_BILL_OF_MATERIALS_V references the following:

SchemaAPPS
ViewBOM_BILL_OF_MATERIALS
PL/SQL PackageFND_GLOBAL - show dependent code

APPS.OKX_BILL_OF_MATERIALS_V is not referenced by any database object