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.IBE_LOG_TO_PHY_PVT dependencies on JTF_AMV_ITEMS_VL

Line 18: x_description OUT NOCOPY jtf_amv_items_vl.description%TYPE,

14: p_logicalid IN ibe_dsp_obj_lgl_ctnt.item_id%TYPE,
15: p_siteid IN ibe_dsp_lgl_phys_map.msite_id%TYPE,
16: p_langcode IN ibe_dsp_lgl_phys_map.language_code%TYPE,
17: x_filename OUT NOCOPY jtf_amv_attachments.file_name%TYPE,
18: x_description OUT NOCOPY jtf_amv_items_vl.description%TYPE,
19:
20: -- added by Guigen Zhang 04-04-2001 16:46
21: x_fileid OUT NOCOPY jtf_amv_attachments.file_id%TYPE) IS
22:

Line 24: l_description jtf_amv_items_vl.description%TYPE := 'description';

20: -- added by Guigen Zhang 04-04-2001 16:46
21: x_fileid OUT NOCOPY jtf_amv_attachments.file_id%TYPE) IS
22:
23: l_filename jtf_amv_attachments.file_name%TYPE;
24: l_description jtf_amv_items_vl.description%TYPE := 'description';
25:
26: -- added by Guigen Zhang 04-04-2001 16:46
27: l_fileid jtf_amv_attachments.file_id%TYPE;
28:

Line 65: jtf_amv_items_vl b,

61: select a.file_name, b.description, a.file_id
62: into l_filename, l_description, l_fileid
63: from
64: jtf_amv_attachments a,
65: jtf_amv_items_vl b,
66: ibe_dsp_lgl_phys_map c
67: where
68: c.item_id = l_logid and
69: c.msite_id = p_siteid and

Line 94: jtf_amv_items_vl b,

90: select a.file_name, b.description, a.file_id
91: into l_filename, l_description, l_fileid
92: from
93: jtf_amv_attachments a,
94: jtf_amv_items_vl b,
95: ibe_dsp_lgl_phys_map c
96: where
97: c.item_id = l_logid and
98: c.default_site = 'Y' and

Line 124: jtf_amv_items_vl b,

120: select a.file_name, b.description, a.file_id
121: into l_filename, l_description, l_fileid
122: from
123: jtf_amv_attachments a,
124: jtf_amv_items_vl b,
125: ibe_dsp_lgl_phys_map c
126: where
127: c.item_id = l_logid and
128: c.msite_id = p_siteid and

Line 153: jtf_amv_items_vl b,

149: select a.file_name, b.description, a.file_id
150: into l_filename, l_description, l_fileid
151: from
152: jtf_amv_attachments a,
153: jtf_amv_items_vl b,
154: ibe_dsp_lgl_phys_map c
155: where
156: c.item_id = l_logid and
157: c.default_site = 'Y' and

Line 221: p_access_name IN jtf_amv_items_vl.access_name%TYPE,

217: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
218: x_return_status OUT NOCOPY VARCHAR2,
219: x_msg_count OUT NOCOPY NUMBER,
220: x_msg_data OUT NOCOPY VARCHAR2,
221: p_access_name IN jtf_amv_items_vl.access_name%TYPE,
222: p_siteid IN ibe_dsp_lgl_phys_map.msite_id%TYPE,
223: p_langcode IN ibe_dsp_lgl_phys_map.language_code%TYPE,
224: x_filename OUT NOCOPY jtf_amv_attachments.file_name%TYPE,
225: x_description OUT NOCOPY jtf_amv_items_vl.description%TYPE,

Line 225: x_description OUT NOCOPY jtf_amv_items_vl.description%TYPE,

221: p_access_name IN jtf_amv_items_vl.access_name%TYPE,
222: p_siteid IN ibe_dsp_lgl_phys_map.msite_id%TYPE,
223: p_langcode IN ibe_dsp_lgl_phys_map.language_code%TYPE,
224: x_filename OUT NOCOPY jtf_amv_attachments.file_name%TYPE,
225: x_description OUT NOCOPY jtf_amv_items_vl.description%TYPE,
226:
227: -- added by Guigen Zhang 04-04-2001 16:46
228: x_fileid OUT NOCOPY jtf_amv_attachments.file_id%TYPE) IS
229:

Line 231: l_description jtf_amv_items_vl.description%TYPE := 'description';

227: -- added by Guigen Zhang 04-04-2001 16:46
228: x_fileid OUT NOCOPY jtf_amv_attachments.file_id%TYPE) IS
229:
230: l_filename jtf_amv_attachments.file_name%TYPE;
231: l_description jtf_amv_items_vl.description%TYPE := 'description';
232:
233: -- added by Guigen Zhang 04-04-2001 16:46
234: l_fileid jtf_amv_attachments.file_id%TYPE;
235:

Line 236: l_accessname jtf_amv_items_vl.access_name%TYPE;

232:
233: -- added by Guigen Zhang 04-04-2001 16:46
234: l_fileid jtf_amv_attachments.file_id%TYPE;
235:
236: l_accessname jtf_amv_items_vl.access_name%TYPE;
237: l_api_name CONSTANT varchar2(30) := 'get_obj_by_name';
238: l_phymed_found boolean := false;
239: BEGIN
240: ---dbms_output.put_line('making api version call');

Line 273: jtf_amv_items_vl b,

269: into l_filename, l_description, l_fileid
270:
271: from
272: jtf_amv_attachments a,
273: jtf_amv_items_vl b,
274: ibe_dsp_lgl_phys_map c
275: where
276: b.access_name = l_accessname and
277: c.msite_id = p_siteid and

Line 303: jtf_amv_items_vl b,

299: into l_filename, l_description, l_fileid
300:
301: from
302: jtf_amv_attachments a,
303: jtf_amv_items_vl b,
304: ibe_dsp_lgl_phys_map c
305: where
306: b.access_name = l_accessname and
307: c.default_site = 'Y' and

Line 333: jtf_amv_items_vl b,

329: into l_filename, l_description, l_fileid
330:
331: from
332: jtf_amv_attachments a,
333: jtf_amv_items_vl b,
334: ibe_dsp_lgl_phys_map c
335: where
336: b.access_name = l_accessname and
337: c.msite_id = p_siteid and

Line 364: jtf_amv_items_vl b,

360: into l_filename, l_description, l_fileid
361:
362: from
363: jtf_amv_attachments a,
364: jtf_amv_items_vl b,
365: ibe_dsp_lgl_phys_map c
366: where
367: b.access_name = l_accessname and
368: c.default_site = 'Y' and