APPS.AP_WEB_EXPORT_ER dependencies on AP_EXPENSE_REPORT_LINES

Line 811: FROM ap_expense_report_lines_all

807:
808:
809: SELECT count(*)
810: INTO l_line_count
811: FROM ap_expense_report_lines_all
812: WHERE report_header_id = p_report_header_id
813: AND amount IS NULL;
814:
815: IF g_debug_switch = 'Y' THEN

Line 841: from ap_expense_report_lines_all

837: select parameter_id into l_parameter_id from ap_expense_report_params_all where expense_type_code = 'PERSONAL';
838:
839: l_debug_info := 'Fetching Line Total';
840: select nvl(sum(amount),0) into l_line_total
841: from ap_expense_report_lines_all
842: where report_header_id = p_report_header_id
843: and (itemization_parent_id is null or itemization_parent_id <> -1)
844: and web_parameter_id <> l_parameter_id;
845:

Line 896: FROM ap_expense_report_lines_all

892: SELECT *
893: FROM fnd_attached_documents
894: WHERE entity_name = 'OIE_LINE_ATTACHMENTS'
895: AND pk1_value IN ( SELECT To_Char(report_line_id)
896: FROM ap_expense_report_lines_all
897: WHERE report_header_id = p_report_header_id
898: )
899: ) ORDER BY entity_name,pk1_value,attached_document_id ;--Used the Order by clause so that seq_num will be first given to Header attachments.
900:

Line 1089: FROM ap_expense_report_lines_all

1085: SELECT *
1086: FROM fnd_attached_documents
1087: WHERE entity_name = 'OIE_LINE_ATTACHMENTS'
1088: AND pk1_value IN ( SELECT To_Char(report_line_id)
1089: FROM ap_expense_report_lines_all
1090: WHERE report_header_id = p_report_header_id
1091: )
1092: ) OIE_ATTACHMENTS
1093: WHERE OIE_ATTACHMENTS.CATEGORY_ID

Line 1251: FROM ap_expense_report_lines xl,

1247: xl.receipt_currency_code,
1248: xl.receipt_conversion_rate,
1249: xl.receipt_currency_amount,xd.amount ,
1250: xd.report_distribution_id
1251: FROM ap_expense_report_lines xl,
1252: ap_exp_report_dists xd
1253: WHERE xd.report_line_id = xl.report_line_id
1254: and xl.report_header_id = l_report_header_id
1255: and xd.report_header_id = l_report_header_id

Line 1638: FROM AP_EXPENSE_REPORT_LINES XL

1634: OR (p_org_id is NOT NULL AND XH.org_id IS NULL)
1635: OR (p_org_id is NULL AND XH.org_id IS NULL))
1636: AND EXISTS
1637: (SELECT 'Y'
1638: FROM AP_EXPENSE_REPORT_LINES XL
1639: WHERE XH.REPORT_HEADER_ID = XL.REPORT_HEADER_ID)
1640: ORDER BY UPPER(emps.last_name) desc,
1641: UPPER(emps.first_name) desc,
1642: UPPER(people.middle_names) desc,

Line 3130: FROM ap_expense_report_lines XL,

3126: '' award_id,
3127: '' invoice_id,
3128: '' accounting_date,
3129: XL.org_id org_id
3130: FROM ap_expense_report_lines XL,
3131: gl_code_combinations gcc,
3132: ap_lookup_codes lc,
3133: fnd_currencies F,
3134: ap_expense_report_headers XH

Line 3579: 'AP_EXPENSE_REPORT_LINES_ALL',

3575: )
3576: (SELECT
3577: p_invoice_id,
3578: 200,
3579: 'AP_EXPENSE_REPORT_LINES_ALL',
3580: xl.report_header_id,
3581: xl.report_line_id,
3582: AP_INVOICE_LINES_INTERFACE_S.nextval,
3583: xl.distribution_line_number,

Line 3681: FROM ap_expense_report_lines XL,

3677: --bug 8658097 starts
3678: ,xl.start_expense_date
3679: ,xl.end_expense_date
3680: --bug 8658097 ends
3681: FROM ap_expense_report_lines XL,
3682: gl_code_combinations gcc,
3683: ap_lookup_codes lc,
3684: fnd_currencies F,
3685: ap_expense_report_headers XH