APPS.PO_DOCUMENT_ACTION_PVT dependencies on PO_LINE_LOCATIONS

Line 2026: FROM po_line_locations poll, po_lines pol;

2022: IS
2023: SELECT pol.item_id, poll.ship_to_organization_id, poll.po_header_id, poll.po_line_id,
2024: poll.line_location_id, poll.po_release_id, poll.quantity_cancelled,
2025: pol.unit_meas_lookup_code, poll.secondary_unit_of_measure
2026: FROM po_line_locations poll, po_lines pol;
2027:
2028: TYPE rc IS REF CURSOR;
2029:
2030: l_cursor rc;

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

2040: || 'poll.line_location_id, poll.po_release_id, poll.quantity_cancelled, '
2041: || 'pol.unit_meas_lookup_code, poll.secondary_unit_of_measure ';
2042:
2043: -- assign table list
2044: l_ship_table_list := 'po_line_locations poll, po_lines pol ';
2045:
2046: -- build where clause
2047: l_ship_where_clause := 'poll.' || p_join_column || ' = ' || p_entity_id;
2048: l_ship_where_clause := l_ship_where_clause || ' AND poll.po_line_id = pol.po_line_id ';

Line 2082: UPDATE po_line_locations

2078: );
2079:
2080: IF (l_converted_qty <> -99999)
2081: THEN
2082: UPDATE po_line_locations
2083: SET secondary_quantity_cancelled = l_converted_qty
2084: WHERE line_location_id = l_ship_rec.line_location_id;
2085: END IF;
2086: END LOOP;