APPS.ETRM_RPT dependencies on FND_APPLICATION

Line 16: from fnd_application

12:
13: cursor cur_app(c_app in varchar2)
14: is
15: select application_id
16: from fnd_application
17: where application_short_name = c_app;
18:
19: vreturn_value number(16) := NULL;
20: begin

Line 156: , fnd_application a

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;
160:

Line 168: , fnd_application a

164: select a.application_short_name
165: , a.application_id
166: , t.view_id
167: from fnd_views t
168: , fnd_application a
169: where view_name = c_name
170: and t.application_id = a.application_id
171: order by a.application_short_name;
172:

Line 919: , fnd_application a

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
923: and d.object_type = 'TABLE'

Line 932: , fnd_application a

928: , a.application_id
929: , t.view_id table_id
930: from dba_objects d
931: , fnd_views t
932: , fnd_application a
933: where a.application_short_name = c_owner
934: and a.application_id = t.application_id
935: and t.view_name = d.object_name
936: and d.object_type = 'VIEW'

Line 993: , fnd_application a

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
997: and d.object_type = 'TABLE'

Line 1005: , fnd_application a

1001: , d.object_id
1002: , d.owner
1003: from dba_objects d
1004: , fnd_views t
1005: , fnd_application a
1006: where a.application_short_name = c_owner
1007: and a.application_id = t.application_id
1008: and t.view_name = d.object_name
1009: and d.object_type = 'VIEW'

Line 1045: from fnd_application a

1041: select a.application_id
1042: , a.application_short_name
1043: , t.application_name
1044: , t.description
1045: from fnd_application a
1046: , fnd_application_tl t
1047: where a.application_id = t.application_id
1048: order by a.application_short_name;
1049:

Line 1046: , fnd_application_tl t

1042: , a.application_short_name
1043: , t.application_name
1044: , t.description
1045: from fnd_application a
1046: , fnd_application_tl t
1047: where a.application_id = t.application_id
1048: order by a.application_short_name;
1049:
1050: cursor cur_appid

Line 1053: from fnd_application

1049:
1050: cursor cur_appid
1051: is
1052: select application_id
1053: from fnd_application
1054: order by application_id;
1055:
1056:
1057:

Line 1058: v_item_appid fnd_application.application_id%type;

1054: order by application_id;
1055:
1056:
1057:
1058: v_item_appid fnd_application.application_id%type;
1059: v_depend_appid fnd_application.application_id%type;
1060: v_item_rowid number(16);
1061: v_loop_start number(16);
1062: v_loop_end number(16);

Line 1059: v_depend_appid fnd_application.application_id%type;

1055:
1056:
1057:
1058: v_item_appid fnd_application.application_id%type;
1059: v_depend_appid fnd_application.application_id%type;
1060: v_item_rowid number(16);
1061: v_loop_start number(16);
1062: v_loop_end number(16);
1063: v_item_name dba_objects.object_name%type;