eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.AP_APPROVAL_PKG dependencies on AP_EXPENSE_REPORT_LINES_ALL

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

8771: Amount ap_exp_report_dists_all.amount%TYPE,
8772: Project_Id ap_exp_report_dists_all.project_id%TYPE,
8773: Task_Id ap_exp_report_dists_all.task_id%TYPE,
8774: Award_Id ap_exp_report_dists_all.award_id%TYPE,
8775: pa_quantity ap_expense_report_lines_all.pa_quantity%TYPE, --bug6699834
8776: Expenditure_Organization_Id ap_exp_report_dists_all.expenditure_organization_id%TYPE,
8777: Expenditure_type ap_expense_report_lines_all.expenditure_type%TYPE,
8778: Expenditure_item_date ap_expense_report_lines_all.expenditure_item_date%TYPE,
8779: merchant_document_number ap_expense_report_lines_all.merchant_document_number%TYPE, --bug14335065 Adding below 5 merchant fields

Line 8777: Expenditure_type ap_expense_report_lines_all.expenditure_type%TYPE,

8773: Task_Id ap_exp_report_dists_all.task_id%TYPE,
8774: Award_Id ap_exp_report_dists_all.award_id%TYPE,
8775: pa_quantity ap_expense_report_lines_all.pa_quantity%TYPE, --bug6699834
8776: Expenditure_Organization_Id ap_exp_report_dists_all.expenditure_organization_id%TYPE,
8777: Expenditure_type ap_expense_report_lines_all.expenditure_type%TYPE,
8778: Expenditure_item_date ap_expense_report_lines_all.expenditure_item_date%TYPE,
8779: merchant_document_number ap_expense_report_lines_all.merchant_document_number%TYPE, --bug14335065 Adding below 5 merchant fields
8780: merchant_name ap_expense_report_lines_all.merchant_name%TYPE,
8781: merchant_reference ap_expense_report_lines_all.merchant_reference%TYPE,

Line 8778: Expenditure_item_date ap_expense_report_lines_all.expenditure_item_date%TYPE,

8774: Award_Id ap_exp_report_dists_all.award_id%TYPE,
8775: pa_quantity ap_expense_report_lines_all.pa_quantity%TYPE, --bug6699834
8776: Expenditure_Organization_Id ap_exp_report_dists_all.expenditure_organization_id%TYPE,
8777: Expenditure_type ap_expense_report_lines_all.expenditure_type%TYPE,
8778: Expenditure_item_date ap_expense_report_lines_all.expenditure_item_date%TYPE,
8779: merchant_document_number ap_expense_report_lines_all.merchant_document_number%TYPE, --bug14335065 Adding below 5 merchant fields
8780: merchant_name ap_expense_report_lines_all.merchant_name%TYPE,
8781: merchant_reference ap_expense_report_lines_all.merchant_reference%TYPE,
8782: merchant_tax_reg_number ap_expense_report_lines_all.merchant_tax_reg_number%TYPE,

Line 8779: merchant_document_number ap_expense_report_lines_all.merchant_document_number%TYPE, --bug14335065 Adding below 5 merchant fields

8775: pa_quantity ap_expense_report_lines_all.pa_quantity%TYPE, --bug6699834
8776: Expenditure_Organization_Id ap_exp_report_dists_all.expenditure_organization_id%TYPE,
8777: Expenditure_type ap_expense_report_lines_all.expenditure_type%TYPE,
8778: Expenditure_item_date ap_expense_report_lines_all.expenditure_item_date%TYPE,
8779: merchant_document_number ap_expense_report_lines_all.merchant_document_number%TYPE, --bug14335065 Adding below 5 merchant fields
8780: merchant_name ap_expense_report_lines_all.merchant_name%TYPE,
8781: merchant_reference ap_expense_report_lines_all.merchant_reference%TYPE,
8782: merchant_tax_reg_number ap_expense_report_lines_all.merchant_tax_reg_number%TYPE,
8783: merchant_taxpayer_id ap_expense_report_lines_all.merchant_taxpayer_id%TYPE,

Line 8780: merchant_name ap_expense_report_lines_all.merchant_name%TYPE,

