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 6769: Org_id ap_exp_report_dists_all.org_id%TYPE,

6765: TYPE Invoice_Dists_Tab_Type IS TABLE OF ap_invoice_distributions_all%ROWTYPE;
6766: l_dist_tab Invoice_Dists_Tab_Type := Invoice_Dists_Tab_Type();
6767:
6768: TYPE Expense_Report_Dists_Rec IS RECORD (
6769: Org_id ap_exp_report_dists_all.org_id%TYPE,
6770: Sequence_Num ap_exp_report_dists_all.sequence_num%TYPE,
6771: Code_Combination_Id ap_exp_report_dists_all.code_combination_id%TYPE,
6772: Amount ap_exp_report_dists_all.amount%TYPE,
6773: Project_Id ap_exp_report_dists_all.project_id%TYPE,

Line 6770: Sequence_Num ap_exp_report_dists_all.sequence_num%TYPE,

6766: l_dist_tab Invoice_Dists_Tab_Type := Invoice_Dists_Tab_Type();
6767:
6768: TYPE Expense_Report_Dists_Rec IS RECORD (
6769: Org_id ap_exp_report_dists_all.org_id%TYPE,
6770: Sequence_Num ap_exp_report_dists_all.sequence_num%TYPE,
6771: Code_Combination_Id ap_exp_report_dists_all.code_combination_id%TYPE,
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,

Line 6771: Code_Combination_Id ap_exp_report_dists_all.code_combination_id%TYPE,

6767:
6768: TYPE Expense_Report_Dists_Rec IS RECORD (
6769: Org_id ap_exp_report_dists_all.org_id%TYPE,
6770: Sequence_Num ap_exp_report_dists_all.sequence_num%TYPE,
6771: Code_Combination_Id ap_exp_report_dists_all.code_combination_id%TYPE,
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,

Line 6772: Amount ap_exp_report_dists_all.amount%TYPE,

6768: TYPE Expense_Report_Dists_Rec IS RECORD (
6769: Org_id ap_exp_report_dists_all.org_id%TYPE,
6770: Sequence_Num ap_exp_report_dists_all.sequence_num%TYPE,
6771: Code_Combination_Id ap_exp_report_dists_all.code_combination_id%TYPE,
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

Line 6773: Project_Id ap_exp_report_dists_all.project_id%TYPE,

6769: Org_id ap_exp_report_dists_all.org_id%TYPE,
6770: Sequence_Num ap_exp_report_dists_all.sequence_num%TYPE,
6771: Code_Combination_Id ap_exp_report_dists_all.code_combination_id%TYPE,
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,

Line 6774: Task_Id ap_exp_report_dists_all.task_id%TYPE,

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

Line 6775: Award_Id ap_exp_report_dists_all.award_id%TYPE,

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

Line 6777: Expenditure_Organization_Id ap_exp_report_dists_all.expenditure_organization_id%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
6781: receipt_currency_code ap_exp_report_dists_all.receipt_currency_code%TYPE,

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

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

Line 6781: receipt_currency_code ap_exp_report_dists_all.receipt_currency_code%TYPE,

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:
6784: TYPE Expense_Report_Dists_Tab_Type IS TABLE OF Expense_Report_Dists_Rec
6785: index by BINARY_INTEGER;

Line 6782: receipt_conversion_rate ap_exp_report_dists_all.receipt_conversion_rate%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:
6784: TYPE Expense_Report_Dists_Tab_Type IS TABLE OF Expense_Report_Dists_Rec
6785: index by BINARY_INTEGER;
6786:

Line 6805: FROM ap_exp_report_dists_all aerd,

6801: aerl.expenditure_item_date,
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