DBA Data[Home] [Help]

APPS.GMS_FUNDS_CONTROL_PKG dependencies on AP_INVOICES_ALL

Line 2307: ap_invoices_all apinv

2303: FROM psa_bc_xla_events_gt xlaevt,
2304: ap_invoice_distributions_all apd,
2305: gms_project_types gpt,
2306: pa_projects_all pp,
2307: ap_invoices_all apinv
2308: WHERE apd.bc_event_id = xlaevt.event_id
2309: AND apd.project_id IS NOT NULL
2310: AND apinv.invoice_id = apd.invoice_id
2311: AND apd.project_id = pp.project_id

Line 2331: ap_invoices_all apinv

2327: from PSA_BC_XLA_EVENTS_GT XLAEVT,
2328: AP_SELF_ASSESSED_TAX_DIST_ALL apsat,
2329: gms_project_types gpt,
2330: pa_projects_all pp,
2331: ap_invoices_all apinv
2332: WHERE apsat.bc_event_id = xlaevt.event_id
2333: AND apsat.project_id IS NOT NULL
2334: AND apinv.invoice_id = apsat.invoice_id
2335: AND apsat.project_id = pp.project_id

Line 2734: ap_invoices_all api,

2730: AND adl1.award_set_id = ap1.award_id
2731: AND adl1.adl_line_num =1 ) burdenable_raw_cost ,
2732: apd.parent_reversal_id parent_reversal_id -- Bug 5369296
2733: FROM ap_invoice_distributions_all apd,
2734: ap_invoices_all api,
2735: gms_award_distributions adl,
2736: pa_expenditure_types et
2737: WHERE apd.invoice_distribution_id = p_ap_dist_id
2738: AND apd.project_id IS NOT NULL

Line 2782: ap_invoices_all api,

2778: AND adl1.award_set_id = apt.award_id
2779: AND adl1.adl_line_num =1 ) burdenable_raw_cost ,
2780: apsat.PARENT_REVERSAL_ID PARENT_REVERSAL_ID
2781: FROM AP_SELF_ASSESSED_TAX_DIST_ALL apsat,
2782: ap_invoices_all api,
2783: gms_award_distributions adl,
2784: PA_EXPENDITURE_TYPES ET
2785: WHERE apsat.invoice_distribution_id = p_ap_dist_id
2786: AND apsat.project_id IS NOT NULL