APPS.WMS_DEPLOY SQL Statements

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

Line: 42

      SELECT concatenated_segment_delimiter
      INTO g_item_flex_delimiter
      FROM fnd_id_flex_structures_vl
      WHERE (application_id=401)
      AND (id_flex_code    ='MSTK');

Line: 61

      SELECT count(1)
      INTO g_item_segment_count
      FROM fnd_id_flex_segments_vl
      WHERE (id_flex_num =101)
      AND (id_flex_code  ='MSTK')
      AND (application_id=401);

Line: 90

       SELECT 'N'
       INTO   costed_flag
       FROM   mtl_system_items
       WHERE  inventory_item_id = p_in_txn_rec.inventory_item_id
       AND    organization_id = p_in_txn_rec.organization_id
       AND    costing_enabled_flag = 'N'
       AND    invoiceable_item_flag = 'N';

Line: 242

        select concatenated_segments
        into l_item_name
        from mtl_system_items_b_kfv
        where inventory_item_id=p_item_id
        and rownum < 2;

Line: 304

                  SELECT client_id , client_code
                  INTO x_client_id , x_client_code
                  FROM mtl_client_parameters
                  WHERE client_id = x_client_id;

Line: 312

                SELECT client_id , client_code
                INTO x_client_id , x_client_code
                FROM mtl_client_parameters
                WHERE client_code = x_client_code;

Line: 322

            SELECT client.party_name
            INTO x_client_name
            FROM hz_parties client, hz_cust_accounts cust_account
            WHERE  client.party_id = cust_account.party_id
            AND cust_account.cust_account_id = x_client_id;

Line: 345

      SELECT concatenated_segments
      INTO   l_item_name
      FROM   mtl_system_items_b_kfv
      WHERE  inventory_item_id = p_item_id
      AND    organization_id   = p_org_id;

Line: 407

      SELECT segment1
      INTO   l_po_name
      FROM   po_headers_all
      WHERE  po_header_id = p_po_header_id;

Line: 479

      SELECT segment1
      INTO   l_po_num
      FROM   po_headers_all
      WHERE  po_header_id = p_po_header_id;

Line: 508

  ELSE SELECT segment1
       INTO x_po_num
       FROM po_headers_all
       WHERE po_header_id = x_po_header_id;