eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_ORDER_IMPORT_MAIN_PVT SQL Statements

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

Line: 142


  l_updated_docref         VARCHAR2(50);

Line: 159


    SELECT order_source_id
      FROM oe_order_sources s
     WHERE (
            (nvl(l_order_source,' ') =  ' ') OR
	    (
             (nvl(l_order_source,' ') <> ' ') AND
             (enabled_flag = 'Y') AND
	     (nvl(to_char(order_source_id),' ')=nvl(rtrim(l_order_source),' '))
	    )
           )
  ORDER BY order_source_id
;

Line: 185


    SELECT order_source_id
	 , orig_sys_document_ref
	, sold_to_org_id
         , sold_to_org
       	 , change_sequence
      , nvl(closed_flag, 'N')
      ,org_id
     FROM oe_headers_iface_all
     WHERE request_id = l_request_id
       AND decode(p_perf_param, 'Y',
           nvl(error_flag,'N'), ' ')
         = decode(p_perf_param, 'Y',
           'N', ' ')
       AND decode(l_looped_flag, 'Y',
           l_rowid, ' ')
         = decode(l_looped_flag, 'Y',
           rowidtochar(rowid), ' ')
  ORDER BY org_id,order_source_id, orig_sys_document_ref, change_sequence
;

Line: 216


    SELECT order_source_id
         , original_sys_document_ref
    	 , change_sequence
         , original_sys_document_line_ref
         , message_text
      FROM oe_processing_msgs_vl
     WHERE request_id = l_request_id
  ORDER BY order_source_id, original_sys_document_ref, change_sequence
;

Line: 229


    SELECT /*+ INDEX (a,OE_PROCESSING_MSGS_N2)
	   USE_NL (a b) */
           a.order_source_id
         , a.original_sys_document_ref
    	    , a.change_sequence
         , a.original_sys_document_line_ref
         , a.org_id
         , b.message_text
      FROM oe_processing_msgs a, oe_processing_msgs_tl b
     WHERE a.request_id = l_request_id
       AND a.transaction_id = b.transaction_id
       AND b.language = oe_globals.g_lang
  ORDER BY a.order_source_id, a.original_sys_document_ref, a.change_sequence
;

Line: 406


   Update Concurrent Request Ids
   -----------------------------------------------------------
