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 %_all and %_f tables
What do you understand by concurrent programs?
What is the package?
tell me the scenarios of between pages in reports
What are the Major differences bteween key flexfields ,descriptive flexfields
4 Answers Sierra Atlantica, TechBulls,
In developer Reports::there are 3 parameters.can you pass the paramter1+paratmeter2 value to the third parameter??
Matrix Report: Simple, Group above, Nested
If the valueset if of type –TABLE then how many tables can we attach in the valueset ?
what is the difference between request group and request security in oracle apps?
how to use .prt file in bitmap reports?
What is the result of this query ? SELECT * FROM EMP WHERE ROWNUM = 1
In hierarchical structure of a database? we have write query from where we should start?