HOW CAN U KNOW TABLE IS REGISTERD IN APPS?
Answers were Sorted based on User's Feedback
Answer / kumar
use the following query to check the same:
select table_name from fnd_tables
where table_name = <table name>
table name = mention the table name, which u want to know
whether it is registered in APPS.
| Is This Answer Correct ? | 12 Yes | 3 No |
Answer / kranthi kumar
U CAN KNOW FROM FRONT END ALSO
NAV: APPLICATION DEVELOPER-->APPLICATION-->DATABASE-->TABLE
QUERY FOR THE TABLE WHICH U WANT TO TEST.
IF IT IS REGISTERED THEN U CAN SEE THAT TABLE THERE.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / venkat kolla
Using ad_dd package.
Example:
First register the table:
EXECUTE ad_dd.register_table
('FND','TABLE_NAME','T',pct_free,pct_used)
Then register the columns:
EXECUTE ad_dd.register_columns
('FND','TABLE_NAME','COLUMN_NAME',
sequence, 'DATATYPE',col_width,nullable,translate)
| Is This Answer Correct ? | 4 Yes | 7 No |
what is the difference between request group and request security group in oracle apps?
Which module is not in multiorg
What is REF Cursor?
19 Answers Infosys, Intelligroup,
What is SET-OF-BOOKS?
What is the use of format trigger?
What are the Major differences bteween key flexfields ,descriptive flexfields
4 Answers Sierra Atlantica, TechBulls,
API?s FOR CUSTOMER INTERFACE? Tell me some API's?
what is unit of measure classes? give atleast two examples. name the underlying table.
What is the package?
Can 2 functions have same name & input parameters but differ only by return datatype ?
which is the table for storing organization information?
9 Answers Infosys, Scan Steel,
What is FORWARD DECLARATION in Packages?
6 Answers British Telecom BT, HCL, Tech Mahindra,