*/
/* oe_debug_pub.add('No of orders in inf table');

Line: 410


   SELECT COUNT(*) INTO l_ord_count
	FROM oe_headers_iface_all
    WHERE order_source_id     = 1084
      AND ( nvl(NULL,' ') =  ' ' OR
           (nvl(NULL,' ') <> ' ' AND
           nvl(NULL,' ') = nvl(orig_sys_document_ref,' ')))
      AND ( nvl(NULL,' ') =  ' ' OR
          (nvl(NULL,' ') <> ' ' AND
           nvl(NULL,' ') = nvl(operation_code,' ')))
      AND request_id          IS NULL
      AND nvl(error_flag,'N') = 'N';

Line: 425


    UPDATE oe_headers_interface
      SET request_id          = l_request_id
    WHERE order_source_id     = l_order_source_id
      AND ( nvl(l_orig_sys_document_ref,' ') =  ' ' OR
           (nvl(l_orig_sys_document_ref,' ') <> ' ' AND
            nvl(l_orig_sys_document_ref,' ') = nvl(orig_sys_document_ref,' ')))
      AND ( nvl(l_operation_code,' ') =  ' ' OR
           (nvl(l_operation_code,' ') <> ' ' AND
            nvl(l_operation_code,' ') = nvl(operation_code,' ')))
      AND ( l_sold_to_org_id IS NULL OR
           (l_sold_to_org_id IS NOT NULL AND
            nvl(l_sold_to_org_id, FND_API.G_MISS_NUM) = nvl(sold_to_org_id, FND_API.G_MISS_NUM)))
      AND
           ( l_sold_to_org IS NULL OR
           (l_sold_to_org IS NOT NULL AND
            nvl(l_sold_to_org, FND_API.G_MISS_CHAR) = nvl(sold_to_org, FND_API.G_MISS_CHAR)))
      AND ( l_change_sequence IS NULL OR
           (l_change_sequence IS NOT NULL AND
            nvl(l_change_sequence, FND_API.G_MISS_CHAR) = nvl(change_sequence, FND_API.G_MISS_CHAR)))
      AND request_id          IS NULL
      AND nvl(error_flag,'N') = 'N';

Line: 457


        UPDATE oe_headers_iface_all
           SET request_id          = l_request_id,
               org_id              = p_default_org_id
         WHERE order_source_id     = l_order_source_id
           AND ( nvl(l_orig_sys_document_ref,' ') =  ' ' OR
               (nvl(l_orig_sys_document_ref,' ') <> ' ' AND
                nvl(l_orig_sys_document_ref,' ') = nvl(orig_sys_document_ref,' ')))
           AND ( nvl(l_operation_code,' ') =  ' ' OR
               (nvl(l_operation_code,' ') <> ' ' AND
                nvl(l_operation_code,' ') = nvl(operation_code,' ')))
           AND ( l_sold_to_org_id IS NULL OR
               (l_sold_to_org_id IS NOT NULL AND
                nvl(l_sold_to_org_id, FND_API.G_MISS_NUM) = nvl(sold_to_org_id, FND_API.G_MISS_NUM)))
           AND
               ( l_sold_to_org IS NULL OR
               (l_sold_to_org IS NOT NULL AND
                nvl(l_sold_to_org, FND_API.G_MISS_CHAR) = nvl(sold_to_org, FND_API.G_MISS_CHAR)))
           AND ( l_change_sequence IS NULL OR
               (l_change_sequence IS NOT NULL AND
                nvl(l_change_sequence, FND_API.G_MISS_CHAR) = nvl(change_sequence, FND_API.G_MISS_CHAR)))
           AND request_id          IS NULL
           AND nvl(error_flag,'N') = 'N'
           AND org_id IS NULL;

Line: 491


   SELECT COUNT(*)
	INTO l_row_count
     FROM oe_headers_iface_all  -- MOAC
    WHERE request_id = l_request_id;

Line: 567


            UPDATE oe_headers_iface_all
	    SET request_id = new_request_id
            WHERE request_id = l_request_id
	    AND ROWNUM =1;

Line: 573


	    UPDATE oe_headers_iface_all
	    SET request_id = new_request_id
            WHERE request_id = l_request_id
	    AND ROWNUM <= batch_size;

Line: 622


   UPDATE oe_lines_iface_all
      SET request_id = l_request_id
    WHERE (order_source_id, orig_sys_document_ref, nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR),nvl(org_id,nvl(p_default_org_id,FND_API.G_MISS_NUM))) IN
	( SELECT order_source_id, orig_sys_document_ref,
nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR), nvl(org_id,FND_API.G_MISS_NUM)
	  FROM oe_headers_iface_all
          WHERE request_id = l_request_id);

Line: 635


   oe_debug_pub.add('rows updated: ' || sql%rowcount);

Line: 640


   UPDATE oe_price_adjs_iface_all
      SET request_id = l_request_id
    WHERE (order_source_id, orig_sys_document_ref,
nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR),nvl(org_id,nvl(p_default_org_id,FND_API.G_MISS_NUM))) IN
	( SELECT order_source_id, orig_sys_document_ref,
nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR), nvl(org_id,FND_API.G_MISS_NUM)
	    FROM oe_headers_iface_all
           WHERE request_id = l_request_id) ;

Line: 656


      UPDATE oe_payments_iface_all
      SET request_id = l_request_id
    WHERE (order_source_id, orig_sys_document_ref,
nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR),nvl(org_id,nvl(p_default_org_id,FND_API.G_MISS_NUM))) IN
	( SELECT order_source_id, orig_sys_document_ref,
nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR), nvl(org_id,FND_API.G_MISS_NUM)
	    FROM oe_headers_iface_all
           WHERE request_id = l_request_id) ;

Line: 671


       oe_debug_pub.add('oe payments rows updated: ' || sql%rowcount);

Line: 677


   UPDATE oe_price_atts_iface_all
      SET request_id = l_request_id
    WHERE (order_source_id, orig_sys_document_ref,
nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR),nvl(org_id,nvl(p_default_org_id,FND_API.G_MISS_NUM))) IN
        ( SELECT order_source_id, orig_sys_document_ref,
nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR), nvl(org_id,FND_API.G_MISS_NUM)
            FROM oe_headers_iface_all
           WHERE request_id = l_request_id) ;

Line: 693


   UPDATE oe_credits_iface_all
      SET request_id = l_request_id
    WHERE (order_source_id, orig_sys_document_ref,
nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR),nvl(org_id,nvl(p_default_org_id,FND_API.G_MISS_NUM))) IN
	( SELECT order_source_id, orig_sys_document_ref,
nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR), nvl(org_id,FND_API.G_MISS_NUM)
	    FROM oe_headers_iface_all
           WHERE request_id = l_request_id) ;

Line: 708


   UPDATE oe_lotserials_iface_all
      SET request_id = l_request_id
    WHERE (order_source_id, orig_sys_document_ref,
nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR),nvl(org_id,nvl(p_default_org_id,FND_API.G_MISS_NUM))) IN
	( SELECT order_source_id, orig_sys_document_ref,
nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR), nvl(org_id,FND_API.G_MISS_NUM)
	    FROM oe_headers_iface_all
           WHERE request_id = l_request_id) ;

Line: 723


   UPDATE oe_reservtns_iface_all
      SET request_id = l_request_id
    WHERE (order_source_id, orig_sys_document_ref,
nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR),nvl(org_id,nvl(p_default_org_id,FND_API.G_MISS_NUM))) IN
	( SELECT order_source_id, orig_sys_document_ref,
nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR), nvl(org_id,FND_API.G_MISS_NUM)
	    FROM oe_headers_iface_all
           WHERE request_id = l_request_id) ;

Line: 738


   UPDATE oe_actions_iface_all
      SET request_id = l_request_id
    WHERE (order_source_id, orig_sys_document_ref,
nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR),nvl(org_id,nvl(p_default_org_id,FND_API.G_MISS_NUM))) IN
	( SELECT order_source_id, orig_sys_document_ref,
nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR), nvl(org_id,FND_API.G_MISS_NUM)
	    FROM oe_headers_iface_all
           WHERE request_id = l_request_id) ;

Line: 794


  select parent_request_id
  into   l_pnt_request_id
  from fnd_concurrent_requests
  where request_id=l_request_id;

Line: 827


UPDATE oe_lines_iface_all
   SET request_id = l_request_id,
       sold_to_org_id = nvl(sold_to_org_id, l_sold_to_org_id),
       sold_to_org = nvl(sold_to_org, l_sold_to_org),
       org_id = l_org_id
 WHERE order_source_id = l_order_source_id
   AND orig_sys_document_ref = l_orig_sys_document_ref
   AND nvl(change_sequence, ' ') = nvl(l_change_sequence, ' ')
   AND nvl(org_id,l_org_id) = l_org_id ;

Line: 844


UPDATE oe_price_adjs_iface_all
   SET request_id = l_request_id,
       sold_to_org_id = nvl(sold_to_org_id, l_sold_to_org_id),
       sold_to_org = nvl(sold_to_org, l_sold_to_org),
       org_id = l_org_id
 WHERE order_source_id = l_order_source_id
   AND orig_sys_document_ref = l_orig_sys_document_ref
   AND nvl(change_sequence, ' ') = nvl(l_change_sequence, ' ')
   AND nvl(org_id,l_org_id) = l_org_id ;

Line: 860


UPDATE oe_payments_iface_all               /* Bug #3419970 */
   SET request_id = l_request_id,
       sold_to_org_id = nvl(sold_to_org_id, l_sold_to_org_id),
       sold_to_org = nvl(sold_to_org, l_sold_to_org),
       org_id = l_org_id
 WHERE order_source_id = l_order_source_id
   AND orig_sys_document_ref = l_orig_sys_document_ref
   AND nvl(change_sequence, ' ') = nvl(l_change_sequence, ' ')
   AND nvl(org_id,l_org_id) = l_org_id ;

