DBA Data[Home] [Help]

APPS.RCV_QUANTITIES_S dependencies on PO_LINES_ALL

Line 727: po_lines_all pl --

723: x_qty_rcv_exception_code,
724: x_item_id,
725: x_po_uom
726: FROM po_line_locations_all pll, --
727: po_lines_all pl --
728: WHERE pll.line_location_id = p_line_location_id
729: AND pll.po_line_id = pl.po_line_id;
730:
731: x_progress := '010';

Line 923: po_lines_all pl --

919: x_amount_cancelled,
920: x_qty_rcv_tolerance,
921: x_qty_rcv_exception_code
922: FROM po_line_locations_all pll, --
923: po_lines_all pl --
924: WHERE pll.line_location_id = p_line_location_id
925: AND pll.po_line_id = pl.po_line_id;
926:
927: x_progress := '010';

Line 2598: po_lines_all pol --

2594: x_qty_received,
2595: x_qty_cancelled
2596: from po_distributions_all pod, --
2597: po_line_locations_all poll, --
2598: po_lines_all pol --
2599: where pod.line_location_id = poll.line_location_id
2600: and pod.po_distribution_id = p_po_distribution_id
2601: and pod.po_line_id = pol.po_line_id;
2602:

Line 2752: po_lines_all pol --

2748: x_amt_received,
2749: x_amt_cancelled
2750: from po_distributions_all pod, --
2751: po_line_locations_all poll, --
2752: po_lines_all pol --
2753: where pod.line_location_id = poll.line_location_id
2754: and pod.po_distribution_id = p_po_distribution_id
2755: and pod.po_line_id = pol.po_line_id;
2756:

Line 3454: po_lines_all pol --

3450: l_qty_received,
3451: l_qty_cancelled
3452: from po_distributions_all pod, --
3453: po_line_locations_all poll, --
3454: po_lines_all pol --
3455: where pod.line_location_id = poll.line_location_id
3456: and pod.po_distribution_id = p_distribution_id
3457: and pod.po_line_id = pol.po_line_id;
3458: