DBA Data[Home] [Help]

APPS.AP_APPROVAL_PKG dependencies on AP_EXPENSE_REPORT_LINES_ALL

Line 6776: pa_quantity ap_expense_report_lines_all.pa_quantity%TYPE, --bug6699834

6772: Amount ap_exp_report_dists_all.amount%TYPE,
6773: Project_Id ap_exp_report_dists_all.project_id%TYPE,
6774: Task_Id ap_exp_report_dists_all.task_id%TYPE,
6775: Award_Id ap_exp_report_dists_all.award_id%TYPE,
6776: pa_quantity ap_expense_report_lines_all.pa_quantity%TYPE, --bug6699834
6777: Expenditure_Organization_Id ap_exp_report_dists_all.expenditure_organization_id%TYPE,
6778: Expenditure_type ap_expense_report_lines_all.expenditure_type%TYPE,
6779: Expenditure_item_date ap_expense_report_lines_all.expenditure_item_date%TYPE,
6780: receipt_currency_amount ap_exp_report_dists_all.receipt_currency_amount%TYPE, --bug6520882

Line 6778: Expenditure_type ap_expense_report_lines_all.expenditure_type%TYPE,

6774: Task_Id ap_exp_report_dists_all.task_id%TYPE,
6775: Award_Id ap_exp_report_dists_all.award_id%TYPE,
6776: pa_quantity ap_expense_report_lines_all.pa_quantity%TYPE, --bug6699834
6777: Expenditure_Organization_Id ap_exp_report_dists_all.expenditure_organization_id%TYPE,
6778: Expenditure_type ap_expense_report_lines_all.expenditure_type%TYPE,
6779: Expenditure_item_date ap_expense_report_lines_all.expenditure_item_date%TYPE,
6780: receipt_currency_amount ap_exp_report_dists_all.receipt_currency_amount%TYPE, --bug6520882
6781: receipt_currency_code ap_exp_report_dists_all.receipt_currency_code%TYPE,
6782: receipt_conversion_rate ap_exp_report_dists_all.receipt_conversion_rate%TYPE);

Line 6779: Expenditure_item_date ap_expense_report_lines_all.expenditure_item_date%TYPE,

6775: Award_Id ap_exp_report_dists_all.award_id%TYPE,
6776: pa_quantity ap_expense_report_lines_all.pa_quantity%TYPE, --bug6699834
6777: Expenditure_Organization_Id ap_exp_report_dists_all.expenditure_organization_id%TYPE,
6778: Expenditure_type ap_expense_report_lines_all.expenditure_type%TYPE,
6779: Expenditure_item_date ap_expense_report_lines_all.expenditure_item_date%TYPE,
6780: receipt_currency_amount ap_exp_report_dists_all.receipt_currency_amount%TYPE, --bug6520882
6781: receipt_currency_code ap_exp_report_dists_all.receipt_currency_code%TYPE,
6782: receipt_conversion_rate ap_exp_report_dists_all.receipt_conversion_rate%TYPE);
6783:

Line 6806: ap_expense_report_lines_all aerl

6802: aerd.receipt_currency_amount, --bug6520882
6803: aerd.receipt_currency_code,
6804: aerd.receipt_conversion_rate
6805: FROM ap_exp_report_dists_all aerd,
6806: ap_expense_report_lines_all aerl
6807: WHERE aerd.report_header_id = p_invoice_line_rec.reference_key1
6808: AND aerd.report_line_id = p_invoice_line_rec.reference_key2
6809: AND aerd.report_line_id = aerl.report_line_id
6810: AND aerd.report_header_id = aerl.report_header_id