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:
309: CURSOR corrected_dist_po(c_invoice_id NUMBER,
310: c_line_number NUMBER) IS
311: SELECT aid.po_distribution_id po_distribution_id,

Line 411: po_line_types plt

407: SELECT plt.matching_basis
408: INTO l_matching_basis
409: FROM po_line_locations_all pll,
410: po_lines_all pl,
411: po_line_types plt
412: WHERE pll.line_location_id = P_Invoice_Lines_Tab(i).po_line_location_id
413: AND pll.po_line_id = pl.po_line_id
414: AND pl.line_type_id = plt.line_type_id;
415:

Line 478: po_line_types plt

474: SELECT plt.matching_basis
475: INTO l_matching_basis
476: FROM po_line_locations_all pll,
477: po_lines_all pl,
478: po_line_types plt
479: WHERE pll.line_location_id = P_Invoice_Lines_Tab(i).po_line_location_id
480: AND pll.po_line_id = pl.po_line_id
481: AND pl.line_type_id = plt.line_type_id;
482: