Oracle WEBADI : Registration Web-adi Table

   Create table script 

     CREATE TABLE BNE.XXST_GOLD_IMPORT_INT_BNE_T

(

  OPERATING_UNIT        VARCHAR2(100),

  SOURCE                VARCHAR2(100),

  INVOICE_NUM           VARCHAR2(200),

  INVOICE_LINE_NUM      VARCHAR2(10),

  CURRENCY              VARCHAR2(20),

BILL_TO_CUSTOMER_NAME VARCHAR2(1000),

  VAT_CODE              VARCHAR2(100),

  VAT_NUMBER            VARCHAR2(100),

  VAT_DATE              DATE,

  CREATION_DATE DATE,

  USER_NAME VARCHAR2(100),

  RESPO_NAME VARCHAR2(100),

  STATUS VARCHAR2(5)

)

   ---Check Table name in Fnd_Tables 

          select * from fnd_tables where table_name='XXST_GOLD_IMPORT_INT_BNE_T';

   ---- Delete table from fnd_tables

       EXEC AD_DD.delete_table('BNE','XXST_GOLD_IMPORT_INT_BNE_T')

   ---Register Table name 

   EXEC AD_DD.REGISTER_TABLE ('BNE','XXST_GOLD_IMPORT_INT_BNE_T','T');

   --- Register Column names in Table

EXEC AD_DD.REGISTER_COLUMN ('BNE','XXST_GOLD_IMPORT_INT_BNE_T','OPERATING_UNIT',1,'VARCHAR2',100,'Y','N');

EXEC AD_DD.REGISTER_COLUMN ('BNE','XXST_GOLD_IMPORT_INT_BNE_T','SOURCE',2,'VARCHAR2',100,'Y','N');

EXEC AD_DD.REGISTER_COLUMN ('BNE','XXST_GOLD_IMPORT_INT_BNE_T','INVOICE_NUM',3,'VARCHAR2',200,'Y','N');

EXEC AD_DD.REGISTER_COLUMN ('BNE','XXST_GOLD_IMPORT_INT_BNE_T','INVOICE_LINE_NUM',4,'VARCHAR2',10,'Y','N');

EXEC AD_DD.REGISTER_COLUMN ('BNE','XXST_GOLD_IMPORT_INT_BNE_T','CURRENCY',5,'VARCHAR2',20,'Y','N');

EXEC AD_DD.REGISTER_COLUMN ('BNE','XXST_GOLD_IMPORT_INT_BNE_T','BILL_TO_CUSTOMER_NAME',6,'VARCHAR2',1000,'Y','N');

EXEC AD_DD.REGISTER_COLUMN ('BNE','XXST_GOLD_IMPORT_INT_BNE_T','VAT_CODE',7,'VARCHAR2',100,'Y','N');

EXEC AD_DD.REGISTER_COLUMN ('BNE','XXST_GOLD_IMPORT_INT_BNE_T','VAT_NUMBER',8,'VARCHAR2',100,'Y','N');

EXEC AD_DD.REGISTER_COLUMN ('BNE','XXST_GOLD_IMPORT_INT_BNE_T','VAT_DATE',9,'DATE',9,'Y','N');

EXEC AD_DD.REGISTER_COLUMN ('BNE','XXST_GOLD_IMPORT_INT_BNE_T','CREATION_DATE',10,'DATE',9,'Y','N');

EXEC AD_DD.REGISTER_COLUMN ('BNE','XXST_GOLD_IMPORT_INT_BNE_T','USER_NAME',11,'VARCHAR2',100,'Y','N');

EXEC AD_DD.REGISTER_COLUMN ('BNE','XXST_GOLD_IMPORT_INT_BNE_T','RESPO_NAME',12,'VARCHAR2',100 ,'Y','N');

EXEC AD_DD.REGISTER_COLUMN ('BNE','XXST_GOLD_IMPORT_INT_BNE_T','STATUS',13,'VARCHAR2',5 ,'Y','N');