asked on
Cursor C5 (v_key integer) is
select orditm_id_rcvd,bltitm.pspec_id,bltitm.quantity
from dss.built_items bltitm,
dss.orders ord,
dss.ordered_items orditm,
dss.received_shipments recshp
where ord.id = orditm.order_id
and orditm.id = bltitm.orditm_id_rcvd
and recshp.id = bltitm.recshp_id
and recshp.id = in_recshp_id
and v_key=1
union all
select orditm_id_rcvd,rcvitm.pspec_id,rcvitm.quantity
from dss.received_items rcvitm,
dss.received_shipments recshp,
dss.orders ord,
dss.ordered_items orditm
where ord.id = orditm.order_id
and orditm.id = rcvitm.orditm_id_rcvd
and recshp.id = rcvitm.recshp_id
and recshp.id = in_recshp_id
and v_key=2;