Oracle AP – Establish the Intercompany Account from a Supplier Site

SELECT gcc.segment5 "Intercompany" ,
vendor_name,
vendor_site_code ,
hou.name ,
apss.accts_pay_code_combination_id ,
gcc.segment1 ,
gcc.segment2 ,
gcc.segment3 ,
gcc.segment4 ,
gcc.segment5 ,
gcc.segment6 ,
gcc.segment7 ,
gcc.segment8 ,
gcc.segment9 ,
gcc.segment10 ,
gcc.segment11 ,
apss.*
FROM AP_SUPPLIERS aps,
AP_SUPPLIER_SITES_ALL apss,
HR_ALL_ORGANIZATION_UNITS hou,
gl_code_combinations gcc
WHERE aps.vendor_id = apss.vendor_id
AND apss.org_id = hou.organization_id
AND gcc.code_combination_id = apss.accts_pay_code_combination_id
ORDER BY 1,2,3;

Leave a Reply