TABLE REGISTRATION

TABLE REGISTRATION:
NOTE: CONNECT TO CUSTOM Schema (WIP) --WIP/WIP@PROD

1)CREATE TABLE CUSTOM_VENDORS

2) GRANT ALL ON CUSTOM_VENDORS TO APPS;

3) CONN APPS/APPS@PROD

4) CREATE PUBLIC SYNONYM CUSTOM_VENDORS FOR PO.CUSTOM_VENDORS;

5) EXEC AD_DD.REGISTER_TABLE ('PO','CUSTOM_VENDORS','T', 8, 10, 90);

6) EXEC AD_DD.REGISTER_COLUMN ('PO','CUSTOM_VENDORS','VENDOR_ID', 1,'NUMBER', 10,'N','Y');

NOTE: REGISTER ALL COLUMNS

7)COMMIT;


VALUE SETS
WHO COLUMNS
FLEXFIELD (DFF,KFF)