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_PO_AMT_MATCH_PKG dependencies on PO_DISTRIBUTIONS

Line 226: l_po_distribution_id po_distributions.po_distribution_id%TYPE := NULL;

222: X_retained_amount IN NUMBER DEFAULT NULL,
223: X_calling_sequence IN VARCHAR2)
224: IS
225: l_single_dist_flag varchar2(1) := 'N';
226: l_po_distribution_id po_distributions.po_distribution_id%TYPE := NULL;
227: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
228: l_item_line_number ap_invoice_lines.line_number%TYPE;
229: l_amount_to_recoup ap_invoice_lines.amount%TYPE;
230: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;

Line 353: --po distributions of the shipment, for distribution level match we need to

349: END IF;
350:
351:
352: --If shipment level match then we need to prorate the match-amount among the
353: --po distributions of the shipment, for distribution level match we need to
354: --derive the invoice_distribution_id, base_amount, ccid.
355:
356: l_debug_info := 'Get Distribution information';
357:

Line 483: po_distributions pd,

479: --end Bug 7483260
480: l_retained_amount,
481: -1 * l_retained_amount
482: FROM ap_invoice_distributions aid,
483: po_distributions pd,
484: po_line_locations pll
485: WHERE aid.invoice_distribution_id = l_invoice_distribution_id
486: AND pd.po_distribution_id = aid.po_distribution_id
487: AND pll.line_location_id = pd.line_location_id)

Line 879: CURSOR po_distributions_cursor(p_total_amount NUMBER) IS

