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 PO_LINES

Line 216: G_Po_Line_Id po_lines_all.po_line_id%TYPE;

212: G_Trx_Business_Category ap_invoices.trx_business_category%TYPE;
213: --Contract Payments
214: G_Vendor_Id ap_invoices.vendor_id%TYPE;
215: G_Vendor_Site_Id ap_invoices.vendor_site_id%TYPE;
216: G_Po_Line_Id po_lines_all.po_line_id%TYPE;
217: G_Recoupment_Rate po_lines_all.recoupment_rate%TYPE;
218: G_Release_Amount_Net_Of_Tax ap_invoices_all.release_amount_net_of_tax%TYPE;
219: --Bugfix:5565310
220: G_intended_use zx_lines_det_factors.line_intended_use%type;

Line 217: G_Recoupment_Rate po_lines_all.recoupment_rate%TYPE;

213: --Contract Payments
214: G_Vendor_Id ap_invoices.vendor_id%TYPE;
215: G_Vendor_Site_Id ap_invoices.vendor_site_id%TYPE;
216: G_Po_Line_Id po_lines_all.po_line_id%TYPE;
217: G_Recoupment_Rate po_lines_all.recoupment_rate%TYPE;
218: G_Release_Amount_Net_Of_Tax ap_invoices_all.release_amount_net_of_tax%TYPE;
219: --Bugfix:5565310
220: G_intended_use zx_lines_det_factors.line_intended_use%type;
221: G_product_type zx_lines_det_factors.product_type%type;

Line 908: FROM po_line_locations pll, po_lines pl

904: IF (x_po_line_location_id IS NOT NULL) THEN
905:
906: SELECT pll.shipment_type, pll.po_line_id, pl.recoupment_rate
907: INTO g_shipment_type, g_po_line_id, g_recoupment_rate
908: FROM po_line_locations pll, po_lines pl
909: WHERE pll.line_location_id = x_po_line_location_id
910: AND pll.po_line_id = pl.po_line_id;
911:
912: END IF;

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

