APPS.RCV_QUANTITIES_S dependencies on PO_LINE_LOCATIONS

Line 751: FROM po_line_locations_all pll, --

747: x_qty_rcv_tolerance,
748: x_qty_rcv_exception_code,
749: x_item_id,
750: x_po_uom
751: FROM po_line_locations_all pll, --
752: po_lines_all pl --
753: WHERE pll.line_location_id = p_line_location_id
754: AND pll.po_line_id = pl.po_line_id;
755:

Line 1055: FROM po_line_locations_all pll, --

1051: x_amount_received,
1052: x_amount_cancelled,
1053: x_qty_rcv_tolerance,
1054: x_qty_rcv_exception_code
1055: FROM po_line_locations_all pll, --
1056: po_lines_all pl --
1057: WHERE pll.line_location_id = p_line_location_id
1058: AND pll.po_line_id = pl.po_line_id;
1059:

Line 3173: po_line_locations_all poll, --

3169: x_qty_received,
3170: x_qty_cancelled,
3171: l_po_line_location_id --
3172: from po_distributions_all pod, --
3173: po_line_locations_all poll, --
3174: po_lines_all pol --
3175: where pod.line_location_id = poll.line_location_id
3176: and pod.po_distribution_id = p_po_distribution_id
3177: and pod.po_line_id = pol.po_line_id;

Line 3461: po_line_locations_all poll, --

3457: x_amt_received,
3458: x_amt_cancelled,
3459: l_po_line_location_id --
3460: from po_distributions_all pod, --
3461: po_line_locations_all poll, --
3462: po_lines_all pol --
3463: where pod.line_location_id = poll.line_location_id
3464: and pod.po_distribution_id = p_po_distribution_id
3465: and pod.po_line_id = pol.po_line_id;

Line 3945: FROM PO_LINE_LOCATIONS PLL,

3941: SELECT PL.ITEM_ID,
3942: PL.UNIT_MEAS_LOOKUP_CODE
3943: INTO x_item_id,
3944: x_po_uom
3945: FROM PO_LINE_LOCATIONS PLL,
3946: PO_LINES PL
3947: WHERE PLL.LINE_LOCATION_ID = p_line_location_id AND
3948: PLL.PO_LINE_ID = PL.PO_LINE_ID;
3949:

Line 4305: po_line_locations_all poll, --

4301: l_qty_ordered,
4302: l_qty_received,
4303: l_qty_cancelled
4304: from po_distributions_all pod, --
4305: po_line_locations_all poll, --
4306: po_lines_all pol --
4307: where pod.line_location_id = poll.line_location_id
4308: and pod.po_distribution_id = p_distribution_id
4309: and pod.po_line_id = pol.po_line_id;