APPS.AP_WEB_EXPORT_ER dependencies on AP_EXPENSE_REPORT_LINES

Line 137: FROM ap_expense_report_lines xl,

133: xl.receipt_currency_code,
134: xl.receipt_conversion_rate,
135: xl.receipt_currency_amount,xd.amount ,
136: xd.report_distribution_id
137: FROM ap_expense_report_lines xl,
138: ap_exp_report_dists xd
139: WHERE xd.report_line_id = xl.report_line_id
140: and xl.report_header_id = l_report_header_id
141: and xd.report_header_id = l_report_header_id

Line 522: FROM AP_EXPENSE_REPORT_LINES XL

518: OR (p_org_id is NOT NULL AND XH.org_id IS NULL)
519: OR (p_org_id is NULL AND XH.org_id IS NULL))
520: AND EXISTS
521: (SELECT 'Y'
522: FROM AP_EXPENSE_REPORT_LINES XL
523: WHERE XH.REPORT_HEADER_ID = XL.REPORT_HEADER_ID)
524: ORDER BY UPPER(emps.last_name) desc,
525: UPPER(emps.first_name) desc,
526: UPPER(people.middle_names) desc,

Line 2046: FROM ap_expense_report_lines XL,

2042: '' award_id,
2043: '' invoice_id,
2044: '' accounting_date,
2045: XL.org_id org_id
2046: FROM ap_expense_report_lines XL,
2047: gl_code_combinations gcc,
2048: ap_lookup_codes lc,
2049: fnd_currencies F,
2050: ap_expense_report_headers XH

Line 2474: 'AP_EXPENSE_REPORT_LINES_ALL',

2470: COUNTRY_OF_SUPPLY)
2471: (SELECT
2472: p_invoice_id,
2473: 200,
2474: 'AP_EXPENSE_REPORT_LINES_ALL',
2475: xl.report_header_id,
2476: xl.report_line_id,
2477: AP_INVOICE_LINES_INTERFACE_S.nextval,
2478: xl.distribution_line_number,

Line 2572: FROM ap_expense_report_lines XL,

2568: to_char(nvl(xl.receipt_conversion_rate, '')),
2569: to_char(nvl(xl.receipt_currency_amount, '')),
2570: nvl(xl.receipt_currency_code, ''),
2571: nvl(xl.country_of_supply, '')
2572: FROM ap_expense_report_lines XL,
2573: gl_code_combinations gcc,
2574: ap_lookup_codes lc,
2575: fnd_currencies F,
2576: ap_expense_report_headers XH