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