[Home] [Help]
View: OKX_BILL_OF_MATERIALS_V
View Text
SELECT BOM.BILL_SEQUENCE_ID ID1
, '#' ID2
, BOM.COMMON_BILL_SEQUENCE_ID COMMON_BILL_SEQUENCE_ID
, BOM.ASSEMBLY_ITEM_ID ASSEMBLY_ITEM_ID
, BOM.ORGANIZATION_ID ORGANIZATION_ID
, BOM.ASSEMBLY_TYPE ASSEMBLY_TYPE
, BOM.ALTERNATE_BOM_DESIGNATOR ALTERNATE_BOM_DESIGNATOR
, BOM.ALTERNATE_BOM_DESIGNATOR NAME
, 'A' STATUS
, BOM.SPECIFIC_ASSEMBLY_COMMENT DESCRIPTION
, SYSDATE START_DATE_ACTIVE
, NULL END_DATE_ACTIVE
FROM BOM_BILL_OF_MATERIALS BOM
Columns
Name |
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 |