DBA Data[Home] [Help]

APPS.PO_SUPPLY dependencies on PO_LINES_ALL

Line 961: || 'FROM po_distributions_all pd, po_lines_all pl ';

957: sql_dist := 'SELECT pd.po_distribution_id, '
958: || 'pd.quantity_ordered - nvl(pd.quantity_delivered, 0) - nvl(pd.quantity_cancelled, 0), '
959: || 'pl.unit_meas_lookup_code, '
960: || 'pd.line_location_id '
961: || 'FROM po_distributions_all pd, po_lines_all pl ';
962:
963:
964: IF (p_entity_type = 'PO') THEN
965:

Line 1206: po_lines_all pl

1202: pd.destination_subinventory,
1203: 'Y'
1204: FROM po_distributions_all pd,
1205: po_line_locations_all pll,
1206: po_lines_all pl
1207: WHERE pd.po_distribution_id = l_distid
1208: AND pll.line_location_id = pd.line_location_id
1209: AND pl.item_id IS NOT NULL --
1210: AND pl.po_line_id = pd.po_line_id