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.GMI_AUTO_ALLOC_BATCH_PKG SQL Statements

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

Line: 98


SELECT  *
FROM  wsh_delivery_details wdd
WHERE wdd.delivery_detail_id = p_delivery_detail_id;

Line: 103


SELECT *
 FROM  gmi_auto_allocation_batch
WHERE  batch_id = p_batch_id;

Line: 112


Select whse_code
from ic_whse_mst
where mtl_organization_id= p_organization_id;

Line: 118


Select mtl_organization_id
From ic_whse_mst
Where whse_code= p_whse_code;

Line: 124


Select inventory_item_id
From ic_item_mst ic,
     mtl_system_items mtl
     where ic.item_id = p_item_id
 AND mtl.segment1 = ic.item_no;

Line: 339


      'SELECT * FROM wsh_delivery_details

         WHERE ' || l_where_clause ||
        'ORDER BY  delivery_detail_id ' ;

Line: 589


Select *
From ic_whse_mst
where whse_code=p_whse_code;

Line: 594


Select *
From ic_item_mst
where item_id=p_item_id;

Line: 601


Select whse_code
from ic_whse_mst
where mtl_organization_id= p_organization_id;

Line: 610


 SELECT SUM(ABS(trans_qty)),SUM(ABS(trans_qty2))
 FROM   ic_tran_pnd
 WHERE  line_id       = p_line_id
 AND    (  lot_id       > 0
        OR location <> p_location )
 AND       item_id       = p_item_id
 AND    doc_type      = 'OMSO'
 AND    staged_ind    = 0
 AND    completed_ind = 0
 AND    delete_mark   = 0
 AND    line_detail_id in
    (Select delivery_detail_id
     From wsh_delivery_details
     Where move_order_line_id = p_mo_line_id
        and released_status in ('R','S'));

Line: 628


SELECT  ic.trans_id, ic.line_id
FROM    ic_tran_pnd ic, wsh_delivery_details wsh
WHERE   ic.line_detail_id = p_delivery_detail_id
   AND  wsh.delivery_detail_id = ic.line_detail_id
   AND  wsh.released_status IN ('R','S')
   AND  ic.doc_type = 'OMSO'
   AND  ic.delete_mark = 0
   AND  ic.staged_ind = 0
   AND  ic.completed_ind = 0
   AND     (ic.lot_id >0 OR ic.location <> 'l_IC$DEFAULT_LOCT');

Line: 715


    IF (NVL(p_batch_rec.delete_existing_aloc_flag,'N') = 'Y' OR
       (p_batch_rec.delete_existing_aloc_flag IS NULL AND UPPER(l_GML$DEL_ALC_BEFORE_AUTO) = 'YES') )
    THEN
       GMI_RESERVATION_UTIL.println('Delete_existing_aloc_flag is Y');

Line: 731


             GMI_Reservation_Util.PrintLn('Before Call to Delete Pending Transaction');

Line: 733


             GMI_TRANS_ENGINE_PUB.delete_pending_transaction (
                          1
                        , FND_API.G_FALSE
                        , FND_API.G_FALSE
                        , FND_API.G_VALID_LEVEL_FULL
                        , l_tran_rec
                        , l_tran_row
                        , x_return_status
                        , x_msg_count
                        , x_msg_data
                        );

Line: 744


             GMI_Reservation_Util.PrintLn('After Call to Delete Pending Transaction');

Line: 745


             GMI_Reservation_Util.PrintLn('Return from DELETE PENDING TRANS x_return_status = ' || x_return_status);

Line: 749


             GMI_RESERVATION_UTIL.PrintLn('Error returned by Delete_Pending_Transaction');

Line: 951


  UPDATE ic_txn_request_lines
  SET   quantity_detailed = l_total_qty
      , secondary_quantity_detailed = l_total_qty2
  WHERE line_id = p_wdd_rec.move_order_line_id;

Line: 1057


 SELECT SUM(ABS(trans_qty)),SUM(ABS(trans_qty2))
 FROM   ic_tran_pnd
 WHERE  line_id       = p_line_id
 AND    doc_type      = 'OMSO'
 AND    completed_ind = 0
 AND    delete_mark   = 0
 AND    (line_detail_id is not null
        and line_detail_id in
           (  Select delivery_detail_id
              From wsh_delivery_details
              Where source_line_id = p_line_id
                 and released_status in ('Y','C')));   -- only the staged, and completed qtys should count

