APPS.ISC_EDW_BOOKINGS_F_C dependencies on MTL_RESERVATIONS

Line 357: mtl_reservations mtl

353: SELECT l_seq_id,
354: mtl.reservation_id,
355: mtl.demand_source_line_id
356: FROM isc_tmp_pk isc,
357: mtl_reservations mtl
358: WHERE isc.PK1 = mtl.demand_source_line_id
359: AND isc.seq_ID = p_parent_seq_id
360: AND mtl.reservation_quantity IS NOT NULL
361: AND mtl.reservation_quantity <> 0

Line 366: FROM mtl_reservations mtl

362: UNION
363: SELECT l_seq_id,
364: mtl.reservation_id,
365: mtl.demand_source_line_id
366: FROM mtl_reservations mtl
367: WHERE mtl.last_update_date BETWEEN g_push_from_date AND g_push_to_date
368: AND mtl.reservation_quantity IS NOT NULL
369: AND mtl.reservation_quantity <> 0;
370:

Line 937: FROM MTL_RESERVATIONS res

933: FROM ISC_EDW_BOOK_DEL@'||l_edw_apps_to_wh||' del
934: WHERE del.inst_name = '''||l_edw_local_instance|| '''
935: AND substr(del.bookings_pk,1,3) = ''RES''
936: AND NOT EXISTS (SELECT demand_source_line_id
937: FROM MTL_RESERVATIONS res
938: WHERE res.demand_source_line_id = del.line_id
939: and del.bookings_pk= ''RES-''||res.reservation_id||''-'||l_edw_local_instance||''')';
940:
941: EXECUTE IMMEDIATE l_stmt;