I have One Oracle Apps Custom Form,In that Form I want to Know form which table the database blaock getting data for form,So I right click the DATA BLOCK-->property palatte-->Database Block.in the database Block =yes/Query data source is Null.no table name is Showing.Please help me to Find the table Name.

CodePudding user response：

There's a binary logic for determining the data source. The table name in the Data Source part has priority in case Database Block option set to Yes as you already checked for.

Otherwise(in case Data Source is null), the Block Name will be considered as the data source name, eg. a table or view name within the currently connected schema, provided again that the Database Block option set to Yes

Another case that you might have a query , presumably within a trigger of forms, populating the fields under that block.