APPS.PO_WF_REQ_NOTIFICATION_R11 SQL Statements

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

Line: 767

  l_req_updates_url  VARCHAR2(2000) := '';

Line: 776

SELECT rql.line_num,
       msi.concatenated_segments,
       rql.item_revision,
       rql.item_description,
       rql.unit_meas_lookup_code,
       rql.quantity,
       rql.unit_price,
       rql.quantity * rql.unit_price,
       rql.need_by_date,
       hrt.location_code,
       per.full_name,
       rql.suggested_vendor_name,
       rql.suggested_vendor_location
  FROM po_requisition_lines   rql,
       mtl_system_items_kfv   msi,
       hr_locations	      hrt,
       per_people_f           per
 WHERE rql.requisition_header_id = v_document_id
   AND NVL(rql.cancel_flag,'N') = 'N'
   AND hrt.location_id (+) = rql.deliver_to_location_id
   AND rql.item_id is not null
   AND rql.item_id = msi.inventory_item_id
   AND nvl(msi.organization_id, rql.destination_organization_id) =
       rql.destination_organization_id
   AND rql.to_person_id = per.person_id(+)
   AND per.effective_start_date(+) <= trunc(sysdate)
   AND per.effective_end_date(+) >= trunc(sysdate)
 UNION
  SELECT rql.line_num,
       NULL,
       rql.item_revision,
       rql.item_description,
       rql.unit_meas_lookup_code,
       rql.quantity,
       rql.unit_price,
       rql.quantity * rql.unit_price,
       rql.need_by_date,
       hrt.location_code,
       per.full_name,
       rql.suggested_vendor_name,
       rql.suggested_vendor_location
  FROM po_requisition_lines   rql,
       hr_locations       hrt,
       per_people_f           per
 WHERE rql.requisition_header_id = v_document_id
   AND NVL(rql.cancel_flag,'N') = 'N'
   AND hrt.location_id (+) = rql.deliver_to_location_id
   AND rql.item_id is NULL
   AND rql.to_person_id = per.person_id(+)
   AND per.effective_start_date(+) <= trunc(sysdate)
   AND per.effective_end_date(+) >= trunc(sysdate)
 ORDER BY 1;

Line: 850

  l_req_updates_url := wf_engine.GetItemAttrText
                                        (itemtype   => l_item_type,
                                         itemkey    => l_item_key,
                                         aname      => 'REQ_UPDATE_URL');

Line: 890

    l_req_updates_url := '' ||
			   fnd_message.get_string('PO', 'PO_WF_NOTIF_EDIT_REQ_URL') || '';

Line: 898

    l_document := l_document || ' ' || '|' || ' ' || l_req_updates_url;

Line: 1005

    l_req_updates_url := substr(l_req_updates_url,
         instr(l_req_updates_url,'''',1,1)+1,
         instr(l_req_updates_url,'''',1,2)- instr(l_req_updates_url,'''',1)-1);

Line: 1010

                  l_req_updates_url || NL1;

Line: 1044

SELECT rql.line_num,
       msi.concatenated_segments,
       rql.item_revision,
       rql.item_description,
       rql.unit_meas_lookup_code,
       rql.quantity,
       rql.unit_price,
       rql.quantity * rql.unit_price,
       rql.need_by_date,
       hrt.location_code,
       per.full_name,
       rql.suggested_vendor_name,
       rql.suggested_vendor_location
  FROM po_requisition_lines   rql,
       mtl_system_items_kfv   msi,
       hr_locations	      hrt,
       per_people_f           per
 WHERE rql.requisition_header_id = v_document_id
   AND NVL(rql.cancel_flag,'N') = 'N'
   AND hrt.location_id (+) = rql.deliver_to_location_id
   AND rql.item_id is not null
   AND rql.item_id = msi.inventory_item_id
   AND nvl(msi.organization_id, rql.destination_organization_id) =
       rql.destination_organization_id
   AND rql.to_person_id = per.person_id(+)
   AND per.effective_start_date(+) <= trunc(sysdate)
   AND per.effective_end_date(+) >= trunc(sysdate)
 UNION
  SELECT rql.line_num,
       NULL,
       rql.item_revision,
       rql.item_description,
       rql.unit_meas_lookup_code,
       rql.quantity,
       rql.unit_price,
       rql.quantity * rql.unit_price,
       rql.need_by_date,
       hrt.location_code,
       per.full_name,
       rql.suggested_vendor_name,
       rql.suggested_vendor_location
  FROM po_requisition_lines   rql,
       hr_locations       hrt,
       per_people_f           per
 WHERE rql.requisition_header_id = v_document_id
   AND NVL(rql.cancel_flag,'N') = 'N'
   AND hrt.location_id (+) = rql.deliver_to_location_id
   AND rql.item_id is NULL
   AND rql.to_person_id = per.person_id(+)
   AND per.effective_start_date(+) <= trunc(sysdate)
   AND per.effective_end_date(+) >= trunc(sysdate)
 ORDER BY 1;

Line: 1295

    SELECT poh.SEQUENCE_NUM,
           per.FULL_NAME,
           polc.DISPLAYED_FIELD,
           poh.ACTION_DATE,
           poh.NOTE,
           poh.OBJECT_REVISION_NUM
      from po_action_history  poh,
           per_people_f       per,
           po_lookup_codes    polc
     where OBJECT_TYPE_CODE = v_object_type
       and poh.action_code = polc.lookup_code
       and POLC.LOOKUP_TYPE IN ('APPROVER ACTIONS','CONTROL ACTIONS')
       and per.person_id = poh.employee_id
       and trunc(sysdate) between per.effective_start_date
                              and per.effective_end_date
       and OBJECT_ID = v_document_id
    UNION ALL
    SELECT poh.SEQUENCE_NUM,
           per.FULL_NAME,
           NULL,
           poh.ACTION_DATE,
           poh.NOTE,
           poh.OBJECT_REVISION_NUM
      from po_action_history  poh,
           per_people_f       per
     where OBJECT_TYPE_CODE = v_object_type
       and poh.action_code is null
       and per.person_id = poh.employee_id
       and trunc(sysdate) between per.effective_start_date
                              and per.effective_end_date
       and OBJECT_ID = v_document_id
   order by 1;