[Home] [Help]
178: G_Build_Prepay_Accts_Flag ap_system_parameters.build_prepayment_accounts_flag%TYPE;
179: G_Income_Tax_Region ap_system_parameters.income_tax_region%TYPE;
180: G_Project_ID pa_projects_all.project_id%TYPE;
181: G_Task_ID pa_tasks.task_id%TYPE;
182: G_Award_ID po_distributions_all.award_id%TYPE;
183: G_Expenditure_Type pa_expenditure_types.expenditure_type%TYPE;
184: G_Invoice_Date ap_invoices.invoice_date%TYPE;
185: G_Expenditure_Organization_ID pa_exp_orgs_it.organization_id%TYPE;
186: G_Asset_Book_Type_Code fa_book_controls.book_type_code%TYPE;
1173: WHERE line_location_id = x_po_line_location_id;
1174:
1175:
1176: l_total_quantity number;
1177: l_po_distribution_id po_distributions_all.po_distribution_id%TYPE;
1178: l_amount_invoiced ap_invoice_distributions_all.amount%TYPE;
1179: l_quantity_invoiced ap_invoice_distributions_all.quantity_invoiced%TYPE;
1180: l_po_dist_ccid po_distributions.code_combination_id%TYPE;
1181: l_accrue_on_receipt_flag po_distributions.accrue_on_receipt_flag%TYPE;
1184: l_reason_unbuilt_flex varchar2(2000):='';
1185: l_dist_ccid ap_invoice_distributions_all.dist_code_combination_id%TYPE;
1186: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
1187: l_task_id po_distributions.task_id%TYPE;
1188: l_award_set_id po_distributions_all.award_id%TYPE;
1189: l_expenditure_type po_distributions.expenditure_type%TYPE;
1190: l_po_expenditure_item_date po_distributions.expenditure_item_date%TYPE;
1191: l_expenditure_organization_id po_distributions.expenditure_organization_id%TYPE;
1192: l_max_dist_amount number := 0;