DBA Data[Home] [Help]

APPS.PO_SUPPLY dependencies on PO_LINES_ALL

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

981: sql_dist := 'SELECT pd.po_distribution_id, '
982: || 'pd.quantity_ordered - nvl(pd.quantity_delivered, 0) - nvl(pd.quantity_cancelled, 0), '
983: || 'pl.unit_meas_lookup_code, '
984: || 'pd.line_location_id '
985: || 'FROM po_distributions_all pd, po_lines_all pl ';
986:
987:
988: IF (p_entity_type = 'PO') THEN
989:

Line 1320: po_lines_all pl

1316: pd.destination_subinventory,
1317: 'Y'
1318: FROM po_distributions_all pd,
1319: po_line_locations_all pll,
1320: po_lines_all pl
1321: WHERE pd.po_distribution_id = l_distid
1322: AND pll.line_location_id = pd.line_location_id
1323: AND pl.item_id IS NOT NULL --
1324: AND pl.po_line_id = pd.po_line_id