eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AD_PATCH dependencies on AD_APPL_TOPS

Line 74: from AD_SNAPSHOTS s, AD_APPL_TOPS a,

70: if (p_appl_top_id = -1)
71: then
72: begin
73: select s.snapshot_id into l_snapshot_id
74: from AD_SNAPSHOTS s, AD_APPL_TOPS a,
75: FND_PRODUCT_GROUPS fpg
76: where s.snapshot_name = GLOBAL_VIEW_SNP_NAME
77: and s.snapshot_type = 'G'
78: and s.appl_top_id = a.appl_top_id

Line 171: from AD_SNAPSHOTS s, AD_APPL_TOPS a,

167: if (p_appl_top_id = -1)
168: then
169: begin
170: select s.snapshot_id into l_snapshot_id
171: from AD_SNAPSHOTS s, AD_APPL_TOPS a,
172: FND_PRODUCT_GROUPS fpg
173: where s.snapshot_name = GLOBAL_VIEW_SNP_NAME
174: and s.snapshot_type = 'G'
175: and s.appl_top_id = a.appl_top_id

Line 371: from AD_SNAPSHOTS s, AD_APPL_TOPS a,

367: if (p_appl_top_id = -1)
368: then
369: begin
370: select s.snapshot_id into l_snapshot_id
371: from AD_SNAPSHOTS s, AD_APPL_TOPS a,
372: FND_PRODUCT_GROUPS fpg
373: where s.snapshot_name = GLOBAL_VIEW_SNP_NAME
374: and s.snapshot_type = 'G'
375: and s.appl_top_id = a.appl_top_id

Line 846: from AD_SNAPSHOTS s, AD_APPL_TOPS a,

842: if (p_appl_top_id = -1)
843: then
844: begin
845: select s.snapshot_id into l_snapshot_id
846: from AD_SNAPSHOTS s, AD_APPL_TOPS a,
847: FND_PRODUCT_GROUPS fpg
848: where s.snapshot_name = GLOBAL_VIEW_SNP_NAME
849: and s.snapshot_type = 'G'
850: and s.appl_top_id = a.appl_top_id

Line 1009: l_app_sys_name ad_appl_tops.applications_system_name%TYPE;

1005: p_app_sys_name in varchar2,
1006: p_appl_top_type in varchar2)
1007: return number
1008: is
1009: l_app_sys_name ad_appl_tops.applications_system_name%TYPE;
1010: l_appl_top_type ad_appl_tops.appl_top_type%TYPE;
1011: l_appl_top_id ad_appl_tops.appl_top_id%TYPE;
1012: begin
1013:

Line 1010: l_appl_top_type ad_appl_tops.appl_top_type%TYPE;

1006: p_appl_top_type in varchar2)
1007: return number
1008: is
1009: l_app_sys_name ad_appl_tops.applications_system_name%TYPE;
1010: l_appl_top_type ad_appl_tops.appl_top_type%TYPE;
1011: l_appl_top_id ad_appl_tops.appl_top_id%TYPE;
1012: begin
1013:
1014: select decode(upper(p_appl_top_type),'','R',

Line 1011: l_appl_top_id ad_appl_tops.appl_top_id%TYPE;

1007: return number
1008: is
1009: l_app_sys_name ad_appl_tops.applications_system_name%TYPE;
1010: l_appl_top_type ad_appl_tops.appl_top_type%TYPE;
1011: l_appl_top_id ad_appl_tops.appl_top_id%TYPE;
1012: begin
1013:
1014: select decode(upper(p_appl_top_type),'','R',
1015: upper(p_appl_top_type))

Line 1028: from AD_APPL_TOPS

1024: end if;
1025:
1026: begin
1027: select appl_top_id into l_appl_top_id
1028: from AD_APPL_TOPS
1029: where name = p_appl_top_name
1030: and appl_top_type = l_appl_top_type
1031: and applications_system_name = l_app_sys_name;
1032: exception

Line 1035: 'No rows in AD_APPL_TOPS table for appl_top_name '||

1031: and applications_system_name = l_app_sys_name;
1032: exception
1033: when no_data_found then
1034: raise_application_error(-20001,
1035: 'No rows in AD_APPL_TOPS table for appl_top_name '||
1036: '''' || p_appl_top_name || ''''||
1037: 'and applications system name '||
1038: '''' || l_app_sys_name || ''''||
1039: ' and appl_top type '||

Line 1044: 'Too many rows in AD_APPL_TOPS table for appl_top_name '||

1040: '''' || l_appl_top_type || '''');
1041: return(0);
1042: when too_many_rows then
1043: raise_application_error(-20001,
1044: 'Too many rows in AD_APPL_TOPS table for appl_top_name '||
1045: '''' || p_appl_top_name || ''''||
1046: 'and applications system name '||
1047: '''' || l_app_sys_name || '''');
1048: return(0);