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_MANAGEMENT_REPORTS_PKG dependencies on AP_EXPENSE_REPORT_VIOLATIONS_V

Line 440: FROM ap_expense_report_violations_v aerv

436: P_ExchangeRateType,
437: aerv.violation_amount
438: ))) as violation_amount,
439: count(aerv.report_header_id) as number_of_violations
440: FROM ap_expense_report_violations_v aerv
441: WHERE ( (aerv.employee_id = P_EmployeeId) or (aerv.paid_on_behalf_employee_id = P_EmployeeId))
442: AND aerv.week_end_date between P_StartDate and P_EndDate
443: AND nvl(aerv.category_code, 'ALL') = decode(P_ExpenseCategory, 'ALL', nvl(aerv.category_code, 'ALL'), P_ExpenseCategory)
444: AND aerv.violation_type = decode(P_ViolationType, 'ALL', aerv.violation_type, P_ViolationType)

Line 483: FROM ap_expense_report_violations_v aerv

479: P_ExchangeRateType,
480: aerv.violation_amount
481: ))) as violation_amount,
482: 1 as number_of_violations
483: FROM ap_expense_report_violations_v aerv
484: WHERE ( (aerv.employee_id = P_EmployeeId) or (aerv.paid_on_behalf_employee_id = P_EmployeeId))
485: AND ( (P_ViolationType = 'ALL') or (P_ViolationType = 'RECEIPT_MISSING')) AND aerv.violation_type = 'RECEIPT_MISSING'
486: AND nvl(aerv.category_code, 'ALL') = decode(P_ExpenseCategory, 'ALL', nvl(aerv.category_code, 'ALL'), P_ExpenseCategory)
487: AND aerv.week_end_date BETWEEN P_StartDate AND P_EndDate

Line 507: ap_expense_report_violations_v aerv

503: (
504: SELECT 1 as number_of_violations,
505: alc.displayed_field as violation_type
506: FROM ap_lookup_codes alc,
507: ap_expense_report_violations_v aerv
508: WHERE alc.lookup_type = 'OIE_POL_VIOLATION_TYPES'
509: AND alc.lookup_code = aerv.violation_type
510: AND ( aerv.employee_id = P_EmployeeId OR aerv.paid_on_behalf_employee_id = P_EmployeeId)
511: AND aerv.week_end_date between P_StartDate and P_EndDate

Line 543: ap_expense_report_violations_v aerv

539: /* Count all the violations for Receipts missing */
540: SELECT 1 as number_of_violations,
541: alc.displayed_field as violation_type
542: FROM ap_lookup_codes alc,
543: ap_expense_report_violations_v aerv
544: WHERE alc.lookup_type = 'OIE_POL_VIOLATION_TYPES'
545: AND alc.lookup_code = aerv.violation_type
546: AND ( aerv.employee_id = P_EmployeeId OR aerv.paid_on_behalf_employee_id = P_EmployeeId)
547: AND aerv.week_end_date between P_StartDate and P_EndDate

Line 1051: FROM ap_expense_report_violations_v aerv

1047: P_ExchangeRateType,
1048: aerv.allowable_amount
1049: ))) as allowable_amount,
1050: count(aerv.report_header_id) as number_of_violations
1051: FROM ap_expense_report_violations_v aerv
1052: WHERE ((aerv.employee_id = P_EmployeeId) or (aerv.paid_on_behalf_employee_id = P_EmployeeId))
1053: AND aerv.week_end_date between P_StartDate and P_EndDate
1054: AND nvl(aerv.category_code, 'ALL') = decode(P_ExpenseCategory, 'ALL', nvl(aerv.category_code, 'ALL'), P_ExpenseCategory)
1055: AND aerv.violation_type = decode(P_ViolationType, 'ALL', aerv.violation_type, P_ViolationType)

Line 1074: ap_expense_report_violations_v aerv

1070: aerv.allowable_amount
1071: ))) as allowable_amount,
1072: count(aerv.report_header_id) as number_of_violations
1073: FROM per_all_assignments_f paf,
1074: ap_expense_report_violations_v aerv
1075: WHERE paf.supervisor_id = P_EmployeeId
1076: AND paf.effective_start_date < P_EndDate
1077: AND paf.effective_end_date > P_StartDate
1078: AND (paf.assignment_type = 'E' OR paf.assignment_type = 'C')

