DBA Data[Home] [Help]

APPS.AP_WEB_DB_EXPLINE_PKG dependencies on AP_POL_VIOLATIONS_V

Line 205: AP_POL_VIOLATIONS_V AV

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

Line 240: AP_POL_VIOLATIONS_V AV

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

Line 310: AP_POL_VIOLATIONS_V AV

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

Line 354: AP_POL_VIOLATIONS_V AV

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

Line 401: AP_POL_VIOLATIONS_V AV

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

Line 441: AP_POL_VIOLATIONS_V av

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