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 228: l_po_distribution_id po_distributions.po_distribution_id%TYPE := NULL;

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

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

437: END IF;
438:
439:
440: --If shipment level match then we need to prorate the match-amount among the
441: --po distributions of the shipment, for distribution level match we need to
442: --derive the invoice_distribution_id, base_amount, ccid.
443:
444: l_debug_info := 'Get Distribution information';
445:

Line 571: po_distributions pd,

567: --end Bug 7483260
568: l_retained_amount,
569: -1 * l_retained_amount
570: FROM ap_invoice_distributions aid,
571: po_distributions pd,
572: po_line_locations pll
573: WHERE aid.invoice_distribution_id = l_invoice_distribution_id
574: AND pd.po_distribution_id = aid.po_distribution_id
575: AND pll.line_location_id = pd.line_location_id)

Line 977: CURSOR po_distributions_cursor(p_total_amount NUMBER) IS

973: X_Overbill_Flag IN VARCHAR2,
974: X_Dist_Tab IN OUT NOCOPY AP_MATCHING_PKG.DIST_TAB_TYPE,
975: X_Calling_Sequence IN VARCHAR2)
976: IS
977: CURSOR po_distributions_cursor(p_total_amount NUMBER) IS
978: SELECT po_distribution_id,
979: /*PRORATED AMOUNT*/
980: DECODE(g_min_acct_unit,
981: '', ROUND( X_match_amount * DECODE(X_match_mode,

Line 1036: FROM po_distributions_ap_v PD

1032: NULL), --expenditure_organization_id
1033: DECODE(PD.destination_type_code,
1034: 'EXPENSE', PD.award_id), --award_id
1035: ap_invoice_distributions_s.nextval
1036: FROM po_distributions_ap_v PD
1037: WHERE line_location_id = x_po_line_location_id;
1038:
1039: l_total_amount number;
1040: l_po_distribution_id po_distributions_all.po_distribution_id%TYPE;

Line 1040: l_po_distribution_id po_distributions_all.po_distribution_id%TYPE;

1036: FROM po_distributions_ap_v PD
1037: WHERE line_location_id = x_po_line_location_id;
1038:
1039: l_total_amount number;
1040: l_po_distribution_id po_distributions_all.po_distribution_id%TYPE;
1041: l_amount_invoiced ap_invoice_distributions_all.amount%TYPE;
1042: l_quantity_invoiced ap_invoice_distributions_all.quantity_invoiced%TYPE;
1043: l_po_dist_ccid po_distributions.code_combination_id%TYPE;
1044: l_accrue_on_receipt_flag po_distributions.accrue_on_receipt_flag%TYPE;

Line 1043: l_po_dist_ccid po_distributions.code_combination_id%TYPE;

1039: l_total_amount number;
1040: l_po_distribution_id po_distributions_all.po_distribution_id%TYPE;
1041: l_amount_invoiced ap_invoice_distributions_all.amount%TYPE;
1042: l_quantity_invoiced ap_invoice_distributions_all.quantity_invoiced%TYPE;
1043: l_po_dist_ccid po_distributions.code_combination_id%TYPE;
1044: l_accrue_on_receipt_flag po_distributions.accrue_on_receipt_flag%TYPE;
1045: l_project_id po_distributions.project_id%TYPE;
1046: l_unbuilt_flex varchar2(240):='';
1047: l_reason_unbuilt_flex varchar2(2000):='';

Line 1044: l_accrue_on_receipt_flag po_distributions.accrue_on_receipt_flag%TYPE;

1040: l_po_distribution_id po_distributions_all.po_distribution_id%TYPE;
1041: l_amount_invoiced ap_invoice_distributions_all.amount%TYPE;
1042: l_quantity_invoiced ap_invoice_distributions_all.quantity_invoiced%TYPE;
1043: l_po_dist_ccid po_distributions.code_combination_id%TYPE;
1044: l_accrue_on_receipt_flag po_distributions.accrue_on_receipt_flag%TYPE;
1045: l_project_id po_distributions.project_id%TYPE;
1046: l_unbuilt_flex varchar2(240):='';
1047: l_reason_unbuilt_flex varchar2(2000):='';
1048: l_dist_ccid ap_invoice_distributions_all.dist_code_combination_id%TYPE;

Line 1045: l_project_id po_distributions.project_id%TYPE;

1041: l_amount_invoiced ap_invoice_distributions_all.amount%TYPE;
1042: l_quantity_invoiced ap_invoice_distributions_all.quantity_invoiced%TYPE;
1043: l_po_dist_ccid po_distributions.code_combination_id%TYPE;
1044: l_accrue_on_receipt_flag po_distributions.accrue_on_receipt_flag%TYPE;
1045: l_project_id po_distributions.project_id%TYPE;
1046: l_unbuilt_flex varchar2(240):='';
1047: l_reason_unbuilt_flex varchar2(2000):='';
1048: l_dist_ccid ap_invoice_distributions_all.dist_code_combination_id%TYPE;
1049: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;

Line 1050: l_task_id po_distributions.task_id%TYPE;

1046: l_unbuilt_flex varchar2(240):='';
1047: l_reason_unbuilt_flex varchar2(2000):='';
1048: l_dist_ccid ap_invoice_distributions_all.dist_code_combination_id%TYPE;
1049: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
1050: l_task_id po_distributions.task_id%TYPE;
1051: l_award_set_id po_distributions_all.award_id%TYPE;
1052: l_expenditure_type po_distributions.expenditure_type%TYPE;
1053: l_po_expenditure_item_date po_distributions.expenditure_item_date%TYPE;
1054: l_expenditure_organization_id po_distributions.expenditure_organization_id%TYPE;

Line 1051: l_award_set_id po_distributions_all.award_id%TYPE;

1047: l_reason_unbuilt_flex varchar2(2000):='';
1048: l_dist_ccid ap_invoice_distributions_all.dist_code_combination_id%TYPE;
1049: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
1050: l_task_id po_distributions.task_id%TYPE;
1051: l_award_set_id po_distributions_all.award_id%TYPE;
1052: l_expenditure_type po_distributions.expenditure_type%TYPE;
1053: l_po_expenditure_item_date po_distributions.expenditure_item_date%TYPE;
1054: l_expenditure_organization_id po_distributions.expenditure_organization_id%TYPE;
1055: l_max_dist_amount number := 0;

Line 1052: l_expenditure_type po_distributions.expenditure_type%TYPE;

1048: l_dist_ccid ap_invoice_distributions_all.dist_code_combination_id%TYPE;
1049: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
1050: l_task_id po_distributions.task_id%TYPE;
1051: l_award_set_id po_distributions_all.award_id%TYPE;
1052: l_expenditure_type po_distributions.expenditure_type%TYPE;
1053: l_po_expenditure_item_date po_distributions.expenditure_item_date%TYPE;
1054: l_expenditure_organization_id po_distributions.expenditure_organization_id%TYPE;
1055: l_max_dist_amount number := 0;
1056: l_sum_prorated_amount number := 0;

Line 1053: l_po_expenditure_item_date po_distributions.expenditure_item_date%TYPE;

1049: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
1050: l_task_id po_distributions.task_id%TYPE;
1051: l_award_set_id po_distributions_all.award_id%TYPE;
1052: l_expenditure_type po_distributions.expenditure_type%TYPE;
1053: l_po_expenditure_item_date po_distributions.expenditure_item_date%TYPE;
1054: l_expenditure_organization_id po_distributions.expenditure_organization_id%TYPE;
1055: l_max_dist_amount number := 0;
1056: l_sum_prorated_amount number := 0;
1057: l_sum_dist_base_amount number := 0;

Line 1054: l_expenditure_organization_id po_distributions.expenditure_organization_id%TYPE;

1050: l_task_id po_distributions.task_id%TYPE;
1051: l_award_set_id po_distributions_all.award_id%TYPE;
1052: l_expenditure_type po_distributions.expenditure_type%TYPE;
1053: l_po_expenditure_item_date po_distributions.expenditure_item_date%TYPE;
1054: l_expenditure_organization_id po_distributions.expenditure_organization_id%TYPE;
1055: l_max_dist_amount number := 0;
1056: l_sum_prorated_amount number := 0;
1057: l_sum_dist_base_amount number := 0;
1058: l_rounding_index po_distributions.po_distribution_id%TYPE;

Line 1058: l_rounding_index po_distributions.po_distribution_id%TYPE;

1054: l_expenditure_organization_id po_distributions.expenditure_organization_id%TYPE;
1055: l_max_dist_amount number := 0;
1056: l_sum_prorated_amount number := 0;
1057: l_sum_dist_base_amount number := 0;
1058: l_rounding_index po_distributions.po_distribution_id%TYPE;
1059: l_base_amount ap_invoice_distributions.base_amount%TYPE;
1060: flex_overlay_failed exception;
1061: current_calling_sequence varchar2(2000);
1062: l_debug_info varchar2(2000);

Line 1080: OPEN PO_Distributions_Cursor(l_total_amount);

1076: X_Overbill_Flag => x_overbill_flag,
1077: X_Total_Amount => l_total_amount,
1078: X_Calling_Sequence => current_calling_sequence);
1079:
1080: OPEN PO_Distributions_Cursor(l_total_amount);
1081:
1082: LOOP
1083:
1084: FETCH PO_Distributions_Cursor INTO l_po_distribution_id,

Line 1084: FETCH PO_Distributions_Cursor INTO l_po_distribution_id,

1080: OPEN PO_Distributions_Cursor(l_total_amount);
1081:
1082: LOOP
1083:
1084: FETCH PO_Distributions_Cursor INTO l_po_distribution_id,
1085: l_amount_invoiced,
1086: l_quantity_invoiced,
1087: l_po_dist_ccid,
1088: l_accrue_on_receipt_flag,

Line 1097: EXIT WHEN PO_Distributions_Cursor%NOTFOUND;

1093: l_expenditure_organization_id,
1094: l_award_set_id,
1095: l_invoice_distribution_id;
1096:
1097: EXIT WHEN PO_Distributions_Cursor%NOTFOUND;
1098:
1099: IF (l_amount_invoiced <> 0) THEN
1100:
1101: x_dist_tab(l_po_distribution_id).po_distribution_id := l_po_distribution_id;

Line 1134: CLOSE PO_Distributions_Cursor;

1130: END IF; /* (l_amount_invoiced <> 0) */
1131:
1132: END LOOP;
1133:
1134: CLOSE PO_Distributions_Cursor;
1135:
1136: --Update the PL/SQL table's amount column with the rounding amount due
1137: --to proration, before the base_amounts are calculated.
1138:

Line 1171: FROM po_distributions_ap_v

1167: x_dist_tab(i).expenditure_type,
1168: x_dist_tab(i).expenditure_item_date,
1169: x_dist_tab(i).expenditure_organization_id,
1170: x_dist_tab(i).invoice_distribution_id
1171: FROM po_distributions_ap_v
1172: WHERE po_distribution_id = x_dist_tab(i).po_distribution_id;
1173:
1174: -- Bug 5554493
1175: x_dist_tab(i).pa_quantity := x_dist_tab(i).quantity_invoiced;

Line 1396: --po_distributions_ap_v.code_combination_id is accrual account

1392: --bugfix:4668058 added the following clause
1393: (x_dist_tab(i).project_id IS NOT NULL AND g_allow_pa_override = 'N')
1394: ) THEN
1395:
1396: --po_distributions_ap_v.code_combination_id is accrual account
1397: --if accruing on receipt or else charge account
1398:
1399: x_dist_tab(i).dist_ccid := x_dist_tab(i).po_ccid;
1400:

