DBA Data[Home] [Help]

APPS.GMS_FUNDS_CONTROL_PKG dependencies on AP_INVOICES_ALL

Line 2260: ap_invoices_all apinv

2256: FROM psa_bc_xla_events_gt xlaevt,
2257: ap_invoice_distributions_all apd,
2258: gms_project_types gpt,
2259: pa_projects_all pp,
2260: ap_invoices_all apinv
2261: WHERE apd.bc_event_id = xlaevt.event_id
2262: AND apd.project_id IS NOT NULL
2263: AND apinv.invoice_id = apd.invoice_id
2264: AND apd.project_id = pp.project_id

Line 2508: ap_invoices_all api,

2504: AND adl1.award_set_id = ap1.award_id
2505: AND adl1.adl_line_num =1 ) burdenable_raw_cost ,
2506: apd.parent_reversal_id parent_reversal_id -- Bug 5369296
2507: FROM ap_invoice_distributions_all apd,
2508: ap_invoices_all api,
2509: gms_award_distributions adl,
2510: pa_expenditure_types et
2511: WHERE apd.invoice_distribution_id = p_ap_dist_id
2512: AND apd.project_id IS NOT NULL