APPS.PO_SUPPLY dependencies on PO_LINES

Line 892: l_uom po_lines.unit_meas_lookup_code%TYPE;

888: l_out_poqty po_distributions.quantity_ordered%TYPE := 0;
889: l_line_loc_id po_distributions.line_location_id%TYPE;
890:
891: l_supply_qty_in_pouom po_distributions.quantity_ordered%TYPE := 0;
892: l_uom po_lines.unit_meas_lookup_code%TYPE;
893: l_supply_qty mtl_supply.quantity%TYPE := 0;
894: l_supply_uom mtl_supply.unit_of_measure%TYPE;
895: l_supply_itemid mtl_supply.item_id%TYPE;
896:

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