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 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