Line: 876


UPDATE oe_price_atts_iface_all
   SET request_id = l_request_id,
       sold_to_org_id = nvl(sold_to_org_id, l_sold_to_org_id),
       sold_to_org = nvl(sold_to_org, l_sold_to_org),
       org_id = l_org_id
 WHERE order_source_id = l_order_source_id
   AND orig_sys_document_ref = l_orig_sys_document_ref
   AND nvl(change_sequence, ' ') = nvl(l_change_sequence, ' ')
   AND nvl(org_id,l_org_id) = l_org_id ;

Line: 892


UPDATE oe_credits_iface_all
   SET request_id = l_request_id,
       sold_to_org_id = nvl(sold_to_org_id, l_sold_to_org_id),
       sold_to_org = nvl(sold_to_org, l_sold_to_org),
       org_id = l_org_id
 WHERE order_source_id = l_order_source_id
   AND orig_sys_document_ref = l_orig_sys_document_ref
   AND nvl(change_sequence, ' ') = nvl(l_change_sequence, ' ')
   AND nvl(org_id,l_org_id) = l_org_id ;

Line: 908


UPDATE oe_reservtns_iface_all
   SET request_id = l_request_id,
       sold_to_org_id = nvl(sold_to_org_id, l_sold_to_org_id),
       sold_to_org = nvl(sold_to_org, l_sold_to_org),
       org_id = l_org_id
 WHERE order_source_id = l_order_source_id
   AND orig_sys_document_ref = l_orig_sys_document_ref
   AND nvl(change_sequence, ' ') = nvl(l_change_sequence, ' ')
   AND nvl(org_id,l_org_id) = l_org_id ;

