[Home] [Help]
717: AND (pv.vat_registration_num IS NOT NULL OR pvs.vat_registration_num IS NOT NULL) -- only B2B invoices for payables.
718: --AND ai.payment_method_code = alc.lookup_code
719: --AND alc.lookup_type = 'PAYMENT METHOD'
720: AND ai.payment_method_code = alc.payment_method_code
721: AND (pvs.country ='IT' OR pvs.country IN ( select territory_code from FND_Territories where alternate_territory_code IS NOT NULL))
722: -- we need to pick only IT countries and EU countries transactions.
723: AND NVL(pv.employee_id, -99) = papf.person_id (+)
724: AND hp.party_id =pv.party_id
725: AND itemline.invoice_id = ai.invoice_id
1143: AND hcsu.cust_acct_site_id = hcas.cust_acct_site_id
1144: AND hcas.party_site_id = hps.party_site_id
1145: AND hp.party_id = hps.party_id
1146: AND hps.location_id = hl.location_id
1147: AND (NVL(hcsu.tax_reference,hp.tax_reference) IS NULL OR hl.country ='IT' OR hl.country IN (select territory_code from FND_Territories where alternate_territory_code IS NOT NULL))
1148: AND ( rctl.vat_tax_id IS not NULL or exists (select 1 from
1149: ra_customer_trx_lines_all rctla
1150: where rctla.customer_trx_id = rct.customer_trx_id
1151: and rctla.link_to_cust_trx_line_id= rctl.customer_trx_line_id))
1277: AND hcsu.cust_acct_site_id = hcas.cust_acct_site_id
1278: AND hcas.party_site_id = hps.party_site_id
1279: AND hp.party_id = hps.party_id
1280: AND hps.location_id = hl.location_id
1281: AND (NVL(hcsu.tax_reference,hp.tax_reference) IS NULL OR hl.country ='IT' OR hl.country IN (select territory_code from FND_Territories where alternate_territory_code IS NOT NULL))
1282: AND ( rctl.vat_tax_id IS not NULL or exists (select 1 from
1283: ra_customer_trx_lines_all rctla
1284: where rctla.customer_trx_id = rct.customer_trx_id
1285: and rctla.link_to_cust_trx_line_id= rctl.customer_trx_line_id))