8776: Expenditure_Organization_Id ap_exp_report_dists_all.expenditure_organization_id%TYPE,
8777: Expenditure_type ap_expense_report_lines_all.expenditure_type%TYPE,
8778: Expenditure_item_date ap_expense_report_lines_all.expenditure_item_date%TYPE,
8779: merchant_document_number ap_expense_report_lines_all.merchant_document_number%TYPE, --bug14335065 Adding below 5 merchant fields
8780: merchant_name ap_expense_report_lines_all.merchant_name%TYPE,
8781: merchant_reference ap_expense_report_lines_all.merchant_reference%TYPE,
8782: merchant_tax_reg_number ap_expense_report_lines_all.merchant_tax_reg_number%TYPE,
8783: merchant_taxpayer_id ap_expense_report_lines_all.merchant_taxpayer_id%TYPE,
8784: receipt_currency_amount ap_exp_report_dists_all.receipt_currency_amount%TYPE, --bug6520882

Line 8781: merchant_reference ap_expense_report_lines_all.merchant_reference%TYPE,

8777: Expenditure_type ap_expense_report_lines_all.expenditure_type%TYPE,
8778: Expenditure_item_date ap_expense_report_lines_all.expenditure_item_date%TYPE,
8779: merchant_document_number ap_expense_report_lines_all.merchant_document_number%TYPE, --bug14335065 Adding below 5 merchant fields
8780: merchant_name ap_expense_report_lines_all.merchant_name%TYPE,
8781: merchant_reference ap_expense_report_lines_all.merchant_reference%TYPE,
8782: merchant_tax_reg_number ap_expense_report_lines_all.merchant_tax_reg_number%TYPE,
8783: merchant_taxpayer_id ap_expense_report_lines_all.merchant_taxpayer_id%TYPE,
8784: receipt_currency_amount ap_exp_report_dists_all.receipt_currency_amount%TYPE, --bug6520882
8785: receipt_currency_code ap_exp_report_dists_all.receipt_currency_code%TYPE,

Line 8782: merchant_tax_reg_number ap_expense_report_lines_all.merchant_tax_reg_number%TYPE,

8778: Expenditure_item_date ap_expense_report_lines_all.expenditure_item_date%TYPE,
8779: merchant_document_number ap_expense_report_lines_all.merchant_document_number%TYPE, --bug14335065 Adding below 5 merchant fields
8780: merchant_name ap_expense_report_lines_all.merchant_name%TYPE,
8781: merchant_reference ap_expense_report_lines_all.merchant_reference%TYPE,
8782: merchant_tax_reg_number ap_expense_report_lines_all.merchant_tax_reg_number%TYPE,
8783: merchant_taxpayer_id ap_expense_report_lines_all.merchant_taxpayer_id%TYPE,
8784: receipt_currency_amount ap_exp_report_dists_all.receipt_currency_amount%TYPE, --bug6520882
8785: receipt_currency_code ap_exp_report_dists_all.receipt_currency_code%TYPE,
8786: receipt_conversion_rate ap_exp_report_dists_all.receipt_conversion_rate%TYPE);

Line 8783: merchant_taxpayer_id ap_expense_report_lines_all.merchant_taxpayer_id%TYPE,

8779: merchant_document_number ap_expense_report_lines_all.merchant_document_number%TYPE, --bug14335065 Adding below 5 merchant fields
8780: merchant_name ap_expense_report_lines_all.merchant_name%TYPE,
8781: merchant_reference ap_expense_report_lines_all.merchant_reference%TYPE,
8782: merchant_tax_reg_number ap_expense_report_lines_all.merchant_tax_reg_number%TYPE,
8783: merchant_taxpayer_id ap_expense_report_lines_all.merchant_taxpayer_id%TYPE,
8784: receipt_currency_amount ap_exp_report_dists_all.receipt_currency_amount%TYPE, --bug6520882
8785: receipt_currency_code ap_exp_report_dists_all.receipt_currency_code%TYPE,
8786: receipt_conversion_rate ap_exp_report_dists_all.receipt_conversion_rate%TYPE);
8787:

Line 8815: ap_expense_report_lines_all aerl

8811: aerd.receipt_currency_amount, --bug6520882
8812: aerd.receipt_currency_code,
8813: aerd.receipt_conversion_rate
8814: FROM ap_exp_report_dists_all aerd,
8815: ap_expense_report_lines_all aerl
8816: WHERE aerd.report_header_id = p_invoice_line_rec.reference_key1
8817: AND aerd.report_line_id = p_invoice_line_rec.reference_key2
8818: AND aerd.report_line_id = aerl.report_line_id
8819: AND aerd.report_header_id = aerl.report_header_id