APPS.POR_RCV_POST_QUERY_PKG SQL Statements

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

Line: 62

    select concatenated_segments
    into   pItemNum
    from   mtl_system_items_kfv
    where  inventory_item_id = pItemId
    and    organization_id = pOrgId;

Line: 79

    select full_name
    into   pName
    from   per_people_f
    where  person_id = pRequestorId
    and    nvl(effective_start_date, sysdate) <= sysdate
    and    nvl(effective_end_date, sysdate) >= sysdate;

Line: 98

    select a.segment1, a.requisition_header_id
    into   pReqNum, pReqHeaderId
    from   po_requisition_headers a,
           po_requisition_lines b
    where  a.requisition_header_id = b.requisition_header_id
    and    b.requisition_line_id = pReqLineId;

Line: 120

    select prh.segment1,prl.requisition_line_id,prh.requisition_header_id
    into   pReqNum, pReqLineId, pReqHeaderId
    from   po_requisition_headers prh,
  	   po_requisition_lines prl,
           po_distributions pod,
           po_req_distributions pord
    where  pod.po_distribution_id= pDistributionId
    and    pord.distribution_id = pod.req_distribution_id
    and    pord.requisition_line_id = prl.requisition_line_id
    and    prl.requisition_header_id = prh.requisition_header_id;

Line: 143

    select pol.vendor_product_num, pod.distribution_num
    into   pSPN, pDistributionNum
    from   po_lines pol,
           po_distributions pod
    where  pod.po_line_id = pol.po_line_id
    and    pod.po_distribution_id = pDistributionId;

Line: 160

  select meaning
  into   xOrderType
  from   fnd_lookup_values
  where  lookup_type = 'POR_RCV_ORDER_TYPE'
  and    lookup_code = pOrderTypeCode
  and    language = 'US';

Line: 175

 select distinct CLM_DOCUMENT_NUMBER into xOrderNumber from PO_CLMREQ_LINE_AWD_REFS_V where requisition_header_id=pReqHeaderId ;

Line: 177

  SELECT ORDER_NUM
  INTO xOrderNumber
  FROM (
  SELECT DISTINCT PH.SEGMENT1 || DECODE(PR.RELEASE_NUM, NULL, '', '-' || PR.RELEASE_NUM) ORDER_NUM
  FROM PO_REQUISITION_LINES_ALL PRL,
     PO_LINE_LOCATIONS_ALL PLL,
     PO_HEADERS_ALL PH,
     PO_RELEASES_ALL PR
  WHERE PRL.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID AND
     PLL.PO_HEADER_ID = PH.PO_HEADER_ID AND
     PLL.PO_RELEASE_ID = PR.PO_RELEASE_ID(+) AND
     PRL.REQUISITION_HEADER_ID = pReqHeaderId
  UNION ALL
  SELECT DISTINCT  TO_CHAR(oe_order_import_interop_pub.Get_Order_Number(POSP.order_source_id,PORL.requisition_header_id,PORL.requisition_line_id)) ORDER_NUM
  FROM  PO_REQUISITION_HEADERS_ALL PORH,
     PO_REQUISITION_LINES_ALL PORL,
     PO_SYSTEM_PARAMETERS POSP
  WHERE  PORL.SOURCE_TYPE_CODE = 'INVENTORY' AND
    PORH.REQUISITION_HEADER_ID = PORL.REQUISITION_HEADER_ID AND
    PORH.REQUISITION_HEADER_ID = pReqHeaderId
  );

Line: 214

 select SUPPLIER into xSupplier from
  (select DISTINCT PV.VENDOR_NAME SUPPLIER FROM PO_CLMREQ_LINE_AWD_REFS_V PH, PO_VENDORS PV
     where PH.VENDOR_ID = PV.VENDOR_ID AND PH.requisition_header_id=pReqHeaderId );

Line: 218

  SELECT SUPPLIER
  INTO xSupplier
  FROM (
  SELECT DISTINCT PV.VENDOR_NAME SUPPLIER
  FROM PO_REQUISITION_LINES_ALL PRL,
     PO_LINE_LOCATIONS_ALL PLL,
     PO_HEADERS_ALL PH,
     PO_VENDORS PV
  WHERE PRL.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID AND
     PLL.PO_HEADER_ID = PH.PO_HEADER_ID AND
     PH.VENDOR_ID = PV.VENDOR_ID AND
     PRL.REQUISITION_HEADER_ID = pReqHeaderId
  UNION ALL
  SELECT DISTINCT HAOU.NAME SUPPLIER
  FROM PO_REQUISITION_LINES_ALL PRL,
     HR_ALL_ORGANIZATION_UNITS_TL HAOU
  WHERE  PRL.SOURCE_TYPE_CODE = 'INVENTORY' AND
    HAOU.ORGANIZATION_ID = PRL.SOURCE_ORGANIZATION_ID AND
    HAOU.LANGUAGE  = USERENV('LANG') AND
    PRL.REQUISITION_HEADER_ID = pReqHeaderId
  );