msgbartop
msgbarbottom

03 Mar 11 Bill Of Material Open Interface

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 ...