APPS.AP_WEB_EXPORT_ER dependencies on AP_EXPENSE_REPORT_LINES_ALL

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 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,