DBA Data[Home] [Help]

APPS.AP_GET_SUPPLIER_BALANCE_PKG dependencies on FND_LOOKUP_VALUES_VL

Line 77: fnd_lookup_values_vl lkv,

73: nvl(ai.discount_amount_taken,0) discount_taken,
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

Line 357: fnd_lookup_values_vl lkv,

353: FROM ap_invoices ai,
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'