DBA Data[Home] [Help]

APPS.AP_IMPORT_UTILITIES_PKG dependencies on PO_LINE_LOCATIONS

Line 550: l_matching_basis PO_LINE_LOCATIONS_ALL.MATCHING_BASIS%TYPE;

546: P_calling_sequence IN VARCHAR2) RETURN BOOLEAN IS
547:
548: current_calling_sequence VARCHAR2(2000);
549: debug_info VARCHAR2(500);
550: l_matching_basis PO_LINE_LOCATIONS_ALL.MATCHING_BASIS%TYPE;
551:
552: BEGIN
553: -- Update the calling sequence
554:

Line 601: po_line_locations pll

597: p_amount_ordered,
598: p_amt_already_billed,
599: l_matching_basis
600: FROM po_distributions_ap_v pod,
601: po_line_locations pll
602: WHERE pod.line_location_id = p_po_shipment_id
603: AND pll.line_location_id = pod.line_location_id
604: GROUP BY pod.distribution_type,pll.matching_basis ;
605:

Line 1655: FROM po_line_locations pll,

1651: INTO p_outstanding,
1652: p_ordered,
1653: p_already_billed,
1654: p_po_line_matching_basis
1655: FROM po_line_locations pll,
1656: po_lines pl
1657: WHERE pll.po_line_id = p_po_line_id
1658: AND pl.po_line_id = pll.po_line_id
1659: -- bug fix 6959362 starts