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.IBY_AR_UTILS dependencies on XMLAGG

Line 61: XMLConcat(XMLAgg(document_headers),

57: (c_extension_id iby_trxn_summaries_all.initiator_extension_id%TYPE,
58: c_card_data_level iby_trxn_core.card_data_level%TYPE) IS
59: /*
60: SELECT
61: XMLConcat(XMLAgg(document_headers),
62: XMLElement("DocumentReceivableCount",count(trxn_extension_id)))
63: FROM iby_xml_fndcpt_doc_headers_v
64: WHERE trxn_extension_id = c_extension_id;
65: */

Line 67: -- Added XMLAgg to pick up all the inovoices which satisfy the criteria

63: FROM iby_xml_fndcpt_doc_headers_v
64: WHERE trxn_extension_id = c_extension_id;
65: */
66: -- Bug# 12790543
67: -- Added XMLAgg to pick up all the inovoices which satisfy the criteria
68: -- Without XMLAgg only the first invoice gets picked up b'coz the cursor
69: -- uses a simple fetch
70: SELECT
71: XMLAgg(

Line 68: -- Without XMLAgg only the first invoice gets picked up b'coz the cursor

64: WHERE trxn_extension_id = c_extension_id;
65: */
66: -- Bug# 12790543
67: -- Added XMLAgg to pick up all the inovoices which satisfy the criteria
68: -- Without XMLAgg only the first invoice gets picked up b'coz the cursor
69: -- uses a simple fetch
70: SELECT
71: XMLAgg(
72: XMLConcat(XMLElement("DocumentReceivable",

Line 71: XMLAgg(

67: -- Added XMLAgg to pick up all the inovoices which satisfy the criteria
68: -- Without XMLAgg only the first invoice gets picked up b'coz the cursor
69: -- uses a simple fetch
70: SELECT
71: XMLAgg(
72: XMLConcat(XMLElement("DocumentReceivable",
73: XMLElement("DocumentID", NVL(headergt.calling_app_doc_ref_number, headergt.doc_unique_ref)),
74: XMLElement("DocumentStatus",
75: XMLElement("Code", NULL),

Line 142: (SELECT xmlagg(

138: XMLElement("Country", headergt.to_country),
139: XMLElement("PostalCode", headergt.to_postal_code)),
140: CASE
141: WHEN(c_card_data_level = '3') THEN
142: (SELECT xmlagg(
143: xmlelement("DocumentLine",
144: xmlelement("LineID", linegt.line_number),
145: xmlelement("LineNumber", linegt.line_number),
146: xmlforest(linegt.po_number AS "PONumber"),

Line 261: XMLConcat(XMLAgg(document_headers),

257: (c_extension_id iby_trxn_summaries_all.initiator_extension_id%TYPE,
258: c_card_data_level iby_trxn_core.card_data_level%TYPE) IS
259: /*
260: SELECT
261: XMLConcat(XMLAgg(document_headers),
262: XMLElement("DocumentReceivableCount",count(trxn_extension_id)))
263: FROM iby_xml_fndcpt_doc_headers_v
264: WHERE trxn_extension_id = c_extension_id;
265: */

Line 267: -- Added XMLAgg to pick up all the inovoices which satisfy the criteria

263: FROM iby_xml_fndcpt_doc_headers_v
264: WHERE trxn_extension_id = c_extension_id;
265: */
266: -- Bug# 12790543
267: -- Added XMLAgg to pick up all the inovoices which satisfy the criteria
268: -- Without XMLAgg only the first invoice gets picked up b'coz the cursor
269: -- uses a simple fetch
270: SELECT
271: XMLAgg(

Line 268: -- Without XMLAgg only the first invoice gets picked up b'coz the cursor

264: WHERE trxn_extension_id = c_extension_id;
265: */
266: -- Bug# 12790543
267: -- Added XMLAgg to pick up all the inovoices which satisfy the criteria
268: -- Without XMLAgg only the first invoice gets picked up b'coz the cursor
269: -- uses a simple fetch
270: SELECT
271: XMLAgg(
272: XMLConcat(XMLElement("DocumentReceivable",

Line 271: XMLAgg(

267: -- Added XMLAgg to pick up all the inovoices which satisfy the criteria
268: -- Without XMLAgg only the first invoice gets picked up b'coz the cursor
269: -- uses a simple fetch
270: SELECT
271: XMLAgg(
272: XMLConcat(XMLElement("DocumentReceivable",
273: XMLElement("DocumentID", NVL(headergt.calling_app_doc_ref_number, headergt.doc_unique_ref)),
274: XMLElement("DocumentStatus",
275: XMLElement("Code", NULL),

Line 342: (SELECT xmlagg(

338: XMLElement("Country", headergt.to_country),
339: XMLElement("PostalCode", headergt.to_postal_code)),
340: CASE
341: WHEN(c_card_data_level = '3') THEN
342: (SELECT xmlagg(
343: xmlelement("DocumentLine",
344: xmlelement("LineID", linegt.line_number),
345: xmlelement("LineNumber", linegt.line_number),
346: xmlforest(linegt.po_number AS "PONumber"),