DBA Data[Home] [Help]

APPS.AP_WEB_UPGRADE_REPORT_DIST_PKG dependencies on AP_EXPENSE_REPORT_LINES_ALL

Line 120: FROM ap_expense_report_lines_all xl,

116: xl.project_id,
117: xl.task_id,
118: xl.award_id,
119: xl.expenditure_organization_id
120: FROM ap_expense_report_lines_all xl,
121: ap_expense_report_headers_all xh,
122: gl_sets_of_books gs
123: WHERE xh.rowid BETWEEN l_start_rowid AND l_end_rowid
124: --Derive chart of accounts ID from set of books ID

Line 182: UPDATE AP_EXPENSE_REPORT_LINES_ALL XL

178:
179: l_debug_info := 'Null out obsolete columns from lines table.';
180: put_line('-- Null out obsolete columns from lines table --');
181:
182: UPDATE AP_EXPENSE_REPORT_LINES_ALL XL
183: SET XL.flex_concatenated = null,
184: XL.code_combination_id = null,
185: XL.project_id = null,
186: XL.project_number = null,