875: X_Overbill_Flag IN VARCHAR2,
876: X_Dist_Tab IN OUT NOCOPY AP_MATCHING_PKG.DIST_TAB_TYPE,
877: X_Calling_Sequence IN VARCHAR2)
878: IS
879: CURSOR po_distributions_cursor(p_total_amount NUMBER) IS
880: SELECT po_distribution_id,
881: /*PRORATED AMOUNT*/
882: DECODE(g_min_acct_unit,
883: '', ROUND( X_match_amount * DECODE(X_match_mode,

Line 938: FROM po_distributions_ap_v PD

934: NULL), --expenditure_organization_id
935: DECODE(PD.destination_type_code,
936: 'EXPENSE', PD.award_id), --award_id
937: ap_invoice_distributions_s.nextval
938: FROM po_distributions_ap_v PD
939: WHERE line_location_id = x_po_line_location_id;
940:
941: l_total_amount number;
942: l_po_distribution_id po_distributions_all.po_distribution_id%TYPE;

Line 942: l_po_distribution_id po_distributions_all.po_distribution_id%TYPE;

938: FROM po_distributions_ap_v PD
939: WHERE line_location_id = x_po_line_location_id;
940:
941: l_total_amount number;
942: l_po_distribution_id po_distributions_all.po_distribution_id%TYPE;
943: l_amount_invoiced ap_invoice_distributions_all.amount%TYPE;
944: l_quantity_invoiced ap_invoice_distributions_all.quantity_invoiced%TYPE;
945: l_po_dist_ccid po_distributions.code_combination_id%TYPE;
946: l_accrue_on_receipt_flag po_distributions.accrue_on_receipt_flag%TYPE;

Line 945: l_po_dist_ccid po_distributions.code_combination_id%TYPE;

941: l_total_amount number;
942: l_po_distribution_id po_distributions_all.po_distribution_id%TYPE;
943: l_amount_invoiced ap_invoice_distributions_all.amount%TYPE;
944: l_quantity_invoiced ap_invoice_distributions_all.quantity_invoiced%TYPE;
945: l_po_dist_ccid po_distributions.code_combination_id%TYPE;
946: l_accrue_on_receipt_flag po_distributions.accrue_on_receipt_flag%TYPE;
947: l_project_id po_distributions.project_id%TYPE;
948: l_unbuilt_flex varchar2(240):='';
949: l_reason_unbuilt_flex varchar2(2000):='';

Line 946: l_accrue_on_receipt_flag po_distributions.accrue_on_receipt_flag%TYPE;

942: l_po_distribution_id po_distributions_all.po_distribution_id%TYPE;
943: l_amount_invoiced ap_invoice_distributions_all.amount%TYPE;
944: l_quantity_invoiced ap_invoice_distributions_all.quantity_invoiced%TYPE;
945: l_po_dist_ccid po_distributions.code_combination_id%TYPE;
946: l_accrue_on_receipt_flag po_distributions.accrue_on_receipt_flag%TYPE;
947: l_project_id po_distributions.project_id%TYPE;
948: l_unbuilt_flex varchar2(240):='';
949: l_reason_unbuilt_flex varchar2(2000):='';
950: l_dist_ccid ap_invoice_distributions_all.dist_code_combination_id%TYPE;

Line 947: l_project_id po_distributions.project_id%TYPE;

943: l_amount_invoiced ap_invoice_distributions_all.amount%TYPE;
944: l_quantity_invoiced ap_invoice_distributions_all.quantity_invoiced%TYPE;
945: l_po_dist_ccid po_distributions.code_combination_id%TYPE;
946: l_accrue_on_receipt_flag po_distributions.accrue_on_receipt_flag%TYPE;
947: l_project_id po_distributions.project_id%TYPE;
948: l_unbuilt_flex varchar2(240):='';
949: l_reason_unbuilt_flex varchar2(2000):='';
950: l_dist_ccid ap_invoice_distributions_all.dist_code_combination_id%TYPE;
951: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;

Line 952: l_task_id po_distributions.task_id%TYPE;

948: l_unbuilt_flex varchar2(240):='';
949: l_reason_unbuilt_flex varchar2(2000):='';
950: l_dist_ccid ap_invoice_distributions_all.dist_code_combination_id%TYPE;
951: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
952: l_task_id po_distributions.task_id%TYPE;
953: l_award_set_id po_distributions_all.award_id%TYPE;
954: l_expenditure_type po_distributions.expenditure_type%TYPE;
955: l_po_expenditure_item_date po_distributions.expenditure_item_date%TYPE;
956: l_expenditure_organization_id po_distributions.expenditure_organization_id%TYPE;

Line 953: l_award_set_id po_distributions_all.award_id%TYPE;

949: l_reason_unbuilt_flex varchar2(2000):='';
950: l_dist_ccid ap_invoice_distributions_all.dist_code_combination_id%TYPE;
951: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
952: l_task_id po_distributions.task_id%TYPE;
953: l_award_set_id po_distributions_all.award_id%TYPE;
954: l_expenditure_type po_distributions.expenditure_type%TYPE;
955: l_po_expenditure_item_date po_distributions.expenditure_item_date%TYPE;
956: l_expenditure_organization_id po_distributions.expenditure_organization_id%TYPE;
957: l_max_dist_amount number := 0;

Line 954: l_expenditure_type po_distributions.expenditure_type%TYPE;

950: l_dist_ccid ap_invoice_distributions_all.dist_code_combination_id%TYPE;
951: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
952: l_task_id po_distributions.task_id%TYPE;
953: l_award_set_id po_distributions_all.award_id%TYPE;
954: l_expenditure_type po_distributions.expenditure_type%TYPE;
955: l_po_expenditure_item_date po_distributions.expenditure_item_date%TYPE;
956: l_expenditure_organization_id po_distributions.expenditure_organization_id%TYPE;
957: l_max_dist_amount number := 0;
958: l_sum_prorated_amount number := 0;

Line 955: l_po_expenditure_item_date po_distributions.expenditure_item_date%TYPE;

951: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
952: l_task_id po_distributions.task_id%TYPE;
953: l_award_set_id po_distributions_all.award_id%TYPE;
954: l_expenditure_type po_distributions.expenditure_type%TYPE;
955: l_po_expenditure_item_date po_distributions.expenditure_item_date%TYPE;
956: l_expenditure_organization_id po_distributions.expenditure_organization_id%TYPE;
957: l_max_dist_amount number := 0;
958: l_sum_prorated_amount number := 0;
959: l_sum_dist_base_amount number := 0;

Line 956: l_expenditure_organization_id po_distributions.expenditure_organization_id%TYPE;

952: l_task_id po_distributions.task_id%TYPE;
953: l_award_set_id po_distributions_all.award_id%TYPE;
954: l_expenditure_type po_distributions.expenditure_type%TYPE;
955: l_po_expenditure_item_date po_distributions.expenditure_item_date%TYPE;
956: l_expenditure_organization_id po_distributions.expenditure_organization_id%TYPE;
957: l_max_dist_amount number := 0;
958: l_sum_prorated_amount number := 0;
959: l_sum_dist_base_amount number := 0;
960: l_rounding_index po_distributions.po_distribution_id%TYPE;

Line 960: l_rounding_index po_distributions.po_distribution_id%TYPE;

956: l_expenditure_organization_id po_distributions.expenditure_organization_id%TYPE;
957: l_max_dist_amount number := 0;
958: l_sum_prorated_amount number := 0;
959: l_sum_dist_base_amount number := 0;
960: l_rounding_index po_distributions.po_distribution_id%TYPE;
961: l_base_amount ap_invoice_distributions.base_amount%TYPE;
962: flex_overlay_failed exception;
963: current_calling_sequence varchar2(2000);
964: l_debug_info varchar2(2000);

Line 982: OPEN PO_Distributions_Cursor(l_total_amount);

978: X_Overbill_Flag => x_overbill_flag,
979: X_Total_Amount => l_total_amount,
980: X_Calling_Sequence => current_calling_sequence);
981:
982: OPEN PO_Distributions_Cursor(l_total_amount);
983:
984: LOOP
985:
986: FETCH PO_Distributions_Cursor INTO l_po_distribution_id,

Line 986: FETCH PO_Distributions_Cursor INTO l_po_distribution_id,

982: OPEN PO_Distributions_Cursor(l_total_amount);
983:
984: LOOP
985:
986: FETCH PO_Distributions_Cursor INTO l_po_distribution_id,
987: l_amount_invoiced,
988: l_quantity_invoiced,
989: l_po_dist_ccid,
990: l_accrue_on_receipt_flag,

Line 999: EXIT WHEN PO_Distributions_Cursor%NOTFOUND;

995: l_expenditure_organization_id,
996: l_award_set_id,
997: l_invoice_distribution_id;
998:
999: EXIT WHEN PO_Distributions_Cursor%NOTFOUND;
1000:
1001: IF (l_amount_invoiced <> 0) THEN
1002:
1003: x_dist_tab(l_po_distribution_id).po_distribution_id := l_po_distribution_id;

Line 1035: CLOSE PO_Distributions_Cursor;

1031: END IF; /* (l_amount_invoiced <> 0) */
1032:
1033: END LOOP;
1034:
1035: CLOSE PO_Distributions_Cursor;
1036:
1037: --Update the PL/SQL table's amount column with the rounding amount due
1038: --to proration, before the base_amounts are calculated.
1039:

Line 1072: FROM po_distributions_ap_v

1068: x_dist_tab(i).expenditure_type,
1069: x_dist_tab(i).expenditure_item_date,
1070: x_dist_tab(i).expenditure_organization_id,
1071: x_dist_tab(i).invoice_distribution_id
1072: FROM po_distributions_ap_v
1073: WHERE po_distribution_id = x_dist_tab(i).po_distribution_id;
1074:
1075: -- Bug 5554493
1076: x_dist_tab(i).pa_quantity := x_dist_tab(i).quantity_invoiced;

Line 1295: --po_distributions_ap_v.code_combination_id is accrual account

1291: --bugfix:4668058 added the following clause
1292: (x_dist_tab(i).project_id IS NOT NULL AND g_allow_pa_override = 'N')
1293: ) THEN
1294:
1295: --po_distributions_ap_v.code_combination_id is accrual account
1296: --if accruing on receipt or else charge account
1297:
1298: x_dist_tab(i).dist_ccid := x_dist_tab(i).po_ccid;
1299:

