[Home] [Help]
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,
356: HZ_PARTIES HP,
357: HZ_CUST_SITE_USES_ALL HCSU
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,
401: HZ_CUST_ACCOUNTS_ALL HCA,
402: HZ_PARTIES HP,
405: (select
406: rctl2.customer_trx_id
407: ,sum(rctl2.extended_amount) AS VAT_AMOUNT
408: from
409: ra_customer_trx_all rct2
410: ,ra_customer_trx_lines_all rctl2
411: ,ar_vat_tax_all_b avt
412: where
413: rct2.bill_to_customer_id=:CUST_ACCOUNT_ID
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,
767: HZ_CUST_ACCOUNTS_ALL HCA,
768: HZ_PARTIES HP,
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,
827: HZ_PARTIES HP,
832: (select
833: rctl2.customer_trx_id
834: ,sum(rctl2.extended_amount) AS VAT_AMOUNT
835: from
836: ra_customer_trx_all rct2
837: ,ra_customer_trx_lines_all rctl2
838: ,ar_vat_tax_all_b avt
839: where
840: rct2.bill_to_customer_id=:CUST_ACCOUNT_ID