APPS.GML_UPDATE_CUST_DATA_PVT SQL Statements

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

Line: 44

   SELECT a.cust_id INTO l_billcust_id
   FROM   op_cust_mst_v a, op_cust_mst_opm b
   WHERE  a.cust_no = b.cust_no
    			AND a.of_cust_id = b.of_cust_id    --Bug 5651374 Performance issue.
          AND a.co_code = b.co_code
          AND b.cust_id = p_opm_cust_id
          AND b.bill_ind = 1
          AND rownum < 2;

Line: 77

   SELECT a.cust_id INTO l_shipcust_id
   FROM   op_cust_mst_v a, op_cust_mst_opm b
   WHERE  a.cust_no = b.cust_no
          AND a.of_cust_id = b.of_cust_id    --Bug 5651374 Performance issue.
          AND a.co_code = b.co_code
          AND b.cust_id = p_opm_cust_id
          AND b.ship_ind = 1
          AND rownum < 2;

Line: 111

   SELECT a.cust_id INTO l_anycust_id
   FROM   op_cust_mst_v a, op_cust_mst_opm b
   WHERE  a.cust_no = b.cust_no
          AND a.of_cust_id = b.of_cust_id    --Bug 5651374 Performance issue.
          AND a.co_code = b.co_code
          AND b.cust_id = p_opm_cust_id
          AND rownum < 2;

Line: 127

 PROCEDURE UPDATE_CUST_ID
 IS

 l_bill_cust_id NUMBER;

Line: 135

 SELECT b.cust_id FROM op_cust_mst a, op_cust_mst_opm b
 WHERE  a.cust_no = b.cust_no
   AND    a.co_code = b.co_code;

Line: 153

     UPDATE gl_acct_map
     SET    cust_id = l_ship_cust_id
     WHERE opm_cust_id = r.cust_id;

Line: 157

     UPDATE op_alot_prm
     SET    cust_id = l_ship_cust_id
     WHERE  opm_cust_id = r.cust_id;

Line: 162

     UPDATE op_cust_asc
     SET    assoccust_id = l_ship_cust_id
     WHERE  opm_assoccust_id = r.cust_id;

Line: 166

     UPDATE op_gnrc_itm
     SET    cust_id = l_ship_cust_id
     WHERE  opm_cust_id = r.cust_id;

Line: 170

     UPDATE op_txcu_asc
     SET    cust_id = l_ship_cust_id
     WHERE  opm_cust_id = r.cust_id;

Line: 174

     UPDATE op_ordr_hdr
     SET    shipcust_id = l_ship_cust_id
     WHERE  opm_shipcust_id = r.cust_id;

Line: 178

     UPDATE op_ordr_hdr
     SET    ultimate_shipcust_id = l_ship_cust_id
     WHERE  opm_ultimate_shipcust_id = r.cust_id;

Line: 182

     UPDATE op_ordr_dtl
     SET    shipcust_id = l_ship_cust_id
     WHERE  opm_shipcust_id = r.cust_id;

Line: 186

     UPDATE op_prsl_hdr
     SET    shipcust_id = l_ship_cust_id
     WHERE  opm_shipcust_id = r.cust_id;

Line: 190

     UPDATE op_prsl_hdr
     SET    ultimate_shipcust_id = l_ship_cust_id
     WHERE  opm_ultimate_shipcust_id = r.cust_id;

Line: 194

     UPDATE op_prsl_dtl
     SET    shipcust_id = l_ship_cust_id
     WHERE  opm_shipcust_id = r.cust_id;

Line: 198

     UPDATE op_prsl_dtl
     SET    ultimate_shipcust_id = l_ship_cust_id
     WHERE  opm_ultimate_shipcust_id = r.cust_id;

Line: 207

     UPDATE op_cust_asc
     SET    cust_id = l_bill_cust_id
     WHERE  opm_cust_id = r.cust_id;

Line: 211

     UPDATE op_ordr_hdr
     SET    billcust_id = l_bill_cust_id
     WHERE  opm_billcust_id = r.cust_id;

Line: 215

     UPDATE op_prsl_hdr
     SET    billcust_id = l_bill_cust_id
     WHERE  opm_billcust_id = r.cust_id;

Line: 219

     UPDATE op_prsl_dtl
     SET    billcust_id = l_bill_cust_id
     WHERE  opm_billcust_id = r.cust_id;

Line: 228

     UPDATE op_chrg_itm
     SET    cust_id = l_any_cust_id
     WHERE  opm_cust_id = r.cust_id;

Line: 232

     UPDATE op_cust_con
     SET    cust_id = l_any_cust_id
     WHERE  opm_cust_id = r.cust_id;

Line: 236

     UPDATE op_cust_itm
     SET    cust_id = l_any_cust_id
     WHERE  opm_cust_id = r.cust_id;

Line: 240

     UPDATE op_prce_eff
     SET    cust_id = l_any_cust_id
     WHERE  opm_cust_id = r.cust_id;

Line: 244

     UPDATE op_ordr_hdr
     SET    soldtocust_id = l_any_cust_id
     WHERE  opm_soldtocust_id = r.cust_id;

Line: 248

     UPDATE op_ordr_dtl
     SET    soldtocust_id = l_any_cust_id
     WHERE  opm_soldtocust_id = r.cust_id;

Line: 252

     UPDATE op_ordr_dtl
     SET    ultimate_shipcust_id = l_any_cust_id
     WHERE  opm_ultimate_shipcust_id = r.cust_id;

Line: 256

     UPDATE op_prsl_hdr
     SET    soldtocust_id= l_any_cust_id
     WHERE  opm_soldtocust_id = r.cust_id;

Line: 260

     UPDATE op_prsl_dtl
     SET    soldtocust_id= l_any_cust_id
     WHERE  opm_soldtocust_id = r.cust_id;

Line: 264

     UPDATE op_cust_shp
     SET    cust_id = l_any_cust_id
     WHERE  opm_cust_id = r.cust_id;

Line: 273

 END UPDATE_CUST_ID;