DBA Data[Home] [Help]

APPS.GMS_AP_API dependencies on AP_INVOICES_ALL

Line 816: l_invoice_num ap_invoices_all.invoice_num%TYPE ;

812: l_award_idX NUMBER ;
813: l_status NUMBER ;
814: AWARD_NOT_FOUND EXCEPTION ;
815:
816: l_invoice_num ap_invoices_all.invoice_num%TYPE ;
817:
818: cursor c_ap is
819: SELECT A.invoice_id INVOICE_ID,
820: A.distribution_line_number distribution_line_number,

Line 834: ap_invoices_all inv

830: inv.invoice_num invoice_num
831: from ap_invoice_distributions_all A,
832: pa_projects_all p,
833: gms_project_types gpt,
834: ap_invoices_all inv
835: where a.invoice_id = p_invoice_id
836: and a.project_id = p.project_id
837: and p.project_type = gpt.project_type
838: and inv.invoice_id = a.invoice_id