Table and Column Registration in APPS

CREATE TABLE WIP_ITEM

(

   ITEM               VARCHAR2 (15),

   ITEMDESCRIPTION    VARCHAR2 (100),

   ITEMCOST           NUMBER (8),

   CATEGORYK          VARCHAR2 (100),

   CREATION_DATE      DATE,

   CREATED_BY         NUMBER (7),

   LAST_UPDATE_DATE   DATE,

   LAST_UPDATED_BY    NUMBER (7),

   ATTRIBUTE_CAT      VARCHAR2 (100),

   ATTRIBUTE1         VARCHAR2 (100),

   ATTRIBUTE2         VARCHAR2 (100),

   ATTRIBUTE3         VARCHAR2 (100),

   ATTRIBUTE4         VARCHAR2 (100),

   ATTRIBUTE5         VARCHAR2 (100)

);

/*

begin

 AD_DD.REGISTER_TABLE

(p_appl_short_name,

p_tab_name, --table name

p_tab_type,

p_next_extent, -- Enter the initial and next extent sizes in kilobytes for your table. You must enter values greater than 0.

p_pct_free,--free storage.

p_pct_used);-- used storage.

end; */

BEGIN

 AD_DD.REGISTER_TABLE('WIP','WIP_ITEM','T',8,10,90);

 COMMIT;

END;

Query with Table Name 

/*

Registering the Columns:

Syntax:  AD_DD.REGISTER_COLUMN p_appl_short_name,

p_tab_name,

p_col_name,

p_col_seq,

p_col_type,

p_col_width,

p_nullable,

p_translate,

p_precision default null,

p_scale default null);

*/

BEGIN

 AD_DD.REGISTER_COLUMN('WIP','WIP_ITEM','ITEM',1,'VARCHAR2',15,'N','Y');

 AD_DD.REGISTER_COLUMN('WIP','WIP_ITEM','ITEMDESCRIPTION',2,'VARCHAR2',100,'N','Y');

 AD_DD.REGISTER_COLUMN('WIP','WIP_ITEM','ITEMCOST',3,'NUMBER',8,'N','Y');

 AD_DD.REGISTER_COLUMN('WIP','WIP_ITEM','CATEGORYK',4,'VARCHAR2',100,'N','Y');

 AD_DD.REGISTER_COLUMN('WIP','WIP_ITEM','CREATION_DATE',5,'DATE',11,'N','Y');

 AD_DD.REGISTER_COLUMN('WIP','WIP_ITEM','CREATED_BY',6,'NUMBER',7,'N','Y');

 AD_DD.REGISTER_COLUMN('WIP','WIP_ITEM','LAST_UPDATE_DATE',7,'DATE',11,'N','Y');

 AD_DD.REGISTER_COLUMN('WIP','WIP_ITEM','LAST_UPDATED_BY',8,'NUMBER',7,'N','Y');

 AD_DD.REGISTER_COLUMN('WIP','WIP_ITEM','ATTRIBUTE_CAT',9,'VARCHAR2',100,'N','Y');

 AD_DD.REGISTER_COLUMN('WIP','WIP_ITEM','ATTRIBUTE1',10,'VARCHAR2',100,'N','Y');

 AD_DD.REGISTER_COLUMN('WIP','WIP_ITEM','ATTRIBUTE2',11,'VARCHAR2',100,'N','Y');

 AD_DD.REGISTER_COLUMN('WIP','WIP_ITEM','ATTRIBUTE3',12,'VARCHAR2',100,'N','Y');

 AD_DD.REGISTER_COLUMN('WIP','WIP_ITEM','ATTRIBUTE4',13,'VARCHAR2',100,'N','Y');

 AD_DD.REGISTER_COLUMN('WIP','WIP_ITEM','ATTRIBUTE5',14,'VARCHAR2',100,'N','Y');

 COMMIT;

END;

Query with Table Name