[Home] [Help]
138:
139: -- Bug: 8342465
140: SELECT FNA.ALLOW_DISC_FLAG, fna.net_currency_rule_code
141: INTO l_allow_disc_flag, l_net_currency_rule_code
142: FROM FUN_NET_BATCHES_ALL FNB,
143: FUN_NET_AGREEMENTS_ALL FNA
144: WHERE FNA.AGREEMENT_ID = FNB.AGREEMENT_ID
145: AND FNB.BATCH_ID = p_batch_id;
146:
175: FNB.SETTLEMENT_DATE,
176: FNB.TRANSACTION_DUE_DATE,
177: FNB.RESPONSE_DATE,
178: LTRIM(TO_CHAR(FNB.TOTAL_NETTED_AMT,''999999999999999999999.999999999999'')) AS TOTAL_NETTED_AMT
179: FROM FUN_NET_BATCHES_ALL FNB,
180: FUN_NET_AGREEMENTS_ALL FNA,
181: HR_OPERATING_UNITS HOU,
182: CE_BANK_ACCOUNTS CBA,
183: FUN_LOOKUPS FLC1,
224: PVS.VENDOR_SITE_CODE AS SITE,
225: PV.NUM_1099 AS SUPPLIER_TAXPAYER_ID,
226: PV.VAT_REGISTRATION_NUM AS SUPPLIER_TAX_REGN_NUM
227: FROM FUN_NET_AP_INVS_ALL FNAP,
228: FUN_NET_BATCHES_ALL FNB,
229: AP_INVOICES_ALL API,
230: AP_LOOKUP_CODES ALC,
231: PO_VENDORS PV,
232: PO_VENDOR_SITES_ALL PVS
268: FNB.BATCH_CURRENCY AS RECKONING_CURRENCY,
269: MIN(APS.DUE_DATE) AS DUE_DATE,
270: LTRIM(TO_CHAR(SUM(nvl(vat.vat_amount,0)),''999999999999999999999.999999999999'')) AS VAT_AMOUNT
271: FROM FUN_NET_AP_INVS_ALL FNAP,
272: FUN_NET_BATCHES_ALL FNB,
273: AP_INVOICES_ALL API,
274: ap_invoice_lines_all ail,
275: AP_LOOKUP_CODES ALC,
276: AP_PAYMENT_SCHEDULES_ALL APS,
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,
356: HZ_PARTIES HP,
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,
401: HZ_CUST_ACCOUNTS_ALL HCA,
516:
517: -- Bug: 8342465
518: SELECT FNA.ALLOW_DISC_FLAG, fna.net_currency_rule_code
519: INTO l_allow_disc_flag, l_net_currency_rule_code
520: FROM FUN_NET_BATCHES_ALL FNB,
521: FUN_NET_AGREEMENTS_ALL FNA
522: WHERE FNA.AGREEMENT_ID = FNB.AGREEMENT_ID
523: AND FNB.BATCH_ID = p_batch_id;
524:
555: FNB.SETTLEMENT_DATE,
556: FNB.TRANSACTION_DUE_DATE,
557: FNB.RESPONSE_DATE,
558: LTRIM(TO_CHAR(FNB.TOTAL_NETTED_AMT,''999999999999999999999.999999999999'')) AS TOTAL_NETTED_AMT
559: FROM FUN_NET_BATCHES_ALL FNB,
560: FUN_NET_AGREEMENTS_ALL FNA,
561: HR_OPERATING_UNITS HOU,
562: CE_BANK_ACCOUNTS CBA,
563: FUN_LOOKUPS FLC1,
611: PVS.STATE AS SUPPLIER_STATE,
612: PVS.ZIP AS SUPPLIER_ZIP,
613: PVC.FIRST_NAME||' '||PVC.LAST_NAME AS CONTACT_FIRST_LAST_NAME
614: FROM FUN_NET_AP_INVS_ALL FNAP,
615: FUN_NET_BATCHES_ALL FNB,
616: AP_INVOICES_ALL API,
617: AP_LOOKUP_CODES ALC,
618: PO_VENDORS PV,
619: PO_VENDOR_SITES_ALL PVS,
676: FNB.BATCH_CURRENCY AS RECKONING_CURRENCY,
677: AC.CHECK_NUMBER AS PAYMENT_NUMBER,
678: LTRIM(TO_CHAR(SUM(nvl(vat.vat_amount,0)),''999999999999999999999.999999999999'')) AS VAT_AMOUNT
679: FROM FUN_NET_AP_INVS_ALL FNAP,
680: FUN_NET_BATCHES_ALL FNB,
681: AP_INVOICES_ALL API,
682: AP_LOOKUP_CODES ALC,
683: PO_VENDORS PV,
684: PO_VENDOR_SITES_ALL PVS,
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,
767: HZ_CUST_ACCOUNTS_ALL HCA,
826: HZ_CUST_ACCOUNTS_ALL HCA,
827: HZ_PARTIES HP,
828: HZ_CUST_SITE_USES_ALL HCSU,
829: AR_CASH_RECEIPTS_ALL ACR,
830: FUN_NET_BATCHES_ALL FNB,
831: -- Russian Requirement
832: (select
833: rctl2.customer_trx_id
834: ,sum(rctl2.extended_amount) AS VAT_AMOUNT