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_MATCHING_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 254: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;

250: X_calling_sequence IN VARCHAR2) IS
251:
252: l_single_dist_flag varchar2(1) := 'N';
253: l_po_distribution_id po_distributions.po_distribution_id%TYPE := NULL;
254: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
255: l_item_line_number ap_invoice_lines_all.line_number%TYPE;
256: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;
257: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
258: l_amount_to_recoup ap_invoice_lines_all.amount%TYPE;

Line 607: FROM ap_invoice_distributions aid,

603: nvl(ail.attribute15, decode(g_transfer_flag, 'Y', pll.attribute15, ail.attribute15)),
604: --end Bug 7483260
605: l_retained_amount,
606: -1 * l_retained_amount
607: FROM ap_invoice_distributions aid,
608: po_distributions pd,
609: po_line_locations pll
610: WHERE aid.invoice_distribution_id = l_invoice_distribution_id
611: AND pd.po_distribution_id = aid.po_distribution_id

Line 1171: ap_invoice_distributions_s.nextval

1167: 'EXPENSE',PD.expenditure_organization_id,
1168: NULL), --expenditure_organization_id
1169: DECODE(PD.destination_type_code,
1170: 'EXPENSE', PD.award_id), --award_id
1171: ap_invoice_distributions_s.nextval
1172: FROM po_distributions_ap_v PD
1173: WHERE line_location_id = x_po_line_location_id;
1174:
1175:

Line 1178: l_amount_invoiced ap_invoice_distributions_all.amount%TYPE;

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;
1182: l_project_id po_distributions.project_id%TYPE;

Line 1179: l_quantity_invoiced ap_invoice_distributions_all.quantity_invoiced%TYPE;

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;
1182: l_project_id po_distributions.project_id%TYPE;
1183: l_unbuilt_flex varchar2(240):='';

Line 1185: l_dist_ccid ap_invoice_distributions_all.dist_code_combination_id%TYPE;

1181: l_accrue_on_receipt_flag po_distributions.accrue_on_receipt_flag%TYPE;
1182: l_project_id po_distributions.project_id%TYPE;
1183: l_unbuilt_flex varchar2(240):='';
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;

Line 1186: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;

1182: l_project_id po_distributions.project_id%TYPE;
1183: l_unbuilt_flex varchar2(240):='';
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;

Line 1196: l_base_amount ap_invoice_distributions.base_amount%TYPE;

1192: l_max_dist_amount number := 0;
1193: l_sum_prorated_amount number := 0;
1194: l_sum_dist_base_amount number := 0;
1195: l_rounding_index po_distributions.po_distribution_id%TYPE;
1196: l_base_amount ap_invoice_distributions.base_amount%TYPE;
1197: flex_overlay_failed exception;
1198: current_calling_sequence varchar2(2000);
1199: l_debug_info varchar2(2000);
1200: l_api_name VARCHAR2(50);

Line 1324: ap_invoice_distributions_s.nextval

1320: award_id,
1321: expenditure_type,
1322: expenditure_item_date,
1323: expenditure_organization_id,
1324: ap_invoice_distributions_s.nextval
1325: INTO x_dist_tab(i).accrue_on_receipt_flag,
1326: x_dist_tab(i).po_ccid,
1327: x_dist_tab(i).project_id,
1328: x_dist_tab(i).task_id,

Line 2631: INSERT INTO ap_invoice_distributions (

2627: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2628: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2629: END IF;
2630:
2631: INSERT INTO ap_invoice_distributions (
2632: batch_id,
2633: invoice_id,
2634: invoice_line_number,
2635: invoice_distribution_id,

Line 3626: ap_invoice_distributions_s.nextval

3622: 'EXPENSE', DECODE(pd.accrue_on_receipt_flag,
3623: 'Y', pd.code_combination_id,
3624: aid1.dist_code_combination_id),
3625: pd.variance_account_id),
3626: ap_invoice_distributions_s.nextval
3627: FROM ap_invoice_lines ail,
3628: ap_invoice_distributions aid1,
3629: po_distributions pd,
3630: ap_invoice_distributions aid2

Line 3628: ap_invoice_distributions aid1,

3624: aid1.dist_code_combination_id),
3625: pd.variance_account_id),
3626: ap_invoice_distributions_s.nextval
3627: FROM ap_invoice_lines ail,
3628: ap_invoice_distributions aid1,
3629: po_distributions pd,
3630: ap_invoice_distributions aid2
3631: WHERE ail.invoice_id = x_corrected_invoice_id
3632: AND ail.line_number = x_corrected_line_number

Line 3630: ap_invoice_distributions aid2

