49:
50: /*
51: Bug Number: 9397208
52: For Performance reasons, iby_xml_fndcpt_doc_headers_v view has been replaced
53: with global temporary tables iby_ar_doc_header_gt and iby_ar_doc_lines_gt.
54: Data will be inserted into GTs before extract view call
55: */
56: CURSOR l_doc_rec_csr
57: (c_extension_id iby_trxn_summaries_all.initiator_extension_id%TYPE,
178: xmlelement("Code", linegt.invoice_currency_code))),
179: xmlelement("RatePercent", linegt.tax_rate),
180: xmlforest('VAT' AS "TaxType"),
181: xmlforest(NULL AS "TaxJurisdiction"))))
182: FROM iby_ar_doc_lines_gt linegt
183: WHERE linegt.doc_unique_ref = headergt.doc_unique_ref)
184: ELSE
185: NULL
186: END
249:
250: /*
251: Bug Number: 9397208
252: For Performance reasons, iby_xml_fndcpt_doc_headers_v view has been replaced
253: with global temporary tables iby_ar_doc_header_gt and iby_ar_doc_lines_gt.
254: Data will be inserted into GTs before extract view call
255: */
256: CURSOR l_doc_rec_csr
257: (c_extension_id iby_trxn_summaries_all.initiator_extension_id%TYPE,
378: xmlelement("Code", linegt.invoice_currency_code))),
379: xmlelement("RatePercent", linegt.tax_rate),
380: xmlforest('VAT' AS "TaxType"),
381: xmlforest(NULL AS "TaxJurisdiction"))))
382: FROM iby_ar_doc_lines_gt linegt
383: WHERE linegt.doc_unique_ref = headergt.doc_unique_ref)
384: ELSE
385: NULL
386: END