Tuesday, September 28, 2010

Register TABLE in Oracle APPS

CREATE SYNONYM XXCUS.XX_LINES FOR APPS.XX_LINES;

begin
AD_DD.REGISTER_TABLE('XXCUS','XX_LINES','T');
end;


BEGIN
AD_DD.REGISTER_COLUMN('XXCUS','XX_LINES','LINE_NO',1,'NUMBER',10,'Y','N');
AD_DD.REGISTER_COLUMN('XXCUS','XX_LINES','ORDER_NO',2,'NUMBER',10,'Y','N');
AD_DD.REGISTER_COLUMN('XXCUS','XX_LINES','ITEM',3,'VARCHAR2',20,'Y','N');
AD_DD.REGISTER_COLUMN('XXCUS','XX_LINES','QTY',4,'NUMBER',10,'Y','N');
AD_DD.REGISTER_COLUMN('XXCUS','XX_LINES','PRICE',5,'NUMBER',10,'Y','N');
AD_DD.REGISTER_COLUMN('XXCUS','XX_LINES','AMOUNT',6,'NUMBER',10,'Y','N');
END;


Begin
ad_dd.register_primary_key('XXCUS','LINES_FK','XX_LINES','number','S','Y','Y');
end;

BEGIN
ad_dd.register_primary_key_column('XXCUS','LINES_FK','XX_LINES','ORDER_NO',1);
END;

No comments:

Post a Comment