APPS.RCV_QUANTITIES_S dependencies on PO_LINE_LOCATIONS

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 3061: FROM PO_LINE_LOCATIONS PLL,

3057: SELECT PL.ITEM_ID,
3058: PL.UNIT_MEAS_LOOKUP_CODE
3059: INTO x_item_id,
3060: x_po_uom
3061: FROM PO_LINE_LOCATIONS PLL,
3062: PO_LINES PL
3063: WHERE PLL.LINE_LOCATION_ID = p_line_location_id AND
3064: PLL.PO_LINE_ID = PL.PO_LINE_ID;
3065:

Line 3275: from po_line_locations

3271: l_progress := '020';
3272:
3273: select nvl(quantity_shipped,0)
3274: into l_quantity_shipped
3275: from po_line_locations
3276: where
3277: line_location_id = p_line_location_id;
3278:
3279:

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;