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.QP_SOURCING_API_PUB dependencies on OE_AGREEMENTS

Line 263: FROM oe_agreements_vl

259: l_name varchar2(240);
260: --
261: CURSOR l_agreement_cursor(name_in varchar2) is
262: SELECT agreement_id
263: FROM oe_agreements_vl
264: WHERE name = name_in;
265: --
266: BEGIN
267:

Line 269: from oe_agreements_vl

265: --
266: BEGIN
267:
268: select name into l_name
269: from oe_agreements_vl
270: WHERE agreement_id = p_agreement_id
271: AND ROWNUM=1;
272:
273: /*

Line 276: FROM oe_agreements_vl

272:
273: /*
274: OPEN l_agreement_cursor FOR
275: SELECT agreement_id
276: FROM oe_agreements_vl
277: WHERE name = l_name;
278: */
279:
280: OPEN l_agreement_cursor(l_name);

Line 564: FROM oe_agreements

560: G_Agreement_Info.agreement_type_code := NULL; -- bug#3276930
561:
562: SELECT agreement_type_code
563: INTO G_Agreement_Info.agreement_type_code
564: FROM oe_agreements
565: WHERE agreement_id = p_agreement_id;
566:
567: RETURN G_Agreement_Info.agreement_type_code;
568: