Friday, 2 August 2013

How to register table in Oracle Apps



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

In how many ways we can link the requisition to purchase order in oracle ebs

 In Oracle E-Business Suite (EBS) R12 / R12.2, a Purchase Requisition can be joined to a Purchase Order across 4 primary levels , depending ...