DBA Data[Home] [Help]

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