APPS.PO_DOCUMENT_ACTION_PVT dependencies on PO_LINES

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