Line: 1073


 SELECT SUM(ABS(trans_qty)),SUM(ABS(trans_qty2))
 FROM   ic_tran_pnd
 WHERE  line_id       = p_line_id
 AND    doc_type      = 'OMSO'
 AND    completed_ind = 0
 AND    delete_mark   = 0
 AND    line_detail_id  = p_line_detail_id;

Line: 1299


SELECT oel.sold_to_org_id
     , oel.ship_to_org_id
     , oel.line_number + (oel.shipment_number / 10)
     , oel.org_id
     , oel.schedule_ship_date
     , oel.header_id
FROM  oe_order_lines_all oel
WHERE  oel.line_id = p_wdd_line.source_line_id;

Line: 1310


SELECT user_id,
       user_name
FROM fnd_user
WHERE  user_id = FND_GLOBAL.USER_ID;

Line: 1317


Select whse_code
from ic_whse_mst
where mtl_organization_id= p_organization_id;

Line: 1323


Select abs(sum(nvl(trans_qty,0))), abs(sum(nvl(trans_qty2,0)))
From ic_tran_pnd
where line_id = p_line_id
  and line_detail_id = p_line_detail_id
  and doc_type = 'OMSO'
  and delete_mark = 0;

Line: 1334


SELECT w.whse_code,
       s.co_code,
       s.orgn_code
FROM   mtl_parameters p,
       ic_whse_mst w,
       sy_orgn_mst s
WHERE
      w.mtl_organization_id   = p.organization_id
AND   p.ORGANIZATION_ID       = p_organization_id
AND   s.orgn_code             = w.orgn_code
AND   s.orgn_code             = p.process_orgn_code
AND   p.process_enabled_flag  ='Y'
AND   s.delete_mark           = 0
AND   w.delete_mark           = 0;

Line: 1542


PROCEDURE Insert_Row (
        p_auto_alloc_batch_rec  IN gmi_auto_allocation_batch%ROWTYPE )
IS
l_err_no NUMBER;

