DBA Data[Home] [Help]

APPS.GHG_TRANSACTIONS_PKG dependencies on FND_LOOKUP_VALUES

Line 649: fnd_lookup_values xnlv

645: aid.project,
646: aid.task
647: FROM ap_invoices_all ai,
648: ap_invoice_distributions_v aid,
649: fnd_lookup_values xnlv
650: WHERE ai.invoice_id = p_invoice_id
651: AND aid.invoice_id = ai.invoice_id
652: AND xnlv.lookup_code = aid.line_type_lookup_code
653: AND xnlv.lookup_type = 'GHG_EMISSION_LINE_TYPES'

Line 679: fnd_lookup_values xnlv

675: SELECT sum(aid.amount)
676: INTO v_invoice_item_total
677: FROM ap_invoices_all ai,
678: ap_invoice_distributions_v aid,
679: fnd_lookup_values xnlv
680: WHERE ai.invoice_id = p_invoice_id
681: AND aid.invoice_id = ai.invoice_id
682: AND xnlv.lookup_code = aid.line_type_lookup_code
683: AND xnlv.lookup_type = 'GHG_EMISSION_LINE_TYPES'