1727: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1728: END IF;
1729:
1730: -- bug 5061826
1731: -- go to base tables PO_LINES_ALL, PO_LINE_LOCATIONS and PO_DISTRIBUTIONS
1732: -- instead of PO_LINE_LOCATIONS_AP_V and PO_DISTRIBUTIONS_AP_V
1733:
1734: INSERT INTO AP_INVOICE_LINES (
1735: INVOICE_ID,

Line 2105: FROM PO_LINES_ALL PL,

2101: G_ASSESSABLE_VALUE,
2102: G_dflt_tax_class_code,
2103: G_PAY_AWT_GROUP_ID --pay_awt_group_id bug8222382
2104: -- bug 5061826 -- new FROM clause that goes to base tables
2105: FROM PO_LINES_ALL PL,
2106: PO_LINE_LOCATIONS_ALL PLL,
2107: po_distributions pd,
2108: mtl_system_items msi
2109: WHERE pll.line_location_id = x_po_line_location_id

Line 5100: l_po_line_id po_lines.po_line_id%TYPE;

5096: l_amount ap_invoice_lines.amount%TYPE;
5097: l_base_amount ap_invoice_lines.base_amount%TYPE;
5098: l_quantity ap_invoice_lines.quantity_invoiced%TYPE;
5099: l_po_line_location_id po_line_locations.line_location_id%TYPE;
5100: l_po_line_id po_lines.po_line_id%TYPE;
5101: l_po_release_id po_releases.po_release_id%TYPE;
5102: l_rcv_transaction_id rcv_transactions.transaction_id%TYPE;
5103: l_receipt_uom_lookup_code rcv_shipment_lines.unit_of_measure%TYPE;
5104: l_po_uom_lookup_code po_lines.unit_meas_lookup_code%TYPE;

Line 5104: l_po_uom_lookup_code po_lines.unit_meas_lookup_code%TYPE;

5100: l_po_line_id po_lines.po_line_id%TYPE;
5101: l_po_release_id po_releases.po_release_id%TYPE;
5102: l_rcv_transaction_id rcv_transactions.transaction_id%TYPE;
5103: l_receipt_uom_lookup_code rcv_shipment_lines.unit_of_measure%TYPE;
5104: l_po_uom_lookup_code po_lines.unit_meas_lookup_code%TYPE;
5105: l_po_unit_price po_lines.unit_price%TYPE;
5106: l_available_shipment_amount po_line_locations.amount%TYPE;
5107: l_item_id po_lines.item_id%TYPE;
5108: l_unit_meas_lookup_code po_lines.unit_meas_lookup_code%TYPE;

Line 5105: l_po_unit_price po_lines.unit_price%TYPE;

5101: l_po_release_id po_releases.po_release_id%TYPE;
5102: l_rcv_transaction_id rcv_transactions.transaction_id%TYPE;
5103: l_receipt_uom_lookup_code rcv_shipment_lines.unit_of_measure%TYPE;
5104: l_po_uom_lookup_code po_lines.unit_meas_lookup_code%TYPE;
5105: l_po_unit_price po_lines.unit_price%TYPE;
5106: l_available_shipment_amount po_line_locations.amount%TYPE;
5107: l_item_id po_lines.item_id%TYPE;
5108: l_unit_meas_lookup_code po_lines.unit_meas_lookup_code%TYPE;
5109: l_price_override po_line_locations.price_override%TYPE;

Line 5107: l_item_id po_lines.item_id%TYPE;

5103: l_receipt_uom_lookup_code rcv_shipment_lines.unit_of_measure%TYPE;
5104: l_po_uom_lookup_code po_lines.unit_meas_lookup_code%TYPE;
5105: l_po_unit_price po_lines.unit_price%TYPE;
5106: l_available_shipment_amount po_line_locations.amount%TYPE;
5107: l_item_id po_lines.item_id%TYPE;
5108: l_unit_meas_lookup_code po_lines.unit_meas_lookup_code%TYPE;
5109: l_price_override po_line_locations.price_override%TYPE;
5110: l_item_description po_lines.item_description%TYPE;
5111: l_asset_category_id mtl_system_items.asset_category_id%TYPE;

Line 5108: l_unit_meas_lookup_code po_lines.unit_meas_lookup_code%TYPE;

5104: l_po_uom_lookup_code po_lines.unit_meas_lookup_code%TYPE;
5105: l_po_unit_price po_lines.unit_price%TYPE;
5106: l_available_shipment_amount po_line_locations.amount%TYPE;
5107: l_item_id po_lines.item_id%TYPE;
5108: l_unit_meas_lookup_code po_lines.unit_meas_lookup_code%TYPE;
5109: l_price_override po_line_locations.price_override%TYPE;
5110: l_item_description po_lines.item_description%TYPE;
5111: l_asset_category_id mtl_system_items.asset_category_id%TYPE;
5112: -- Removed for bug 4277744

Line 5110: l_item_description po_lines.item_description%TYPE;

5106: l_available_shipment_amount po_line_locations.amount%TYPE;
5107: l_item_id po_lines.item_id%TYPE;
5108: l_unit_meas_lookup_code po_lines.unit_meas_lookup_code%TYPE;
5109: l_price_override po_line_locations.price_override%TYPE;
5110: l_item_description po_lines.item_description%TYPE;
5111: l_asset_category_id mtl_system_items.asset_category_id%TYPE;
5112: -- Removed for bug 4277744
5113: -- l_ussgl_transaction_code po_line_locations.ussgl_transaction_code%TYPE;
5114: l_type_1099 po_lines.type_1099%TYPE;

Line 5114: l_type_1099 po_lines.type_1099%TYPE;

5110: l_item_description po_lines.item_description%TYPE;
5111: l_asset_category_id mtl_system_items.asset_category_id%TYPE;
5112: -- Removed for bug 4277744
5113: -- l_ussgl_transaction_code po_line_locations.ussgl_transaction_code%TYPE;
5114: l_type_1099 po_lines.type_1099%TYPE;
5115: l_attribute_category po_line_locations.attribute_category%TYPE;
5116: l_attribute1 po_line_locations.attribute1%TYPE;
5117: l_attribute2 po_line_locations.attribute2%TYPE;
5118: l_attribute3 po_line_locations.attribute3%TYPE;

Line 5143: l_rect_unit_price po_lines.unit_price%TYPE;

5139: l_transaction_qty NUMBER;
5140: l_billed_qty NUMBER;
5141: l_accepted_qty NUMBER;
5142: l_rejected_qty NUMBER;
5143: l_rect_unit_price po_lines.unit_price%TYPE;
5144: l_max_line_amount ap_invoice_lines.amount%TYPE := 0;
5145: l_rounded_index po_line_locations.line_location_id%TYPE;
5146: l_sum_prorated_amount ap_invoice_lines.amount%TYPE := 0;
5147: l_available_amount po_line_locations.amount%TYPE;