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 458: from ap_invoices I,

454: , d.expenditure_organization_id
455: , adl.resource_list_member_id
456: , adl.bud_task_id
457: , adl.ind_compiled_set_id
458: from ap_invoices I,
459: ap_invoice_distributions D,
460: gms_award_distributions ADL,
461: GL_LEDGERS G
462: where i.invoice_id = d.invoice_id

Line 516: from AP_INVOICES I,

512: , APSAT.expenditure_organization_id
513: , adl.resource_list_member_id
514: , adl.bud_task_id
515: , adl.ind_compiled_set_id
516: from AP_INVOICES I,
517: AP_SELF_ASSESSED_TAX_DIST apsat,
518: gms_award_distributions ADL,
519: GL_LEDGERS G
520: where i.invoice_id = apsat.invoice_id

Line 577: from ap_invoices I,

573: , d.expenditure_organization_id
574: , adl.resource_list_member_id
575: , adl.bud_task_id
576: , adl.ind_compiled_set_id
577: from ap_invoices I,
578: ap_invoice_distributions D,
579: gms_award_distributions ADL,
580: gl_ledgers g
581: where i.invoice_id = d.invoice_id

Line 651: from ap_invoices I,

647: , d.expenditure_organization_id
648: , adl.resource_list_member_id
649: , adl.bud_task_id
650: , adl.ind_compiled_set_id
651: from ap_invoices I,
652: ap_invoice_distributions D,
653: gms_award_distributions ADL,
654: gl_ledgers g
655: where i.invoice_id = d.invoice_id

Line 704: from AP_INVOICES I,

700: , apsat.expenditure_organization_id
701: , adl.resource_list_member_id
702: , adl.bud_task_id
703: , adl.ind_compiled_set_id
704: from AP_INVOICES I,
705: AP_SELF_ASSESSED_TAX_DIST_ALL apsat,
706: gms_award_distributions ADL,
707: gl_ledgers g
708: where i.invoice_id = apsat.invoice_id

Line 2906: from ap_invoices inv

2902: x_credit BOOLEAN ;
2903:
2904: CURSOR C_MEMO is
2905: select invoice_id
2906: from ap_invoices inv
2907: where inv.invoice_type_lookup_code IN ('CREDIT','DEBIT')
2908: and inv.invoice_id = bc_pkt_rec.document_header_id ;
2909: --
2910: -- Bug 4737148