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 989: FROM po_line_locations pll, po_lines pl

985: IF (x_po_line_location_id IS NOT NULL) THEN
986:
987: SELECT pll.shipment_type, pll.po_line_id, pl.recoupment_rate
988: INTO g_shipment_type, g_po_line_id, g_recoupment_rate
989: FROM po_line_locations pll, po_lines pl
990: WHERE pll.line_location_id = x_po_line_location_id
991: AND pll.po_line_id = pl.po_line_id;
992:
993: END IF;

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

1826: END IF;
1827: --End Bug#13505998
1828:
1829: -- bug 5061826
1830: -- go to base tables PO_LINES_ALL, PO_LINE_LOCATIONS and PO_DISTRIBUTIONS
1831: -- instead of PO_LINE_LOCATIONS_AP_V and PO_DISTRIBUTIONS_AP_V
1832:
1833: INSERT INTO AP_INVOICE_LINES (
1834: INVOICE_ID,

Line 2205: FROM PO_LINES_ALL PL,

2201: DECODE(X_Amount,l_full_mtch_amt,G_ASSESSABLE_VALUE, NULL),
2202: G_dflt_tax_class_code,
2203: G_PAY_AWT_GROUP_ID --pay_awt_group_id bug8222382
2204: -- bug 5061826 -- new FROM clause that goes to base tables
2205: FROM PO_LINES_ALL PL,
2206: PO_LINE_LOCATIONS_ALL PLL,
2207: po_distributions pd,
2208: mtl_system_items msi
2209: WHERE pll.line_location_id = x_po_line_location_id

Line 5225: l_po_line_id po_lines.po_line_id%TYPE;

5221: l_amount ap_invoice_lines.amount%TYPE;
5222: l_base_amount ap_invoice_lines.base_amount%TYPE;
5223: l_quantity ap_invoice_lines.quantity_invoiced%TYPE;
5224: l_po_line_location_id po_line_locations.line_location_id%TYPE;
5225: l_po_line_id po_lines.po_line_id%TYPE;
5226: l_po_release_id po_releases.po_release_id%TYPE;
5227: l_rcv_transaction_id rcv_transactions.transaction_id%TYPE;
5228: l_receipt_uom_lookup_code rcv_shipment_lines.unit_of_measure%TYPE;
5229: l_po_uom_lookup_code po_lines.unit_meas_lookup_code%TYPE;

Line 5229: l_po_uom_lookup_code po_lines.unit_meas_lookup_code%TYPE;

5225: l_po_line_id po_lines.po_line_id%TYPE;
5226: l_po_release_id po_releases.po_release_id%TYPE;
5227: l_rcv_transaction_id rcv_transactions.transaction_id%TYPE;
5228: l_receipt_uom_lookup_code rcv_shipment_lines.unit_of_measure%TYPE;
5229: l_po_uom_lookup_code po_lines.unit_meas_lookup_code%TYPE;
5230: l_po_unit_price po_lines.unit_price%TYPE;
5231: l_available_shipment_amount po_line_locations.amount%TYPE;
5232: l_item_id po_lines.item_id%TYPE;
5233: l_unit_meas_lookup_code po_lines.unit_meas_lookup_code%TYPE;

Line 5230: l_po_unit_price po_lines.unit_price%TYPE;

5226: l_po_release_id po_releases.po_release_id%TYPE;
5227: l_rcv_transaction_id rcv_transactions.transaction_id%TYPE;
5228: l_receipt_uom_lookup_code rcv_shipment_lines.unit_of_measure%TYPE;
5229: l_po_uom_lookup_code po_lines.unit_meas_lookup_code%TYPE;
5230: l_po_unit_price po_lines.unit_price%TYPE;
5231: l_available_shipment_amount po_line_locations.amount%TYPE;
5232: l_item_id po_lines.item_id%TYPE;
5233: l_unit_meas_lookup_code po_lines.unit_meas_lookup_code%TYPE;
5234: l_price_override po_line_locations.price_override%TYPE;

Line 5232: l_item_id po_lines.item_id%TYPE;

5228: l_receipt_uom_lookup_code rcv_shipment_lines.unit_of_measure%TYPE;
5229: l_po_uom_lookup_code po_lines.unit_meas_lookup_code%TYPE;
5230: l_po_unit_price po_lines.unit_price%TYPE;
5231: l_available_shipment_amount po_line_locations.amount%TYPE;
5232: l_item_id po_lines.item_id%TYPE;
5233: l_unit_meas_lookup_code po_lines.unit_meas_lookup_code%TYPE;
5234: l_price_override po_line_locations.price_override%TYPE;
5235: l_item_description po_lines.item_description%TYPE;
5236: l_asset_category_id mtl_system_items.asset_category_id%TYPE;

Line 5233: l_unit_meas_lookup_code po_lines.unit_meas_lookup_code%TYPE;

5229: l_po_uom_lookup_code po_lines.unit_meas_lookup_code%TYPE;
5230: l_po_unit_price po_lines.unit_price%TYPE;
5231: l_available_shipment_amount po_line_locations.amount%TYPE;
5232: l_item_id po_lines.item_id%TYPE;
5233: l_unit_meas_lookup_code po_lines.unit_meas_lookup_code%TYPE;
5234: l_price_override po_line_locations.price_override%TYPE;
5235: l_item_description po_lines.item_description%TYPE;
5236: l_asset_category_id mtl_system_items.asset_category_id%TYPE;
5237: -- Removed for bug 4277744

Line 5235: l_item_description po_lines.item_description%TYPE;

5231: l_available_shipment_amount po_line_locations.amount%TYPE;
5232: l_item_id po_lines.item_id%TYPE;
5233: l_unit_meas_lookup_code po_lines.unit_meas_lookup_code%TYPE;
5234: l_price_override po_line_locations.price_override%TYPE;
5235: l_item_description po_lines.item_description%TYPE;
5236: l_asset_category_id mtl_system_items.asset_category_id%TYPE;
5237: -- Removed for bug 4277744
5238: -- l_ussgl_transaction_code po_line_locations.ussgl_transaction_code%TYPE;
5239: l_type_1099 po_lines.type_1099%TYPE;

Line 5239: l_type_1099 po_lines.type_1099%TYPE;

5235: l_item_description po_lines.item_description%TYPE;
5236: l_asset_category_id mtl_system_items.asset_category_id%TYPE;
5237: -- Removed for bug 4277744
5238: -- l_ussgl_transaction_code po_line_locations.ussgl_transaction_code%TYPE;
5239: l_type_1099 po_lines.type_1099%TYPE;
5240: l_attribute_category po_line_locations.attribute_category%TYPE;
5241: l_attribute1 po_line_locations.attribute1%TYPE;
5242: l_attribute2 po_line_locations.attribute2%TYPE;
5243: l_attribute3 po_line_locations.attribute3%TYPE;

Line 5268: l_rect_unit_price po_lines.unit_price%TYPE;

5264: l_transaction_qty NUMBER;
5265: l_billed_qty NUMBER;
5266: l_accepted_qty NUMBER;
5267: l_rejected_qty NUMBER;
5268: l_rect_unit_price po_lines.unit_price%TYPE;
5269: l_max_line_amount ap_invoice_lines.amount%TYPE := 0;
5270: l_rounded_index po_line_locations.line_location_id%TYPE;
5271: l_sum_prorated_amount ap_invoice_lines.amount%TYPE := 0;
5272: l_available_amount po_line_locations.amount%TYPE;