DBA Data[Home] [Help]

APPS.GMS_COST_PLUS_EXTN dependencies on AP_INVOICES

Line 378: from ap_invoices I,

374: , d.expenditure_organization_id
375: , adl.resource_list_member_id
376: , adl.bud_task_id
377: , adl.ind_compiled_set_id
378: from ap_invoices I,
379: ap_invoice_distributions D,
380: gms_award_distributions ADL,
381: GL_LEDGERS G
382: where i.invoice_id = d.invoice_id

Line 439: from ap_invoices I,

435: , d.expenditure_organization_id
436: , adl.resource_list_member_id
437: , adl.bud_task_id
438: , adl.ind_compiled_set_id
439: from ap_invoices I,
440: ap_invoice_distributions D,
441: gms_award_distributions ADL,
442: gl_ledgers g
443: where i.invoice_id = d.invoice_id

Line 2606: from ap_invoices inv

2602: x_credit BOOLEAN ;
2603:
2604: CURSOR C_MEMO is
2605: select invoice_id
2606: from ap_invoices inv
2607: where inv.invoice_type_lookup_code IN ('CREDIT','DEBIT')
2608: and inv.invoice_id = bc_pkt_rec.document_header_id ;
2609: --
2610: -- Bug 4737148