APPS.PO_DOCUMENT_ACTION_PVT dependencies on PO_LINE_LOCATIONS

Line 2035: FROM po_line_locations poll, po_lines pol;

2031: IS
2032: SELECT pol.item_id, poll.ship_to_organization_id, poll.po_header_id, poll.po_line_id,
2033: poll.line_location_id, poll.po_release_id, poll.quantity_cancelled,
2034: pol.unit_meas_lookup_code, poll.secondary_unit_of_measure
2035: FROM po_line_locations poll, po_lines pol;
2036:
2037: TYPE rc IS REF CURSOR;
2038:
2039: l_cursor rc;

Line 2053: l_ship_table_list := 'po_line_locations poll, po_lines pol ';

2049: || 'poll.line_location_id, poll.po_release_id, poll.quantity_cancelled, '
2050: || 'pol.unit_meas_lookup_code, poll.secondary_unit_of_measure ';
2051:
2052: -- assign table list
2053: l_ship_table_list := 'po_line_locations poll, po_lines pol ';
2054:
2055: -- build where clause
2056: l_ship_where_clause := 'poll.' || p_join_column || ' = ' || p_entity_id;
2057: l_ship_where_clause := l_ship_where_clause || ' AND poll.po_line_id = pol.po_line_id ';

Line 2091: UPDATE po_line_locations

2087: );
2088:
2089: IF (l_converted_qty <> -99999)
2090: THEN
2091: UPDATE po_line_locations
2092: SET secondary_quantity_cancelled = l_converted_qty
2093: WHERE line_location_id = l_ship_rec.line_location_id;
2094: END IF;
2095: END LOOP;