DBA Data[Home] [Help]

APPS.AP_GET_SUPPLIER_BALANCE_PKG dependencies on GL_LEDGERS

Line 78: gl_ledgers gl --bug9050332

74: gl.currency_code --bug9050332
75: FROM ap_invoices_all ai,
76: fnd_lookup_types_vl lkp,
77: fnd_lookup_values_vl lkv,
78: gl_ledgers gl --bug9050332
79: WHERE ai.set_of_books_id = gl.ledger_id --bug9050332
80: AND lkp.lookup_type = 'INVOICE TYPE'
81: AND lkp.application_id = 200
82: AND lkv.view_application_id = 200 --bug13716228

Line 358: gl_ledgers gl --bug9050332

354: ap_invoice_distributions aid1,
355: ap_invoice_distributions pd, --bug13411905
356: fnd_lookup_types_vl lkp,
357: fnd_lookup_values_vl lkv,
358: gl_ledgers gl --bug9050332
359: WHERE 1=1
360: AND ai.invoice_type_lookup_code = 'PREPAYMENT'
361: AND ai.payment_status_flag = 'Y'
362: AND lkp.lookup_type = 'INVOICE TYPE'