DBA Data[Home] [Help]

APPS.GHG_TRANSACTIONS_PKG dependencies on AP_INVOICES_ALL

Line 647: FROM ap_invoices_all ai,

643: aid.amount,
644: aid.dist_code_combination_id code_combination_id,
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

Line 677: FROM ap_invoices_all ai,

673:
674: -- Get Invoice Item Total
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