APPS.GMI_VALID_GRP SQL Statements

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

Line: 111

SELECT
  item_id
FROM
  ic_item_mst
WHERE
  item_no = p_item_no;

Line: 586

SELECT
  inv_type
FROM
  ic_invn_typ
WHERE
    ic_invn_typ.inv_type    = p_inv_type
AND ic_invn_typ.delete_mark = 0;

Line: 734

SELECT
  abc_code
FROM
  ic_rank_mst
WHERE
    ic_rank_mst.abc_code    = p_item_abccode
AND ic_rank_mst.delete_mark = 0;

Line: 797

SELECT
  icgl_class
FROM
  ic_gled_cls
WHERE
    ic_gled_cls.icgl_class  = p_gl_class
AND ic_gled_cls.delete_mark = 0;

Line: 855

SELECT
  icinv_class
FROM
  ic_invn_cls
WHERE
    ic_invn_cls.icinv_class = p_inv_class
AND ic_invn_cls.delete_mark = 0;

Line: 913

SELECT
  icsales_class
FROM
  ic_sale_cls
WHERE
    ic_sale_cls.icsales_class = p_sales_class
AND ic_sale_cls.delete_mark   = 0;

Line: 971

SELECT
  icship_class
FROM
  ic_ship_cls
WHERE
    ic_ship_cls.icship_class = p_ship_class
AND ic_ship_cls.delete_mark  = 0;

Line: 1029

SELECT
  icfrt_class
FROM
  ic_frgt_cls
WHERE
    ic_frgt_cls.icfrt_class = p_frt_class
AND ic_frgt_cls.delete_mark = 0;

Line: 1087

SELECT
  icprice_class
FROM
  ic_prce_cls
WHERE
    ic_prce_cls.icprice_class = p_price_class
AND ic_prce_cls.delete_mark   = 0;

Line: 1145

SELECT
  icstorage_class
FROM
  ic_stor_cls
WHERE
    ic_stor_cls.icstorage_class = p_storage_class
AND ic_stor_cls.delete_mark     = 0;

Line: 1203

SELECT
  icpurch_class
FROM
  ic_prch_cls
WHERE
    ic_prch_cls.icpurch_class = p_purch_class
AND ic_prch_cls.delete_mark   = 0;

Line: 1261

SELECT
  ictax_class
FROM
  ic_taxn_cls
WHERE
    ic_taxn_cls.ictax_class = p_tax_class
AND ic_taxn_cls.delete_mark = 0;

Line: 1319

SELECT
  iccustoms_class
FROM
  ic_ctms_cls
WHERE
    ic_ctms_cls.iccustoms_class = p_customs_class
AND ic_ctms_cls.delete_mark     = 0;

Line: 1377

SELECT
  alloc_class
FROM
  ic_allc_cls
WHERE
    ic_allc_cls.alloc_class = p_alloc_class
AND ic_allc_cls.delete_mark = 0;

Line: 1435

SELECT
  planning_class
FROM
  ps_plng_cls
WHERE
    ps_plng_cls.planning_class = p_planning_class
AND ps_plng_cls.delete_mark    = 0;

Line: 1493

SELECT
  itemcost_class
FROM
  ic_cost_cls
WHERE
    ic_cost_cls.itemcost_class = p_itemcost_class
AND ic_cost_cls.delete_mark    = 0;

Line: 1550

SELECT
  cost_mthd_code
FROM
  cm_mthd_mst
WHERE
    cm_mthd_mst.cost_mthd_code = p_cost_mthd_code
AND cm_mthd_mst.delete_mark    = 0;

Line: 1698

SELECT
  qc_grade
FROM
  qc_grad_mst
WHERE
    qc_grad_mst.qc_grade    = p_qc_grade
AND qc_grad_mst.delete_mark = 0;

Line: 1768

SELECT
  lot_status
FROM
  ic_lots_sts
WHERE
    ic_lots_sts.lot_status  = p_lot_status
AND ic_lots_sts.delete_mark = 0;

Line: 1837

SELECT
  qchold_res_code
FROM
  qc_hres_mst
WHERE
    qc_hres_mst.qchold_res_code = p_qchold_res_code
AND qc_hres_mst.delete_mark     = 0;

Line: 1906

SELECT
  action_code
FROM
  qc_actn_mst
WHERE
    qc_actn_mst.action_code = p_expaction_code
AND qc_actn_mst.delete_mark = 0;

Line: 2057

SELECT
  seq_dpnd_class
FROM
  cr_sqdt_cls
WHERE
    cr_sqdt_cls.seq_dpnd_class = p_seq_dpnd_class
AND cr_sqdt_cls.delete_mark    = 0;

Line: 2116

SELECT
  commodity_code
FROM
  ic_comd_cds
WHERE
    ic_comd_cds.commodity_code = p_commodity_code
AND ic_comd_cds.delete_mark    = 0;

Line: 2291

SELECT
  lookup_type
FROM
  gem_lookups
WHERE
  lookup_type   = 'ORIGINATION_TYPE'
AND lookup_code = p_origination_type;

Line: 2349

SELECT
  vendor_no
, vendor_id
FROM
  po_vend_mst
WHERE
    vendor_no   = p_shipvendor_no
AND delete_mark = 0;

Line: 2420

SELECT
  a.item_no
, a.item_id
, b.lot_no
, b.sublot_no
FROM
  ic_item_mst a
, ic_lots_mst b
WHERE
    p_item_no     = a.item_no
AND a.item_id     = b.item_id
AND p_lot_no      = b.lot_no
AND p_sublot_no   = b.sublot_no
AND b.delete_mark = 0;

Line: 2492

SELECT
  location
FROM
  ic_loct_mst
WHERE
    whse_code   = p_whse_code
AND location    = p_location
AND delete_mark = 0;

Line: 2583

SELECT
  a.item_no
FROM
  ic_item_mst a
, ic_lots_mst b
, ic_item_cnv c
WHERE
    p_item_no     = a.item_no
AND a.item_id     = b.item_id
AND p_lot_no      = b.lot_no
AND p_sublot_no   = b.sublot_no
AND b.delete_mark = 0
AND c.item_id     = a.item_id
AND c.lot_id      = b.lot_id
AND c.um_type     = p_um_type;