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_LOOKUP_CODES

Line 201: ap_lookup_codes LC,

197: av.displayed_field,
198: XL.merchant_name
199: FROM ap_expense_report_params XP,
200: ap_expense_report_lines XL,
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

Line 239: ap_lookup_codes LC,

235: av.displayed_field,
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

Line 306: ap_lookup_codes LC,

302: FROM ap_expense_report_params XP,
303: ap_expense_report_lines XL,
304: ap_expense_report_headers XH,
305: ap_credit_card_trxns CC,
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

Line 353: ap_lookup_codes LC,

349: FROM ap_expense_report_params XP,
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

Line 397: ap_lookup_codes LC,

393: XL.mileage_rate_adjusted_flag
394: FROM ap_expense_report_params XP,
395: ap_expense_report_lines XL,
396: ap_expense_report_headers XH,
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

Line 440: ap_lookup_codes LC,

436: XL.mileage_rate_adjusted_flag
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

Line 502: ap_lookup_codes LC,

498: XL.MERCHANT_NAME --Bug 2942773
499: FROM ap_expense_report_params XP,
500: ap_expense_report_lines XL,
501: ap_credit_card_trxns CC,
502: ap_lookup_codes LC,
503: PA_PROJECTS_ALL PAP, -- AP_WEB_PA_PROJECTS_V PAP, -- bug 1652647
504: PA_TASKS_EXPEND_V PAT -- AP_WEB_PA_PROJECTS_TASKS_V PAT -- bug 1652647
505: WHERE XL.report_header_id = p_report_header_id
506: AND XL.project_id is not null

Line 536: ap_lookup_codes LC

532: XL.MERCHANT_NAME --Bug 2942773
533: FROM ap_expense_report_params XP,
534: ap_expense_report_lines XL,
535: ap_credit_card_trxns CC,
536: ap_lookup_codes LC
537: WHERE XL.report_header_id = p_report_header_id
538: AND XL.web_parameter_id = XP.parameter_id
539: AND XL.line_type_lookup_code = LC.lookup_code
540: AND LC.lookup_type = 'INVOICE DISTRIBUTION TYPE'

Line 2928: ap_lookup_codes LC,

2924: XL.attribute15,
2925: XL.report_line_id
2926: FROM ap_expense_report_params XP,
2927: ap_expense_report_lines XL,
2928: ap_lookup_codes LC,
2929: PA_PROJECTS_ALL PAP,
2930: PA_TASKS_EXPEND_V PAT,
2931: GMS_AWARDS GMS
2932: WHERE XL.report_header_id = p_report_header_id

Line 2977: ap_lookup_codes LC

2973: XL.attribute15,
2974: XL.report_line_id
2975: FROM ap_expense_report_params XP,
2976: ap_expense_report_lines XL,
2977: ap_lookup_codes LC
2978: WHERE XL.report_header_id = p_report_header_id
2979: AND XL.web_parameter_id = XP.parameter_id
2980: AND XL.line_type_lookup_code = LC.lookup_code
2981: AND LC.lookup_type = 'INVOICE DISTRIBUTION TYPE'

Line 5240: ap_lookup_codes alc

5236: CC.billed_currency_code,
5237: nvl(CC.Merchant_name1 , Merchant_name2)
5238: FROM ap_expense_report_headers XH,
5239: ap_credit_card_trxns CC,
5240: ap_lookup_codes alc
5241: WHERE XH.report_header_id = p_report_header_id
5242: AND XH.report_header_id = CC.report_header_id
5243: AND XH.total = 0
5244: AND alc.lookup_type = 'PAYMENT_DUE_FROM'

Line 5275: ap_lookup_codes alc

5271: SELECT count(*)
5272: INTO p_personal_count
5273: FROM ap_expense_report_headers XH,
5274: ap_credit_card_trxns CC,
5275: ap_lookup_codes alc
5276: WHERE XH.report_header_id = p_report_header_id
5277: AND XH.report_header_id = CC.report_header_id
5278: AND XH.total = 0
5279: AND alc.lookup_type = 'PAYMENT_DUE_FROM'