Line: 1549


   INSERT INTO GMI_AUTO_ALLOCATION_BATCH (
                BATCH_ID
                ,NAME
                ,FROM_ORDER_HEADER_NO
                ,TO_ORDER_HEADER_NO
                ,FROM_SCHED_SHIP_DATE
                ,TO_SCHED_SHIP_DATE
                ,FROM_LOT_NO
                ,TO_LOT_NO
                ,FROM_SUBLOT_NO
                ,TO_SUBLOT_NO
                ,ORDER_TYPE_ID
                ,FROM_EXPIRATION_DATE
                ,TO_EXPIRATION_DATE
                ,FROM_CREATION_DATE
                ,TO_CREATION_DATE
                ,LOCATION
                ,ITEM_ID
                ,WHSE_CODE
                ,LOT_STATUS
                ,TO_DELIVERY_DETAIL_ID
                ,PICK_CONFIRM_FLAG
                ,ALLOC_ALL_LOT_FLAG
                ,LOTS_INDIVISIBLE_FLAG
                ,OVERRIDE_RULES
                ,DELETE_EXISTING_ALOC_FLAG
                ,ATTRIBUTE_CATEGORY
                ,ATTRIBUTE1
                ,ATTRIBUTE2
                ,ATTRIBUTE3
                ,ATTRIBUTE4
                ,ATTRIBUTE5
                ,ATTRIBUTE6
                ,ATTRIBUTE7
                ,ATTRIBUTE8
                ,ATTRIBUTE9
                ,ATTRIBUTE11
                ,ATTRIBUTE12
                ,ATTRIBUTE13
                ,ATTRIBUTE14
                ,ATTRIBUTE15
                ,CREATION_DATE
                ,CREATED_BY
                ,LAST_UPDATE_DATE
                ,LAST_UPDATED_BY
                ,LAST_UPDATE_LOGIN
                ,PROGRAM_APPLICATION_ID
                ,PROGRAM_ID
                ,PROGRAM_UPDATE_DATE )

        VALUES  (
                p_auto_alloc_batch_rec.BATCH_ID
                ,p_auto_alloc_batch_rec.NAME
                ,p_auto_alloc_batch_rec.FROM_ORDER_HEADER_NO
                ,p_auto_alloc_batch_rec.TO_ORDER_HEADER_NO
                ,p_auto_alloc_batch_rec.FROM_SCHED_SHIP_DATE
                ,p_auto_alloc_batch_rec.TO_SCHED_SHIP_DATE
                ,p_auto_alloc_batch_rec.FROM_LOT_NO
                ,p_auto_alloc_batch_rec.TO_LOT_NO
                ,p_auto_alloc_batch_rec.FROM_SUBLOT_NO
                ,p_auto_alloc_batch_rec.TO_SUBLOT_NO
                ,p_auto_alloc_batch_rec.ORDER_TYPE_ID
                ,p_auto_alloc_batch_rec.FROM_EXPIRATION_DATE
                ,p_auto_alloc_batch_rec.TO_EXPIRATION_DATE
                ,p_auto_alloc_batch_rec.FROM_CREATION_DATE
                ,p_auto_alloc_batch_rec.TO_CREATION_DATE
                ,p_auto_alloc_batch_rec.LOCATION
                ,p_auto_alloc_batch_rec.ITEM_ID
                ,p_auto_alloc_batch_rec.WHSE_CODE
                ,p_auto_alloc_batch_rec.LOT_STATUS
                ,p_auto_alloc_batch_rec.TO_DELIVERY_DETAIL_ID
                ,p_auto_alloc_batch_rec.PICK_CONFIRM_FLAG
                ,p_auto_alloc_batch_rec.ALLOC_ALL_LOT_FLAG
                ,p_auto_alloc_batch_rec.LOTS_INDIVISIBLE_FLAG
                ,p_auto_alloc_batch_rec.OVERRIDE_RULES
                ,p_auto_alloc_batch_rec.DELETE_EXISTING_ALOC_FLAG
                ,p_auto_alloc_batch_rec.ATTRIBUTE_CATEGORY
                ,p_auto_alloc_batch_rec.ATTRIBUTE1
                ,p_auto_alloc_batch_rec.ATTRIBUTE2
                ,p_auto_alloc_batch_rec.ATTRIBUTE3
                ,p_auto_alloc_batch_rec.ATTRIBUTE4
                ,p_auto_alloc_batch_rec.ATTRIBUTE5
                ,p_auto_alloc_batch_rec.ATTRIBUTE6
                ,p_auto_alloc_batch_rec.ATTRIBUTE7
                ,p_auto_alloc_batch_rec.ATTRIBUTE8
                ,p_auto_alloc_batch_rec.ATTRIBUTE9
                ,p_auto_alloc_batch_rec.ATTRIBUTE11
                ,p_auto_alloc_batch_rec.ATTRIBUTE12
                ,p_auto_alloc_batch_rec.ATTRIBUTE13
                ,p_auto_alloc_batch_rec.ATTRIBUTE14
                ,p_auto_alloc_batch_rec.ATTRIBUTE15
                ,p_auto_alloc_batch_rec.CREATION_DATE
                ,p_auto_alloc_batch_rec.CREATED_BY
                ,p_auto_alloc_batch_rec.LAST_UPDATE_DATE
                ,p_auto_alloc_batch_rec.LAST_UPDATED_BY
                ,p_auto_alloc_batch_rec.LAST_UPDATE_LOGIN
                ,p_auto_alloc_batch_rec.PROGRAM_APPLICATION_ID
                ,p_auto_alloc_batch_rec.PROGRAM_ID
                ,p_auto_alloc_batch_rec.PROGRAM_UPDATE_DATE);

Line: 1655


    WSH_UTIL_CORE.Println(' Line Insert Error => ' || l_err_no || l_err_msg);

Line: 1656


        gmi_reservation_util.Println(' Line Insert Error => ' || l_err_no ||
                l_err_msg );

Line: 1663


            ,   'Insert_Row'
            );

Line: 1670


END Insert_Row;