DBA Data[Home] [Help]

APPS.QP_ITEM_RANGE_PVT SQL Statements

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

Line: 34

  l_rows_updated  INTEGER;
Line: 37

  l_update_stmt   VARCHAR2(4000);
Line: 56

  l_update_stmt := 'SELECT m.inventory_item_id
    		            FROM mtl_system_items m
    		           WHERE m.organization_id = :l_org ';
Line: 63

    l_update_stmt := l_update_stmt || 'AND m.CUSTOMER_ORDER_FLAG = ''Y'' ';
Line: 93

      l_update_stmt := l_update_stmt ||
           'AND    (m.segment1 IS NULL) ';
Line: 96

      l_update_stmt := l_update_stmt ||
           'AND    (m.segment1   BETWEEN ';
Line: 98

      l_update_stmt := l_update_stmt ||p_segment1_lohi;
Line: 99

      l_update_stmt := l_update_stmt ||' )';
Line: 103

      l_update_stmt := l_update_stmt ||
           'AND    (m.segment2 IS NULL) ';
Line: 106

      l_update_stmt := l_update_stmt ||
           'AND    (m.segment2   BETWEEN ';
Line: 108

      l_update_stmt := l_update_stmt ||p_segment2_lohi;
Line: 109

      l_update_stmt := l_update_stmt ||' )';
Line: 113

      l_update_stmt := l_update_stmt ||
           'AND    (m.segment3 IS NULL) ';
Line: 116

      l_update_stmt := l_update_stmt ||
           'AND    (m.segment3   BETWEEN ';
Line: 118

      l_update_stmt := l_update_stmt ||p_segment3_lohi;
Line: 119

      l_update_stmt := l_update_stmt ||' )';
Line: 123

      l_update_stmt := l_update_stmt ||
           'AND    (m.segment4 IS NULL) ';
Line: 126

      l_update_stmt := l_update_stmt ||
           'AND    (m.segment4   BETWEEN ';
Line: 128

      l_update_stmt := l_update_stmt ||p_segment4_lohi;
Line: 129

      l_update_stmt := l_update_stmt ||' )';
Line: 133

      l_update_stmt := l_update_stmt ||
           'AND    (m.segment5 IS NULL) ';
Line: 136

      l_update_stmt := l_update_stmt ||
           'AND    (m.segment5   BETWEEN ';
Line: 138

      l_update_stmt := l_update_stmt ||p_segment5_lohi;
Line: 139

      l_update_stmt := l_update_stmt ||' )';
Line: 143

      l_update_stmt := l_update_stmt ||
           'AND    (m.segment6 IS NULL) ';
Line: 146

      l_update_stmt := l_update_stmt ||
           'AND    (m.segment6   BETWEEN ';
Line: 148

      l_update_stmt := l_update_stmt ||p_segment6_lohi;
Line: 149

      l_update_stmt := l_update_stmt ||' )';
Line: 153

      l_update_stmt := l_update_stmt ||
           'AND    (m.segment7 IS NULL) ';
Line: 156

      l_update_stmt := l_update_stmt ||
           'AND    (m.segment7   BETWEEN ';
Line: 158

      l_update_stmt := l_update_stmt ||p_segment7_lohi;
Line: 159

      l_update_stmt := l_update_stmt ||' )';
Line: 163

      l_update_stmt := l_update_stmt ||
           'AND    (m.segment8 IS NULL) ';
Line: 166

      l_update_stmt := l_update_stmt ||
           'AND    (m.segment8   BETWEEN ';
Line: 168

      l_update_stmt := l_update_stmt ||p_segment8_lohi;
Line: 169

      l_update_stmt := l_update_stmt ||' )';
Line: 173

      l_update_stmt := l_update_stmt ||
           'AND    (m.segment9 IS NULL) ';
Line: 176

      l_update_stmt := l_update_stmt ||
           'AND    (m.segment9   BETWEEN ';
Line: 178

      l_update_stmt := l_update_stmt ||p_segment9_lohi;
Line: 179

      l_update_stmt := l_update_stmt ||' )';
Line: 183

      l_update_stmt := l_update_stmt ||
           'AND    (m.segment10 IS NULL) ';
Line: 186

      l_update_stmt := l_update_stmt ||
           'AND    (m.segment10   BETWEEN ';
Line: 188

      l_update_stmt := l_update_stmt ||p_segment10_lohi;
Line: 189

      l_update_stmt := l_update_stmt ||' )';
Line: 193

      l_update_stmt := l_update_stmt ||
           'AND    (m.segment11 IS NULL) ';
Line: 196

      l_update_stmt := l_update_stmt ||
           'AND    (m.segment11   BETWEEN ';
Line: 198

      l_update_stmt := l_update_stmt ||p_segment11_lohi;
Line: 199

      l_update_stmt := l_update_stmt ||' )';
Line: 203

      l_update_stmt := l_update_stmt ||
           'AND    (m.segment12 IS NULL) ';
Line: 206

      l_update_stmt := l_update_stmt ||
           'AND    (m.segment12   BETWEEN ';
Line: 208

      l_update_stmt := l_update_stmt ||p_segment12_lohi;
Line: 209

      l_update_stmt := l_update_stmt ||' )';
