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 199: ap_lookup_codes LC,

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

Line 237: ap_lookup_codes LC,

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

Line 304: ap_lookup_codes LC,

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

Line 351: ap_lookup_codes LC,

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

Line 395: ap_lookup_codes LC,

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

Line 438: ap_lookup_codes LC,

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

Line 500: ap_lookup_codes LC,

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

Line 534: ap_lookup_codes LC

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

Line 2671: ap_lookup_codes LC,

2667: XL.attribute15,
2668: XL.report_line_id
2669: FROM ap_expense_report_params XP,
2670: ap_expense_report_lines XL,
2671: ap_lookup_codes LC,
2672: PA_PROJECTS_ALL PAP,
2673: PA_TASKS PAT,
2674: GMS_AWARDS GMS
2675: WHERE XL.report_header_id = p_report_header_id

Line 2720: ap_lookup_codes LC

2716: XL.attribute15,
2717: XL.report_line_id
2718: FROM ap_expense_report_params XP,
2719: ap_expense_report_lines XL,
2720: ap_lookup_codes LC
2721: WHERE XL.report_header_id = p_report_header_id
2722: AND XL.web_parameter_id = XP.parameter_id
2723: AND XL.line_type_lookup_code = LC.lookup_code
2724: AND LC.lookup_type = 'INVOICE DISTRIBUTION TYPE'

Line 4925: ap_lookup_codes alc

4921: CC.billed_currency_code,
4922: nvl(CC.Merchant_name1 , Merchant_name2)
4923: FROM ap_expense_report_headers XH,
4924: ap_credit_card_trxns CC,
4925: ap_lookup_codes alc
4926: WHERE XH.report_header_id = p_report_header_id
4927: AND XH.report_header_id = CC.report_header_id
4928: AND XH.total = 0
4929: AND alc.lookup_type = 'PAYMENT_DUE_FROM'

Line 4960: ap_lookup_codes alc

4956: SELECT count(*)
4957: INTO p_personal_count
4958: FROM ap_expense_report_headers XH,
4959: ap_credit_card_trxns CC,
4960: ap_lookup_codes alc
4961: WHERE XH.report_header_id = p_report_header_id
4962: AND XH.report_header_id = CC.report_header_id
4963: AND XH.total = 0
4964: AND alc.lookup_type = 'PAYMENT_DUE_FROM'