DBA Data[Home] [Help]

APPS.AP_RCT_AMT_MATCH_PKG dependencies on PO_LINES

Line 205: G_Po_Line_Id po_lines_all.po_line_id%TYPE;

201: G_Trx_Business_Category ap_invoices.trx_business_category%TYPE;
202: --Contract Payments
203: G_Vendor_Id ap_invoices.vendor_id%TYPE;
204: G_Vendor_Site_Id ap_invoices.vendor_site_id%TYPE;
205: G_Po_Line_Id po_lines_all.po_line_id%TYPE;
206: G_Recoupment_Rate po_lines_all.recoupment_rate%TYPE;
207:
208: --Bugfix:5565310
209: G_intended_use zx_lines_det_factors.line_intended_use%type;

Line 206: G_Recoupment_Rate po_lines_all.recoupment_rate%TYPE;

202: --Contract Payments
203: G_Vendor_Id ap_invoices.vendor_id%TYPE;
204: G_Vendor_Site_Id ap_invoices.vendor_site_id%TYPE;
205: G_Po_Line_Id po_lines_all.po_line_id%TYPE;
206: G_Recoupment_Rate po_lines_all.recoupment_rate%TYPE;
207:
208: --Bugfix:5565310
209: G_intended_use zx_lines_det_factors.line_intended_use%type;
210: G_product_type zx_lines_det_factors.product_type%type;

Line 914: FROM po_line_locations pll, po_lines pl

910: IF (x_po_line_location_id is not null) THEN
911:
912: SELECT pll.match_option,pll.shipment_type, pll.po_line_id, pl.recoupment_rate
913: INTO g_match_option,g_shipment_type, g_po_line_id, g_recoupment_rate
914: FROM po_line_locations pll, po_lines pl
915: WHERE pll.line_location_id = x_po_line_location_id
916: AND pll.po_line_id = pl.po_line_id;
917:
918: END IF;