DBA Data[Home] [Help]

APPS.PA_FUNDS_CONTROL_PKG1 dependencies on AP_INVOICES_ALL

Line 2688: ap_invoices_all apinv

2684: ,'NONREC_TAX',DECODE(apd.prepay_distribution_id,NULL,apd.line_type_lookup_code,'PREPAY')
2685: ,apd.line_type_lookup_code)
2686: FROM ap_invoice_distributions_all apd ,
2687: psa_bc_xla_events_gt xlaevt,
2688: ap_invoices_all apinv
2689: WHERE apd.bc_event_id = xlaevt.event_id
2690: AND apd.project_id IS NOT NULL
2691: AND NVL(apd.pa_addition_flag, 'X' ) <> 'T'
2692: AND apinv.invoice_id = apd.invoice_id

Line 2983: ap_invoices_all apinv

2979: apd.expenditure_item_date,
2980: apd.org_id,
2981: apinv.vendor_id
2982: FROM ap_invoice_distributions_all apd,
2983: ap_invoices_all apinv
2984: WHERE apd.invoice_distribution_id = p_inv_dist_id
2985: AND apinv.invoice_id = apd.invoice_id;
2986:
2987: --R12 Funds Management Uptake:Deleted CBC related logic