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 |
tell me the scenarios of the independent in reports
IN GL,AP,PO,AR WHICH MODULE DOESNOT HAVE _ALL TABLES THEN WHY?
We have to show a logo/image in a report? what are the steps and which format it is?whether in pdf format is applicable or not?
maximum how many parameters we can pass through pl/sql stored procedure to oracle apps?how many mandatory parameters we can pass through pl/sql program to oracle apps11i?
while registering executable and concurent program we register both with application name|<oracle purchasing>? so my question is why we are defining in both concurent program and executable?
what is instead of trigger in where u will use?
WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?
Is it possible to do purchase order without requisition?
How many typres of Purchase order and what are those.
what are the tables of auto invoice.
Is PlaceHolderColumn Function or Procedure? Why we don't write any code in that?
what is fiscalcalendar?