APPS.PO_PDOI_HEADER_PROCESS_PVT dependencies on PO_LOCATIONS_VAL_V

Line 2242: FROM po_locations_val_v

2238: INSERT INTO po_session_gt(key, num1, num2)
2239: SELECT p_key,
2240: p_index_tbl(i),
2241: location_id
2242: FROM po_locations_val_v
2243: WHERE x_location_id_tbl(i) IS NULL
2244: AND p_location_tbl(i) IS NOT NULL
2245: AND location_code = p_location_tbl(i)
2246: AND nvl(ship_to_site_flag, 'N') = 'Y';

Line 2253: FROM po_locations_val_v

2249: INSERT INTO po_session_gt(key, num1, num2)
2250: SELECT p_key,
2251: p_index_tbl(i),
2252: location_id
2253: FROM po_locations_val_v
2254: WHERE x_location_id_tbl(i) IS NULL
2255: AND p_location_tbl(i) IS NOT NULL
2256: AND location_code = p_location_tbl(i)
2257: AND nvl(bill_to_site_flag, 'N') = 'Y';