Register Table in Oracle Apps EBS

Create custom table on Custom Scheme

After that create synonym in APPS scheme.

 

CREATE TABLE XX_XTR_BOND_MASTER

(

BOND_CODE_ID          NUMBER                  NOT NULL,

BOND_CODE             VARCHAR2(20 BYTE)       NOT NULL,

BOND_NAME             VARCHAR2(200 BYTE),

TENURE                NUMBER,

HOLIDAY_CONSESSION    VARCHAR2(2 BYTE),

INTEREST_FREQUENCY    VARCHAR2(2 BYTE),

INTEREST_PAY_DATE     DATE,

EFFECTIVE_START_DATE  DATE,

EFFECTIVE_END_DATE    DATE,

LAST_UPDATE_DATE      DATE                    NOT NULL,

LAST_UPDATED_BY       NUMBER                  NOT NULL,

LAST_UPDATE_LOGIN     NUMBER,

CREATION_DATE         DATE                    NOT NULL,

CREATED_BY            NUMBER(15)              NOT NULL,

ATTRIBUTE1            VARCHAR2(150 BYTE),

ATTRIBUTE2            VARCHAR2(150 BYTE),

ATTRIBUTE3            VARCHAR2(150 BYTE),

ATTRIBUTE4            VARCHAR2(150 BYTE),

ATTRIBUTE5            VARCHAR2(150 BYTE),

ATTRIBUTE6            VARCHAR2(150 BYTE),

ATTRIBUTE7            VARCHAR2(150 BYTE),

ATTRIBUTE8            VARCHAR2(150 BYTE),

ATTRIBUTE9            VARCHAR2(150 BYTE),

ATTRIBUTE10           VARCHAR2(150 BYTE),

ATTRIBUTE11           VARCHAR2(150 BYTE),

ATTRIBUTE12           VARCHAR2(150 BYTE),

ATTRIBUTE13           VARCHAR2(150 BYTE),

ATTRIBUTE14           VARCHAR2(150 BYTE),

ATTRIBUTE15           VARCHAR2(150 BYTE),

ATTRIBUTE_CATEGORY1   VARCHAR2(250 BYTE)

);

 

 

CREATE SYNONYM APPS.XX_XTR_BOND_MASTER FOR XX_XTR_BOND_MASTER;

 

 

BEGIN

AD_DD.REGISTER_TABLE(‘XX’,’XX_XTR_BOND_MASTER’,’T’);

END;

 

BEGIN

AD_DD.DELETE_TABLE(‘XX’,’XX_XTR_BOND_MASTER’);

END;

 

 

BEGIN

AD_DD.REGISTER_COLUMN(‘XXREC’,’XX_XTR_BOND_MASTER’,’BOND_CODE_ID’,1,’NUMBER’,100,’N’,’N’);

AD_DD.REGISTER_COLUMN(‘XXREC’,’XX_XTR_BOND_MASTER’,’BOND_CODE’,2,’VARCHAR2′,20,’N’,’N’);

AD_DD.REGISTER_COLUMN(‘XXREC’,’XX_XTR_BOND_MASTER’,’BOND_NAME’,3,’VARCHAR2′,200,’Y’,’N’);

AD_DD.REGISTER_COLUMN(‘XXREC’,’XX_XTR_BOND_MASTER’,’TENURE’,4,’NUMBER’,100,’Y’,’N’);

AD_DD.REGISTER_COLUMN(‘XXREC’,’XX_XTR_BOND_MASTER’,’HOLIDAY_CONSESSION’,5,’VARCHAR2′,2,’Y’,’N’);

AD_DD.REGISTER_COLUMN(‘XXREC’,’XX_XTR_BOND_MASTER’,’INTEREST_FREQUENCY’,6,’VARCHAR2′,2,’Y’,’N’);

AD_DD.REGISTER_COLUMN(‘XXREC’,’XX_XTR_BOND_MASTER’,’INTEREST_PAY_DATE’,7,’DATE’,20,’Y’,’N’);

AD_DD.REGISTER_COLUMN(‘XXREC’,’XX_XTR_BOND_MASTER’,’EFFECTIVE_START_DATE’,8,’DATE’,20,’Y’,’N’);

AD_DD.REGISTER_COLUMN(‘XXREC’,’XX_XTR_BOND_MASTER’,’EFFECTIVE_END_DATE’,9,’DATE’,20,’Y’,’N’);

