eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_WEB_DB_EXPLINE_PKG dependencies on AP_POL_VIOLATIONS_V

Line 203: AP_POL_VIOLATIONS_V AV

199: ap_lookup_codes LC,
200: PA_PROJECTS_ALL PAP, -- AP_WEB_PA_PROJECTS_V PAP, -- bug 1652647
201: PA_TASKS PAT, -- AP_WEB_PA_PROJECTS_TASKS_V PAT, -- bug 1652647
202: GMS_AWARDS GMS,
203: AP_POL_VIOLATIONS_V AV
204: WHERE XL.report_header_id = p_report_header_id
205: AND XL.project_id is not null
206: AND XL.task_id is not null
207: AND XL.web_parameter_id = XP.parameter_id

Line 238: AP_POL_VIOLATIONS_V AV

234: XL.merchant_name
235: FROM ap_expense_report_params XP,
236: ap_expense_report_lines XL,
237: ap_lookup_codes LC,
238: AP_POL_VIOLATIONS_V AV
239: WHERE XL.report_header_id = p_report_header_id
240: AND XL.web_parameter_id = XP.parameter_id
241: AND XL.line_type_lookup_code = LC.lookup_code
242: AND LC.lookup_type = 'INVOICE DISTRIBUTION TYPE'

Line 308: AP_POL_VIOLATIONS_V AV

304: ap_lookup_codes LC,
305: PA_PROJECTS_ALL PAP, -- AP_WEB_PA_PROJECTS_V PAP, -- bug 1652647
306: PA_TASKS PAT, -- AP_WEB_PA_PROJECTS_TASKS_V PAT -- bug 1652647
307: GMS_AWARDS GMS,
308: AP_POL_VIOLATIONS_V AV
309: WHERE XL.report_header_id = p_report_header_id
310: AND XL.report_header_id = XH.report_header_id
311: AND XL.project_id is not null
312: AND XL.task_id is not null

Line 352: AP_POL_VIOLATIONS_V AV

348: ap_expense_report_lines XL,
349: ap_expense_report_headers XH,
350: ap_credit_card_trxns CC,
351: ap_lookup_codes LC,
352: AP_POL_VIOLATIONS_V AV
353: WHERE XL.report_header_id = p_report_header_id
354: AND XL.report_header_id = XH.report_header_id
355: AND XL.web_parameter_id = XP.parameter_id
356: AND XL.line_type_lookup_code = LC.lookup_code

Line 399: AP_POL_VIOLATIONS_V AV

395: ap_lookup_codes LC,
396: PA_PROJECTS_ALL PAP, -- AP_WEB_PA_PROJECTS_V PAP, -- bug 1652647
397: PA_TASKS PAT, -- AP_WEB_PA_PROJECTS_TASKS_V PAT -- bug 1652647
398: GMS_AWARDS GMS,
399: AP_POL_VIOLATIONS_V AV
400: WHERE XL.report_header_id = p_report_header_id
401: AND XL.report_header_id = XH.report_header_id
402: AND XL.project_id is not null
403: AND XL.task_id is not null

Line 439: AP_POL_VIOLATIONS_V av

435: FROM ap_expense_report_params XP,
436: ap_expense_report_lines XL,
437: ap_expense_report_headers XH,
438: ap_lookup_codes LC,
439: AP_POL_VIOLATIONS_V av
440: WHERE XL.report_header_id = p_report_header_id
441: AND XL.report_header_id = XH.report_header_id
442: AND XL.web_parameter_id = XP.parameter_id
443: AND XL.line_type_lookup_code = LC.lookup_code