3626: ap_invoice_distributions_s.nextval
3627: FROM ap_invoice_lines ail,
3628: ap_invoice_distributions aid1,
3629: po_distributions pd,
3630: ap_invoice_distributions aid2
3631: WHERE ail.invoice_id = x_corrected_invoice_id
3632: AND ail.line_number = x_corrected_line_number
3633: AND aid1.invoice_id = ail.invoice_id
3634: AND aid1.po_distribution_id = pd.po_distribution_id /*bugfix:5606697*/

Line 3668: ap_invoice_distributions_s.nextval

3664: ) amount,
3665: round((x_correction_quantity * decode(pd.distribution_type,'PREPAYMENT',nvl(pd.quantity_financed,0),nvl(pd.quantity_billed,0)))/
3666: p_total_quantity_billed , 15) corrected_quantity,
3667: aid.dist_code_combination_id,
3668: ap_invoice_distributions_s.nextval
3669: FROM ap_invoice_distributions aid,
3670: ap_invoice_lines ail,
3671: po_distributions pd
3672: WHERE ail.invoice_id = x_corrected_invoice_id

Line 3669: FROM ap_invoice_distributions aid,

3665: round((x_correction_quantity * decode(pd.distribution_type,'PREPAYMENT',nvl(pd.quantity_financed,0),nvl(pd.quantity_billed,0)))/
3666: p_total_quantity_billed , 15) corrected_quantity,
3667: aid.dist_code_combination_id,
3668: ap_invoice_distributions_s.nextval
3669: FROM ap_invoice_distributions aid,
3670: ap_invoice_lines ail,
3671: po_distributions pd
3672: WHERE ail.invoice_id = x_corrected_invoice_id
3673: AND ail.line_number = x_corrected_line_number

Line 3684: l_corrected_inv_dist_id ap_invoice_distributions.corrected_invoice_dist_id%TYPE;

3680: /*AND aid.line_type_lookup_code NOT IN ('PREPAY','AWT','RETAINAGE')
3681: AND (aid.line_type_lookup_code NOT IN ('REC_TAX','NONREC_TAX')
3682: OR aid.prepay_distribution_id IS NULL); */
3683:
3684: l_corrected_inv_dist_id ap_invoice_distributions.corrected_invoice_dist_id%TYPE;
3685: l_amount ap_invoice_distributions.amount%TYPE;
3686: l_corrected_quantity ap_invoice_distributions.corrected_quantity%TYPE;
3687: l_total_quantity_billed number;
3688: l_base_amount ap_invoice_distributions.base_amount%TYPE;

Line 3685: l_amount ap_invoice_distributions.amount%TYPE;

3681: AND (aid.line_type_lookup_code NOT IN ('REC_TAX','NONREC_TAX')
3682: OR aid.prepay_distribution_id IS NULL); */
3683:
3684: l_corrected_inv_dist_id ap_invoice_distributions.corrected_invoice_dist_id%TYPE;
3685: l_amount ap_invoice_distributions.amount%TYPE;
3686: l_corrected_quantity ap_invoice_distributions.corrected_quantity%TYPE;
3687: l_total_quantity_billed number;
3688: l_base_amount ap_invoice_distributions.base_amount%TYPE;
3689: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;

Line 3686: l_corrected_quantity ap_invoice_distributions.corrected_quantity%TYPE;

3682: OR aid.prepay_distribution_id IS NULL); */
3683:
3684: l_corrected_inv_dist_id ap_invoice_distributions.corrected_invoice_dist_id%TYPE;
3685: l_amount ap_invoice_distributions.amount%TYPE;
3686: l_corrected_quantity ap_invoice_distributions.corrected_quantity%TYPE;
3687: l_total_quantity_billed number;
3688: l_base_amount ap_invoice_distributions.base_amount%TYPE;
3689: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
3690: l_max_dist_amount ap_invoice_distributions.amount%TYPE := 0;

Line 3688: l_base_amount ap_invoice_distributions.base_amount%TYPE;

3684: l_corrected_inv_dist_id ap_invoice_distributions.corrected_invoice_dist_id%TYPE;
3685: l_amount ap_invoice_distributions.amount%TYPE;
3686: l_corrected_quantity ap_invoice_distributions.corrected_quantity%TYPE;
3687: l_total_quantity_billed number;
3688: l_base_amount ap_invoice_distributions.base_amount%TYPE;
3689: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
3690: l_max_dist_amount ap_invoice_distributions.amount%TYPE := 0;
3691: l_sum_prorated_amount ap_invoice_distributions.amount%TYPE := 0;
3692: l_rounding_index ap_invoice_distributions.invoice_distribution_id%TYPE;

Line 3689: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;

3685: l_amount ap_invoice_distributions.amount%TYPE;
3686: l_corrected_quantity ap_invoice_distributions.corrected_quantity%TYPE;
3687: l_total_quantity_billed number;
3688: l_base_amount ap_invoice_distributions.base_amount%TYPE;
3689: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
3690: l_max_dist_amount ap_invoice_distributions.amount%TYPE := 0;
3691: l_sum_prorated_amount ap_invoice_distributions.amount%TYPE := 0;
3692: l_rounding_index ap_invoice_distributions.invoice_distribution_id%TYPE;
3693: l_sum_dist_base_amount ap_invoice_distributions.base_amount%TYPE := 0;

Line 3690: l_max_dist_amount ap_invoice_distributions.amount%TYPE := 0;

3686: l_corrected_quantity ap_invoice_distributions.corrected_quantity%TYPE;
3687: l_total_quantity_billed number;
3688: l_base_amount ap_invoice_distributions.base_amount%TYPE;
3689: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
3690: l_max_dist_amount ap_invoice_distributions.amount%TYPE := 0;
3691: l_sum_prorated_amount ap_invoice_distributions.amount%TYPE := 0;
3692: l_rounding_index ap_invoice_distributions.invoice_distribution_id%TYPE;
3693: l_sum_dist_base_amount ap_invoice_distributions.base_amount%TYPE := 0;
3694: l_dist_ccid ap_invoice_distributions.dist_code_combination_id%TYPE;

Line 3691: l_sum_prorated_amount ap_invoice_distributions.amount%TYPE := 0;

3687: l_total_quantity_billed number;
3688: l_base_amount ap_invoice_distributions.base_amount%TYPE;
3689: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
3690: l_max_dist_amount ap_invoice_distributions.amount%TYPE := 0;
3691: l_sum_prorated_amount ap_invoice_distributions.amount%TYPE := 0;
3692: l_rounding_index ap_invoice_distributions.invoice_distribution_id%TYPE;
3693: l_sum_dist_base_amount ap_invoice_distributions.base_amount%TYPE := 0;
3694: l_dist_ccid ap_invoice_distributions.dist_code_combination_id%TYPE;
3695: l_po_dist_id ap_invoice_distributions.po_distribution_id%TYPE;

Line 3692: l_rounding_index ap_invoice_distributions.invoice_distribution_id%TYPE;

3688: l_base_amount ap_invoice_distributions.base_amount%TYPE;
3689: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
3690: l_max_dist_amount ap_invoice_distributions.amount%TYPE := 0;
3691: l_sum_prorated_amount ap_invoice_distributions.amount%TYPE := 0;
3692: l_rounding_index ap_invoice_distributions.invoice_distribution_id%TYPE;
3693: l_sum_dist_base_amount ap_invoice_distributions.base_amount%TYPE := 0;
3694: l_dist_ccid ap_invoice_distributions.dist_code_combination_id%TYPE;
3695: l_po_dist_id ap_invoice_distributions.po_distribution_id%TYPE;
3696: l_price_variance ap_invoice_distributions.amount%TYPE := 0;

Line 3693: l_sum_dist_base_amount ap_invoice_distributions.base_amount%TYPE := 0;

3689: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
3690: l_max_dist_amount ap_invoice_distributions.amount%TYPE := 0;
3691: l_sum_prorated_amount ap_invoice_distributions.amount%TYPE := 0;
3692: l_rounding_index ap_invoice_distributions.invoice_distribution_id%TYPE;
3693: l_sum_dist_base_amount ap_invoice_distributions.base_amount%TYPE := 0;
3694: l_dist_ccid ap_invoice_distributions.dist_code_combination_id%TYPE;
3695: l_po_dist_id ap_invoice_distributions.po_distribution_id%TYPE;
3696: l_price_variance ap_invoice_distributions.amount%TYPE := 0;
3697: l_debug_info varchar2(2000);

Line 3694: l_dist_ccid ap_invoice_distributions.dist_code_combination_id%TYPE;

3690: l_max_dist_amount ap_invoice_distributions.amount%TYPE := 0;
3691: l_sum_prorated_amount ap_invoice_distributions.amount%TYPE := 0;
3692: l_rounding_index ap_invoice_distributions.invoice_distribution_id%TYPE;
3693: l_sum_dist_base_amount ap_invoice_distributions.base_amount%TYPE := 0;
3694: l_dist_ccid ap_invoice_distributions.dist_code_combination_id%TYPE;
3695: l_po_dist_id ap_invoice_distributions.po_distribution_id%TYPE;
3696: l_price_variance ap_invoice_distributions.amount%TYPE := 0;
3697: l_debug_info varchar2(2000);
3698: current_calling_sequence varchar2(2000);