Line 1177: FROM ap_expense_report_violations_v aerv

1173: P_ExchangeRateType,
1174: aerv.allowable_amount
1175: ))) as allowable_amount,
1176: count(aerv.report_header_id) as number_of_violations
1177: FROM ap_expense_report_violations_v aerv
1178: WHERE ((aerv.employee_id = P_EmployeeId) or (aerv.paid_on_behalf_employee_id = P_EmployeeId))
1179: AND aerv.week_end_date between P_StartDate and P_EndDate
1180: AND nvl(aerv.category_code, 'ALL') = decode(P_ExpenseCategory, 'ALL', nvl(aerv.category_code, 'ALL'), P_ExpenseCategory)
1181: AND ((P_ViolationType = 'ALL') or (P_ViolationType = 'RECEIPT_MISSING')) AND aerv.violation_type = 'RECEIPT_MISSING'

Line 1200: ap_expense_report_violations_v aerv

1196: aerv.allowable_amount
1197: ))) as allowable_amount,
1198: count(aerv.report_header_id) as number_of_violations
1199: FROM per_all_assignments_f paf,
1200: ap_expense_report_violations_v aerv
1201: WHERE paf.supervisor_id = P_EmployeeId
1202: AND paf.effective_start_date < P_EndDate
1203: AND paf.effective_end_date > P_StartDate
1204: AND (paf.assignment_type = 'E' OR paf.assignment_type = 'C')

Line 1578: FROM ap_expense_report_violations_v aerv

1574: P_ExchangeRateType,
1575: aerv.allowable_amount
1576: ))) as allowable_amount,
1577: count(aerv.report_header_id) as number_of_violations
1578: FROM ap_expense_report_violations_v aerv
1579: WHERE ((aerv.employee_id = P_EmployeeId) or (aerv.paid_on_behalf_employee_id = P_EmployeeId))
1580: AND aerv.week_end_date between P_StartDate and P_EndDate
1581: AND nvl(aerv.category_code, 'ALL') = decode(P_ExpenseCategory, 'ALL', nvl(aerv.category_code, 'ALL'), P_ExpenseCategory)
1582: AND aerv.violation_type = decode(P_ViolationType, 'ALL', aerv.violation_type, P_ViolationType)

Line 1601: ap_expense_report_violations_v aerv

1597: aerv.allowable_amount
1598: ))) as allowable_amount,
1599: count(aerv.report_header_id) as number_of_violations
1600: FROM per_all_assignments_f paf,
1601: ap_expense_report_violations_v aerv
1602: WHERE paf.supervisor_id = P_EmployeeId
1603: AND paf.effective_start_date < P_EndDate
1604: AND paf.effective_end_date > P_StartDate
1605: AND (paf.assignment_type = 'E' OR paf.assignment_type = 'C')

Line 1704: FROM ap_expense_report_violations_v aerv

1700: P_ExchangeRateType,
1701: aerv.allowable_amount
1702: ))) as allowable_amount,
1703: count(aerv.report_header_id) as number_of_violations
1704: FROM ap_expense_report_violations_v aerv
1705: WHERE ((aerv.employee_id = P_EmployeeId) or (aerv.paid_on_behalf_employee_id = P_EmployeeId))
1706: AND aerv.week_end_date between P_StartDate and P_EndDate
1707: AND nvl(aerv.category_code, 'ALL') = decode(P_ExpenseCategory, 'ALL', nvl(aerv.category_code, 'ALL'), P_ExpenseCategory)
1708: AND ((P_ViolationType = 'ALL') or (P_ViolationType = 'RECEIPT_MISSING')) AND aerv.violation_type = 'RECEIPT_MISSING'

Line 1727: ap_expense_report_violations_v aerv

1723: aerv.allowable_amount
1724: ))) as allowable_amount,
1725: count(aerv.report_header_id) as number_of_violations
1726: FROM per_all_assignments_f paf,
1727: ap_expense_report_violations_v aerv
1728: WHERE paf.supervisor_id = P_EmployeeId
1729: AND paf.effective_start_date < P_EndDate
1730: AND paf.effective_end_date > P_StartDate
1731: AND (paf.assignment_type = 'E' OR paf.assignment_type = 'C')