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 pay run id ?
What is the maximum number of statements that can be specified in a trigger statement?
in sql loader,i have 100 records in my flatefile, i want to skip the 80 to 90 records .please help me
Hi all I am in big career dilemma. I am currently working as Oracle Apps functional consultant scm with 1 yr of exp. I am thinking to do mba. Hos it will work to di MBA in scm or operations. Please guide .
Can u define operating units inplace of inventory?
please any one provide the oracle erp technical interview questions on modules(PO,AP,AR,INV,GL,OM)wise to my mail id..narendra_609@yahoo.co.in
what is instead of trigger in where u will use?
If the flat file is having the duplicate records in the interface how can you restrict while transferring the flat file data in to interface tables?
what r the objects u have to do in u experiance
In interface how u find errors and how to solve. How to fix it?
how to get the on hand quantity of an item across all organizations? name the underlying tables.
2 Answers Ranves IT Solutions, Scan Steel,
How many typres of Purchase order and what are those.