APPS.AP_WEB_EXPORT_ER dependencies on AP_INVOICE_DISTRIBUTIONS_ALL
Line 91: FROM ap_invoice_distributions_all AID, ap_invoice_distributions_all APD
87: AND aeh.vouchno is not null
88: AND hou.organization_id(+) = aeh.org_id
89: AND I.invoice_id = aeh.vouchno
90: AND P.invoice_id IN ( SELECT apd.invoice_id 91: FROM ap_invoice_distributions_all AID, ap_invoice_distributions_all APD 92: WHERE AID.invoice_id = I.invoice_id
93: AND AID.prepay_distribution_id = APD.invoice_distribution_id
94: AND AID.line_type_lookup_code = 'PREPAY')
95: AND V.vendor_id = I.vendor_id