DBA Data[Home] [Help]

APPS.RCV_QUANTITIES_S dependencies on PO_LINES_ALL

Line 752: po_lines_all pl --

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:
756: x_progress := '010';

Line 1056: po_lines_all pl --

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:
1060: x_progress := '010';

Line 3174: po_lines_all pol --

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;
3178:

Line 3462: po_lines_all pol --

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;
3466:

Line 4306: po_lines_all pol --

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;
4310: