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.

APPS.AP_APPROVAL_PKG dependencies on AP_EXP_REPORT_DISTS_ALL

Line 8768: Org_id ap_exp_report_dists_all.org_id%TYPE,

8764: TYPE Invoice_Dists_Tab_Type IS TABLE OF ap_invoice_distributions_all%ROWTYPE;
8765: l_dist_tab Invoice_Dists_Tab_Type := Invoice_Dists_Tab_Type();
8766:
8767: TYPE Expense_Report_Dists_Rec IS RECORD (
8768: Org_id ap_exp_report_dists_all.org_id%TYPE,
8769: Sequence_Num ap_exp_report_dists_all.sequence_num%TYPE,
8770: Code_Combination_Id ap_exp_report_dists_all.code_combination_id%TYPE,
8771: Amount ap_exp_report_dists_all.amount%TYPE,
8772: Project_Id ap_exp_report_dists_all.project_id%TYPE,

Line 8769: Sequence_Num ap_exp_report_dists_all.sequence_num%TYPE,

8765: l_dist_tab Invoice_Dists_Tab_Type := Invoice_Dists_Tab_Type();
8766:
8767: TYPE Expense_Report_Dists_Rec IS RECORD (
8768: Org_id ap_exp_report_dists_all.org_id%TYPE,
8769: Sequence_Num ap_exp_report_dists_all.sequence_num%TYPE,
8770: Code_Combination_Id ap_exp_report_dists_all.code_combination_id%TYPE,
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,

Line 8770: Code_Combination_Id ap_exp_report_dists_all.code_combination_id%TYPE,

8766:
8767: TYPE Expense_Report_Dists_Rec IS RECORD (
8768: Org_id ap_exp_report_dists_all.org_id%TYPE,
8769: Sequence_Num ap_exp_report_dists_all.sequence_num%TYPE,
8770: Code_Combination_Id ap_exp_report_dists_all.code_combination_id%TYPE,
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,

Line 8771: Amount ap_exp_report_dists_all.amount%TYPE,

8767: TYPE Expense_Report_Dists_Rec IS RECORD (
8768: Org_id ap_exp_report_dists_all.org_id%TYPE,
8769: Sequence_Num ap_exp_report_dists_all.sequence_num%TYPE,
8770: Code_Combination_Id ap_exp_report_dists_all.code_combination_id%TYPE,
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

Line 8772: Project_Id ap_exp_report_dists_all.project_id%TYPE,

8768: Org_id ap_exp_report_dists_all.org_id%TYPE,
8769: Sequence_Num ap_exp_report_dists_all.sequence_num%TYPE,
8770: Code_Combination_Id ap_exp_report_dists_all.code_combination_id%TYPE,
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,

Line 8773: Task_Id ap_exp_report_dists_all.task_id%TYPE,

8769: Sequence_Num ap_exp_report_dists_all.sequence_num%TYPE,
8770: Code_Combination_Id ap_exp_report_dists_all.code_combination_id%TYPE,
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,

Line 8774: Award_Id ap_exp_report_dists_all.award_id%TYPE,

8770: Code_Combination_Id ap_exp_report_dists_all.code_combination_id%TYPE,
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,

Line 8776: Expenditure_Organization_Id ap_exp_report_dists_all.expenditure_organization_id%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
8780: merchant_name ap_expense_report_lines_all.merchant_name%TYPE,

Line 8784: receipt_currency_amount ap_exp_report_dists_all.receipt_currency_amount%TYPE, --bug6520882

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:
8788: TYPE Expense_Report_Dists_Tab_Type IS TABLE OF Expense_Report_Dists_Rec

Line 8785: receipt_currency_code ap_exp_report_dists_all.receipt_currency_code%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:
8788: TYPE Expense_Report_Dists_Tab_Type IS TABLE OF Expense_Report_Dists_Rec
8789: index by BINARY_INTEGER;

Line 8786: receipt_conversion_rate ap_exp_report_dists_all.receipt_conversion_rate%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:
8788: TYPE Expense_Report_Dists_Tab_Type IS TABLE OF Expense_Report_Dists_Rec
8789: index by BINARY_INTEGER;
8790:

Line 8814: FROM ap_exp_report_dists_all aerd,

8810: aerl.merchant_taxpayer_id,
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