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.AR_GTA_REPORTS_PKG dependencies on DUAL

Line 692: dual;

688: , Xmlconcat(L_Ar_Trx,L_Gt_Invoices)))
689: INTO
690: l_ar_trxs
691: FROM
692: dual;
693:
694: FETCH C_Trx_Ids INTO L_Ar_Trx_Id;
695: END LOOP;
696:

Line 727: FROM DUAL;

723: , ar_gta_trx_util.To_Xsd_Date_String(P_Ar_Inv_Date_From) AS "ARTrxDateFrom"
724: , ar_gta_trx_util.To_Xsd_Date_String(P_Ar_Inv_Date_TO) AS "ARTrxDateTo"))
725: INTO
726: l_Parameter
727: FROM DUAL;
728:
729: --Generate Summary Section
730: SELECT
731: Xmlelement("Summary", Xmlforest

Line 739: DUAL;

735: )
736: INTO
737: L_Summary
738: FROM
739: DUAL;
740:
741: --Generate Golden Tax Currency Section
742: OPEN C_cur;
743: FETCH C_cur INTO l_gt_cur;

Line 751: DUAL;

747: Xmlelement("RepCurr", l_gt_cur)
748: INTO
749: L_gt_currency
750: FROM
751: DUAL;
752:
753: --Generate Reports Xml Data
754: IF l_no_data_flag='Y'
755: THEN

Line 769: DUAL;

765: ))
766: INTO
767: L_Report
768: FROM
769: DUAL;
770: ELSE
771:
772: SELECT Xmlelement( "MappingReport", Xmlconcat
773: ( Xmlelement("ReportFailed",'N')

Line 784: DUAL;

780: ))
781: INTO
782: L_Report
783: FROM
784: DUAL;
785: END IF;
786:
787: ar_gta_trx_util.output_conc(L_Report.Getclobval());
788:

Line 1680: dual;

1676: )
1677: INTO
1678: l_ar_customer_bank_account_m
1679: FROM
1680: dual;
1681: ELSE
1682: l_ar_customer_bank_account_m:='';
1683: END IF; --l_ar_customer_bank_account IS NOT NULL
1684:

Line 1705: dual;

1701: )
1702: INTO
1703: l_gta_customer_bank_account_m
1704: FROM
1705: dual;
1706: ELSE
1707: l_gta_customer_bank_account_m:='';
1708: END IF; --l_gta_customer_bank_account IS NOT NULL
1709:

Line 1729: dual;

1725: )
1726: INTO
1727: l_gt_customer_bank_account_m
1728: FROM
1729: dual;
1730: ELSE
1731: l_gt_customer_bank_account_m:='';
1732: END IF; --l_gt_customer_bank_account IS NOT NULL
1733:

Line 4250: FROM dual;

4246: ,l_primary_sales_name AS "PrimarySalesPerson"
4247: )
4248: INTO
4249: l_parameter_xml
4250: FROM dual;
4251:
4252: --To calculate total number of AR transactions that have discrepancy
4253: OPEN c_ar_diff_count;
4254: FETCH c_ar_diff_count INTO l_ar_diff_count;

Line 4282: dual;

4278: )
4279: INTO
4280: l_report_xml
4281: FROM
4282: dual;
4283:
4284: ELSE
4285: --
4286: --Generate xml for summary section

Line 4317: dual;

4313: )
4314: INTO
4315: l_summary_xml
4316: FROM
4317: dual;
4318:
4319: --To get base currency
4320: OPEN c_base_currency;
4321: FETCH c_base_currency INTO l_base_currency;

Line 4370: dual;

4366: )
4367: INTO
4368: l_gta_header_xml
4369: FROM
4370: dual;
4371: END IF; --l_gta_header_xml IS NULL
4372: FETCH c_gta_header_xml INTO l_gta_header_xml_tmp;
4373: END LOOP; --c_gta_header_xml%FOUND
4374: CLOSE c_gta_header_xml;

Line 4397: dual;

