DBA Data[Home] [Help]

APPS.RCV_QUANTITIES_S dependencies on PO_LINE_LOCATIONS_ALL

Line 726: FROM po_line_locations_all pll, --

722: x_qty_rcv_tolerance,
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:

Line 922: FROM po_line_locations_all pll, --

918: x_amount_received,
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:

Line 2597: po_line_locations_all poll, --

2593: x_qty_ordered,
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;

Line 2751: po_line_locations_all poll, --

2747: x_amt_ordered,
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;

Line 3453: po_line_locations_all poll, --

3449: l_qty_ordered,
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;