Line 1436: FROM po_distributions_ap_v

1432: ,0)),
1433: DECODE(distribution_type,'PREPAYMENT',
1434: NVL(amount_financed,0),NVL(amount_billed, 0))))
1435: INTO X_Total_Amount
1436: FROM po_distributions_ap_v
1437: WHERE line_location_id = X_Po_Line_Location_Id;
1438:
1439: EXCEPTION
1440: WHEN OTHERS THEN

Line 1567: l_debug_info := 'Call the PO_AP_INVOICE_MATCH_GRP to update the Po Distributions and Po Line Locations';

1563: END IF;
1564:
1565: END LOOP;
1566:
1567: l_debug_info := 'Call the PO_AP_INVOICE_MATCH_GRP to update the Po Distributions and Po Line Locations';
1568: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1569: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1570: END IF;
1571:

Line 1666: -- go to base tables PO_LINES_ALL, PO_LINE_LOCATIONS and PO_DISTRIBUTIONS

1662:
1663: l_debug_info := 'Inserting Item Line Matched to a PO';
1664:
1665: -- perf bug 5058993
1666: -- go to base tables PO_LINES_ALL, PO_LINE_LOCATIONS and PO_DISTRIBUTIONS
1667: -- instead of PO_LINE_LOCATIONS_AP_V and PO_DISTRIBUTIONS_AP_V
1668:
1669:
1670: INSERT INTO AP_INVOICE_LINES (

Line 1667: -- instead of PO_LINE_LOCATIONS_AP_V and PO_DISTRIBUTIONS_AP_V

1663: l_debug_info := 'Inserting Item Line Matched to a PO';
1664:
1665: -- perf bug 5058993
1666: -- go to base tables PO_LINES_ALL, PO_LINE_LOCATIONS and PO_DISTRIBUTIONS
1667: -- instead of PO_LINE_LOCATIONS_AP_V and PO_DISTRIBUTIONS_AP_V
1668:
1669:
1670: INSERT INTO AP_INVOICE_LINES (
1671: INVOICE_ID,

Line 2043: po_distributions pd,

2039: G_dflt_tax_class_code
2040: -- bug 5061826 -- new FROM clause that goes to base tables
2041: FROM PO_LINES_ALL PL,
2042: PO_LINE_LOCATIONS_ALL PLL,
2043: po_distributions pd,
2044: mtl_system_items msi
2045: WHERE pll.line_location_id = x_po_line_location_id
2046: and pd.line_location_id = pll.line_location_id
2047: AND PLL.PO_LINE_ID = PL.PO_LINE_ID

Line 2054: PO_DISTRIBUTIONS_AP_V PD,

2050: and msi.organization_id(+) = g_inventory_organization_id
2051: and rownum = 1;
2052: /* -- commented out older from clause below
2053: FROM PO_LINE_LOCATIONS_AP_V PLL,
2054: PO_DISTRIBUTIONS_AP_V PD,
2055: MTL_SYSTEM_ITEMS MSI
2056: WHERE PLL.LINE_LOCATION_ID = X_PO_LINE_LOCATION_ID
2057: AND PD.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID
2058: AND PD.PO_DISTRIBUTION_ID = NVL(X_PO_DISTRIBUTION_ID,PD.PO_DISTRIBUTION_ID)

Line 2754: FROM po_distributions pd,

2750: g_intended_use, --intended_use
2751: 'N', --accrual_posted_flag
2752: 'N', --cash_posted_flag
2753: 'N' --rcv_charge_addition_flag
2754: FROM po_distributions pd,
2755: ap_invoice_lines ail,
2756: gl_code_combinations gcc
2757: WHERE ail.invoice_id = x_invoice_id
2758: AND ail.line_number = x_invoice_line_number

Line 2927: l_po_distribution_id PO_DISTRIBUTIONS.PO_DISTRIBUTION_ID%TYPE := NULL;

2923: X_Uom_Lookup_Code IN VARCHAR2,
2924: X_Retained_Amount IN NUMBER DEFAULT NULL,
2925: X_Calling_Sequence IN VARCHAR2) IS
2926:
2927: l_po_distribution_id PO_DISTRIBUTIONS.PO_DISTRIBUTION_ID%TYPE := NULL;
2928: l_item_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE;
2929: l_amount_to_recoup AP_INVOICE_LINES_ALL.AMOUNT%TYPE;
2930: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;
2931: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;

Line 3332: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_PO_AMT_MATCH_PKG.Update_Corr_Po_Distributions(+)');

3328:
3329: current_calling_sequence := 'Update_Corr_Po_Shipments_Dists<-'||x_calling_sequence;
3330:
3331: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3332: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_PO_AMT_MATCH_PKG.Update_Corr_Po_Distributions(+)');
3333: END IF;
3334:
3335: l_debug_info := 'Create l_po_ap_dist_rec object';
3336: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 3381: l_debug_info := 'Call the PO_AP_INVOICE_MATCH_GRP to update the Po Distributions and Po Line Locations';

3377: END IF;
3378:
3379: END LOOP;
3380:
3381: l_debug_info := 'Call the PO_AP_INVOICE_MATCH_GRP to update the Po Distributions and Po Line Locations';
3382: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3383: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3384: END IF;
3385:

Line 4165: po_distributions pd

4161: 'N', --cash_posted_flag
4162: 'N' --rcv_charge_addition_flag
4163: FROM ap_invoice_lines ail,
4164: ap_invoice_distributions aid,
4165: po_distributions pd
4166: WHERE ail.invoice_id = x_invoice_id
4167: AND ail.line_number = x_invoice_line_number
4168: AND aid.invoice_id = ail.corrected_inv_id
4169: AND aid.invoice_line_number = ail.corrected_line_number