APPS.PO_PDOI_HEADER_PROCESS_PVT dependencies on PO_LOCATIONS_VAL_V

Line 1733: FROM po_locations_val_v

1729: INSERT INTO po_session_gt(key, num1, num2)
1730: SELECT p_key,
1731: p_index_tbl(i),
1732: location_id
1733: FROM po_locations_val_v
1734: WHERE x_location_id_tbl(i) IS NULL
1735: AND p_location_tbl(i) IS NOT NULL
1736: AND location_code = p_location_tbl(i)
1737: AND nvl(ship_to_site_flag, 'N') = 'Y';

Line 1744: FROM po_locations_val_v

1740: INSERT INTO po_session_gt(key, num1, num2)
1741: SELECT p_key,
1742: p_index_tbl(i),
1743: location_id
1744: FROM po_locations_val_v
1745: WHERE x_location_id_tbl(i) IS NULL
1746: AND p_location_tbl(i) IS NOT NULL
1747: AND location_code = p_location_tbl(i)
1748: AND nvl(bill_to_site_flag, 'N') = 'Y';