APPS.FUN_XML_REPORT_PKG dependencies on FUN_NET_AR_TXNS_ALL

Line 351: FROM FUN_NET_AR_TXNS_ALL FNAR,

347: HCSU.LOCATION,
348: HCSU.SITE_USE_ID AS SITE_USE_ID,
349: HP.JGZZ_FISCAL_CODE AS CUST_TAXPAYER_ID,
350: HP.TAX_REFERENCE AS CUST_TAX_REGN_NUM
351: FROM FUN_NET_AR_TXNS_ALL FNAR,
352: FUN_NET_BATCHES_ALL FNB,
353: RA_CUSTOMER_TRX_ALL RCT,
354: RA_CUST_TRX_TYPES_ALL RCTT,
355: HZ_CUST_ACCOUNTS_ALL HCA,

Line 396: FROM FUN_NET_AR_TXNS_ALL FNAR,

392: FNB.BATCH_CURRENCY AS RECKONING_CURRENCY,
393: LTRIM(TO_CHAR(FNAR.OPEN_AMT,''999999999999999999999.999999999999'')) AS TRX_RECKONING_OPEN_AMOUNT,
394: MIN(APS.DUE_DATE) AS DUE_DATE,
395: LTRIM(TO_CHAR(sum(nvl(vat_amount,0)),''999999999999999999999.999999999999'')) AS VAT_AMOUNT -- Russian Requirement
396: FROM FUN_NET_AR_TXNS_ALL FNAR,
397: FUN_NET_BATCHES_ALL FNB,
398: RA_CUSTOMER_TRX_ALL RCT,
399: RA_CUST_TRX_TYPES_ALL RCTT,
400: AR_PAYMENT_SCHEDULES_ALL APS,

Line 762: FROM FUN_NET_AR_TXNS_ALL FNAR,

758: HZL.ADDRESS3 AS CUSTOMER_ADDRESS3,
759: HZL.CITY AS CUSTOMER_CITY,
760: HZL.STATE AS CUSTOMER_STATE,
761: HZL.POSTAL_CODE AS CUSTOMER_POSTAL_CODE
762: FROM FUN_NET_AR_TXNS_ALL FNAR,
763: FUN_NET_BATCHES_ALL FNB,
764: RA_CUSTOMER_TRX_ALL RCT,
765: RA_CUSTOMER_TRX_LINES_ALL RCTL,
766: RA_CUST_TRX_TYPES_ALL RCTT,

Line 822: FROM FUN_NET_AR_TXNS_ALL FNAR,

818: LTRIM(TO_CHAR(decode(FNAR.NETTED_AMT, 0, null, FNAR.NETTED_AMT),''999999999999999999999.999999999999'')) AS NETTED_AMT_RECKONING_CURR,
819: FNB.BATCH_CURRENCY AS RECKONING_CURRENCY,
820: ACR.RECEIPT_NUMBER,
821: LTRIM(TO_CHAR(sum(nvl(vat_amount,0)),''999999999999999999999.999999999999'')) AS VAT_AMOUNT -- Russian Requirement
822: FROM FUN_NET_AR_TXNS_ALL FNAR,
823: RA_CUSTOMER_TRX_ALL RCT,
824: RA_CUSTOMER_TRX_LINES_ALL RCTL,
825: RA_CUST_TRX_TYPES_ALL RCTT,
826: HZ_CUST_ACCOUNTS_ALL HCA,