Line: 213

      l_update_stmt := l_update_stmt ||
           'AND    (m.segment13 IS NULL) ';
Line: 216

      l_update_stmt := l_update_stmt ||
           'AND    (m.segment13   BETWEEN ';
Line: 218

      l_update_stmt := l_update_stmt ||p_segment13_lohi;
Line: 219

      l_update_stmt := l_update_stmt ||' )';
Line: 223

      l_update_stmt := l_update_stmt ||
           'AND    (m.segment14 IS NULL) ';
Line: 226

      l_update_stmt := l_update_stmt ||
           'AND    (m.segment14   BETWEEN ';
Line: 228

      l_update_stmt := l_update_stmt ||p_segment14_lohi;
Line: 229

      l_update_stmt := l_update_stmt ||' )';
Line: 233

      l_update_stmt := l_update_stmt ||
		 'AND    (m.segment15 IS NULL) ';
Line: 236

      l_update_stmt := l_update_stmt ||
           'AND    (m.segment15   BETWEEN ';
Line: 238

      l_update_stmt := l_update_stmt ||p_segment15_lohi;
Line: 239

      l_update_stmt := l_update_stmt ||' )';
Line: 243

      l_update_stmt := l_update_stmt ||
           'AND    (m.segment16 IS NULL) ';
Line: 246

      l_update_stmt := l_update_stmt ||
           'AND    (m.segment16   BETWEEN ';
Line: 248

      l_update_stmt := l_update_stmt ||p_segment16_lohi;
Line: 249

      l_update_stmt := l_update_stmt ||' )';
Line: 253

      l_update_stmt := l_update_stmt ||
           'AND    (m.segment17 IS NULL) ';
Line: 256

      l_update_stmt := l_update_stmt ||
           'AND    (m.segment17   BETWEEN ';
Line: 258

      l_update_stmt := l_update_stmt ||p_segment17_lohi;
Line: 259

      l_update_stmt := l_update_stmt ||' )';
Line: 263

      l_update_stmt := l_update_stmt ||
           'AND    (m.segment18 IS NULL) ';
Line: 266

      l_update_stmt := l_update_stmt ||
           'AND    (m.segment18   BETWEEN ';
Line: 268

      l_update_stmt := l_update_stmt ||p_segment18_lohi;
Line: 269

      l_update_stmt := l_update_stmt ||' )';
Line: 273

      l_update_stmt := l_update_stmt ||
           'AND    (m.segment19 IS NULL) ';
Line: 276

      l_update_stmt := l_update_stmt ||
           'AND    (m.segment19   BETWEEN ';
Line: 278

      l_update_stmt := l_update_stmt ||p_segment19_lohi;
Line: 279

      l_update_stmt := l_update_stmt ||' )';
Line: 283

      l_update_stmt := l_update_stmt ||
           'AND    (m.segment20 IS NULL) ';
Line: 286

      l_update_stmt := l_update_stmt ||
           'AND    (m.segment20   BETWEEN ';
Line: 288

      l_update_stmt := l_update_stmt ||p_segment20_lohi;
Line: 289

      l_update_stmt := l_update_stmt ||' )';
Line: 298

    l_update_stmt := l_update_stmt ||
		 'AND    m.inventory_item_status_code =  :l_stat ';
Line: 306

    l_update_stmt := l_update_stmt ||
                 'AND    m.inventory_item_id IN
                 ( SELECT ic.inventory_item_id
                   FROM   mtl_item_categories ic
                   WHERE  ic.inventory_item_id = m.inventory_item_id
                   AND    ic.organization_id   = m.organization_id
                   AND    ic.organization_id   = :l_org )';
Line: 318

    l_update_stmt := l_update_stmt ||
                 'AND    m.inventory_item_id IN
                 ( SELECT ic.inventory_item_id
                   FROM   mtl_item_categories ic
                   WHERE  ic.inventory_item_id = m.inventory_item_id
                   AND    ic.organization_id   = m.organization_id
                   AND    ic.organization_id   = :l_org
                   AND    ic.category_set_id   = :l_set )';
Line: 332

    l_update_stmt := l_update_stmt ||
                 'AND    m.inventory_item_id IN
                 ( SELECT ic.inventory_item_id
                   FROM   mtl_item_categories ic
                   WHERE  ic.inventory_item_id = m.inventory_item_id
                   AND    ic.organization_id   = m.organization_id
                   AND    ic.organization_id   = :l_org
                   AND    ic.category_set_id   = :l_set
                   AND    ic.category_id       = :l_cat )';
Line: 347

    l_update_stmt := l_update_stmt ||
		 'AND    m.inventory_item_id IN
		 ( SELECT ic.inventory_item_id
		   FROM   mtl_item_categories ic
		   WHERE  ic.inventory_item_id = m.inventory_item_id
		   AND    ic.organization_id   = m.organization_id
		   AND    ic.category_set_id   = :l_set
		   AND    ic.category_id       = :l_cat )';
Line: 361

  DBMS_SQL.PARSE(l_cursor_id, l_update_stmt, DBMS_SQL.V7);
Line: 386

  l_rows_updated := DBMS_SQL.EXECUTE(l_cursor_id);