Line 3695: l_po_dist_id ap_invoice_distributions.po_distribution_id%TYPE;

3691: l_sum_prorated_amount ap_invoice_distributions.amount%TYPE := 0;
3692: l_rounding_index ap_invoice_distributions.invoice_distribution_id%TYPE;
3693: l_sum_dist_base_amount ap_invoice_distributions.base_amount%TYPE := 0;
3694: l_dist_ccid ap_invoice_distributions.dist_code_combination_id%TYPE;
3695: l_po_dist_id ap_invoice_distributions.po_distribution_id%TYPE;
3696: l_price_variance ap_invoice_distributions.amount%TYPE := 0;
3697: l_debug_info varchar2(2000);
3698: current_calling_sequence varchar2(2000);
3699: l_api_name varchar2(50);

Line 3696: l_price_variance ap_invoice_distributions.amount%TYPE := 0;

3692: l_rounding_index ap_invoice_distributions.invoice_distribution_id%TYPE;
3693: l_sum_dist_base_amount ap_invoice_distributions.base_amount%TYPE := 0;
3694: l_dist_ccid ap_invoice_distributions.dist_code_combination_id%TYPE;
3695: l_po_dist_id ap_invoice_distributions.po_distribution_id%TYPE;
3696: l_price_variance ap_invoice_distributions.amount%TYPE := 0;
3697: l_debug_info varchar2(2000);
3698: current_calling_sequence varchar2(2000);
3699: l_api_name varchar2(50);
3700:

Line 3722: FROM ap_invoice_distributions_all

3718: --Commented for bug#11886930
3719: /* BEGIN
3720: SELECT nvl(sum(amount),0) -- Bug 5629985. Added the NVL
3721: INTO l_price_variance
3722: FROM ap_invoice_distributions_all
3723: WHERE invoice_id = x_corrected_invoice_id
3724: AND invoice_line_number = x_corrected_line_number
3725: AND line_type_lookup_code = 'IPV';
3726: EXCEPTION

Line 3778: ap_invoice_distributions aid

3774:
3775: SELECT sum(decode(pd.distribution_type,'PREPAYMENT',nvl(pd.quantity_financed,0),nvl(pd.quantity_billed,0)))
3776: INTO l_total_quantity_billed
3777: FROM po_distributions pd,
3778: ap_invoice_distributions aid
3779: WHERE pd.po_distribution_id = aid.po_distribution_id
3780: AND aid.invoice_id = x_corrected_invoice_id
3781: AND aid.invoice_line_number = x_corrected_line_number
3782: -- Bug 5585744, Modified the condition below

Line 3845: SELECT ap_invoice_distributions_s.nextval

3841: FOR i IN nvl(x_corr_dist_tab.first,0) ..nvl(x_corr_dist_tab.last,0) LOOP
3842:
3843: IF (x_corr_dist_tab.exists(i)) THEN
3844:
3845: SELECT ap_invoice_distributions_s.nextval
3846: INTO x_corr_dist_tab(i).invoice_distribution_id
3847: FROM DUAL;
3848:
3849: x_corr_dist_tab(i).pa_quantity := x_corr_dist_tab(i).corrected_quantity;

Line 4539: l_distribution_line_number ap_invoice_distributions.distribution_line_number%type := 1;

4535: x_total_amount IN NUMBER,
4536: x_calling_sequence IN VARCHAR2) IS
4537:
4538: i NUMBER;
4539: l_distribution_line_number ap_invoice_distributions.distribution_line_number%type := 1;
4540: l_debug_info VARCHAR2(2000);
4541: current_calling_sequence VARCHAR2(2000);
4542: l_api_name VARCHAR2(50);
4543:

Line 4558: INSERT INTO AP_INVOICE_DISTRIBUTIONS(

4554: FOR i in NVL(x_corr_dist_tab.FIRST,0) .. NVL(x_corr_dist_tab.LAST,0) LOOP
4555:
4556: IF (x_corr_dist_tab.exists(i)) THEN
4557:
4558: INSERT INTO AP_INVOICE_DISTRIBUTIONS(
4559: batch_id,
4560: invoice_id,
4561: invoice_line_number,
4562: invoice_distribution_id,

Line 4887: ap_invoice_distributions aid,

4883: decode(g_site_allow_awt_flag,'Y',
4884: ail.pay_awt_group_id,NULL),
4885: NULL) --pay_awt_group_id bug8222382
4886: FROM ap_invoice_lines ail,
4887: ap_invoice_distributions aid,
4888: po_distributions pd
4889: WHERE ail.invoice_id = x_invoice_id
4890: AND ail.line_number = x_invoice_line_number
4891: AND aid.invoice_id = ail.corrected_inv_id