APPS.OKS_KTO_INSREL_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 105

 select ose.order_header_id
 ,ose.order_line_id
 ,osh.instance_id
 ,osh.dnz_chr_id
 from oks_subscr_elements ose,
 oks_subscr_header_b osh,
 okc_k_headers_b hdr
 where ose.osh_id=osh.id
 and osh.dnz_chr_id=hdr.id
 and hdr.id= p_contract_id
 and ose.order_header_id  is not null;

Line: 119

select oh.header_id
,ol.line_id
,cii.instance_id
,cii.inventory_item_id
,cii.last_oe_order_line_id
from
csi_item_instances cii,
oe_order_lines_all ol,
oe_order_headers_all oh
where oh.header_id=ol.header_id
and oh.header_id=p_header_id
and cii.last_oe_order_line_id = ol.line_id
and ol.flow_status_code='CLOSED'
and ol.shipped_quantity=ol.fulfilled_quantity
order by oh.header_id;