[Home] [Help]
195: XL.distribution_line_number dist_num,
196: nvl(GMS.award_number, '&' || 'nbsp'),
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
233: XL.distribution_line_number dist_num,
234: NULL,
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
298: av.displayed_field,
299: XL.merchant_name,
300: nvl(XL.flex_concatenated, XH.flex_concatenated),
301: XL.mileage_rate_adjusted_flag
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,
345: av.displayed_field,
346: XL.merchant_name,
347: nvl(XL.flex_concatenated, XH.flex_concatenated),
348: XL.mileage_rate_adjusted_flag
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,
390: av.displayed_field,
391: XL.merchant_name,
392: nvl(XL.flex_concatenated, XH.flex_concatenated),
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
433: av.displayed_field,
434: XL.merchant_name,
435: nvl(XL.flex_concatenated, XH.flex_concatenated),
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
495: nvl(PAT.task_number, '&' || 'nbsp'),
496: XL.credit_card_trx_id,
497: XL.distribution_line_number,
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
529: NULL,
530: XL.credit_card_trx_id,
531: XL.distribution_line_number,
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
761: XL.attribute15,
762: XD.cost_center,
763: XL.AP_VALIDATION_ERROR,
764: XL.Report_Line_id
765: FROM ap_expense_report_params XP,
766: ap_expense_report_lines XL,
767: ap_exp_report_dists XD
768: WHERE XL.report_header_id = p_exp_report_id
769: AND XL.web_parameter_id = XP.parameter_id
1384: P_AttributeCol(14),
1385: P_AttributeCol(15),
1386: ap_expense_report_lines_s.nextval,
1387: mo_global.get_current_org_id()
1388: FROM ap_expense_report_params
1389: WHERE parameter_id = p_expLines.parameter_id;
1390:
1391: ELSE -- parameter_id IS NULL
1392: INSERT INTO AP_EXPENSE_REPORT_LINES
2678: SET awt_group_id = decode(p_sys_allow_awt_flag, 'Y',
2679: decode(p_ven_allow_awt_flag, 'Y', p_ven_awt_group_id,
2680: null), null),
2681: justification_required_flag = (SELECT nvl(justification_required_flag,'V')
2682: FROM ap_expense_report_params
2683: WHERE parameter_id = RL.web_parameter_id)
2684: WHERE report_header_id = p_report_header_id;
2685:
2686: return TRUE;
2922: XL.attribute13,
2923: XL.attribute14,
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,
2971: XL.attribute13,
2972: XL.attribute14,
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