DBA Data[Home] [Help]

APPS.ETRM_RPT dependencies on FND_TABLES

Line 88: from applsys.fnd_tables

84: cursor cur_name(n_appid in number
85: , n_tabid in number)
86: is
87: select table_name
88: from applsys.fnd_tables
89: where application_id = n_appid
90: and table_id = n_tabid;
91:
92: vreturn_value varchar2(512) := '%';

Line 155: from fnd_tables t

151: is
152: select a.application_short_name
153: , a.application_id
154: , t.table_id
155: from fnd_tables t
156: , fnd_application a
157: where table_name = c_name
158: and t.application_id = a.application_id
159: order by a.application_short_name;

Line 391: from applsys.fnd_tables

387: , MAX_TRANS
388: , PCT_FREE
389: , PCT_USED
390: , description
391: from applsys.fnd_tables
392: where application_id = n_appid
393: and table_id = n_tabid
394: order by table_name;
395: --

Line 918: , fnd_tables t

914: , d.owner
915: , a.application_id
916: , t.table_id
917: from dba_objects d
918: , fnd_tables t
919: , fnd_application a
920: where a.application_short_name = c_owner
921: and a.application_id = t.application_id
922: and t.table_name = d.object_name

Line 992: , fnd_tables t

988: , d.object_type
989: , d.object_id
990: , d.owner
991: from dba_objects d
992: , fnd_tables t
993: , fnd_application a
994: where a.application_short_name = c_owner
995: and a.application_id = t.application_id
996: and t.table_name = d.object_name