Monday, September 17, 2007

Create Primary Key For Oracle Apps Table

SELECT DISTINCT(PRIMARY_KEY_TYPE) FROM FND_PRIMARY_KEYS;

D - Developer or D-Surrogate

SQL> BEGIN
2 AD_DD.REGISTER_PRIMARY_KEY('INV','DEPT_PK','DEPT','Primary Key for Deparment','S','Y','Y');
3 END;
4 /

0 comments: