[Home] [Help]
193: XL.distribution_line_number dist_num,
194: nvl(GMS.award_number, '&' || 'nbsp'),
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
231: XL.distribution_line_number dist_num,
232: NULL,
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
296: av.displayed_field,
297: XL.merchant_name,
298: nvl(XL.flex_concatenated, XH.flex_concatenated),
299: XL.mileage_rate_adjusted_flag
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,
343: av.displayed_field,
344: XL.merchant_name,
345: nvl(XL.flex_concatenated, XH.flex_concatenated),
346: XL.mileage_rate_adjusted_flag
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,
388: av.displayed_field,
389: XL.merchant_name,
390: nvl(XL.flex_concatenated, XH.flex_concatenated),
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
431: av.displayed_field,
432: XL.merchant_name,
433: nvl(XL.flex_concatenated, XH.flex_concatenated),
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
493: nvl(PAT.task_number, '&' || 'nbsp'),
494: XL.credit_card_trx_id,
495: XL.distribution_line_number,
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
527: NULL,
528: XL.credit_card_trx_id,
529: XL.distribution_line_number,
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
759: XL.attribute15,
760: XD.cost_center,
761: XL.AP_VALIDATION_ERROR,
762: XL.Report_Line_id
763: FROM ap_expense_report_params XP,
764: ap_expense_report_lines XL,
765: ap_exp_report_dists XD
766: WHERE XL.report_header_id = p_exp_report_id
767: AND XL.web_parameter_id = XP.parameter_id
1379: P_AttributeCol(14),
1380: P_AttributeCol(15),
1381: ap_expense_report_lines_s.nextval,
1382: mo_global.get_current_org_id()
1383: FROM ap_expense_report_params
1384: WHERE parameter_id = p_expLines.parameter_id;
1385:
1386: ELSE -- parameter_id IS NULL
1387: INSERT INTO AP_EXPENSE_REPORT_LINES
2421: SET awt_group_id = decode(p_sys_allow_awt_flag, 'Y',
2422: decode(p_ven_allow_awt_flag, 'Y', p_ven_awt_group_id,
2423: null), null),
2424: justification_required_flag = (SELECT nvl(justification_required_flag,'V')
2425: FROM ap_expense_report_params
2426: WHERE parameter_id = RL.web_parameter_id)
2427: WHERE report_header_id = p_report_header_id;
2428:
2429: return TRUE;
2665: XL.attribute13,
2666: XL.attribute14,
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,
2714: XL.attribute13,
2715: XL.attribute14,
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