DBA Data[Home] [Help]

APPS.AP_QUICK_CREDIT_PKG dependencies on PO_LINE_TYPES

Line 307: l_matching_basis PO_LINE_TYPES.matching_basis%TYPE; /* ABM */

303:
304: l_Corr_Dist_Tab_Po AP_MATCHING_PKG.corr_dist_tab_type;
305: l_Corr_Dist_Tab_Rcv AP_MATCHING_PKG.corr_dist_tab_type;
306:
307: l_matching_basis PO_LINE_TYPES.matching_basis%TYPE; /* ABM */
308: l_copy_gdf VARCHAR2(1); --Bug#13464635
309:
310: CURSOR corrected_dist_po(c_invoice_id NUMBER,
311: c_line_number NUMBER) IS

Line 425: po_line_types plt

421: SELECT plt.matching_basis
422: INTO l_matching_basis
423: FROM po_line_locations_all pll,
424: po_lines_all pl,
425: po_line_types plt
426: WHERE pll.line_location_id = P_Invoice_Lines_Tab(i).po_line_location_id
427: AND pll.po_line_id = pl.po_line_id
428: AND pl.line_type_id = plt.line_type_id;
429:

Line 492: po_line_types plt

488: SELECT plt.matching_basis
489: INTO l_matching_basis
490: FROM po_line_locations_all pll,
491: po_lines_all pl,
492: po_line_types plt
493: WHERE pll.line_location_id = P_Invoice_Lines_Tab(i).po_line_location_id
494: AND pll.po_line_id = pl.po_line_id
495: AND pl.line_type_id = plt.line_type_id;
496: