1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
|
INSERT INTO table_test (org_id,
champ_test)
SELECT fous.org_id, --ORG_id
--package1.p1 (fous.vendor_site_id)
(SELECT paym.payment_method_code
FROM ap_suppliers f
JOIN ap_supplier_sites_all fs
ON f.vendor_id = fs.vendor_id,
JOIN iby_external_payees_all payee
ON f.party_id = payee.payee_party_id
JOIN iby_ext_party_pmt_mthds paym
ON payee.ext_payee_id = paym.ext_pmt_party_id
AND fs.vendor_site_id = payee.supplier_site_id --> jointure triangulaire !!!
WHERE paym.primary_flag = 'Y'
AND fs.vendor_site_id = fous.vendor_site_id) , 0)
FROM ap_supplier_sites_all fous
WHERE fous.vendor_site_id in (SELECT DISTINCT vendor_site_id_attribute1
FROM table_test2_v); |
Partager