Line 1537: FROM po_distributions_ap_v

1533: ,0)),
1534: DECODE(distribution_type,'PREPAYMENT',
1535: NVL(amount_financed,0),NVL(amount_billed, 0))))
1536: INTO X_Total_Amount
1537: FROM po_distributions_ap_v
1538: WHERE line_location_id = X_Po_Line_Location_Id;
1539:
1540: EXCEPTION
1541: WHEN OTHERS THEN

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

1664: END IF;
1665:
1666: END LOOP;
1667:
1668: l_debug_info := 'Call the PO_AP_INVOICE_MATCH_GRP to update the Po Distributions and Po Line Locations';
1669: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1670: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1671: END IF;
1672:

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

1778:
1779: --End Bug#13505998
1780:
1781: -- perf bug 5058993
1782: -- go to base tables PO_LINES_ALL, PO_LINE_LOCATIONS and PO_DISTRIBUTIONS
1783: -- instead of PO_LINE_LOCATIONS_AP_V and PO_DISTRIBUTIONS_AP_V
1784:
1785:
1786: INSERT INTO AP_INVOICE_LINES (

Line 1783: -- instead of PO_LINE_LOCATIONS_AP_V and PO_DISTRIBUTIONS_AP_V

1779: --End Bug#13505998
1780:
1781: -- perf bug 5058993
1782: -- go to base tables PO_LINES_ALL, PO_LINE_LOCATIONS and PO_DISTRIBUTIONS
1783: -- instead of PO_LINE_LOCATIONS_AP_V and PO_DISTRIBUTIONS_AP_V
1784:
1785:
1786: INSERT INTO AP_INVOICE_LINES (
1787: INVOICE_ID,

Line 2162: po_distributions pd,

2158: G_Pay_Awt_Group_Id --Bug 9689194
2159: -- bug 5061826 -- new FROM clause that goes to base tables
2160: FROM PO_LINES_ALL PL,
2161: PO_LINE_LOCATIONS_ALL PLL,
2162: po_distributions pd,
2163: mtl_system_items msi
2164: WHERE pll.line_location_id = x_po_line_location_id
2165: and pd.line_location_id = pll.line_location_id
2166: AND PLL.PO_LINE_ID = PL.PO_LINE_ID

Line 2173: PO_DISTRIBUTIONS_AP_V PD,

2169: and msi.organization_id(+) = g_inventory_organization_id
2170: and rownum = 1;
2171: /* -- commented out older from clause below
2172: FROM PO_LINE_LOCATIONS_AP_V PLL,
2173: PO_DISTRIBUTIONS_AP_V PD,
2174: MTL_SYSTEM_ITEMS MSI
2175: WHERE PLL.LINE_LOCATION_ID = X_PO_LINE_LOCATION_ID
2176: AND PD.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID
2177: AND PD.PO_DISTRIBUTION_ID = NVL(X_PO_DISTRIBUTION_ID,PD.PO_DISTRIBUTION_ID)

Line 2903: FROM po_distributions pd,

2899: 'N', --accrual_posted_flag
2900: 'N', --cash_posted_flag
2901: 'N', --rcv_charge_addition_flag
2902: x_dist_tab(i).pay_awt_group_id --pay_awt_group_id --Bug 9689194
2903: FROM po_distributions pd,
2904: ap_invoice_lines ail,
2905: gl_code_combinations gcc
2906: WHERE ail.invoice_id = x_invoice_id
2907: AND ail.line_number = x_invoice_line_number

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

3076: X_Uom_Lookup_Code IN VARCHAR2,
3077: X_Retained_Amount IN NUMBER DEFAULT NULL,
3078: X_Calling_Sequence IN VARCHAR2) IS
3079:
3080: l_po_distribution_id PO_DISTRIBUTIONS.PO_DISTRIBUTION_ID%TYPE := NULL;
3081: l_item_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE;
3082: l_amount_to_recoup AP_INVOICE_LINES_ALL.AMOUNT%TYPE;
3083: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;
3084: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;

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

3483:
3484: current_calling_sequence := 'Update_Corr_Po_Shipments_Dists<-'||x_calling_sequence;
3485:
3486: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3487: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_PO_AMT_MATCH_PKG.Update_Corr_Po_Distributions(+)');
3488: END IF;
3489:
3490: l_debug_info := 'Create l_po_ap_dist_rec object';
3491: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

3532: END IF;
3533:
3534: END LOOP;
3535:
3536: l_debug_info := 'Call the PO_AP_INVOICE_MATCH_GRP to update the Po Distributions and Po Line Locations';
3537: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3538: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3539: END IF;
3540:

Line 4328: po_distributions pd

4324: NULL) --pay_awt_group_id Bug 9689194
4325:
4326: FROM ap_invoice_lines ail,
4327: ap_invoice_distributions aid,
4328: po_distributions pd
4329: WHERE ail.invoice_id = x_invoice_id
4330: AND ail.line_number = x_invoice_line_number
4331: AND aid.invoice_id = ail.corrected_inv_id
4332: AND aid.invoice_line_number = ail.corrected_line_number