APPS.PO_POXQUAPR_XMLP_PKG SQL Statements

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

Line: 73

        select structure_id
        into l_p_struct_num
        from mtl_default_sets_view
        where functional_area_id = 2 ;

Line: 261

select sum(rct.primary_quantity) into ret_qty
from rcv_transactions     rct
where rct.transaction_type = 'RETURN TO VENDOR'
and   rct.po_line_location_id = parent_line_location_id
UNION
select sum(rct.primary_quantity)
from rcv_transactions     rct
where rct.transaction_type = 'RETURN TO VENDOR'
and   rct.po_line_location_id = parent_line_location_id
and Item_id is NULL
group by rct.po_line_location_id;

Line: 273

select sum(rct.primary_quantity) into cor_qty
from rcv_transactions     rct, rcv_transactions rct1
where rct.transaction_type = 'CORRECT'
and   rct.po_line_location_id = parent_line_location_id
and   rct.parent_transaction_id = rct1.transaction_id
and   rct1.transaction_type = 'RETURN TO VENDOR'
UNION
select sum(rct.primary_quantity)
from rcv_transactions     rct, rcv_transactions rct1
where rct.transaction_type = 'CORRECT'
and   rct.po_line_location_id = parent_line_location_id
and Item_id is NULL
and   rct.parent_transaction_id = rct1.transaction_id
and   rct1.transaction_type = 'RETURN TO VENDOR'
group by rct.po_line_location_id;

Line: 309

select sum(rct.primary_quantity) into ins_qty
from rcv_transactions     rct
where rct.transaction_type = 'RETURN TO VENDOR'
and nvl(rct.inspection_status_code,'NOT INSPECTED') = 'NOT INSPECTED'
and   rct.po_line_location_id = parent_line_location_id
UNION
select sum(rct.primary_quantity)
from rcv_transactions     rct
where rct.transaction_type = 'RETURN TO VENDOR'
and nvl(rct.inspection_status_code,'NOT INSPECTED') = 'NOT INSPECTED'
and   rct.po_line_location_id = parent_line_location_id
and Item_id is NULL
group by rct.po_line_location_id;

Line: 323

select sum(rct.primary_quantity) into cor_qty
from rcv_transactions     rct, rcv_transactions rct1
where rct.transaction_type = 'CORRECT'
and   rct.po_line_location_id = parent_line_location_id
and   rct.parent_transaction_id = rct1.transaction_id
and   rct1.transaction_type = 'RETURN TO VENDOR'
and nvl(rct1.inspection_status_code,'NOT INSPECTED') = 'NOT INSPECTED'
UNION
select sum(rct.primary_quantity)
from rcv_transactions     rct, rcv_transactions rct1
where rct.transaction_type = 'CORRECT'
and   rct.po_line_location_id = parent_line_location_id
and Item_id is NULL
and   rct.parent_transaction_id = rct1.transaction_id
and   rct1.transaction_type = 'RETURN TO VENDOR'
and nvl(rct1.inspection_status_code,'NOT INSPECTED') = 'NOT INSPECTED'
group by rct.po_line_location_id;

Line: 361

select sum(rct.primary_quantity) into rec_qty
from rcv_transactions     rct
where rct.transaction_type = 'RECEIVE'
and   rct.po_line_location_id = parent_line_location_id
UNION
select sum(rct.primary_quantity)
from rcv_transactions     rct
where rct.transaction_type = 'RECEIVE'
and   rct.po_line_location_id = parent_line_location_id
and Item_id is NULL
group by rct.po_line_location_id;

Line: 373

select sum(rct.primary_quantity) into cor_qty
from rcv_transactions     rct, rcv_transactions rct1
where rct.transaction_type = 'CORRECT'
and   rct.po_line_location_id = parent_line_location_id
and   rct.parent_transaction_id = rct1.transaction_id
and   rct1.transaction_type = 'RECEIVE'
UNION
select sum(rct.primary_quantity)
from rcv_transactions     rct, rcv_transactions rct1
where rct.transaction_type = 'CORRECT'
and   rct.po_line_location_id = parent_line_location_id
and Item_id is NULL
and   rct.parent_transaction_id = rct1.transaction_id
and   rct1.transaction_type = 'RECEIVE'
group by rct.po_line_location_id;

Line: 406

 select        conversion_rate    into con_rate
from
	mtl_uom_conversions_view
where
	inventory_item_id = item_id
and           organization_id = c_organization_id
and           primary_uom_code = Item_Unit
and           uom_code = PO_unit_of_measure
 and mtl_uom_conversions_view.uom_code=PO_unit_of_measure;