APPS.GMI_GLOBAL_GRP SQL Statements

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

Line: 62

SELECT
  *
FROM
  ic_item_mst
WHERE
    item_no     = p_item_no;

Line: 70

SELECT
  *
FROM
  ic_item_cpg
WHERE
  item_id = v_item_id;

Line: 138

SELECT
  *
FROM
  ic_lots_mst
WHERE
    lot_no      = p_lot_no
AND ( sublot_no   = p_sublot_no OR
      sublot_no is NULL)
AND item_id     = p_item_id;

Line: 149

SELECT
  *
FROM
  ic_lots_cpg
WHERE
  lot_id = v_lot_id;

Line: 211

SELECT
  *
FROM
  ic_whse_mst
WHERE
    whse_code   = p_whse_code;

Line: 263

, p_delete_mark IN  ic_loct_inv.delete_mark%TYPE
, x_ic_loct_inv OUT NOCOPY ic_loct_inv%ROWTYPE
)
IS
CURSOR ic_loct_inv_c1 IS
SELECT
  *
FROM
  ic_loct_inv
WHERE
    item_id     = p_item_id
AND whse_code   = p_whse_code
AND lot_id      = p_lot_id
AND location    = p_location
AND delete_mark = p_delete_mark;

Line: 326

SELECT
  *
FROM
  sy_uoms_mst
WHERE
    um_code     = p_um_code
AND delete_mark = 0;

Line: 335

SELECT
  *
FROM
  sy_uoms_typ
WHERE
    um_type     = v_um_type
AND delete_mark = 0;

Line: 399

, p_delete_mark IN  ic_loct_inv.delete_mark%TYPE
, x_lot_onhand  OUT NOCOPY NUMBER
)
IS
CURSOR ic_lot_inv_c1 IS
SELECT
  SUM(loct_onhand)
FROM
  ic_loct_inv
WHERE
    item_id     = p_item_id
AND lot_id      = p_lot_id
AND delete_mark = p_delete_mark;