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.FUN_XML_REPORT_PKG dependencies on FUN_NET_BATCHES_ALL

Line 166: FROM FUN_NET_BATCHES_ALL FNB,

162: FNB.SETTLEMENT_DATE,
163: FNB.TRANSACTION_DUE_DATE,
164: FNB.RESPONSE_DATE,
165: FNB.TOTAL_NETTED_AMT
166: FROM FUN_NET_BATCHES_ALL FNB,
167: FUN_NET_AGREEMENTS_ALL FNA,
168: HR_OPERATING_UNITS HOU,
169: CE_BANK_ACCOUNTS CBA,
170: FUN_LOOKUPS FLC1,

Line 212: FUN_NET_BATCHES_ALL FNB,

208: PVS.VENDOR_SITE_CODE AS SITE,
209: PV.NUM_1099 AS SUPPLIER_TAXPAYER_ID,
210: PV.VAT_REGISTRATION_NUM AS SUPPLIER_TAX_REGN_NUM
211: FROM FUN_NET_AP_INVS_ALL FNAP,
212: FUN_NET_BATCHES_ALL FNB,
213: AP_INVOICES_ALL API,
214: AP_LOOKUP_CODES ALC,
215: PO_VENDORS PV,
216: PO_VENDOR_SITES_ALL PVS

Line 252: FUN_NET_BATCHES_ALL FNB,

248: FNB.BATCH_CURRENCY AS RECKONING_CURRENCY,
249: MIN(APS.DUE_DATE) AS DUE_DATE,
250: SUM(nvl(vat.vat_amount,0)) AS VAT_AMOUNT
251: FROM FUN_NET_AP_INVS_ALL FNAP,
252: FUN_NET_BATCHES_ALL FNB,
253: AP_INVOICES_ALL API,
254: ap_invoice_lines_all ail,
255: AP_LOOKUP_CODES ALC,
256: AP_PAYMENT_SCHEDULES_ALL APS,

Line 331: FUN_NET_BATCHES_ALL FNB,

327: HCSU.SITE_USE_ID AS SITE_USE_ID,
328: HP.JGZZ_FISCAL_CODE AS CUST_TAXPAYER_ID,
329: HP.TAX_REFERENCE AS CUST_TAX_REGN_NUM
330: FROM FUN_NET_AR_TXNS_ALL FNAR,
331: FUN_NET_BATCHES_ALL FNB,
332: RA_CUSTOMER_TRX_ALL RCT,
333: RA_CUST_TRX_TYPES_ALL RCTT,
334: HZ_CUST_ACCOUNTS_ALL HCA,
335: HZ_PARTIES HP,

Line 372: FUN_NET_BATCHES_ALL FNB,

368: FNAR.OPEN_AMT AS TRX_RECKONING_OPEN_AMOUNT,
369: MIN(APS.DUE_DATE) AS DUE_DATE,
370: sum(nvl(vat_amount,0)) AS VAT_AMOUNT -- Russian Requirement
371: FROM FUN_NET_AR_TXNS_ALL FNAR,
372: FUN_NET_BATCHES_ALL FNB,
373: RA_CUSTOMER_TRX_ALL RCT,
374: RA_CUST_TRX_TYPES_ALL RCTT,
375: AR_PAYMENT_SCHEDULES_ALL APS,
376: HZ_CUST_ACCOUNTS_ALL HCA,

Line 521: FROM FUN_NET_BATCHES_ALL FNB,

517: FNB.SETTLEMENT_DATE,
518: FNB.TRANSACTION_DUE_DATE,
519: FNB.RESPONSE_DATE,
520: FNB.TOTAL_NETTED_AMT
521: FROM FUN_NET_BATCHES_ALL FNB,
522: FUN_NET_AGREEMENTS_ALL FNA,
523: HR_OPERATING_UNITS HOU,
524: CE_BANK_ACCOUNTS CBA,
525: FUN_LOOKUPS FLC1,

Line 567: FUN_NET_BATCHES_ALL FNB,

563: PVS.VENDOR_SITE_CODE AS SITE,
564: PV.NUM_1099 AS SUPPLIER_TAXPAYER_ID,
565: PV.VAT_REGISTRATION_NUM AS SUPPLIER_TAX_REGN_NUM
566: FROM FUN_NET_AP_INVS_ALL FNAP,
567: FUN_NET_BATCHES_ALL FNB,
568: AP_INVOICES_ALL API,
569: AP_LOOKUP_CODES ALC,
570: PO_VENDORS PV,
571: PO_VENDOR_SITES_ALL PVS

Line 606: FUN_NET_BATCHES_ALL FNB,

602: FNB.BATCH_CURRENCY AS RECKONING_CURRENCY,
603: AC.CHECK_NUMBER AS PAYMENT_NUMBER,
604: SUM(nvl(vat.vat_amount,0)) AS VAT_AMOUNT
605: FROM FUN_NET_AP_INVS_ALL FNAP,
606: FUN_NET_BATCHES_ALL FNB,
607: AP_INVOICES_ALL API,
608: AP_LOOKUP_CODES ALC,
609: PO_VENDORS PV,
610: PO_VENDOR_SITES_ALL PVS,

Line 684: FUN_NET_BATCHES_ALL FNB,

680: HCSU.SITE_USE_ID AS SITE_USE_ID,
681: HP.JGZZ_FISCAL_CODE AS CUST_TAXPAYER_ID,
682: HP.TAX_REFERENCE AS CUST_TAX_REGN_NUM
683: FROM FUN_NET_AR_TXNS_ALL FNAR,
684: FUN_NET_BATCHES_ALL FNB,
685: RA_CUSTOMER_TRX_ALL RCT,
686: RA_CUSTOMER_TRX_LINES_ALL RCTL,
687: RA_CUST_TRX_TYPES_ALL RCTT,
688: HZ_CUST_ACCOUNTS_ALL HCA,

Line 737: FUN_NET_BATCHES_ALL FNB,

733: HZ_CUST_ACCOUNTS_ALL HCA,
734: HZ_PARTIES HP,
735: HZ_CUST_SITE_USES_ALL HCSU,
736: AR_CASH_RECEIPTS_ALL ACR,
737: FUN_NET_BATCHES_ALL FNB,
738: -- Russian Requirement
739: (select
740: rctl2.customer_trx_id
741: ,sum(rctl2.extended_amount) AS VAT_AMOUNT