DBA Data[Home] [Help]

APPS.PA_MASS_ADDITIONS_CREATE_PKG dependencies on AP_INVOICES

Line 271: ap_invoices api,

267: apd.assets_tracking_flag
268: from pa_expenditure_items ei,
269: pa_expenditure_comments eic,
270: pa_cost_distribution_lines cdl,
271: ap_invoices api,
272: ap_batches_all apb,
273: ap_invoice_lines apil,
274: ap_invoice_distributions apd,
275: financials_system_params_all fsp,

Line 292: 'INTERPROJECT_AP_INVOICES','INTERCOMPANY_AP_INVOICES')

288: where ei.expenditure_item_id = cdl.expenditure_item_id
289: and cdl.expenditure_item_id = eic.expenditure_item_id (+)
290: and cdl.line_num = eic.line_number (+)
291: and ei.transaction_source in ('AP INVOICE' , 'AP EXPENSE', 'AP NRTAX', 'AP VARIANCE', 'AP ERV', /* Bug 5284323 */
292: 'INTERPROJECT_AP_INVOICES','INTERCOMPANY_AP_INVOICES')
293: and cdl.gl_date <= P_acctg_date
294: and cdl.line_type = 'R'
295: and cdl.transfer_status_code = 'A'
296: and cdl.si_assets_addition_flag = 'T'

Line 928: ap_invoices api,

924: apd.assets_tracking_flag
925: from pa_expenditure_items ei,
926: pa_expenditure_comments eic,
927: pa_cost_distribution_lines cdl,
928: ap_invoices api,
929: ap_invoice_lines apil,
930: ap_invoice_distributions apd,
931: financials_system_params_all fsp,
932: ap_invoice_payments apip,