APPS.PO_NEGOTIATION_REQ_NOTIF SQL Statements

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

Line: 59

         select to_char(PO_WF_ITEMKEY_S.NEXTVAL) into l_seq from sys.dual;

Line: 119

	  select count(*)
	  into   x_wf_created
	  from   wf_items
	  where  item_type = ItemType
	  and  item_key  = ItemKey;

Line: 149

        select segment1  into x_req_num
        from po_requisition_headers_all
        where requisition_header_id = DocumentId;

Line: 161

          select org_id
          into x_org_id
          from po_system_parameters;

Line: 279

SELECT rql.requisition_line_id,
       rql.line_num,
       rql.auction_line_number,
       rqh.segment1,
       msi.concatenated_segments,
       rql.item_description,
       rql.unit_meas_lookup_code,
       rql.quantity,
       rql.need_by_date,
       rql.cancel_flag,
       rql.closed_code,
       null,
       null
       ,rql.auction_header_id --Bug 4107528
  FROM po_requisition_lines   rql,
       po_requisition_headers_all rqh,    -- 
       mtl_system_items_kfv   msi
 WHERE rql.requisition_header_id = rqh.requisition_header_id
 and   rql.requisition_header_id = v_document_id
 and   rql.auction_display_number = v_negotiation_num
 AND   rql.at_sourcing_flag = 'Y' --
 and  (rql.cancel_flag = 'Y' or rql.closed_code = 'FINALLY CLOSED')
 and  (trunc(rql.cancel_date) = trunc(sysdate) or trunc(rql.closed_date) = trunc(sysdate))
 AND   rql.item_id = msi.inventory_item_id(+)
 AND   nvl(msi.organization_id, rql.destination_organization_id) =
       rql.destination_organization_id
 ORDER BY rql.auction_line_number;

Line: 308

SELECT rql.requisition_line_id,
       rql.line_num,
       rql.auction_line_number,
       rqh.segment1,
       msi.concatenated_segments,
       rql.item_description,
       rql.unit_meas_lookup_code,
       rql.quantity,
       rql.need_by_date,
       rql.cancel_flag,
       rql.closed_code,
       null,
       null
       ,rql.auction_header_id --Bug 4107528
  FROM po_requisition_lines   rql,
       po_requisition_headers_all rqh,   -- 
       mtl_system_items_kfv   msi
 WHERE rql.requisition_header_id = rqh.requisition_header_id
 and   rql.requisition_line_id = v_document_id
   AND rql.item_id = msi.inventory_item_id(+)
   AND nvl(msi.organization_id, rql.destination_organization_id) =
       rql.destination_organization_id;

Line: 549

SELECT rql.requisition_line_id,
       rql.line_num,
       rql.auction_line_number,
       rqh.segment1,
       msi.concatenated_segments,
       rql.item_description,
       rql.unit_meas_lookup_code,
       rql.quantity,
       rql.need_by_date,
       rql.cancel_flag,
       null,
       resc.orig_quantity,
       resc.orig_need_by_date
       ,rql.auction_header_id --Bug 4107528
  FROM po_reschedule_interface resc,
       po_requisition_lines   rql,
       po_requisition_headers_all rqh,       -- 
       mtl_system_items_kfv   msi
 WHERE resc.auction_display_number = v_negotiation_num
 and   resc.process_id = v_process_id
 and   resc.line_id = rql.requisition_line_id
 and   rql.requisition_header_id = rqh.requisition_header_id
   AND rql.item_id = msi.inventory_item_id(+)
   AND nvl(msi.organization_id, rql.destination_organization_id) =
       rql.destination_organization_id;

Line: 577

SELECT rql.requisition_line_id,
       rql.line_num,
       rql.auction_line_number,
       rqh.segment1,
       msi.concatenated_segments,
       rql.item_description,
       rql.unit_meas_lookup_code,
       rql.quantity,
       rql.need_by_date,
       rql.cancel_flag,
       null,
       null,
       null
       ,rql.auction_header_id --Bug 4107528
 FROM po_requisition_lines   rql,
       po_requisition_headers_all rqh,       -- 
       mtl_system_items_kfv   msi
 WHERE rql.requisition_header_id = rqh.requisition_header_id
 and   rql.requisition_header_id = v_document_id
 and   rql.auction_display_number = v_negotiation_num
 AND   at_sourcing_flag = 'Y' --
 AND   rql.item_id = msi.inventory_item_id(+)
 AND   nvl(msi.organization_id, rql.destination_organization_id) =
       rql.destination_organization_id
 ORDER BY rql.auction_line_number;

Line: 895

select auction_header_id,
       auction_display_number
from po_requisition_lines
where requisition_line_id = x_doc_id
AND at_sourcing_flag = 'Y'; --

Line: 902

select distinct auction_header_id ,
       auction_display_number
from po_requisition_lines
where requisition_header_id = x_doc_id
AND at_sourcing_flag = 'Y' --
and (cancel_flag = 'Y' or closed_code = 'FINALLY CLOSED')
and (trunc(cancel_date) = trunc(sysdate) or trunc(closed_date) = trunc(sysdate));

Line: 911

select distinct auction_header_id ,
       auction_display_number
from po_requisition_lines
where requisition_header_id = x_doc_id
AND at_sourcing_flag = 'Y'; --

Line: 918

select distinct auction_header_id,
       auction_display_number
from po_reschedule_interface
where auction_header_id is not null
and process_id = v_process_id;