Line: 924


UPDATE oe_lotserials_iface_all
   SET request_id = l_request_id,
       sold_to_org_id = nvl(sold_to_org_id, l_sold_to_org_id),
       sold_to_org = nvl(sold_to_org, l_sold_to_org),
       org_id = l_org_id
 WHERE order_source_id = l_order_source_id
   AND orig_sys_document_ref = l_orig_sys_document_ref
   AND nvl(change_sequence, ' ') = nvl(l_change_sequence, ' ')
   AND nvl(org_id,l_org_id) = l_org_id ;

Line: 940


UPDATE oe_actions_iface_all
   SET request_id = l_request_id,
       sold_to_org_id = nvl(sold_to_org_id, l_sold_to_org_id),
       sold_to_org = nvl(sold_to_org, l_sold_to_org),
       org_id = l_org_id
 WHERE order_source_id = l_order_source_id
   AND orig_sys_document_ref = l_orig_sys_document_ref
   AND nvl(change_sequence, ' ') = nvl(l_change_sequence, ' ')
   AND nvl(org_id,l_org_id) = l_org_id ;

Line: 1055


    select rowidtochar(rowid)
    into l_rowid
    from oe_headers_iface_all    --MOAC
    where request_id = l_pnt_request_id
    and rownum = 1;

Line: 1061


     UPDATE oe_headers_iface_all  --MOAC
        SET request_id = l_request_id
        WHERE request_id = l_pnt_request_id
        AND   nvl(error_flag,'N') = 'N'
        AND rowidtochar(rowid)      = l_rowid
        AND rownum = 1
        RETURNING orig_sys_document_ref
        INTO l_updated_docref;

Line: 1073


        oe_debug_pub.add('rowcount:' || sql%rowcount || ' updated docref:' || l_updated_docref);

Line: 1097


  oe_debug_pub.add('others exception when attempting update' ||sqlerrm);

Line: 1128


/*   SELECT count(*) INTO l_count_msgs
     FROM oe_processing_msgs_vl
    WHERE request_id = l_request_id;

Line: 1239


   SELECT closed_flag
   INTO   l_closed_flag
   FROM   oe_headers_iface_all
   WHERE  orig_sys_document_ref = p_orig_sys_document_ref
   AND    order_source_id = p_order_source_id
   AND    nvl(sold_to_org_id, -999) = nvl(p_sold_to_org_id, -999)
   AND    nvl(sold_to_org, ' ') = nvl(p_sold_to_org, ' ')
   AND    nvl(change_sequence, ' ') = nvl(p_change_sequence, ' ')
   AND    nvl(org_id,-99) = nvl(p_org_id,-99)
   AND    nvl(request_id, -999) = nvl(p_request_id, -999);