DBA Data[Home] [Help]

APPS.AP_GET_SUPPLIER_BALANCE_PKG dependencies on FND_LOOKUP_TYPES_VL

Line 99: fnd_lookup_types_vl lkp,

95: FROM
96: /*bug 5264865*/
97: ap_invoices_all ai,
98: ap_invoice_distributions_all aid1,
99: fnd_lookup_types_vl lkp,
100: fnd_lookup_values_vl lkv
101: -- 3641604 ap_payment_schedules aps
102: WHERE
103: ai.invoice_id = aid1.invoice_id

Line 392: fnd_lookup_types_vl lkp,

388: SUM(nvl(AID1.PREPAY_AMOUNT_REMAINING,AID1.AMOUNT)))
389: FROM
390: ap_invoices ai,
391: ap_invoice_distributions aid1,
392: fnd_lookup_types_vl lkp,
393: fnd_lookup_values_vl lkv
394: WHERE
395: ai.invoice_id=aid1.invoice_id
396: and ((aid1.line_type_lookup_code = 'ITEM') or