Firstly I create a custom table.
CREATE TABLE APPS.XXINN_CREATING_BOM
(ORGANIZATION_CODE VARCHAR2(5 BYTE),
ITEM_NUMBER VARCHAR2(240 BYTE),
FROM_END_ITEM_UNIT_NUMBER VARCHAR2(30 BYTE),
TO_END_ITEM_UNIT_NUMBER VARCHAR2(30 BYTE),
COMPONENT_ITEM_NUMBER VARCHAR2(240 BYTE),
ITEM_NUM NUMBER,
COMPONENT_QUANTITY NUMBER,
COMPONENT_REMARKS VARCHAR2(240 BYTE)
)
I write an insert ...