AD_DD.REGISTER_COLUMN(‘XXREC’,’XX_XTR_BOND_MASTER’,’LAST_UPDATE_DATE’,10,’DATE’,20,’N’,’N’);

AD_DD.REGISTER_COLUMN(‘XXREC’,’XX_XTR_BOND_MASTER’,’LAST_UPDATED_BY’,11,’NUMBER’,20,’N’,’N’);

AD_DD.REGISTER_COLUMN(‘XXREC’,’XX_XTR_BOND_MASTER’,’LAST_UPDATE_LOGIN’,12,’NUMBER’,20,’Y’,’N’);

AD_DD.REGISTER_COLUMN(‘XXREC’,’XX_XTR_BOND_MASTER’,’CREATION_DATE’,13,’DATE’,20,’N’,’N’);

AD_DD.REGISTER_COLUMN(‘XXREC’,’XX_REC_XTR_BOND_MASTER’,’CREATED_BY’,14,’NUMBER’,20,’N’,’N’);

AD_DD.REGISTER_COLUMN(‘XXREC’,’XX_XTR_BOND_MASTER’,’ATTRIBUTE1′,15,’VARCHAR2′,250,’N’,’N’);

AD_DD.REGISTER_COLUMN(‘XXREC’,’XX_XTR_BOND_MASTER’,’ATTRIBUTE2′,16,’VARCHAR2′,250,’N’,’N’);

AD_DD.REGISTER_COLUMN(‘XXREC’,’XX_XTR_BOND_MASTER’,’ATTRIBUTE3′,17,’VARCHAR2′,250,’N’,’N’);

AD_DD.REGISTER_COLUMN(‘XXREC’,’XX_XTR_BOND_MASTER’,’ATTRIBUTE4′,18,’VARCHAR2′,250,’N’,’N’);

AD_DD.REGISTER_COLUMN(‘XXREC’,’XX_XTR_BOND_MASTER’,’ATTRIBUTE5′,19,’VARCHAR2′,250,’N’,’N’);

AD_DD.REGISTER_COLUMN(‘XXREC’,’XX_XTR_BOND_MASTER’,’ATTRIBUTE6′,20,’VARCHAR2′,250,’N’,’N’);

AD_DD.REGISTER_COLUMN(‘XXREC’,’XX_XTR_BOND_MASTER’,’ATTRIBUTE7′,21,’VARCHAR2′,250,’N’,’N’);

AD_DD.REGISTER_COLUMN(‘XXREC’,’XX_XTR_BOND_MASTER’,’ATTRIBUTE8′,22,’VARCHAR2′,250,’N’,’N’);

AD_DD.REGISTER_COLUMN(‘XXREC’,’XX_XTR_BOND_MASTER’,’ATTRIBUTE9′,23,’VARCHAR2′,250,’N’,’N’);

AD_DD.REGISTER_COLUMN(‘XXREC’,’XX_XTR_BOND_MASTER’,’ATTRIBUTE10′,24,’VARCHAR2′,250,’N’,’N’);

AD_DD.REGISTER_COLUMN(‘XXREC’,’XX_XTR_BOND_MASTER’,’ATTRIBUTE11′,25,’VARCHAR2′,250,’N’,’N’);

AD_DD.REGISTER_COLUMN(‘XXREC’,’XX_XTR_BOND_MASTER’,’ATTRIBUTE12′,26,’VARCHAR2′,250,’N’,’N’);

AD_DD.REGISTER_COLUMN(‘XXREC’,’XX_XTR_BOND_MASTER’,’ATTRIBUTE13′,27,’VARCHAR2′,25,’N’,’N’);

AD_DD.REGISTER_COLUMN(‘XXREC’,’XX_XTR_BOND_MASTER’,’ATTRIBUTE14′,28,’VARCHAR2′,250,’N’,’N’);

AD_DD.REGISTER_COLUMN(‘XXREC’,’XX_XTR_BOND_MASTER’,’ATTRIBUTE15′,29,’VARCHAR2′,250,’N’,’N’);

AD_DD.REGISTER_COLUMN(‘XXREC’,’XX_XTR_BOND_MASTER’,’ATTRIBUTE_CATEGORY1′,30,’VARCHAR2′,250,’N’,’N’);

END;

Advertisements