4393: )
4394: INTO
4395: l_gta_line_xml
4396: FROM
4397: dual;
4398: END IF; --l_gta_line_xml IS NULL
4399: FETCH c_gta_line_xml INTO l_gta_line_xml_tmp;
4400: END LOOP; --c_gta_line_xml%FOUND
4401: CLOSE c_gta_line_xml;

Line 4423: dual;

4419: )
4420: INTO
4421: l_missing_line_xml
4422: FROM
4423: dual;
4424: END IF; --l_missing_line_xml IS NULL
4425: FETCH c_missing_line_xml INTO l_missing_line_xml_tmp;
4426: END LOOP; --c_missing_line_xml%FOUND
4427: CLOSE c_missing_line_xml;

Line 4449: dual;

4445: )
4446: INTO
4447: l_unmatched_line_xml
4448: FROM
4449: dual;
4450: END IF; --l_unmatched_line_xml IS NULL
4451: FETCH c_unmatched_line_xml INTO l_unmatched_line_xml_tmp;
4452: END LOOP; --c_unmatched_line_xml%FOUND
4453: CLOSE c_unmatched_line_xml;

Line 4477: dual;

4473: )
4474: )
4475: INTO l_ar_invoice_xml_tmp
4476: FROM
4477: dual;
4478:
4479: IF l_ar_invoice_xml IS NULL
4480: THEN
4481: l_ar_invoice_xml:=l_ar_invoice_xml_tmp;

Line 4489: FROM dual;

4485: ,l_ar_invoice_xml_tmp
4486: )
4487: INTO
4488: l_ar_invoice_xml
4489: FROM dual;
4490: END IF; --l_ar_invoice_xml IS NULL
4491: FETCH c_ar_difference INTO l_ar_difference;
4492: END LOOP; --c_ar_difference%found
4493: CLOSE c_ar_difference;

Line 4512: dual;

4508: )
4509: INTO
4510: l_missing_artrx_xml
4511: FROM
4512: dual;
4513: END IF;--l_missing_artrx_xml IS NULL
4514:
4515: FETCH c_missing_artrx_xml INTO l_missing_artrx_xml_tmp;
4516: END LOOP;--c_missing_artrx_xml%FOUND

Line 4535: dual;

4531: )
4532: INTO
4533: l_report_xml
4534: FROM
4535: dual;
4536: END IF; -- (l_ar_diff_count=0) AND (l_missing_artrx_count=0)
4537:
4538:
4539:

Line 5391: FROM DUAL;

5387: , Xmlconcat(l_consolidation_trx
5388: , l_consolidated_trxs)))
5389: INTO
5390: l_consolidation_trxs
5391: FROM DUAL;
5392:
5393: FETCH c_consolidation_trx_ids INTO l_consolidation_trx_id;
5394: END LOOP; --c_consolidation_trx_ids%FOUND
5395: CLOSE c_consolidation_trx_ids;

Line 5448: FROM DUAL;

5444: , l_invoice_type_disp AS "InvoiceType"))
5445: -- end modified by Allen Yang
5446: INTO
5447: l_parameter
5448: FROM DUAL;
5449:
5450: --Generate Reports Xml Data
5451: IF l_no_data_flag='Y'
5452: THEN

Line 5466: FROM DUAL;

5462: , ar_gta_trx_util.To_Xsd_Date_String(SYSDATE))
5463: , l_parameter))
5464: INTO
5465: l_report
5466: FROM DUAL;
5467: ELSE
5468: SELECT Xmlelement("ConsolidationMappingReport"
5469: , Xmlconcat(Xmlelement("ReportFailed",'N')
5470: , Xmlelement("FailedWithParameters",'N')

Line 5477: FROM DUAL;

5473: , l_parameter
5474: , xmlelement("Invoices", l_consolidation_trxs)))
5475: INTO
5476: l_report
5477: FROM DUAL;
5478: END IF; --l_no_data_flag='Y'
5479:
5480: ar_gta_trx_util.output_conc(l_report.getclobval());
5481: